…several new features that MySQL 5.6 brought: GTID-based replication…-prefix of col2_2 # Key definitions: # KEY `col2` (`col2`), # KEY `col2_2` (`col2`,`col3`) #… # Key redundant ends with a prefix of the clustered index # Key definitions: # KEY `redundant` (`…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… on MySQL 5.6 GTIDs. You can find part one here. Our goal will be to go from setup #1 to setup #2… the ideas of GTIDs: having for each event across the cluster a monotonically incremental identifier for each event. Notice that this…=10002; mysql> start slave; # And then check the number of records from the t table s1> select count(*) from t; +———-+ | count(*) | +———-+ | 2…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2 ] Now we can upgrade all servers to 6…Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL is still running: [root@percona2 …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…of a single port. [Don’t try more than 2; the additional work that the kernel has to …only worked with one customer that’s using 5.6), is that I question its readiness. There have …say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…clusters I’ve seen a lot of people setting up clusters with 3-6… # 2 nodes in the cluster…mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql]# service mysql…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
…. MySQL Cluster and MySQL Press were announced during this event; “High Performance MySQL” 1st edition written by Jeremy and Derek was also available. MySQL 4… promises what the final version will contain. MySQL 5.5.11 is GA and MySQL 5.6.2 is nonGA. 2012 marks the first… announces Percona XtraDB Cluster as GA – the new approach to MySQL High Availability in and out of the Cloud. MySQL 5.5.23…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… MySQL 5.6 and Percona XtraDB Cluster We started beta support for MySQL 5.6 in 2.1.8 when 5.6 was still beta. Now that MySQL 5.6… to MySQL 5.6, be sure to upgrade to Percona Toolkit 2.2, too. We also started beta support for Percona XtraDB Cluster in 2.1…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…dpkg and binary packages remain unchanged. Percona XtraDB Cluster was also affected by this bug and …(Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex… Release notes for Percona Server for MySQL 5.5.30-30.2 are available in our online documentation…
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
… it quite a bit and expanded to fit (hopefully) a 6 hour format. Expect a lot of down and dirty hands…/percona-xtradb-cluster-galera-practice-part-1 http://www.percona.com/live/mysql-conference-2013/sessions/percona-xtradb-cluster-galera-practice-part-2 Migrating to Percona XtraDB Cluster for MySQL This is a…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. … in CentOS 6.3 during installation. Bug fixed #1031427 (Ignacio Nin). In case the Percona XtraDB Cluster was …2 including all the bug fixes in it and on Codership wsrep API 5.5.30-23.7.4, Percona XtraDB Cluster…
