Show master status - "mysqld_multi" - distribution master
- Date: Tue, 23 Aug 2016 10:14:33 -0300
- From: Jose Julian Buda <jbuda@xxxxxxxxxxxxxxxxxxxxxx>
- Subject: Show master status - "mysqld_multi" - distribution master
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
- Prev by Date: Re: filename-safe conversion of database-/tablenames
- Next by Date: Re: Show master status - "mysqld_multi" - distribution master[SOLVED]
- Previous by thread: filename-safe conversion of database-/tablenames
- Next by thread: Re: Show master status - "mysqld_multi" - distribution master[SOLVED]