maria-discuss team mailing list archive

[pslawek83 <pslawek83@xxxxx>]

Hi Guys, quick question about lock tables with replication...

I basically use it to achieve atomicity of some database writes, but it seems that queries like
LOCK TABLES ___tsc WRITE
UNLOCK TABLES
are not replicated to slave.

Eg. i can lock table on master, for write, but still read from it on the slave, which could lead to issues...

We're reading some data from slaves, and writing data to it atomically using LOCK TABLES, it seems that this way will lead to race conditions and inconsistent reads from the slave. Any way of having aria/myisam writes to be atomic on the slaves too? I thought to copy the table to random temporary name, do the changes and then rename... but it seems like not very optimal.

Thanks.