MaxScale, an open-source database-centric router for MySQL and MariaDB makes High Availability possible by hiding the complexity of backends and masking failures. MaxScale itself however is a single application running in a Linux box between the client application and the databases - so how do we make MaxScale High Available? This blog post shows how to quickly setup a Pacemaker/Corosync environment and configure MaxScale as a managed cluster resource. We will guide you step by step on how to enable basic High Availability by setting up three Linux Centos 6.5 servers with MaxScale.
Let's assume you want to start an automatically expanding and shrinking MySQL replication cluster with up-to seven database servers. This blog shows how to setup up and start MaxScale to work with a master and a single slave and, when needed, how it adapts to the changing cluster configurations. While the set up here is simple similar behavior can be applied in bigger and more complex scenarios.
The server weighting feature of MaxScale may initially be seen as a way to influence load balancing for unequal servers, but it can also be useful for other reasons. Here we look at how we can use it to segregate different workloads within a cluster of MariaDB or MySQL servers.
Today we will use the MariaDB Cluster cluster we created in the previous two blog entries, and tie it all together with an HA Proxy virtual machine setup with separate read and write pools. This assumes your application is already using different connections for reads and writes, or you're using MaxScale, MySQL Proxy, etc to splits reads and writes.
Set up a 3-Node MariaDB Cluster with HA Proxy on VirtualBox
Today we will build a three node MariaDB Cluster 5.5 using the Oracle VirtualBox virtual machine template we created in Part 1.
For this tutorial, we will need three IP addresses. I will be using the following. I recommend noting what IP addresses you will be using unless you're going to use the same.
This is a blog post series on setting up a 3-node MariaDB Enterprise Cluster with HA Proxy on VirtualBox. In this first part we will set up a virtual machine template using Oracle VirtualBox.
We are proud to finally release a fully blown training course for MariaDB Galera Cluster. We've been working on this training course for a very long time and it's been over a year since we delivered a first version of the course. However, the refining process has taken longer than expected. While we have already delivered this training multiple times internally for our customers, it is not until now that we make the course public together with upcoming training dates.
Als Nachbetrachtung zum deutschsprachigen Webseminar "Galera Cluster und MariaDB Enterprise" - die Aufzeichnung finden Sie hier - möchte ich in diesem Blog Post die Gelegenheit nutzen nochmals auf die wichtigsten Fragen einzugehen, die im Webseminar von den zahlreichen Teilnehmern gestellt wurden.
This past summer, when I joined SkySQL’s development team as product manager for MariaDB Enterprise, it became clear to me that the product needed to solve a specific, defined problem for customers trying to use MariaDB for business critical applications. Something that could be easily implemented, but that would remove a significant pain point.