… chance for replication to be lagging, broken, stopped etc which makes failover process tricky. Not only Failover process for MySQL replication is … replication while retaining most of operational and development properties of familiar Innodb tables. MySQL Cluster is often a lot more powerful …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…Replication is delayed or stopped. Our plugins are structured to monitor as few things as possible, but as many as needed. Replication…mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication… has to be power cycled. In addition, other …
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
…GumTree is powered by MySQL but unlike craigslist it looks like they are shy in tuning their MySQL …search results. I’m wondering if that is replication lag or issues with full text search … you better analyze word frequencies and build stop word list which matches your application. For example …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…stop reading this document, you don’t need HA. For the others, let’s move on! How to determine which MySQL… MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM manager Good, average MySQL…KVM over IP and adequate remote power management, an on site intervention …
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
… – power goes down MySQL crashes etc. If you however are using MEMORY table in replication and just want to do a restart without replication… in your my.cnf; run SLAVE STOP; dump all your memory tables using MySQLDump; Restart the MySQL As planned; Load Dumped tables… you may not want these changes to be replicated. What could have done better ? MySQL could have features to make it more…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…location Your entire datacenter loses power and the generators do not …time Restoring data while automatically replicating out to all slaves mysqlbinlog… … –read-from-remote-server –raw –stop-never” Useful to mirror … backups Decompressing Percona XtraBackup for MySQL in parallel using all your…
Post: Percona's Commitments to MySQL Users
November 5, 2010 By 10 Comments
… Always improving Our flagship database server Percona Server with XtraDB powers critical portions of the U.S. economy, applications you rely… monitoring, query analysis, replication management, and other capabilities. If you’re worried about Oracle making MySQL closed-source, stop worrying. It can’t…
Comment: White Paper: Preventing MySQL Emergencies
March 30, 2011 By 7 Comments
…down the server, stop replication and issue SHOW SLAVE STATUS. Save the result to… that replication starts in the correct position” Can please anyone explain me, why to do this? AFAIK mysql saves this information into the master.info file, so you only need to sync it to disk before you power…
Comment: White Paper: Preventing MySQL Emergencies
February 7, 2011 By 7 Comments
…replication starts in the correct position” Can please anyone explain me, why to do this? AFAIK mysql saves this information into the master.info file, so you only need to sync it to disk before you power…
