How to change private IP in DigitalOcean Managed Databases?

September 12, 2019 74 views
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.

1 Answer

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

by Anatoliy Dimitrov
by Hanif Jetha
The MySQL Cluster distributed database provides high availability and throughput for your MySQL database management system. This tutorial demonstrates how to install and configure a 3 node MySQL Cluster on Ubuntu 18.04 servers.
Have another answer? Share your knowledge.