… And create the cluster, perform the following command on one server only: [root@percona1 ~]# ccs -f /etc/cluster/cluster.conf –createcluster lefred…quorum… [ OK ] Starting fenced… [ OK ] Starting dlm_controld… [ OK ] Tuning DLM kernel config… [ OK ] Starting gfs_controld… [ OK ] Unfencing…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… other magic that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit controls when flow… as soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider… 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
… can be modified cluster-wide is once per RTT. What about WAN clusters? Callaghan’s law applies to WAN clusters as well. LANs… multiple cluster nodes simultaneously. You can. It does NOT set an lower bound on performance, only a upper bound. The best performance you… you can update much faster. I see this tuning very frequently for “performance” reasons when data durability isn’t as crucial. This…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
…s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” Luís Soares, … Jay Janssen, Consulting Lead, Percona Topic: “Migrating to Percona XtraDB Cluster” Mark Atwood, Vipul Sabhaya, and Jim Cooley, HP Topic: “…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… of Hardware OS And Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well… and see how you can get advantage of Innodb properties – clustering by primary key, having primary key in all indexes (so… (try to be easy on indexes). With these basic innodb performance tunings you will be better of when majority of Innodb users…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… around 100ms. All environments used Percona Server or Percona XtraDB Cluster server 5.5.24. Innodb durability was disabled for all…). XtraDB Cluster 1-colo 3 nodes in one datacenter. Writes were only done on a single node. The cluster contained the tuning: wsrep…_support_xa being disabled in the PXC environments Semi-sync performs dismally under concurrency. Think about it, our single inserts took…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… big tables, a secondary index reserves different extents from the clustered index. Q4: Does Innodb ever merges sequential pages together if…(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent environments. Sets the max\ imum number of…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…, it will only perform an IST. When I mention bootstrapping here and in the webinar, I mean wsrep_cluster_address=’gcomm://’ and… split. Q: How does latency and bandwidth affect performance? Is it practical to buildthe cluster over a wan connection with ~ 5 ms…’t have any specific recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments, you may want…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…amazingly useful metric for discovering periods of poor performance), and more. Analyze the distribution of service times… typical response time (which will usually be clustered tightly, given that this is an exponential … get some “static”, sort of like de-tuning the radio just a little bit (if…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… Optimizer – such as in memory nature of MEMORY storage engine, clustering by Primary key in Innodb and distributed nature of NDB… deal with balancing – allocating resources to different storage engines and performance tuning becomes more complicated. Now what is interesting for probably 95…
