… relative to the size of the receive queue (visible via the wsrep_local_recv_queue global status variable). Donor/Desynced nodes do… committed and the oldest unapplied transaction small. The larger the queue is, the more costly certification gets. EDIT: actually the cost… writes coming from them. However, with multi-node writing, larger queues will make certification more expensive replication conflicts more likely and…
Comment: Is Synchronous Replication right for your app?
May 15, 2013 By 18 Comments
All this talk of queues and they are likely to be a worst-case for … skip-locked or even more support to improve innodb-as-queue concurrency with and without Galera? http://asktom.oracle.com/pls…
Comment: Is Synchronous Replication right for your app?
May 16, 2013 By 18 Comments
… a system that uses a separate service for a message queue, not MySQL at all. E.g. ActiveMQ, RabbitMQ, Resque, etc…
Comment: Is Synchronous Replication right for your app?
May 16, 2013 By 18 Comments
… standalone Innodb, let alone Galera. I had considered a job queue system in Innodb in the past that, in absence of…
Comment: Is Synchronous Replication right for your app?
May 15, 2013 By 18 Comments
… before committing: Your apps send frequent updates into a message queue. Then a consumer thread reads from the MQ and applies…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… and while the first is still in the local apply queue on their nodes will get a deadlock error. So, the…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… via a lightweight python app (using multi threading and internal queues) that accepted connections from the app (php, java, python, etc…
Post: Using MySQL as a Queue, and Free Percona Live Tickets
September 15, 2011 By Leave a Comment
…: Many people realize the difficulties in building a good job queue or batch processing system, and try not to create one inside MySQL. Although the job queue is a great design pattern from the developer’s point… in a relational database. However, experience shows me that job queues sneak up in unexpected ways, even if you’re a…
Post: Why message queues and offline processing are so important
August 10, 2010 By 3 Comments
… in the foreground to instead be sent to a message queue, or Gearman. Or in plain English: The same MySQL…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… remove them in the future. Queue This is information about the replication queues in both directions. The ‘Up’ queue is outbound replication. This… nearly immediately. Local certification failures only happen when the inbound queue is > 0. Instead brute force aborts are applying writesets rolling…
