… from standard mysql replication. 1 master with 5 async …ip ro add dev eth1 224.0.0.0/4 [all nodes]# ip…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…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… later evolved into “MySQL Enterprise,” and MySQL 5.0 is finally available as GA with version 5.0.20a… MySQL 5.1 is in development (5.1.9) 2007… and announced Percona XtraDB as improved and extended Innodb Plugin version, MySQL 5.1 is FA with 5.1.34 and MySQL 5.4.0 is in… XtraDB Cluster as GA – the new approach to MySQL High Availability in and out of the Cloud. MySQL 5.5.23 is GA and 5.6.5…
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 available… are in the range [0, 255] (inclusive). Quorum is computed using weighted sum over group members. Percona XtraDB Cluster binary will now… impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona XtraDB Cluster has fixed number…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… support for 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… four base versions of MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four major forks (Percona Server, MariaDB, Percona XtraDB Cluster, and MariaDB…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump … May Not Even Work! MyISAM tables are supported within Percona XtraDB Cluster, however, MyISAM has only basic support, primarily because the… async master <= 5.0 though, you can workaround this by turning off wsrep_auto_increment_control from the Percona XtraDB Cluster nodes as…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… XtraBackup for MySQL 2.0.6, plus the following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6…/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool dump files). Percona XtraBackup can use XtraDB changed page tracking feature to…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
…MySQL Sunny Bains, Senior Principal Software Engineer, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5… 5.6” Jay Janssen, Consulting Lead, Percona Topic: “Migrating to Percona XtraDB… Program Topic: “MariaDB 10.0 & What’s New With …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is… in the 2.0 series. New Features: This version of Percona XtraBackup has implemented full support for new MySQL 5.6 features (GTID… support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…, XtraBackup drives down backup costs while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved…’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin… removed in Percona XtraBackup 2.1. Percona XtraBackup can use XtraDB changed page tracking feature to perform the Incremental Backups now…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… Live, I delivered a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered… cluster permission to continue replication. This setting traditionally defaulted to 0.5, meaning the queue had to fall below 50% of the… be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES; gcs.fc_factor=1.0“; Working…
