Hi there,
I have created a MySQL Database Cluster, which name is “testing-mysql-cluster”. Now I want to change the host/IP of Private Network.
Is it possible? If possible, then how?
Thank you.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hello,
May I ask you if you’ve followed this article - https://www.digitalocean.com/community/tutorials/how-to-create-a-multi-node-mysql-cluster-on-ubuntu-18-04
If that is correct you can tweak/edit the /var/lib/mysql-cluster/config.ini file according to your needs.
To change the hostname of the droplet you can use the following command (for Ubuntu droplet)
In Ubuntu 18.04 we can change the system hostname and related settings using the command hostnamectl.
For example, to change the system static hostname to production, you would use the following command:
sudo hostnamectl set-hostname production
Then open the /etc/hosts file and change the old hostname to the new one.
127.0.0.1 localhost
127.0.0.1 production
# The following lines are desirable for IPv6 capable hosts
::1 localhost ip6-localhost ip6-loopback
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
To verify that the hostname was successfully changed, once again use the hostnamectl command:
hostnamectl
Let me know how it goes.
Alex
