Read-Write Splitting for Java Apps Using Connector/J, MySQL Replication and HAProxy
In a previous post, we looked into load balancing for PHP apps and how to configure read-write splitting on MySQL Replication setups. The native PHP MySQL driver (php-mysqlnd_ms) would perform read/write splits, and the MySQL...
New Whitepaper: MySQL Replication for High Availability
MySQL Replication is probably the most popular high availability solution for MySQL, and widely used by top web properties like Twitter and Facebook. Although easy to set up, ongoing maintenance like software upgrades, schema changes,...
MySQL Replication Failoverv – Maxscale vs MHA: Part Three
In our previous two posts we described in depth how MySQL Master-HA (MHA) and MaxScale + MariaDB Replication Manager (MRM) both perform their so called slave promotions (also known as master failover). MHA has been...
MySQL Replication Failover – Maxscale vs MHA: Part Two
In our previous post, we described how MySQL Master-HA (MHA) performs a so called slave promotion (also known as master failover) and ensures all remaining slaves in the topology get attached under the new master...
MySQL Replication Failover – Maxscale vs MHA: Part One
In our MySQL replication tutorial we have covered different aspects of replication including master failover by performing a slave promotion using ClusterControl. The slave promotion will turn a slave into the new master, and re-attach...
High Availability Read-Write Splitting with php-mysqlnd, MySQL Replication and HAProxy
MySQL Replication is used in a variety of use cases - scale out read workloads, provide high availability and geographic redundancy, offload backups and reporting/analytic jobs. However it has a big drawback - the application...
Webinar Replay: Managing MySQL Replication for High Availability
Thanks to everyone who participated in this week’s live webinar on Managing MySQL Replication for High Availability led by our colleague Krzysztof Książek, Senior Support Engineer at Severalnines. The webinar included theory discussions bundled with...
Webinar Replay: Performing Live Database Upgrades in Replication & Clustered Setups
Thanks to everyone who joined us for our recent live webinar on performing live database upgrades for MySQL Replication & Galera, led by Krzysztof Książek. The replay and slides to the webinar are now available...
Webinar Replay: Schema Changes for MySQL Replication & Galera Cluster
Thanks to everyone who joined us for our recent live webinar on ‘Schema Changes for MySQL Replication & Galera Cluster’ led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the...
Replicate from a MySQL Server into a Galera Cluster
This article describes how to setup replication between a regular MySQL server and a Galera Cluster. The regular MySQL Server is the MASTER , and one of the Galera nodes will be the SLAVE: In...