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"
mailto:jb...@noticiasargentinas.com>> 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.
Thank you
Jose Julian Buda
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
