Loading ...Scenario: Master-Master replication Description: Master A is the active db server whilst Master B is a read only swappable db server hence both are creating binary logs. During backup I run “FLUSH LOGS” in order to have a simpler point in time recovery procedure if that case arises. Problem: Flush logs is mean mean command [...]
Posts Tagged ‘replication’
Do you use MySQL replication? Do you use “FLUSH LOGS”? If yes you might want to read this.
Posted: 31st August 2010 by Darren Cassar in Intermediate, MySQLTags: binary log, error log, flush logs, MySQL, replication
4
Replicating from MySQL to *
Posted: 29th May 2009 by Darren Cassar in Advanced, Intermediate, MySQLTags: bash, MySQL, mysqlbinlog, parsing, replication, row based replication, statement based replication
Recently I needed to replicate between MySQL and another database technology. You might say, why on earth would you want to do something like that, but believe me there are reasons and definitely not (to go away from MySQL to some other DB technology like Oracle or SQL server). Unsurprisingly there are quite a few different tools to do it from any platform towards MySQL but very few which do it the other way round, just to name a couple: Golden Gate and DSCallards.
Circular Replication Implementation / Testing using MySQL Sandbox
Posted: 28th January 2009 by Darren Cassar in Databases, Intermediate, Linux, Mac OS, MySQL, SolarisTags: circular replication, replication, sandbox
This is a simple mysql circular replication implementation on a single machine (just a proof of concept) which can easily be done on a broader scale. Just be aware of the cons of circular replication which mainly gets down to: once a node freaks out or stops for one reason or the other, it’s a [...]