Also, you must understand that replication is asynchronous or
semi-synchronous. What means - your update will come to slave in
"unspecified" amount of time - maybe 1 millisecond, maybe 1 day.
For example, your client may have access to master and slave but the link
between master and slave may be b
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 t
Am 13.01.2016 um 15:35 schrieb pslawek83:
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 m
It would be much faster to use bcp to dump the data, and load it into
mariadb using the 'LOAD DATA INFILE' command.
You can use freebcp from the mariadb server to get data from mssql.
Rich
___
Mailing list: https://launchpad.net/~maria-discuss
Post to
4 matches
Mail list logo
