… replication. 1 master with 5 async slaves is going to send a separate replication stream to each, so your bandwidth requirements…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… may be broken. Scenario #3: The master has crashed before sending all writes If the binary logs of the master are…
Comment: Is Synchronous Replication right for your app?
May 16, 2013 By 18 Comments
… all. E.g. ActiveMQ, RabbitMQ, Resque, etc. All applications would send updates to the MQ in lieu of writing directly to…
Comment: Is Synchronous Replication right for your app?
May 15, 2013 By 18 Comments
… you update a row multiple times before committing: Your apps send frequent updates into a message queue. Then a consumer thread…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… errors and not so much the waiting, you could simply send all your writes to one node. This should prevent the…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… 109 0 0 Notice node3′s queue fills up, it sends 1 flow control message (to pause) and then Flow control…
Comment: How to start a Percona XtraDB Cluster
April 27, 2013 By 10 Comments
…-cluster-address=”gcomm://” option, or anything else you want to send along to mysqld. I needed this to bootstrap my cluster…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… file system (instead of xfs). Use FLUSH LOGS instead of sending SIGHUP When copytruncate is disabled, MySQL must be told to… the slow log file. There are two options for signaling: Send a HUP signal to the mysqld process. Use the mysql…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… (Raghavendra D Prabhu). High values in variables evs.send_window and evs.user_send_window could trigger cluster crash under high load…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… be 36 hours. For our mysqlbinlog processes, we have it sending nsca alerts every 30 seconds and have it alert when… hour If backups throw an error and are aborted, we send a critical alert immediately to be investigated The number one…
