Web lists-archives.com

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"
<jbuda@xxxxxxxxxxxxxxxxxxxxxx <mailto:jbuda@xxxxxxxxxxxxxxxxxxxxxx>> 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