How to change private IP in DigitalOcean Managed Databases?

Posted September 12, 2019
DigitalOcean Databases Ubuntu 18.04

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.

milky

Submit an answer

You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

alexdo • September 12, 2019

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: