… 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: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…_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: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… 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…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
…mathew: Wrong, it’s still the same in 5.5. Here is the related output from show engine innodb status: —… rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row… NULL) group by ld.label_id, cai.inventory_id All 4 tables in the query are locked!
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… 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: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only… substantially faster than InnoDB both cold and hot. SSB Flight #4 There is one query in this flight, Q4.3, which… better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… and extended Innodb Plugin version, MySQL 5.1 is FA with 5.1.34 and MySQL 5.4.0 is in a nonGA version… MySQL Alternatives including keynotes for Drizzle and MariaDB. MySQL 5.5 replaced MySQL 5.4 as next planned GA release. Percona releases GA version… source alternative to Innodb Hot backup. MySQL 5.1.46 is GA and MySQL 5.5.4 is not GA at the time of…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… huge problems (it’s anyway no longer supported from MySQL 5.5). If you want to know more details, please read on… set master-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5.5, the situation has slightly changed. First the master…_Log_File: mysql_sandbox18676-relay-bin.000001 Relay_Log_Pos: 4 [...] As stated in the documentation, the connection parameters are still…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… glad to announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are… it and on Codership wsrep API 5.5.30-23.7.4, Percona XtraDB Cluster 5.5.30-23.7.4 is now the current stable…-source and free. Release notes for Percona XtraDB Cluster 5.5.30-23.7.4 are available in our online documentation. We did…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
…-8577-11e2-a3d7-080027635ef5:1-5 Executed_Gtid_Set: 7d72f9b4-8577-11e2-a3d7-080027635ef5:1-4 There are different ways to find… has retrieved transactions 1 to 5 but has only executed 1 to 4. That means that transaction 5 is the one that is…. STOP SLAVE; SET GTID_NEXT=”7d72f9b4-8577-11e2-a3d7-080027635ef5:5“; BEGIN; COMMIT; SET GTID_NEXT=”AUTOMATIC”; START SLAVE; [...] Retrieved_Gtid…
