June 20, 2013

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

….69-14.7 release we merged not the exact Oracle 5.1.69 sources, but a later version that is pre-5.1.70 due to Oracle putting a version tag on … if inconvenient, we’ll resolve this by making a proper 5.1.70 release.

Comment: Percona Server 5.6.11-60.3 first Release Candidate now available

does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… be used for SST (Note, the wsrep_sst_xtrabackup in 5.5.30 can’t do those except parallel, the one in 5.5.31 will handle them all, also XB 2.1 is … with a single serving process (we are adding one in 5.5.31), looking for optimizations with HAProxy to account for high…

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

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

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

…_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce… could lead to unresolved package dependencies when installing Percona Server 5.1. Bug fixed #893860. The log tracker thread was unaware… #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation. Bugs can be…

Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2

… second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. Our goal…-11e2-b985-0800272864ba:1, 3d3871d1-c3ae-11e2-b986-0800272864ba:1-4 We can see that it’s not obvious to know…-11e2-b985-0800272864ba:1 or 3d3871d1-c3ae-11e2-b986-0800272864ba:4 ? A ‘Last_Executed_GTID’ column would have been useful. In…

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

… you want two identical physical boxes with at least 4 NIC ports. Why 4? Two of those NICs should be directly connected… have personally only worked with one customer that’s using 5.6), is that I question its readiness. There have been some unfortunate performance regressions compared to 5.5, such as bug #69258, and bug #69318, and I think…

Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera

… really much different from standard mysql replication.  1 master with 5 async slaves is going to send a separate replication stream… nodes]# ip ro show | grep 224 224.0.0.0/4 dev eth1 scope link In that space, we pick an….168.70.2,192.168.70.3,192.168.70.4 wsrep_cluster_address = gcomm://239.192.0.11 And this…

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

…_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad to announce… all the bug fixes from latest Percona Server 5.5 release (currently Percona Server 5.5.31-30.3). New Features: Percona Server has…, bug fixed #1154954. Release notes for Percona Server for MySQL 5.6.11-60.3 are available in our online documentation…

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

….  If you try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE…`.`test` DROP INDEX `col2`; # ######################################################################## # Summary of indexes # ######################################################################## # Size Duplicate Indexes 5 # Total Duplicate Indexes 1 # Total Indexes 3 Additionally, pt-duplicate…