S
S
sevmax2011-03-18 00:29:54
MySQL
sevmax, 2011-03-18 00:29:54

Naming mysql slave server

In the output of the " show slave hosts; " command, there is a host column , where the server name should logically be. However, the CHANGE MASTER TO documentation doesn't say anything about how to name the slave when connecting to the master. Actually the question is how to assign names to different slaves in order to distinguish them by verbal description, and not by ID. Thanks in advance.

+-----------+------+------+-----------+
| Server_id | Host | Port | Master_id |
+-----------+------+------+-----------+




Answer the question

In order to leave comments, you need to log in

1 answer(s)
Y
YourChief, 2011-03-18
@sevmax

this is done on the slave started with the parameter for --report-host=host_name
sure in the my.cnf config of the slave, you can also specify it as a variable. read here

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question