EmergencyEMERGENCY? Get 24/7 Help Now!

Where Do I Put ProxySQL?

 | July 20, 2017 |  Posted In: High-availability, ProxySQL, Replication

ProxySQL

In this blog post, we’ll look at how to deploy ProxySQL. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. It was created for DBAs by René Cannaò, as a means of solving […]

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

Webinar Thursday, June 15, 2017: Demystifying Postgres Logical Replication

 | June 13, 2017 |  Posted In: MySQL, PostgreSQL, Replication, Technical Webinars

Postgres Logical Replication

Join Percona’s Senior Technical Services Engineer Emanuel Calvo as he presents Demystifying Postgres Logical Replication on Thursday, June 15, 2017 at 7 am PDT / 10 am EDT (UTC-7). Register Now The Postgres logical decoding feature was added in version 9.4, and thankfully it is continuously improving due to the vibrant open source community. In this […]

Read More

What About ProxySQL and Mirroring?

 | May 25, 2017 |  Posted In: MySQL, Percona Monitoring and Management, Percona XtraDB Cluster, ProxySQL, ProxySQL, Replication

ProxySQL and Mirroring

In this blog post, we’ll look at how ProxySQL and mirroring go together. Overview Let me be clear: I love ProxySQL, and I think it is a great component for expanding architecture flexibility and high availability. But not all that shines is gold! In this post, I want to correctly set some expectations, and avoid selling […]

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

Quest for Better Replication in MySQL: Galera vs. Group Replication

 | February 24, 2017 |  Posted In: Group Replication, High-availability, Insight for DBAs, Insight for Developers, MySQL, Percona XtraDB Cluster, Replication

Group Replication

UPDATE: Some of the language in the original post was considered overly-critical of Oracle by some community members. This was not my intent, and I’ve modified the language to be less so. I’ve also changed term “synchronous” (which the use of is inaccurate and misleading) to “virtually synchronous.” This term is more accurate and already used by both […]

Read More

MySQL super_read_only Bugs

and  | February 8, 2017 |  Posted In: Insight for DBAs, MySQL, Replication

MySQL error code 1215

This blog we describe an issue with MySQL 5.7’s super_read_only feature when used alongside with GTID in chained slave instances. Background In MySQL 5.7.5 and onward introduced the gtid_executed table in the MySQL database to store every GTID. This allows slave instances to use the GTID feature regardless whether the binlog option is set or not. Here […]

Read More

Overview of Different MySQL Replication Solutions

 | February 7, 2017 |  Posted In: MySQL, Percona XtraBackup, Percona XtraDB Cluster, Replication, Solutions Engineering

MySQL Replication

In this blog post, I will review some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). I will also try to clarify some of the misconceptions people have about replication. Since I’ve been working on the Solution Engineering team, I’ve noticed that – although information […]

Read More

WAN Synchronous Clusters: Dealing with Latency Using Concurrency

 | February 1, 2017 |  Posted In: Group Replication, Insight for DBAs, Insight for Developers, MySQL, Percona XtraDB Cluster, Replication

WAN Latency

In this blog, we’ll discuss how to use concurrency to help with WAN latency when using synchronous clusters. WAN Latency Problem Our customers often ask us for help or advice with WAN clustering problems. Historically, the usual solution for MySQL WAN deployments is having the primary site in one data center, and stand-by backup site in […]

Read More

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