…create the cluster, perform the following command on one server only: [root@percona1 ~]# ccs -f /etc/cluster/cluster.conf –…MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… actual physical volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual machines tend… MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-… test.test # ######################################################################## # Key redundant ends with a prefix of the clustered index # Key definitions: # KEY `redundant` (`col2`,`id`) # …
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
…if you’re using the Percona XtraBackup with Percona XtraDB Cluster. This release is the latest stable release in the …of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… of the MySQL Community: Vadim Tkachenko, Percona co-Founder and CTO, will talk about Percona XtraDB Cluster, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… #1174426. Fixed the Percona-Server-shared-55 and Percona-XtraDB-Cluster-shared RPM package dependences. Bug fixed #1050654. Fixed the upstream… the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…This scenario can happen when you want to perform a planned failover. With GTIDs, all the … GTIDs: having for each event across the cluster a monotonically incremental identifier for each event. …For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And …
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… to announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are… impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona XtraDB Cluster has fixed number of….user_send_window could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL port would be used when…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
…, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, …Jay Janssen, Consulting Lead, Percona Topic: “Migrating to Percona XtraDB Cluster” Mark Atwood, Vipul Sabhaya, and Jim Cooley, HP Topic: “…
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 … similar to Percona XtraDB Cluster in that if you want an async event replicated to the whole cluster you have to have…, and because cluster performance is somewhat dependent on the slowest node – this overhead can easily become visible on the whole cluster and your…
