Not the answer you need?
Register and ask your own question!

Replication troubleshooting with Slave_SQL

pavel.hladikpavel.hladik EntrantInactive User Role Beginner
Hi,

I use Percona MySQL for a almost 5 years and I'm really satisfied, and I have a broken replication between master and slave. After troubleshooting steps I found out, that Slave_IO is working well a Slave_SQL is not working. My Percona MySQL server is latest 5.6.31.

I red Slave_IO is taking care about grabbing master bin logs and delivering to slave relay log and Slave_SQL is taking care about processing of SQLs to databases. I have to say that I see IO and SQL is working:

Slave_IO_Running: Yes
Slave_SQL_Running: Yes

Anyway, when I start the completely new bin logs on master I do replication and I see all datas are transferred to relay logs on slave, the output from SHOW SLAVE STATUS\G seems to be ok. Zero seconds behind master, waiting for master to send data, slave has read all relay log; waiting for the slave I/O thread to update it, BUT the tables are not updated with a new data.

Can you please give me a hint how to get back with replication? Thank you.

Comments

  • sujitkumarjhasujitkumarjha Entrant Current User Role Novice
    Hi Pavel,

    I am also facing same issue. Did you found any solution?

    Regards,
    Sujit
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.