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"
> <jbuda@noticiasargentinas.com <mailto:jbuda@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