…MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a warm standby server which is flipped into service if the active…have…You will need Percona Server in order to use innodb_fake_changes. Thread pool Percona Playback added a connection…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…have a supported version of this code, it was agreed that Monty would rewrite this and MySQL Inc would provide a supported MySQL…active connections” when determining a thread pool size. FYI, it was really hard to do a SHOW PROCESSLIST with so many connections…
Post: How Does Semisynchronous MySQL Replication Work?
January 19, 2012 By 24 Comments
…you commit a transaction, the commit does not complete until all replicas have also committed successfully. In MySQL…connection…have reached any slave. Finally, I would be interested to hear how many people are actually running semi-synchronous replication in production. I have…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… when you have to ALTER the table otherwise it can easily cause a stall as many threads can get piled up waiting for table metadata lock bringing down the MySQL server or causing all the connections… with how Active MQ uses MySQL when in HA mode. In HA mode there are two Active MQ …
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… for your screen as many connectors that are sold have a wrong pin layout (… NTSC) connector. Once you have your hardware, here is how to get Percona Server for MySQL up and running…active (sshd=ssh daemon, a software package allowing you to connect to a [Linux] server console/command prompt). Connect…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…call an Active Cache meaning it takes care of the misses itself, without you have to …you have item invalidated from query cache and there are multiple connection requesting the same item. What MySQL will… Improve Manageability What is in the MySQL Query Cache ? How many hits did we get for this query…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
…be connected to. name The name of this local node (first 5 characters). This is handy when you have…distance — This is a general indicator of how many parallel replication threads you could use. In practice I haven…to it. There isn’t any replication queue activity, and I find this is common except …
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
Many of the prominent companies in the MySQL… about how we’ll work with you, so …You hire Percona to review the architecture. We do not authorize you to mention our name in connection…this is rare. Most vendors have active sales efforts, so … If you have any questions or comments, I invite you to…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…you have workload which includes some very long SELECT queries you…mysql client, so you might get a feel you can’t connect to the database at all (use mysql…you‘re just using Innodb tables and you‘re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway) you…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…many aspects of MySQL replication, but my main focus will be the logistics – how replication events are written on the master, how…you connect…you got that right – it is reads that are limiting replication performance, not writes. Let me explain this further. Assume you have…
