… the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific …. You can also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a …is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6,…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… possible. An example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit… discover which node is causing flow control. I would strongly recommend monitoring and graphing wsrep_flow_control_sent so you can…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… But lets assume you have not followed these recommendations to the book or some things just slipped … not panic and go change all kind of configuration options in case you get lucky. Sometimes you do…side load. Setting up 2 MySQL Servers side by side (for example with MySQL Sandbox) can especially be…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…: Can you recommend a three node cluster for production use? A: Yes, that’s the recommended configuration. The … on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: … process, it gets bootstrapped because of this option, and you can end up having 2 …
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
…configure, tune, start/stop MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL…MySQL. No problems there. It’s now clear that I never recommend…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…MySQL server running on localhost. In order to achieve this, we will configure HaProxy on the client node. There are 2 possible configurations…log global mode http option tcplog option dontlognull retries 3 option redispatch maxconn 2000 …only_from = 0.0.0.0/0 # recommended to put the IPs that need # …
Post: Percona XtraBackup 1.6.3
September 23, 2011 By 5 Comments
…XtraBackup failed when innodb_flush_method in the server configuration file was set to ALL_O_DIRECT. Bug…Note that this fix may not work correctly with MySQL 5.5 or Percona Server 5.5 prior…_file_per_table option is being used, an upgrade to XtraBackup 1.6.3 isstrongly recommended. Under this scenario…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…fact an odd number is recommended in that kind of … setup (no special galera options), 2 nodes: two running nodes…mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL…Ignoring possible split-brain (allowed by configuration) from view: view(view…
Post: Timezone and pt-table-checksum
September 25, 2012 By 1 Comment
…here is how MySQL handles …configured in PDT time while node2 is configured in EDT time. Now, lets insert some rows into a table with timestamp field configured…is the recommended practice – …crc | +———-+————+ | 4cdfe786 | 4cdfe786 | +———-+————+ This same option can …
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
…backup of choice on a node and optionally keep the node out of production …you configure. The HAproxy daemon will listen on those two separate ports with separate configurations, …MySQL server in question. It should be easy to use this tool to monitor at least some of the monitoring recommendations…
