Jose Julian Buda Re: Show master status - "mysqld_multi" - distribution master[SOLVED]
Aug 23, 2016; 12:30
Jose Julian Buda
Re: Show master status - "mysqld_multi" - distribution master[SOLVED]
On 23/08/16 11:26, sujeet gupta wrote: > Hi Dear, > It's not a mysql issue, show me every step you followed to create master > slave hierarchy. > Its like you missed some steps while configuring server. > Show master configuration and slave configuration separately. > > On Aug 23, 2016 6:45 PM, "Jose Julian Buda" > <email@example.com <mailto:firstname.lastname@example.org>> wrote: > > Hi, i have a server acting as a replication distribution > master(taking from the real master), with several mysql instances > (instance 1,instance 2...) with mysqld_multi script, and many > replication filters just to avoid using bandwidth to the remote > datacenters with useless data. > It's working fine, but when i need to see the log pos of an instance > to sync the replication or anything else(for example a delay in the > links): > > mysql -P instance_1_port -u user -ppassword > > mysql>show master status; > > It show me the wrong logfile name and position, in fact it show > always the same log file name, not the file that the slave is taking > to replicate("show slave status" on slave), regardeless the mysql > instance port. > And "show slave status" on master dont show me the Replicate_Do_DB/ > Replicate_Do_Table rules applied in each instance, but everything is > working fine. > > How can i see the right logfile name/position(show master status) > for each mysql instance on the replication distribution master? > > Is it a mysql client issue? > > The log distribution server is running MySql 5.5.50 > > Thank you in advance. > > -- > Jose Julian Buda > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql >
Thank you, it was a mysql client issue.
The client always connects through default sockets unless you specify a host, so this commands work fine:
mysql -h 127.0.0.1 -P instance_1_port -u user -ppassword
mysql -h 127.0.0.1 -P instance_2_port -u user -ppassword .... .... and so for all instances port,
it show me the right log filename and its position and every Replicate_Do* settings, for each mysql instances.
Jose Julian Buda
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!