Slave out of sync after editing Query

[expired user #9319]'s profile image [expired user #9319] posted 9 years ago in General Permalink
Hi,

I'm using MySQL 5.6.27 with Slaving-servers (Statement).
Within the MySQL enviroment are multiple databases.

The problem is that if I connect with Heidi to the Master.
1- Directly go to the Query-tab.
2- Execute a Select-Query (SELECT database1.table1 WHERE key1 = 1)
3- Edit a field in the resultSet and Post it.
4- The Slave is out of Sync.

This probably happens because "USE database" isn't run yet.
---
If I first select a Database the slaves stays OK.







Please login to leave a reply, or register at first.