(Ulf Wendel) Replication is as old as life on earth. No life without replication. MySQL replication is as old as MySQL, almost. No MySQL without replication.
Tag: Open Source
MySQL Connection Timeouts
(Peter Zaitsev) Sometimes on very busy MySQL server you will see sporadic connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If you have connects timed in your application you will see some successful connections taking well over the second.
Monitoring Table and Index IO with PERFORMANCE_SCHEMA
(Mark Leith) Another new feature of performance_schema within 5.6 is the ability to monitor both table and index IO – this was added in two parts:
SkySQL Builds MySQL Reference Architecture
(Sean Michael Kerner) Deploying a MySQL database today to meet modern infrastructure demands isn’t as easy as it used to be.
MySQL 5.6: Index Condition Pushdown
(Olav Sandstå) Index Condition Pushdown (ICP) is one of the new optimizer features in the MySQL 5.6.2 milestone release. The goal with Index Condition Pushdown is to move as much as possible of the processing of conditions (mainly WHERE clauses) from the server to the storage engine.
Sharing user credentials between MySQL Servers with Cluster
(Andrew Morgan) The Developer Release for MySQL Cluster 7.2 includes a new feature that allows the system data required for checking user access to be shared amongst all of your MySQL Servers. By default all of the tables holding these credentials are stored in MyISAM and so are local to that MySQL
Setting up Multi-master and read slaves using Severalnines
(Johan Andersson) This tutorial shows how you can use the Severalnines Configurator for MySQL Replication to deploy a Multi-master replication setup, and install ClusterControl.
Dramatically Increased MySQL Cluster JOIN performance with Adaptive Query Localization
(Andrew Morgan) Regular readers of this Blog or attendees at the 2010 O’Reilly MySQL Conference may recall a feature that the MySQL Cluster team were working to speed up JOINs (see Jonas’s slides from that conference here). The good news is that work has continued since then and it is now part of th
Xeround Autoscales MySQL
(Sean Michael Kerner) How do you figure out how much database capacity you actually need?
Replication Event Checksum
(Mats Kindahl) MySQL replication is fast, easy to use, and reliable, but once it breaks, it can be very hard to figure out what the problem is. One of the concerns often raised is that events are corrupted, either through failing hardware, network failure, or software bugs. Even though it is possibl