One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is an OCF Resource Agent for Corosync / Pacemaker that take cares of MySQL and manages the replication. Corosync…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
….6: Percona XtraBackup can now save Galera replication information while performing a backup when … topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, …usage, tricks tutorial, Tuesday 10th April Introducing XtraBackup Manager, Wednesday 11th April 15:30 – 16:…
Comment: Online MySQL Configuration Wizard from Percona
March 15, 2012 By 23 Comments
… one?): “Make the server read-only” and “Log replication updates” (the second one especially if binlogging is … idea of putting socket and pid files in mysql data directory. My usual choice for them is /… is less safe (disk full), and harder to manage and monitor. I would add few more options, …
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…regarding Virtual IP addresses, VIPs, management. We decided to call this solution PRM for Percona Replication Manager. All the parts are opensource …ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_defaults $id=”rsc-…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
…MySQL Replication goes in single thread it is enough for one statement to get stuck to have all replication stalled. Long Queries – MySQL Replication…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… quite common in MySQL world and in fact I already wrote about it. There are many aspects of managing mysql replication lag such as… result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication is single threaded, which means…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…with MySQL Replication, such as filtered replication or cross storage engine replication, though which are not typically used for HA purposes. Time Delayed replication …use to SAN based high availability solutions with active-passive management software. Quite often these guys would have be familiar …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… consider “MySQL replication” and “Master-Master with MMM manager” otherwise, you can only consider the other three solutions. Data 100% safe MySQL replication no Master… table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM manager Good, average MySQL DBA + good Sysadmin skills…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… for MySQL, replication. High Availability solution for MySQL: Replication This HA solution is the easiest to implement and to manage. You basically need to setup MySQL replication… by the availability of the MySQL replication link between the servers. Replication often break for various reasons and while replication is broken, there is…
