Buy Percona ServicesBuy Now!

Fixing ER_MASTER_HAS_PURGED_REQUIRED_GTIDS when pointing a slave to a different master

 | July 2, 2018 |  Posted In: GTID, MySQL, Replication

gtid auto position

GTID replication has made it convenient to setup and maintain MySQL replication. You need not worry about binary log file and position thanks to GTID and auto-positioning. However, things can go wrong when pointing a slave to a different master. Consider a situation where the new master has executed transactions that haven’t been executed on […]

Read More

Webinar 6/28: Securing Database Servers From External Attacks

 | June 27, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, PostgreSQL, Replication, Security, Technical Webinars

securing database servers

Please join Percona’s Chief Evangelist Colin Charles on Thursday, June 28th, 2018, as he presents Securing Database Servers From External attacks at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   A critical piece of your infrastructure is the database tier, yet people don’t pay enough attention to it judging by how […]

Read More

Binlog Encryption with Percona Server for MySQL

 | March 8, 2018 |  Posted In: Database Monitoring, Insight for DBAs, MySQL, Percona Server for MySQL, Security

binlog encryption

In this blog post, we’ll look at how to turn on binlog encryption in Percona Server for MySQL. Why do I need this? As you probably know, Percona Server for MySQL’s binlog contains sensitive information. Replication uses the binlog to copy events between servers. They contain all the information from one server so that it can […]

Read More

Migrating Data from an Encrypted Amazon MySQL RDS Instance to an Encrypted Amazon Aurora Instance

 | August 23, 2017 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Cloud and MySQL, MySQL

Migrating Data

In this blog post, we’ll discuss migrating data from encrypted Amazon MySQL RDS to encrypted Amazon Aurora. One of my customers wanted to migrate from an encrypted MySQL RDS instance to an encrypted Aurora instance. They have a pretty large database, therefore using mysqldump or a similar tool was not suitable for them. They also wanted to setup […]

Read More

The MySQL High Availability Landscape in 2017 (The Adults)

 | August 22, 2017 |  Posted In: High-availability, MySQL, Percona XtraDB Cluster

In this blog post, we’ll look at some of the MySQL high availability solution options. In the previous post of this series, we looked at the MySQL high availability (HA) solutions that have been around for a long time. I called these solutions “the elders.” Some of these solutions (like replication) are heavily used today […]

Read More

Multi-Threaded Slave Statistics

 | July 19, 2017 |  Posted In: Insight for DBAs, MySQL, Replication

Multi-Threaded Slave Statistics

In this blog post, I’ll talk about multi-threaded slave statistics printed in MySQL error log file. MySQL version 5.6 and later allows you to execute replicated events using parallel threads. This feature is called Multi-Threaded Slave (MTS), and to enable it you need to modify the slave_parallel_workers variable to a value greater than 1. Recently, a […]

Read More

The MySQL High Availability Landscape in 2017 (The Elders)

 | June 20, 2017 |  Posted In: Group Replication, GTID, High-availability, MySQL, Percona XtraDB Cluster

High Availability

In this blog, we’ll look at different MySQL high availability options. The dynamic MySQL ecosystem is rapidly evolving many technologies built around MySQL. This is especially true for the technologies involved with the high availability (HA) aspects of MySQL. When I joined Percona back in 2009, some of these HA technologies were very popular – […]

Read More

Percona Live 2017: Real-Time Data Loading from MySQL and Oracle into Analytics/Big Data

 | April 25, 2017 |  Posted In: Big Data, Percona Live, Replication

Real-Time Data Loading

It looks like the first day of the Percona Live Open Source Database Conference 2017 is coming to a close. Before we shut it down for today, we’ll look at a presentation on Real-Time Data Loading from MySQL and Oracle into Analytics/Big Data. In this session, Continuent’s VP of Products MC Brown looked at Tungsten […]

Read More

TokuDB Hotbackup and Replication

 | April 14, 2017 |  Posted In: MySQL

mysqlpump

TokuDB Hotbackup is a solution that allows you to do backups on the fly. It works as a library that intercepts certain system calls that duplicate data written to already copied parts of files, so that at the end of the backup process the copied files contain the same content as the original files. There are several […]

Read More

MySQL Bug 72804 Workaround: “BINLOG statement can no longer be used to apply query events”

 | February 16, 2017 |  Posted In: MySQL

MySQL Bug

In this blog post, we’ll look at a workaround for MySQL bug 72804. Recently I worked on a ticket where a customer performed a point-in-time recovery PITR using a large set of binary logs. Normally we handle this by applying the last backup, then re-applying all binary logs created since the last backup. In the middle of the […]

Read More