…know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware…to use. Do push concurrency too high Many developers will test script with multiple level of …good idea. It also often helps with monopolizing replication thread. For example if I need to …
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… easy and affordable for everyone. You can convert your existing MySQL replication setup into a cluster in just a couple minutes. Tomorrow… will be a big topic on coming MySQL User Conference, both Codership and Percona development team will be there, you will have….x, a generic Synchronous Multi-Master replication plugin for transactional applications. The Galera library is developed by Codership Oy company and Galera…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… of the most painful things anyone experiences with MySQL is significantly alleviated. If you’ve ever …tool is not new to the toolkit. We developed it some time ago for a client and…that it is replication-aware and inspects replicas, throttles its operation to avoid causing replication delay, watches …
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… started looking at other ways of achieving higher availability using MySQL replication. One of the weakness of MMM is its communication layer… a flat tire, we decided, Baron Schwartz and I, to develop a solution using Pacemaker, a well known and established cluster…=”ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_defaults $id=”rsc-options…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… safety for example Upgrade QA Upgrade needs to start with development/QA boxes. If you’re using safe approach you probably… you want to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave with new version… possible as MySQL only fully support slaves newer than the master. Older slaves may have issues unable to interpret new replication stream…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right… of cases I’ve seen such filtering being broken by developer forgetting this restriction and running one time update query without… can see no matter which road you take with partial MySQL Replication there are things to be careful with, so if you…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication is single threaded, which means… of problems and often save massive hardware purchases or development efforts based on assumption MySQL replication can’t possibly keep up any more.
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… development has too much autonomy. I must note in this aspect however DRBD goes on par with MySQL Statement Based Replication – …with MySQL Replication, such as filtered replication or cross storage engine replication, though which are not typically used for HA purposes. Time Delayed replication …
Post: How expensive is MySQL Replication for the Master
January 16, 2010 By 13 Comments
I generally thought about MySQL replication as being quite low overhead on Master, depending on number …) I guess this scenario is just not really caught any developer attention yet as it should be rather easy to optimize… and process several packets at the time we could make replication threads to be woken up in the batches. For example…
Post: Percona Server 5.1 with Galera replication
July 14, 2011 By 2 Comments
As you may know I closely follow Galera replication development, and right now I am evaluating how it performs in … is Percona Server, so I made port of Galera from MySQL/InnoDB-plugin to Percona Server 5.1.57. Right now…, we are going to provide Percona Server binaries with Galera replication module. Follow @VadimTk
