When I attended AWS Re:Invent 2018, I saw there was a lot of attention from both customers and the AWS team on Amazon RDS Aurora Serverless. So I decided to take a deeper look at this technology, and write a series of blog posts on this topic. In this first post of the series, you will learn [&]

https://www.percona.com/blog/2018/12/17/amazon-rds-aurora-serverless-the-basics/

We have many backup methods to backup a MongoDB database using native mongodump or external tools. However, in this article, well take a look at the backup tools offered by Percona, keeping in mind the restoration scenarios for MongoDB replicaSet and Sharded Cluster environments. Well explore how and when to use the tool mongodb-consistent-backup from Percona [&]

https://www.percona.com/blog/2018/12/13/mongodb-backup-how-and-when-to-use-psmdb-hotbackup-and-mongodb_consistent_backup/

At AWS Re:Invent 2018 there were many great announcements of AWS New Services and New Features, but one basic feature that I’ve been waiting for years to be released is still nowhere to be  found. AWS Elastic Block Storage (EBS) is great and its got better through the years, adding different storage types and features like Provisioned [&]

https://www.percona.com/blog/2018/12/12/aws-elastic-block-storage-ebs-can-we-get-it-truly-elastic/

Percona announces the early access release of Percona XtraDB Cluster Operator. Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools created by Percona staff. These handy utilities can help you save time and effort. Percona software builds located in the PerconaLabs and Percona-QA repositories are not officially released software, and also [&]

https://www.percona.com/blog/2018/12/11/percona-xtradb-cluster-operator-is-now-available-as-an-early-access-release/

Please join Percona’s CEO Peter Zaitsev as he presents MySQL 8 for Developers on Wednesday, December 12th, 2018 at 11:00 AM PST (UTC-7) / 2:00 PM EST (UTC-5). Register Now There are many great new features in MySQL 8, but how exactly can they help your application? This session takes a practical look at MySQL [&]

https://www.percona.com/blog/2018/12/11/webinar-mysql-8-developers/

Percona announces the early access release of Percona Server for MongoDB Operator. Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools created by Percona staff. These handy utilities can help you save time and effort. Percona software builds located in the PerconaLabs and Percona-QA repositories are not officially released software, and [&]

https://www.percona.com/blog/2018/12/11/percona-server-for-mongodb-operator-is-now-available-as-an-early-access-release/

Percona is glad to announce the release of Percona XtraBackup 8.0.4 on December 10, 2018. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, [&]

https://www.percona.com/blog/2018/12/10/percona-xtrabackup-8-0-4-is-now-available/

& or what I should keep in mind in case of disaster To retrieve and maintain in SQL format the definition of all tables in a database, is a best practice that we all should adopt. To have that under version control is also another best practice to keep in mind. While doing that may [&]

https://www.percona.com/blog/2018/12/07/mysql-8-frm-drop-how-to-recover-table-ddl/

Working on a test case with sysbench, I encountered this: [crayon-5c0a761e07fe2465164286/] I was really surprised. First, and the most important, id is a primary key and the rand() function should produce just one value. How come it returns two rows? Second, why is the response time 0.30 sec? That seems really high for a primary [&]

https://www.percona.com/blog/2018/12/05/nondeterministic-functions-in-mysql-i-e-rand-can-surprise-you/

Percona announces the release of Percona Server for MySQL 5.7.24-26 on December 4, 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-26 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/04/percona-server-for-mysql-5-7-24-26-is-now-available/

Percona announces the release of Percona Server for MySQL 5.7.24-26 on December 4, 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-26 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/04/percona-server-for-mysql-5-7-24-26-is-now-available/

MongoDB 4.0 is around, and there are a lot of new features and improvements. In this article were going to focus on the major feature which is, undoubtedly, the support for multi-document ACID transactions. This novelty for a NoSQL database could be seen as a way to get closer to the relational world. Well, its [&]

https://www.percona.com/blog/2018/12/04/mongodb-4-0-using-acid-multi-document-transactions/

MongoDB 4.0 is around, and there are a lot of new features and improvements. In this article were going to focus on the major feature which is, undoubtedly, the support for multi-document ACID transactions. This novelty for a NoSQL database could be seen as a way to get closer to the relational world. Well, its [&]

https://www.percona.com/blog/2018/12/04/mongodb-4-0-using-acid-multi-document-transactions/

Announcing the opening of the Percona Live 2019 Open Source Database Conference call for papers. It will be open from now until January 20, 2019. The Percona Live Open Source Database Conference 2019 takes place May 28-30 in Austin, Texas. Our theme this year is CONNECT. ACCELERATE. INNOVATE. As a speaker at Percona Live, you’ll have the [&]

https://www.percona.com/blog/2018/12/03/percona-live-2019-call-for-papers-is-now-open/

PostgreSQL streaming physical replication with slots simplifies setup and maintenance procedures. Usually, you should estimate disk usage for the Write Ahead Log (WAL) and provide appropriate limitation to the number of segments and setup of the WAL archive procedure. In this article, you will see how to use replication with slots and understand what problems it [&]

https://www.percona.com/blog/2018/11/30/postgresql-streaming-physical-replication-with-slots/

Percona announces the release of Percona Server 5.6.42-84.2 on November 29, 2018 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.42, including all the bug fixes in it, Percona Server 5.6.42-84.2 is the current GA release in the Percona Server 5.6 series. All of Percona‘s software is open-source and free. Improvements PS-4790: Improve user statistics accuracy Bugs Fixed Slave replication could [&]

https://www.percona.com/blog/2018/11/29/percona-server-for-mysql-5-6-42-84-2-is-now-available/

Continuing on the series of blog posts about MySQL High Availability, today we will talk about stale reads and how to overcome this issue. The Problem Stale reads is a read operation that fetches an incorrect value from a source that has not synchronized an update operation to the value (source Wiktionary). A practical scenario [&]

https://www.percona.com/blog/2018/11/29/mysql-high-availability-stale-reads-and-how-to-fix-them/

The settings of MySQL configuration variables have a fundamental impact on the performance of your database system. Sometimes it can be a little tricky to predict how changing one variable can affect others, and especially when dealing with cases like the one Ill describe in this post, where the outcome is not very intuitive. So [&]

https://www.percona.com/blog/2018/11/28/what-happens-if-you-set-innodb_open_files-higher-than-open_files_limit/

By the end of this article, you should be able to have a Percona Server for MongoDB and Percona Server for MySQL instance able to authenticate on an OpenLDAP backend. While this is mostly aimed at testing scenarios, it can be easily extended for production by following the OpenLDAP production best practices i.e. attending to [&]

https://www.percona.com/blog/2018/11/27/setup-compatible-openldap-server-for-mongodb-and-mysql/

Please join Percona’s Sr. Technical Operations Architect, Tim Vaillancourt, as he presents Improve MongoDB Performance with Proper Queries on Thursday, November 29th, 2018, at 12:30 PM PST (UTC-8) / 3:30 PM EST (UTC-5). Register Now There are many different ways you can use queries in MongoDB to find the data you need. However, knowing which [&]

https://www.percona.com/blog/2018/11/26/webinar-improve-mongodb-proper-queries/