MySQL

Category to track posts in PlanetMySQL

MySQL: Disk Space Exhaustion for Implicit Temporary Tables

Implicit Temporary Tables

I was recently faced with a real issue about completely exhausting the disk space on MySQL. This was a serious issue because of the continuous outages of the service, as the customer had to constantly restart the server and wait for the next outage.
What was happening? In this article, I’m going to explain it […]

Read more

Assessing MySQL Performance Amongst AWS Options – Part One

MySQL Performance on AWS

With such a wide range of options available for running MySQL based servers in Amazon cloud environments, how do you choose? There’s no doubt it’s a challenge. In this two-part series of blog posts, we’ll try to draw a fair and informative comparison based on well-established benchmark scenarios – at scale.
In part one we […]

Read more

Upcoming Webinar 7/18: Learn how to connect a MySQL database with Java

connect a MySQL database with Java

Please join Percona’s Service Delivery Manager Rodrigo Trindade as he presents “Troubleshooting Java Connections to MySQL” on Thursday, July 18th, 2019 at 10:00 AM PDT (UTC-7).
Register Now
This talk will explain the steps needed to make a connection from Java to MySQL work and highlight potential issues you might encounter. It will cover all components, […]

Read more

Percona Kubernetes Operator for Percona XtraDB Cluster 1.1.0 Now Available

Percona Kubernetes Operator for Percona XtraDB Cluster 1.1.0

We are glad to announce the 1.1.0 release of the  Percona Kubernetes Operator for Percona XtraDB Cluster.
The Percona Kubernetes Operator for Percona XtraDB Cluster automates the lifecycle and provides a consistent Percona XtraDB Cluster instance. The Operator can be used to create a Percona XtraDB Cluster, or scale an existing Cluster, and contains the […]

Read more

Percona Live Europe 2019 Conference Updates

The Percona Live Open Source Database Conference, Europe 2019 will have a one week extension of the call for papers.  Our new close date will be Monday July 22, 2019.  Any and all topics related to open source database technologies are invited.
This year’s conference takes a new approach, organizing tracks along these key business […]

Read more

Percona XtraBackup 2.4.15 Is Now Available

Percona XtraBackup 8.0

Percona is glad to announce the release of Percona XtraBackup 2.4.15 on July 10, 2019. 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. […]

Read more

MongoDB Disaster, Snapshot Restore and Point-in-time Replay

MongoDB update schema disaster

Mistakes can happen. If only we could go back in time to the very second before that mistake was made.
Act 1: The Disaster

Plain text version for those who cannot run the asciicast above:

Shell

akira@perc01:/data$ #OK, let’s get this party started!
akira@perc01:/data$ # The frontend has been shut down for 20 mins so they can
akira@perc01:/data$ # update […]

Read more