Recently, I was working with one of our customer and this is what their requirement as they want to automate this process for converting galera node to async slave and make async slave to galera node without shutting down any server. ———- Here are the steps for how to do that. I assumes that you already have working 3 nodes galera cluster if not, then for the testing purpose you can create it from my previous post. setup-three-nodes-mariadb-galera-cluster-on-single-server-with-mysql-sandbox ———- Btw, there is no matter how many nodes you have. Now, create one test1 table and add 3 records in galera cluster.
MariaDB [nil]> select * from test1; +------+-----------+ | id | name | +------+-----------+ | 1 | nilnandan | | 2 | joshi | | 3 | niljoshi | +------+-----------+ …[Read more]