One of the most exciting features Amazon Aurora Serverless brings to the table is its ability to go to sleep (pause) when idle. This is a fantastic feature for development and test environments. You get access to a powerful database to run tests quickly, but it goes easy on your wallet as you only pay [&]

https://www.percona.com/blog/2019/01/09/amazon-aurora-serverless-the-sleeping-beauty/

Percona Live Open Source Database Conference 2019 in North America has moved to Austin, Texas: a cool place to be, and host to many big names in the tech space. Read what Dave Stokes, MySQL Community Manager for Oracle, has to say in favor of Austin. If you need a conference ticket for Austin, put [&]

https://www.percona.com/blog/2019/01/08/percona-live-2019-tracks/

Please join Percona’s MySQL Product Manager, Tyler Duzan as he presents Walkthrough of Percona Server MySQL 8.0 on Wednesday, January 9th at 11:00 AM PDT (UTC-7) / 2:00 PM (UTC-4). Register Now Our Percona Server for MySQL 8.0 software is the company’s free, enhanced, drop-in replacement for MySQL Community Edition. The software includes all of [&]

https://www.percona.com/blog/2019/01/08/walkthrough-percona-server-mysql-8-0/

Since 5.7.12 MySQL includes what is called the X plugin, but also it includes X protocol and X DevApi. But what is all this and how does it work? Let me share a personal short story on how I found myself investigating this feature. In a previous post I wrote about the MySQL Router tool, and [&]

https://www.percona.com/blog/2019/01/07/understanding-mysql-x-all-flavors/

Amazon Aurora with MySQL Compatibility comes in three editions which, at the time of writing, have quite a few differences around the features that they support.  Make sure you dont assume the newer Aurora 2.x supports everything in Aurora 1.x. On the contrary, right now Aurora 1.x (MySQL 5.6 based) supports most Aurora features.  The [&]

https://www.percona.com/blog/2019/01/04/amazon-rds-aurora-mysql-differences-among-editions/

Percona announces the release of Percona XtraDB Cluster 5.6.42-28.30 (PXC) on January 4, 2019. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.42-28.30 is now the current release, based on the following: Percona Server 5.6.42 Codership WSREP API release 5.6.42 Codership Galera library 3.25 All Percona software is open-source [&]

https://www.percona.com/blog/2019/01/04/percona-xtradb-cluster-5-6-42-28-30-is-now-available/

Percona is glad to announce the release of Percona XtraDB Cluster 5.7.24-31.33 (PXC) on January 4, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.24-31.33 is now the current release, based on the following: Percona Server for MySQL 5.7.24 Galera Replication library 3.25 Galera/Codership WSREP API Release 5.7.24 Deprecated The [&]

https://www.percona.com/blog/2019/01/04/percona-xtradb-cluster-5-7-24-31-33-is-now-available/

Please join Percona’s Senior Software Engineer, Ibrar Ahmed as he presents his High-Performance PostgreSQL, Tuning and Optimization Guide on Friday, January, 4th, at 8:00 AM PDT (UTC-7) / 11:00 AM EDT (UTC-4). Register Now PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any [&]

https://www.percona.com/blog/2019/01/03/performance-postgresql-tuning-optimization/

In this post, well take a look at the differences between the MMAP and WiredTiger engines in MongoDB®. Ive been asked this question by customers many times, and this blog is for you! Well tell you about the key features of these engines, then you can choose the right engine based on your requirement. In [&]

https://www.percona.com/blog/2019/01/03/mongodb-engines-mmapv1-vs-wiredtiger/

Recently, I encountered a situation where MySQL gave error messages that I had never seen before: [crayon-5c2fff706801c447645121/] I was thinking maybe we hit some [crayon-5c2fff7068020658773338-i/] limitations or similar, but all the usual suspects were set high enough, and we were not even close to them. After googling and discussing with the customer, I found they had [&]

