Codership has released patches for MySQL to address security issues and improve stability.
Codership-mysql is a software that includes write set replication patches for MySQL that are maintained by the Codership team. These patches incorporate MySQL/Innodb engine hooks to allow users to create an external replication system for their MySQL servers. The system built using these hooks can either be asynchronous or synchronous and can offer single or multi-master support.
The write sets management is achieved through these hooks, with populating of write sets on the sending side and applying them on the receiving end. The application is done through high priority transactions, with Innodb lock manager being modified to prioritize dedicated high priority MySQL threads.
Furthermore, Codership-mysql also offers features to enable "total order isolated" processing of several SQL statements. This feature ensures that the SQL statements are processed in the same order and without any interruption on each MySQL server within the cluster. This is a critical feature for DDL statements as they need to be processed in isolation to maintain data consistency in the cluster.
Overall, Codership-mysql's write set replication patches and added features make it a robust tool for anyone looking to build an external replication system for their MySQL servers.
The write sets management is achieved through these hooks, with populating of write sets on the sending side and applying them on the receiving end. The application is done through high priority transactions, with Innodb lock manager being modified to prioritize dedicated high priority MySQL threads.
Furthermore, Codership-mysql also offers features to enable "total order isolated" processing of several SQL statements. This feature ensures that the SQL statements are processed in the same order and without any interruption on each MySQL server within the cluster. This is a critical feature for DDL statements as they need to be processed in isolation to maintain data consistency in the cluster.
Overall, Codership-mysql's write set replication patches and added features make it a robust tool for anyone looking to build an external replication system for their MySQL servers.
What's New
Version 0.6.1: N/A