How can I reinstall a node?
I want to know if its possible and how can I completely reinstall a single node in case hardware it's completely broken, in a working clustercontrol-mysql-galera-codership cluster.
I have been searching documentation and looking install scripts and seems that you can deploy the complete cluster easily, but better explained I can't find if it possible or not reinstalling a single node, once you completely lose it.
Thanks in advance.
-
In the Enterprise version you can simply remove the broken node and add a new node .
For the community, you need to:
- spin up the new vm/server.
- Install mysql/codership binaries.
- Create the mysql user and datadir
- run mysql_install_db etc..
- Take the same my.cnf as you have already on one of the other nodes.
- Setup password less ssh to the new server.
- Then you can run, from the command line (part of s9s-admin tools on github): ./s9s_aws --change-ip -h <old server addr> -n <new server addr> -k < new server ip> if <new server addr> == < new server ip> then set the same for -n and -k . (s9s_aws is a tool really designed for AWS, but can be used for on non-AWS setups too).
The admin tools you find here:
https://github.com/severalnines/s9s-admin
git clone git://github.com/severalnines/s9s-admin.git
I hope this helps.
BR
johan
Please sign in to leave a comment.
Comments
2 comments