When deciding on your backup strategy, one of the key components for Point In Time Recovery (PITR) will be the binary logs. Thankfully, the mysqlbinlog command allows you to easily take binary log backups, including those that would otherwise be encrypted on disk using encrypt_binlog=ON. When [crayon-5bbe4e3a03770277735682-i/]  is used with [crayon-5bbe4e3a0377a788388861-i/]  then it will retrieve binary logs [&]

The post The Importance of mysqlbinlog version appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/04/the-importance-of-mysqlbinlog-version/

Offering over 110 conference sessions across Tuesday, 6 and Wednesday, 7 November, and a full tutorial day on Monday 5 November, we hope youll find that this fantastic line up of talks for Percona Live Europe 2018 to be one of our best yet! Innovation in technology continues to arrive at an accelerated rate, and [&]

The post Percona Live Europe 2018 Session Programme Published appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/04/percona-live-europe-2018-session-programme-published/

Perconas latest blog poll asks how you run your database in the cloud? Join in! Are you using a fully managed service or are you self-managing your databases in the cloud? And what provider are you relying on? Perhaps youre using more than one. Dont worry, you can tick multiple boxes, so please choose up [&]

The post Percona Blog Poll: How Do You Run Your Database in the Cloud? appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/03/percona-blog-poll-database-in-the-cloud/

Perconas latest blog poll asks how you run your database in the cloud? Join in! Are you using a fully managed service or are you self-managing your databases in the cloud? And what provider are you relying on? Perhaps youre using more than one. Dont worry, you can tick multiple boxes, so please choose up [&]

The post Percona Blog Poll: How Do You Run Your Database in the Cloud? appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/03/percona-blog-poll-database-in-the-cloud/

Some time ago, a customer had a performance issue with an internal process. He was comparing, finding, and reporting the rows that were different between two tables. This is simple if you use a LEFT JOIN and an [crayon-5bb531ff69722715358825-i/]  comparison over the second table in the WHERE clause, but what if the column could be null? That [&]

The post Finding Table Differences on Nullable Columns Using MySQL Generated Columns appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/03/finding-table-differences-nullable-columns-using-mysql-generated-columns/

To resolve a critical regression, Percona announces the release of Percona XtraDB Cluster 5.7.23-31.31.2 on October 2, 2018 Binaries are available from the downloads section or from our software repositories. This release resolves a critical regression in Galeras wsrep library and supersedes 5.7.23-31.31 Percona XtraDB Cluster 5.7.23-31.31.2 is now the current release, based on the following: Percona Server [&]

The post CRITICAL UPDATE for Percona XtraDB Cluster users: 5.7.23-31.31.2 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/02/percona-xtradb-cluster-5-7-23-31-31-2-is-now-available/

In the previous blog posts in this series weve covered some of the essential aspects of an Enterprise-grade solution: security, high availability, and backups. Another important aspect is the scalability of the solution: as our application grows how do we accommodate an increase in traffic while maintaining the quality of the service (response time)? The [&]

The post Scaling PostgreSQL using Connection Poolers and Load Balancers for an Enterprise Grade environment appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/02/scaling-postgresql-using-connection-poolers-and-load-balancers-for-an-enterprise-grade-environment/

Following my post from a year ago https://www.percona.com/blog/2017/07/06/clickhouse-one-year/, I wanted to review what happened in ClickHouse during this year. There is indeed some interesting news to share. 1. ClickHouse in DB-Engines Ranking. It did not quite get into the top 100, but the gain from position 174 to 106 is still impressive. Its DB-Engines Ranking score [&]

The post ClickHouse: Two Years! appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/01/clickhouse-two-years/

Following my post from a year ago https://www.percona.com/blog/2017/07/06/clickhouse-one-year/, I wanted to review what happened in ClickHouse during this year. There is indeed some interesting news to share. 1. ClickHouse in DB-Engines Ranking. It did not quite get into the top 100, but the gain from position 174 to 106 is still impressive. Its DB-Engines Ranking score [&]

The post ClickHouse: Two Years! appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/01/clickhouse-two-years/

Following my post from a year ago https://www.percona.com/blog/2017/07/06/clickhouse-one-year/, I wanted to review what happened in ClickHouse during this year. There is indeed some interesting news to share. 1. ClickHouse in DB-Engines Ranking. It did not quite get into the top 100, but the gain from position 174 to 106 is still impressive. Its DB-Engines Ranking score [&]

The post ClickHouse: Two Years! appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/01/clickhouse-two-years/

