EmergencyEMERGENCY? Get 24/7 Help Now!

Managing Replication with Percona XtraDB Cluster

 | December 1, 2016 |  Posted In: GTID, High-availability, Percona XtraDB Cluster, Replication

Managing Replication

This blog post discusses managing replication with Percona XtraDB Cluster. Recently a customer asked me to setup replication between two distinct Percona XtraDB Clusters located in geographically separate data centers. The customer goal was to use one of the clusters only in case of disaster recovery. They tried extending the cluster, but because of the […]

Read More

Rescuing a crashed pt-online-schema-change with pt-archiver

 | June 30, 2016 |  Posted In: MySQL, Percona Server for MySQL, Percona Software, Percona Toolkit, Replication

crashed pt-online-schema-change

This article discusses how to salvage a crashed pt-online-schema-change by leveraging pt-archiver and executing queries to ensure that the data gets accurately migrated. I will show you how to continue the data copy process, and how to safely close out the pt-online-schema-change via manual operations such as RENAME TABLE and DROP TRIGGER commands. The normal process to […]

Read More

pt-online-schema-change (if misused) can’t save the day

 | May 24, 2016 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit, Replication

GTID replication

In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it. Always use pt-osc? Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER types are still not online, or sometimes just too expensive to execute on busy production […]

Read More

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

and  | April 26, 2016 |  Posted In: GTID, High-availability, MySQL, Orchestrator, Percona Server for MySQL, Replication

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 […]

Read More

Docker MySQL Replication 101

 | March 30, 2016 |  Posted In: Cloud and MySQL, Docker, High-availability, MySQL, Percona Server for MySQL, Replication

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 […]

Read More

Orchestrator: MySQL Replication Topology Manager

and  | March 8, 2016 |  Posted In: MySQL, Orchestrator, Replication

Orchestrator MySQL topology manager

This blog post discusses Orchestrator: MySQL Replication Topology Manager. What is Orchestrator? Orchestrator is a replication topology manager for MySQL. It has many great features: The topology and status of the replication tree is automatically detected and monitored Either a GUI, CLI or API can be used to check the status and perform operations Supports automatic […]

Read More

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

 | December 21, 2015 |  Posted In: High-availability, Insight for DBAs, MySQL, Percona XtraDB Cluster, Replication, XtraDB Cluster

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 […]

Read More

Featured Talk: The Future of Replication is Today: New Features in Practice

 | August 18, 2015 |  Posted In: Events and Announcements, Percona Live, Replication

In the past years, both MySQL 5.6, MySQL 5.7 and MariaDB 10 have been successful implementing new features. For many DBAs, the “old way” of replicating data is comfortable so taking the action to implement these new features seems like a momentous leap rather then a simple step. But perhaps it isn’t that complicated… Giuseppe […]

Read More