…-brain immunity. Nobody likes to debug async replication while its broken or do the master-master/master-slave switchover when master is…, naturally duration of SST is paramount. We recommend Xtrabackup SST for its reduced locking period from its use (which means the donor is… resources – you scale more with less, and that is how it should be. We would like to hear from you about your architectural…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… to slave, and if so, how? A: Yes. There are a few of ways to do it. One way is to set up… #69318, and I think it might take one or two more point releases before we can consider it truly production-ready. I suppose…: How do you monitor MySQL to determine when it‘s not responsive? A: The easiest way to do this is to simply connect to it…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…failover than with file-based replication. We will see how to change the replication topology …: #For s2 (the new master), we remove its configuration as a slave s1> stop slave;…we did above. So we will suppose that we can read the binary logs of the crashed master. The first thing to do…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…. The manual describes very nicely how to switch to GTID-based replication, I won’t repeat it. Basically the steps are: Make… instance: Do we really need to restart all the servers at the same time? Downtime is something we like to avoid! Is it necessary… replication only (gtid_mode=on for all servers). Additional question: how can you know if a slave is using GTID-based…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…(correlated, non-correlated, derived tables, scalar subqueries) and we saw in my presentation that sometimes these …try writing a SQL query optimizer and see how easy it is? ;-) Generative grammars like SQL can … explain more about why you thought about doing that and why it helped? When I did not …
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… via parent_id, however in child_B it is explicit. This has an impact on how SchemaSpy identifies the relationship, and whether… shops that we see, where the parent table is known as id, and on the child tables they reference it as parent…’re done. What are some ERD tools you use and how do they compare with SchemaSpy? Feel free to answer via the…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… take it from some old backup. A new tool sys_parser can recover the table structure from InnoDB dictionary. Why do we need a new tool anyway? It is absolutely critical to have an accurate table… create one implicitely. Its name will be GEN_CLUST_INDEX. It doesn’t matter how the primary index gets created it will have minimal…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…, it could get slower if apply times start to lag. So what about my application? Think about your workload. How frequently do you update any given row? We call rows that are updated heavily “hotspots…’t change the law, you can only adapt around it, but how might you do that ? Write to one node If your issue…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… Galera Create and propagate a single key/cert pair First, we create a private key/cert pair: [root@node1 ssl]# openssl… of how you might do it. Just take care to not expose your private key and keep it secure as possible while still getting it… our nodes. However, it‘s not possible to have a mixed cluster where some have SSL and some do not. This is…
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 … GTID we need to find a way to ignore that transaction. The way to do it is creating a new empty transaction with it the GTID we want to skip. STOP SLAVE…