MySQL supports replicating to a slave that is one release higher. This allows us to easily upgrade our MySQL setup to a new version, by promoting the slave and pointing the application to it. However, though unsupported, there are times when the MySQL version of slave deployed is one release lower. In this scenario, if [&]

The post How To Fix MySQL Replication After an Incompatible DDL Command appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/01/how-to-fix-mysql-replication-after-an-incompatible-ddl-command/

MySQL supports replicating to a slave that is one release higher. This allows us to easily upgrade our MySQL setup to a new version, by promoting the slave and pointing the application to it. However, though unsupported, there are times when the MySQL version of slave deployed is one release lower. In this scenario, if [&]

The post How To Fix MySQL Replication After an Incompatible DDL Command appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/01/how-to-fix-mysql-replication-after-an-incompatible-ddl-command/

High availability (HA) and database replication is a major topic of discussion for database technologists. There are a number of informed choices to be made to optimize PostgreSQL replication so that you achieve HA. In this post we introduce an overview of the topic, and cover some options available to achieve high availability in PostgreSQL. [&]

The post High Availability for Enterprise-Grade PostgreSQL environments appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/28/high-availability-for-enterprise-grade-postgresql-environments/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. I consider this to be the biggest news for the week: Alpha Build of Percona Server for MySQL 8.0. Experiment with it in a Docker container. It is missing column compression with dictionary support, native partitioning [&]

The post This Week in Data with Colin Charles #54: Percona Server for MySQL is Alpha appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/28/this-week-in-data-with-colin-charles-54-percona-server-for-mysql-is-alpha/

Starting with PMM 1.13,  PMM uses Prometheus 2 for metrics storage, which tends to be heaviest resource consumer of CPU and RAM.  With Prometheus 2 Performance Improvements, PMM can scale to more than 1000 monitored nodes per instance in default configuration. In this blog post we will look into PMM scaling and capacity planning—how to [&]

The post Scaling Percona Monitoring and Management (PMM) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/28/scaling-percona-monitoring-management-pmm/

Alpha Build of Percona Server 8.0 released An alpha version of Percona Server 8.0 is now available in the Percona experimental software repositories. This is a 64-bit release only.  You may experiment with this alpha release by running it in a Docker container: $ docker run -d -e MYSQL_ROOT_PASSWORD=password -p 3306:3306 perconalab/percona-server:8.0.12.alpha When the container [&]

The post Announcement: Alpha Build of Percona Server 8.0 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/27/announcement-alpha-build-of-percona-server-8-0/

Alpha Build of Percona Server 8.0 released An alpha version of Percona Server 8.0 is now available in the Percona experimental software repositories. This is a 64-bit release only.  You may experiment with this alpha release by running it in a Docker container: $ docker run -d -e MYSQL_ROOT_PASSWORD=password -p 3306:3306 perconalab/percona-server:8.0.12.alpha When the container [&]

The post Announcement: Alpha Build of Percona Server 8.0 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/27/announcement-alpha-build-of-percona-server-8-0/

Alpha Build of Percona Server 8.0 released An alpha version of Percona Server 8.0 is now available in the Percona experimental software repositories. This is a 64-bit release only.  You may experiment with this alpha release by running it in a Docker container: $ docker run -d -e MYSQL_ROOT_PASSWORD=password -p 3306:3306 perconalab/percona-server:8.0.12.alpha When the container [&]

The post Announcement: Alpha Build of Percona Server 8.0 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/27/announcement-alpha-build-of-percona-server-8-0/

Percona announces the release of Percona Server for MongoDB 3.4.17-2.15 on September 27, 2018. Download the latest version from the Percona website or the Percona Software Repositories. Percona Server for MongoDB 3.4 is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.4 Community Edition. It supports MongoDB 3.4 protocols and drivers. Percona Server for MongoDB extends [&]

The post Percona Server for MongoDB 3.4.17-2.15 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/27/percona-server-for-mongodb-3-4-17-2-15-is-now-available/

Percona announces the release of Percona Server for MongoDB 3.4.17-2.15 on September 27, 2018. Download the latest version from the Percona website or the Percona Software Repositories. Percona Server for MongoDB 3.4 is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.4 Community Edition. It supports MongoDB 3.4 protocols and drivers. Percona Server for MongoDB extends [&]

The post Percona Server for MongoDB 3.4.17-2.15 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/27/percona-server-for-mongodb-3-4-17-2-15-is-now-available/