Clone a DB

Follow

xxx

• March 29, 2016 14:55

I have a 3 node galera cluster. I am wanting to make a copy of a DB. I have the mysqldump for DB_1, can I just create a new DB called DB_2 and dump my data into it. The dump file is ~23GB, will this cause a galera lock?

 

 

0

• 

  Art van Scheppingen

  • March 29, 2016 15:36

  Hi Brandon,

  You can create the dump and load it into the new database without a problem as long as you load the dump on one of the nodes and not to, let's say, a load balanced connection. In principle the Galera replication has a multitude of parallel slave threads (set by wsrep_slave_threads) so there will be no lock of it like you have with normal MySQL replication. Also don't forget to ensure there is no "use DB_1" at the beginning of the dump.

  Best regards,

  Art

  0

  Comment actions Permalink
• 

  Johan

  • March 30, 2016 05:26

  Hi,
  Unless you have other application traffic you could also do:

  set globlal wsrep_desync=on;

  on the other two galera nodes. This will take out the galera nodes from flow control.

  when dump completes:

  set globlal wsrep_desync=off;

   

  BR

  johan

   

  0

  Comment actions Permalink
• 

  xxx

  • March 30, 2016 15:55

  I tested this first with a DB that was about 1.2GB and it worked without issue. Now I am going to try the 53GB DB.

   

  0

  Comment actions Permalink
• 

  xxx

  • March 30, 2016 17:55

  I successfully dumped the 53GB dump into a new database.

  Thanks for the reassurance Art. I figured it would work just didnt want to cause any downtime.

  0

  Comment actions Permalink

Please sign in to leave a comment.