High-availability

Choosing MySQL High Availability Solutions

Group Replication

In this blog post we’ll look at various MySQL high availability solutions, and examine their pluses and minuses.
High availability environments provide substantial benefit for databases that must remain available. A high availability database environment co-locates a database across multiple machines, any one of which can assume the functions of the database. In this way, […]

Read more

Take Percona’s one-click high availability poll

high availability

Wondering what high availability (HA) solutions are most popular? Take our high availability poll below!
HA is always a hot topic. The reality is that if your data is not available, your customers cannot do business with you. In fact, estimates show the average cost of downtime is about $5K per minute. With an average […]

Read more

How We Made MySQL Great Again, or Upgrading MySQL with Orchestrator

Upgrading MySQL with Orchestrator

In this blog post, we’ll discuss upgrading MySQL with Orchestrator.
I recently had a client, Life360, that wanted to upgrade from Percona Server 5.5 to Percona Server 5.6, and implement GTID in their high transaction environment. They had co-masters and multiple read slaves.
Orchestrator made this job much easier for us. My colleague, Tibi, recently posted about […]

Read more

Docker MySQL Replication 101

Docker

In this blog post, we’ll discuss some of the basics regarding Docker MySQL replication. Docker has gained widespread popularity in recent years as a lightweight alternative to virtualization. It is ideal for building virtual development and testing environments. The solution is flexible and seamlessly integrates with popular CI tools.
 
This post walks through the setup of MySQL replication […]

Read more

How MaxScale monitors servers

maxscale monitors servers

In this post, we’ll address how MaxScale monitors servers. We saw in the
We saw in the previous post how we could deal with high availability (HA) and read-write split using MaxScale.
If you remember from the previous post, we used this section to monitor replication:

Shell

[Replication Monitor]
type=monitor
module=mysqlmon
servers=percona1, percona2, percona3
user=maxscale
passwd=264D375EC77998F13F4D0EC739AABAD4
monitor_interval=1000
script=/usr/local/bin/failover.sh
events=master_down

123456789

[Replication Monitor]type=monitormodule=mysqlmonservers=percona1, percona2, percona3user=maxscalepasswd=264D375EC77998F13F4D0EC739AABAD4monitor_interval=1000script=/usr/local/bin/failover.shevents=master_down

But what are […]

Read more

High availability with asynchronous replication… and transparent R/W split

High availability with asynchronous replication

In this post, the first one of a Maxscale series, I describe how to use MariaDB’s MaxScale and MySQL-utilities with MySQL Asynchronous replication.
When we talk about high availability with asynchronous replication, we always think about MHA or PRM. But if we want to transparently use the slave(s) for READs, what can we use ?
Description:

Three MySQL servers, […]

Read more

Better high availability: MySQL and Percona XtraDB Cluster with good application design

High Availability
Have you ever wondered if your application should be able to work in read-only mode? How important is that question?
MySQL seems to be the most popular database solution for web-based products. Most typical Internet application workloads consist of many reads, with usually few writes. There are exceptions of course – MMO games for […]

Read more

MySQL 5.7 first impressions on group-replication

During the last few weeks I’ve been testing and playing a bit with the new group-replication plugin available for MySQL 5.7. Before continuing I’d like to clarify some aspects: the plugin is only available in labs and is not yet ready for production. The current version is 0.6. I used 5.7.9 GA running in a Vagrant […]

Read more

Webinar: Writing Application Code for MySQL High Availability Followup Questions

Thanks to all who attended my webinar last week on Writing Application Code for MySQL High Availability.  This blog is for me to address the extra questions I didn’t have time to answer on the stream.
What do you think about using Galera Cluster but writing to a single Node with LVS ?
Whatever HA strategy you […]

Read more

Playing with Percona XtraDB Cluster in Docker

Like any good, thus lazy, engineer I don’t like to start things manually. Creating directories, configuration files, specify paths, ports via command line is too boring. I wrote already how I survive in case when I need to start MySQL server (here). There is also the MySQL Sandbox which can be used for the […]

Read more