… with support for GTID based replication. As promised, here is the step-by-step guide on how to create a new GTID based… MASTER TO MASTER_HOST=”10.0.1.1″, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication… 1 to 5 are already on this slave. That’s all, we have created a new slave in our GTID based replication…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…: UPDATE achievements SET count = count + 1 where achievement = ‘killed_troll’; How many players might accomplish this achievement at the same time…()); Conclusion Choosing a system to replicate your data to a distributed system requires tradeoffs. Most of us are used to the tradeoffs we take…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
In a previous post I explained how to repair MySQL 5.6 GTID replication using two different methods. I didn’t mention the… any easy way to skip a single transaction? There is! Injecting empty transactions. Let’s imagine that the replication in slave server…-8577-11e2-a3d7-080027635ef5:1-4 There are different ways to find the failed transaction. You can examine the binary logs…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… replication. This may sound counter-intuitive at first: how would synchronous replication get behind? As I’ve mentioned before, Galera’s replication is synchronous to… queues will make certification more expensive replication conflicts more likely and therefore time-consuming to the application. How to tell if flow control is…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…’s easy to shoot yourself in the foot if you use it incorrectly. So how do you safely disconnect a replication slave? In short For MySQL 5.0 and 5.1, run STOP SLAVE, CHANGE MASTER TO… any case, you will be able to restart replication, but again as no replication coordinate is specified, replication will start at the beginning of…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… for MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a warm standby server which is flipped into service… virtual IP that points to the active server of a pair. The passive server has mysqld running and replicating from the active…_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to follow the log stream across log…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… (PXC) replication can be encrypted via SSL for secure transfer of your replicated data. Setting this up is actually quite easy to do and probably will look familiar to a lot of… key.pem These are just examples of how you might do it. Just take care to not expose your private key and…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… concurrency levels can be compared with this baseline to see how they are affected and how the system scales with increasing concurrency in… execution is what is going to happen — many batch jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel replication but…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… Soares, Senior Software Engineer, Oracle Topic: “MySQL 5.6: Redefining Replication” Breakout Sessions on Percona Server and Related Projects Stewart Smith… Widenius and Sergei Golubchik, VP Architecture, Monty Program Ab Topic: “Replication Changes in MariaDB” Sergei Golubchik, VP Architecture, Monty Program Ab… will focus on MySQL 5.6 and how MySQL must evolve if it is to remain competitive in the new world order…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… therefore always has to be part of the deal. A good early example of this is classic MySQL replication, which was implemented… code”), but at least the approach was right and while replication is not perfect, it’s done brilliantly well for tens… showed how, when done differently, it didn’t have that problem. There were many other aspects to it, leading Brian Aker to decide to…
