Buy Percona ServicesBuy Now!

How to Set Up Replication Between AWS Aurora and an External MySQL Instance

 | July 4, 2018 |  Posted In: Amazon Aurora, Amazon RDS, Insight for DBAs, MySQL, Replication

Amazon RDS Aurora replication to external server

Amazon RDS Aurora (MySQL) provides its own low latency replication. Nevertheless, there are cases where it can be beneficial to set up replication from Aurora to an external MySQL server, as Amazon RDS Aurora is based on MySQL and supports native MySQL replication. Here are some examples of when replicating from Amazon RDS Aurora to […]

Read More

Linux OS Tuning for MySQL Database Performance

 | July 3, 2018 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0, Percona Server for MySQL, Percona XtraDB Cluster, XtraDB Cluster

Linux OS tuning for MySQL database performance

In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud. Other posts have addressed MySQL parameters, like Alexander’s blog MySQL 5.7 […]

Read More

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

This Week in Data with Colin Charles 44: MongoDB 4.0 and Facebook MyRocks

 | June 30, 2018 |  Posted In: MariaDB, MongoDB, MyRocks, MySQL, PostgreSQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. There have been two big pieces of news this week: the release of MongoDB 4.0 and the fact that Facebook has migrated the Messenger backend over to MyRocks. MongoDB 4.0 is stable, with support for […]

Read More

Percona XtraDB Cluster 5.7.22-29.26 Is Now Available

 | June 29, 2018 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.7.22-29.26 (PXC) on June 29, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.7.22-29.26 is now the current release, based on the following: Percona Server for MySQL 5.7.22 Galera/Codership WSREP API Release 5.7.21 Galera Replication library 3.23 Deprecated The following variables […]

Read More

Percona Monitoring and Management 1.12.0 Is Now Available

 | June 27, 2018 |  Posted In: Amazon RDS, AWS, Database Monitoring, Events and Announcements, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM

Percona Monitoring and Management

PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL and MongoDB servers to ensure that your data works as efficiently as possible. In release 1.12, we invested our efforts in the following areas: Visual Explain in […]

Read More

Scaling PostgreSQL with PgBouncer: You May Need a Connection Pooler Sooner Than You Expect

 | June 27, 2018 |  Posted In: Benchmarks, PostgreSQL

PostgreSQL connection pools

As PostgreSQL based applications scale, the need to implement connection pooling can become apparent sooner than you might expect. Since, PostgreSQL to date has no built-in connection pool handler, in this post I’ll explore some of the options for implementing connection pooling. In doing so, we’ll take a look at some of the implications for application […]

Read More