… 5.5.31 will handle them all, also XB 2.1 is required for most). Finally, the HAProxy. HAProxy is one…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
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
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…, this isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a… our my.cnf: wsrep_provider_options = “gmcast.mcast_addr=239.192.0.11″ If you already have wsrep_provider_options set… address: #wsrep_cluster_address = gcomm://192.168.70.2,192.168.70.3,192.168.70.4 wsrep_cluster_address = gcomm://239.192.0.11 And this works…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… -q pacemaker pacemaker-1.1.7-6.el6.x86_64 [root@percona1 ~]# rpm -q corosync corosync-1.4.1-7.el6_3.1.x86_64 Everything is working 
Let’s update our system to 6.4 on one server….4 (Final) [root@percona1 ~]# rpm -q pacemaker pacemaker-1.1.8-7.el6.x86_64 [root@percona1 ~]# rpm -q corosync corosync-1.4.1-15.el6_4.1…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… t; +———-+ | count(*) | +———-+ | 0 | +———-+ Can we still use master_auto_position = 1? Let’s hope so, as it is one of the…_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba:1, 3d3871d1-c3ae-11e2-b986-0800272864ba:1-4 We can see that it’s not obvious…: is it 219be3a9-c3ae-11e2-b985-0800272864ba:1 or 3d3871d1-c3ae-11e2-b986-0800272864ba:4 ? A ‘Last_Executed_GTID’ column would have…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…” align=”alignright” width=”247″] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce the… lead to unresolved package dependencies when installing Percona Server 5.1. Bug fixed #893860. The log tracker thread was unaware of… #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… with a two-NIC bonded pair you’ll get roughly 1.67x the throughput of a single port. [Don’t try…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… is glad to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available…. It’s advised to upgrade your latest 2.1 version to 2.1.3 if you’re using the Percona XtraBackup with…. Release notes with all the bugfixes for Percona XtraBackup 2.1.3 are available in our online documentation. Bugs can be…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row… t as SELECT ld.label_id, cai.inventory_id, COUNT(1) as installed_count from client_app_inventory cai inner join… NULL) group by ld.label_id, cai.inventory_id All 4 tables in the query are locked!
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… common in OLAP analysis. Each query in each flight (Q1.1 for example) is tested with a cold buffer pool. Then… InnoDB. SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database is cold… substantially faster than InnoDB both cold and hot. SSB Flight #4 There is one query in this flight, Q4.3, which…
