AWS Elastic Block Storage (EBS) – Can We Get It Truly Elastic?

very old disk storage

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 it’s got better through the years, adding different storage types and features like Provisioned […]

Read more

Percona XtraDB Cluster Operator Is Now Available as an Early Access Release

Percona XtraDB Cluster Operator

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 aren’t […]

Read more

Upcoming Webinar Wed 12/12: MySQL 8 for Developers

MySQL 8 for Developers

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 8 […]

Read more

Percona Server for MongoDB Operator Is Now Available as an Early Access Release

Percona Server for MongoDB Operator

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 also […]

Read more

Percona XtraBackup 8.0.4 Is Now Available

Percona XtraBackup 8.0

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, […]

Read more

MySQL 8 and The FRM Drop… How To Recover Table DDL

MySQL 8 frm drop recover ddl

… 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 seem […]

Read more

Nondeterministic Functions in MySQL (i.e. rand) Can Surprise You

MySQL non deterministic functions rand

Working on a test case with sysbench, I encountered this:

MySQL

mysql> select * from sbtest1 where id = round(rand()*10000, 0);
+——+——–+————————————————————————————————————————-+————————————————————-+
| id | k | c […]

Read more

Percona Server for MySQL 5.7.24-26 Is Now Available

Percona Server for MySQL

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 […]

Read more

MongoDB 4.0: Using ACID Multi-Document Transactions

mongodb 4.0 acid compliant transactions

MongoDB 4.0 is around, and there are a lot of new features and improvements. In this article we’re 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, […]

Read more

Percona Live 2019 Call for Papers is Now Open!

Percona Live CFP 2019

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 opportunity […]

Read more