Buy Percona ServicesBuy Now!

When Should I Use Amazon Aurora and When Should I use RDS MySQL?

 | July 17, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Cloud and MySQL, Insight for DBAs, MySQL, MySQL DBaaS, ProxySQL

Now that Database-as-a-service (DBaaS) is in high demand, there is one question regarding AWS services that cannot always be answered easily : When should I use Aurora and when RDS MySQL? DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure, and without installing software. I’m not sure if there is […]

Read More

The Multi-Source GTID Replication Maze

 | March 13, 2018 |  Posted In: GTID, Insight for DBAs, MySQL, Replication

Multi-Source GTID Replication

In this blog post, we’ll look at how to navigate some of the complexities of multi-source GTID replication. GTID replication is often a real challenge for DBAs, especially if this has to do with multi-source GTID replication. A while back, I came across a really interesting customer environment with shards where multi-master, multi-source, multi-threaded MySQL 5.6 […]

Read More

ProxySQL Query Cache: What It Is, How It Works

 | February 7, 2018 |  Posted In: Insight for DBAs, MySQL, ProxySQL

ProxySQL query cache

In this blog post, I’ll present the ProxySQL query cache functionality. This is a query caching mechanism on top of ProxySQL. As there are already many how-tos regarding the ProxySQL prerequisites and installation process, we are going to skip these steps. For those who are already familiar with ProxySQL query cache configuration, let’s go directly […]

Read More