This article is specific to this known issue stated in https://jira.mariadb.org/browse/MDEV-17379 which caused failure during deployment as we have stated in this Twitter post.
We have discuss this internally to find a solution. However, since the issue depends on the MariaDB to resolve this issue, we think of a workaround that would be feasible but not seamless compared to how the ClusterControl deployment is supposed to work but will work for you as of this time.
In this example, I want a 3-node MariaDB 10.3. Galera Cluster to be deployed. So here are the steps I took:
1.) Let the ClusterControl handle the installation for all your nodes to make it quicker and no manual hands-on to be applied:
- Deploy -> Select MySQL Galera -> Setup your SSH user credentials and cluster name -> Select MariaDB 10.3 -> Add Node one at a time. This means let CC install the packages for each and every node. The downside is that you have to duplicate this task each on every node but only replace the IP/Hostname on the "Add Node" part with the IP/hostname of the current node you're targeting to install
2.) Stop all the mariadb processes on all of the nodes i.e.
systemctl stop mariadb
3.) Edit /bin/galera_new_cluster and on the last line, replace the "return" command with "exit" which would be the expected output of the last line would look like as follows:
exit $extcode
4.) Once done with installing the packages on all of the 3 nodes, go back again to ClusterControl then,
"Deploy -> Select MySQL Galera -> Setup your SSH user credentials and cluster name and down below the "Cluster Name", you see the checkbox "Install Software". Set this to NO by clicking it leaving it just like 
then hit continue -> Select MariaDB 10.3 -> Add Node. This time, you can add all the nodes with it's IP/Hostname in order to setup your desired cluster.
This works for me without any errors and I was able to run it without any issues:
Let us know if this works for you.
Comments
4 comments
Just an update:
MaiaDB 10.3.11 has already fixed this. So you'll notice that in /bin/galera_new_cluster, instead of "return", the "exit" function is now used.
Very useful. Thanks for Sharing.
The new update is pretty complete and I like it.
basket random
Thanks for sharing these detailed steps! It’s a solid workaround for deploying a 3-node MariaDB 10.3 Galera Cluster despite the current limitations with the known issue. Your method of letting ClusterControl handle each node’s installation individually, followed by manually editing the galera_new_cluster script, seems like an effective approach to bypass the issue until MariaDB resolves it. This will help others facing deployment challenges with ClusterControl to achieve a stable setup for their clusters, even if it requires a bit more manual input. Great work, and thanks for contributing to the community!
Please sign in to leave a comment.