Slave from Galera Cluster

Comments

3 comments

  • Avatar
    Ashraf Sharif

    Hi Mike,

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

    Regards,

    Ashraf

  • Avatar
    Mike Lowery

    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?

  • Avatar
    Ashraf Sharif

    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

Please sign in to leave a comment.

Powered by Zendesk