Clever Geek Handbook

Changing MemSQL host / node to use private IP

The servers we use have both internal and private internal IP addresses. When using the MemSQL Ops GUI to add a MemSQL node and nodes, the installation defaults to using the public IP address, even if provided with a private IP address.

How can we use the private IP used during installation? Or how can this IP address be changed after installation?

Tried using memsql-ops memsql-update-config

to update a parameter reported_hostname

that confirms a successful change and says reload. memsql-ops cluster-restart

does not show any changes.

Process that works: Installing agents through the command line through memsql-ops agent-deploy

(after the initial ops installation) then using memsql-ops restart

each node to restart with a new interface and node bindings. When the agent reboots and shows a private IP, using the OPs interface to install the memsql node works fine.

+3


source to share


1 answer


The IP shown in the Ops is not necessarily the IP addresses used in the MemSQL database.

The source of the truth about the addresses used in the cluster comes from the output of the SHOW LEAVES command.



http://docs.memsql.com/latest/ref/SHOW_LEAVES/

0


source






More articles:


All Articles