Slave from Galera Cluster

Follow

Mike Lowery

• August 19, 2014 17:47

Running a cluster of 3+1 of galera cluster with cluster control.

 

Looking at adding in a slave.   what is the best practice for doing this?

 

Thanks!

0

• 

  Ashraf Sharif

  • August 19, 2014 23:23

  Hi Mike,

  You can refer to this blog post: http://www.severalnines.com/blog/asynchronous-replication-galera-cluster-mysql-server-gtid

  Regards,

  Ashraf

  0

  Comment actions Permalink
• 

  Mike Lowery

  • August 20, 2014 12:25

  Ashraf,

     Thanks for replying!  I seen that and its a perfect solution the only issue is im running "  mysql Ver 15.1 Distrib 5.5.39-MariaDB, for Linux (x86_64) using readline 5.1  " and the guide is for 5.6   or is that not an issue anylonger?

  0

  Comment actions Permalink
• 

  Ashraf Sharif

  • August 21, 2014 08:20

  Hi Mike,

  MariaDB 5.5 doesn't support GTID. You need MariaDB 10 which equivalent to MySQL 5.6. You can stick with 5.5 but you will fall under what has been explained in Hybrid Replication in MySQL 5.5 section of the blog post.

  If you are OK with that, you can just choose one of the Galera node and set it up as a master (enable binlog, grant replication user etc). Then dump out the data to the slave node and start the replication.

  Regards,

  Ashraf

  0

  Comment actions Permalink

Please sign in to leave a comment.