…MySQL replication makes restoring slave a bit tricky (if possible at all). The main problem is that InnoDB transaction state and replication…worse is that files with replication state (relay-log.info, master.info) are not synchronized …more complex and I do not see easy way to solve it. So we propose …
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
…before trying to get replication to use it via PRM’s automation that does the CHANGE MASTER for you. …mysql/ssl/server-cert.pem ssl-ca=/etc/mysql/ssl/ca-cert.pem Now, maybe the rest of the world finds it easy…and server, which turns out to be a great way to verify your SSL environment and keys/certs …
Comment: MySQL Master-Master replication manager released
April 9, 2007 By 27 Comments
… same data both for master and the slave. You can’t get it with MySQL replication by design because … the master is not hard as you have positions where each slave is on the master which is easy … define Synchronous replication the same way I do 
“I was able to find a REALLY trivial way to solve …
Post: Here's a quick way to Foresee if Replication Slave is ever going to catch up and When!
August 29, 2012 By 11 Comments
…replication slave that is severely behind, you probably noticed that it’s not catching up with a busy master…it depends..” and indeed it is not an easy question to answer. There are few reasons … awk: delay=60 cmd=”mysql -e ‘show slave status\G’ | grep Seconds_Behind_Master | awk ‘{print \$2}’” while…
Comment: Is DRBD the right choice for me?
July 8, 2009 By 18 Comments
… purely “Uptime” not redundancy. “Since Master-Master rely on replication and replication as no built-in self-healing,…- especially when it can get in the way of choosing the best (performance-wise) solution….and I wish that MySQL Replication had the same features. But it’s fairly easy to emulate most…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…restoring single tables easy. You can … while automatically replicating out to …master and slave Re-transfer files that are partially transferred Compress the files after successful transfer Amazon S3 for MySQL…ways that could improve this in the future. Other details on Percona Remote DBA for MySQL…
Post: Small things are better
October 8, 2006 By 15 Comments
…they can get corrupted because of MySQL bugs, OS Bugs or hardware bugs, …have. You can of course use MASTER-MASTER replication and run statement on one server,… process will be much faster this way as whole indexes will well …of course, it is not always easy to partition your data appropriately, also…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
… could be removed. Collecting data It’s quite easy to collect statistics about index usage in Percona Server… it could be a master, or just a slave somewhere (just be careful not to break replication!). mysql> create schema … set (0.03 sec) Now I need a way to find the set of indexes in all_indexes…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…replication, especially as it has to serialize transactions on the slave which could be executed in parallel on the master…MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not replicated…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
…replication system have been reused many times (including for two of these bugs!) This brings us to our first bug: mysql… this happen in 4 easy steps: 1) Create a… there may be other ways to go about hitting …schema) retcode, result_set = execute_query(query, master_server) self.assertEquals(retcode,0,…