https://www.percona.com/blog/2019/01/02/tasksmax-another-setting-that-can-cause-mysql-error-messages/

In this blog post, well look back at whats been going on in the world of PostgreSQL in 2018. Before we start talking about the good things that have happened in the PostgreSQL in  2018, we hope you had a wonderful year and we wish you a happy and prosperous 2019. PostgreSQL has been a [&]

https://www.percona.com/blog/2018/12/31/great-things-that-happened-with-postgresql-in-the-year-2018/

Percona has released Percona Server for MySQL 8.0 as Generally Available (GA). Our Percona Server for MySQL 8.0 software is the companys free, enhanced, drop-in replacement for MySQL Community Edition. Percona Server for MySQL 8.0 includes all of the great features in MySQL Community Edition 8.0. It also includes enterprise-class features from Percona made available [&]

https://www.percona.com/blog/2018/12/21/announcing-general-availability-of-percona-server-for-mysql-8-0/

Percona announces the GA release of Percona Server for MySQL 8.0.13-3 on December 21, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 8.0.13, including all the bug fixes in it. Percona Server for MySQL 8.0.13-3 is now the current GA release in the 8.0 series. All of Percona’s software is open-source and free. Percona Server for [&]

https://www.percona.com/blog/2018/12/21/release-notes-percona-server-for-mysql-8-0-13-3-ga/

pg_basebackup is a widely used PostgreSQL backup tool that allows us to take an ONLINE and CONSISTENT file system level backup. These backups can be used for point-in-time-recovery or to set up a slave/standby. You may want to refer to our previous blog posts, PostgreSQL Backup Strategy, Streaming Replication in PostgreSQL and Faster PITR in PostgreSQL where we describe [&]

https://www.percona.com/blog/2018/12/21/backup-restore-postgresql-cluster-multiple-tablespaces-using-pg_basebackup/

This article will walk you through using the SASL library to allow your Percona Server for MongoDB instance to authenticate with your companys Active Directory server. Percona Server for MongoDB includes enterprise level features, such as LDAP authentication, audit logging and with the 3.6.8 release a beta version of data encryption at rest, all in [&]

https://www.percona.com/blog/2018/12/21/percona-server-for-mongodb-authentication-using-active-directory/

Linux kernel provides a wide range of configuration options that can affect performance. It’s all about getting the right configuration for your application and workload. Just like any other database, PostgreSQL relies on the Linux kernel to be optimally configured. Poorly configured parameters can result in poor performance. Therefore, it is important that you benchmark [&]

https://www.percona.com/blog/2018/12/20/benchmark-postgresql-with-linux-hugepages/

Lets look at some of the most popular Percona Database Performance Blog posts in 2018. The closing of a year lends itself to looking back. And making lists. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple [&]

https://www.percona.com/blog/2018/12/20/percona-database-performance-blog-2018-year-in-review-top-blog-posts/

Percona announces the release of Percona Server for MySQL 5.7.24-27 on December 19, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.24, including all the bug fixes in it. Percona Server for MySQL 5.7.24-27 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free. [&]

https://www.percona.com/blog/2018/12/19/percona-server-for-mysql-5-7-24-27-is-now-available/

In this article Im going to talk about partial and sparse indexes in MongoDB® and Percona Server for MongoDB®. Ill show you how to use them, and look at cases where they can be helpful. Prior to discussing these indexes in MongoDB in detail, though, lets talk about an issue on a relational database like MySQL®. [&]

https://www.percona.com/blog/2018/12/19/using-partial-and-sparse-indexes-in-mongodb/

Percona announces the GA release of Percona Server for MongoDB 4.0.4-1 on December 18, 2018. Download the latest version from the Percona website or the Percona software repositories. Date: December 18, 2018 Download: Percona website Installation: Installing Percona Server for MongoDB Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB [&]

https://www.percona.com/blog/2018/12/18/percona-server-for-mongodb-4-0-4-1-ga-is-now-available/