… PDT. Topics will include: Backups from the cluster Avoiding SST Flow Control What and How to Monitor Tuning best practices This webinar…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…, but that is beyond the scope of this post. Tuning flow control Flow control is triggered when a Synced node exceeds a specific threshold… flow control What happens during flow control Simply speaking: flow control makes replication stop, and therefore makes writes (which are synchronous) stop, on all nodes until flow control…
Post: Using flow control functions for performance monitoring queries
May 24, 2008 By 12 Comments
I’m not big fan on flow control functions like IF or CASE used in MySQL Queries as …
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… which node was the originator of the transaction. Flow Flow gives some information about Flow Control events. Galera has some sophisticated ways of metering… flow control. This is a general indicator that flow control is slowing replication (and hence overall cluster writes) down. snt wsrep_flow_control_sent — how many flow control…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… contact with one another and then both try to take control of shared resources or provide simultaneously the cluster service. On…-d509-11e1-0800-013f68429ec1 120724 10:58:09 [Note] WSREP: Flow-control interval: [8, 16] 120724 10:58:09 [Note] WSREP: New…-0800-013f68429ec1 2012-07-24 11:42:51.292 INFO: Flow-control interval: [9999999, 9999999] 2012-07-24 11:42:51.292…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… masters. Let’ s have a look first at the normal flow: Replication flow: [1] When you setup MySQL replication, you define the… master should also replicate events : Closer look: Infinite Replication Loop flow: If you have master-master with slaves or if you… like mmm can cause failover if you stop replication # mmm_control @production set_passive (to avoid automatic failover) 2. stop replication…
Comment: Using flow control functions for performance monitoring queries
May 28, 2008 By 12 Comments
… example a retrograde thinking: “I’m not big fan on flow control functions like IF or CASE used in MySQL Queries as… in such way that will handle well those if/case control functions. It’s time for MySQL RDBMS to evolve.
Comment: Using flow control functions for performance monitoring queries
May 24, 2008 By 12 Comments
The flow control technique to control the monitor seems to be cool. I will surely learn to operate the monitor using this technique.
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… much harder task than it seems. But that’s under control. Fortunately, we have three great people here at Percona working… the mad scientist topics. So, please get your creative juices flowing, and submit those session and tutorial proposals on DRBD, partitioning…
Comment: Using flow control functions for performance monitoring queries
May 28, 2008 By 12 Comments
… be optimized as well as equivalent set of queries without flow control functions.
