…, 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: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… multiple cluster nodes simultaneously. You can. It does NOT set an lower bound on performance, only a upper bound. The best performance you…
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… other magic that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit controls when flow… example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… so our dpkg and binary packages remain unchanged. Percona XtraDB Cluster was also affected by this bug and will also have… on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster…, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and… not responsive because of swapping is pretty bad for a cluster and we often ended up is strange, unexpected states. What…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… performance issue. Still MYSQL load was very high but site was not going down. Then we did some R&D on Percona MYSQL… file, site performance was good. But from second day again performance degradation started and now it is slow again. MySQL load is not….2.15 (CentOS) PHP Version – 5.3.3 MySQL – 5.1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP…
Post: Tutorial Insights for Percona Live, London
August 24, 2011 By Leave a Comment
… NDB Cluster/MySQL Cluster technology which is rapidly gaining popularity for building high performance and highly available systems with MySQL. Initially designed for Telecom Applications MySQL Cluster… experienced MySQL Cluster consultants in United States, having worked with MySQL Cluster deployments in many high scale mission critical applications. Yves specializes in MySQL Cluster Performance Optimizations…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
…’d expect folks interested in efficient schema design for high performance to get a lot of out of Rick’s talk… 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: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…MySQL Replication Latency in Percona XtraDB Cluster[/caption] I was curious to check how Percona XtraDB Cluster behaves when it comes to MySQL replication… the different tables on the different nodes. Summary: Percona XtraDB Cluster performs very well when it comes to small transactions offering very…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… test to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is… quorum: By ignoring the quorum, we ask to the cluster to not perform the majority calculation to define the Primary Component (PC… comes back it will perform its IST or SST. In conclusion: 2 nodes cluster is possible with Percona XtraDB Cluster but it’s…
