Great article. Did you do a part 3-6? I did not see them in your posts. I would appreciate an email if you did. Thanks.
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
Comment: Minimizing Downtime from Lengthy AWS Outages
June 12, 2013 By 7 Comments
Please post your experience on Percona XtraDB Cluster (PXC) on AWS. I would help us since we want to explore this option.
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… great questions. I answered as many as we had time for during the session, but here are all …, can you explain more about why you thought about doing that and why it helped? When I did not… in performance like this, so it pays to test all different solutions, and measure the resulting performance! …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…. For instance: Do we really need to restart all the servers at the same time? Downtime is something we like…_SQL_Running: Yes [...] The error log tells us why the IO thread has not started: 2013-05… auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table has…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
…, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve…. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We recommend support for critical production deployments.
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…test environment to get familiar with the technology, certainly there’s nothing wrong with a virtual-machine approach, but for…that the kernel has to do in reordering TCP packets … more point releases before we can consider it truly production…my initial reaction was, honestly, why would you ever want …
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…for duplicate keys, but not redundant ones. What is the difference? Let’s see an example. If we execute: mysql> ALTER TABLE test…for filtering on both columns, but also for filtering by just the first one. Why can’t MySQL enforce this kind of constraints? For…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… get nervous around 100MBps. By default Galera uses unicast TCP for replication. Because synchronous replication needs to replicate to all nodes… really easy to do. First, we need to make sure our environment will support multicast. This is a question for your network guys… 39685 0t0 TCP *:3306 (LISTEN) Now, let’s re-do our above test: # 2 nodes in the cluster eth1 DOWN:15 KB…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… referenced the most, and which are candidates for dropping (why keep old data if you don’t need to?)…. environment may be like a lot of shops that we see, where the parent table is known as id… tools you use and how do they compare with SchemaSpy? Feel free to answer via the comments. Thanks for …
