Percona XtraDB Cluster (PXC) was released over a year ago and since then …. As such, I’m giving a webinar entitled Percona XtraDB Cluster Operations on June 26th 2013 from 10-11AM PDT. Topics will include: Backups from the cluster Avoiding SST Flow Control What and How to Monitor Tuning best practices This webinar is not…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL is still running: [root@percona2 percona]#…quorum… [ OK ] Starting fenced… [ OK ] Starting dlm_controld… [ OK ] Tuning DLM kernel config… [ OK ] Starting gfs_controld… [ OK ] …
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
…MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” Luís Soares, Senior Software Engineer, Oracle Topic: “MySQL…Janssen, Consulting Lead, Percona Topic: “Migrating to Percona XtraDB Cluster” Mark Atwood, Vipul Sabhaya, and Jim Cooley, HP Topic:…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…, I delivered a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered (by… soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs… limits the amount of delay any node in the cluster might have applying cluster transactions. Therefore, it keeps reads more up to…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication…cluster-wide is once per RTT. What about WAN clusters? Callaghan’s law applies to WAN clusters … update much faster. I see this tuning very frequently for “performance” reasons when …
Post: MySQL and SSD | Percona XtraDB Cluster talks
September 13, 2012 By Leave a Comment
… XtraDB Cluster: HA solution for MySQL“. I will give introduction in MySQL clustering and show how Percona XtraDB Cluster solves HA and scalability problems. MySQL and SSD: usage and tuning…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
… up to Rick’s talk might be: Advanced query optimizer tuning and analysis This 3 hour session is being given by… MySQL conference. There are several MySQL HA related tutorials: Using Tungsten Replicator to solve replication problems (3 hr) Ramp-up tutorial for MySQL Cluster – Scaling with continuous availability (6 hr) Percona XtraDB Cluster / Galera in Practice (6 hr) But…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…, galera and built-in mysql replication are independent from each other. Q: I installed Percona as cluster database working with Zabbix (innodb…’t have any specific recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments, you may want…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
…Cluster, MariaDB, Amazon RDS for MySQL, Drizzle, and Oracle MySQL, MySQL 5.6 is fully supported by our MySQL Consulting, MySQL Support, MySQL Server Development, and MySQL…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 22 Comments
… your cluster and do not worry that eventually you get out-of-sync situation, as it regularly happens with regular MySQL replication… XtraDB Cluster provides it, and let’s see how it works. With our Cluster you can write to any node, and the Cluster… replication. Slave can have many parallel threads, and you can tune it by variable wsrep_slave_threads Second: There might be…
