EmergencyEMERGENCY? Get 24/7 Help Now!

First MongoDB replica-set Configuration for MySQL DBAs

 | December 7, 2016 |  Posted In: MongoDB

Replica-Set Configuration

In this blog post, we will work on the first replica-set configuration for MySQL DBAs. We will map as many names as possible and compare how the databases work. Replica-sets are the most common MongoDB deployment nowadays. One of the most frequent questions is: How do you deploy a replica-set? In this blog, the setup […]

Read More

Webinar Thursday, December 8: Virtual Columns in MySQL and MariaDB

 | December 6, 2016 |  Posted In: MariaDB, MySQL, Technical Webinars

Virtual Columns

Please join Federico Razzoli, Consultant at Percona, on Thursday, December 8, 2016, at 8 AM PT / 11 AM ET (UTC – 8) as he presents Virtual Columns in MySQL and MariaDB. MariaDB 5.2 and MySQL 5.7 introduced virtual columns, with different implementations.Their features and limitations are similar, but not identical. The main difference is […]

Read More

Percona Live 2017 Open Source Database Conference Tutorial Schedule is Live!

 | December 5, 2016 |  Posted In: MongoDB, MySQL, open source databases, Percona Live

Percona Live 2017

We are excited to announce that the tutorial schedule for the Percona Live 2017 Open Source Database Conference is up! The Percona Live 2017 Open Source Database Conference 2017 is April 24th – 27th, at the Hyatt Regency Santa Clara & The Santa Clara Convention Center. Click through to the tutorial link right now, look […]

Read More

MongoDB Troubleshooting: My Top 5

 | December 5, 2016 |  Posted In: MongoDB

MongoDB Troubleshooting

In this blog post, I’ll discuss my top five go-to tips for MongoDB troubleshooting. Every DBA has a war chest of their go-to solutions for any support issues they run into for a specific technology. MongoDB is no different. Even if you have picked it because it’s a good fit and it runs well for […]

Read More

Business Continuity and MySQL Backups

 | December 2, 2016 |  Posted In: MySQL

MySQL Backups

This blog post discusses the business continuity plan around MySQL backups, and how organizations should think about them. During the years I’ve worked in IT, I’ve learned that backups sometimes are a conceptual subject in organizations. Many companies have them, but don’t document the associated business continuation plan for them. I experienced this the hard way many […]

Read More

Make MySQL 8.0 Better Through Better Benchmarking

 | December 2, 2016 |  Posted In: Benchmarks, MySQL

MySQL 8.0

This blog post discusses how better MySQL 8.0 benchmarks can improve MySQL in general. Like many in MySQL community, I’m very excited about what MySQL 8.0 offers. There are a lot of great features and architecture improvements. Also like many in the MySQL community, I would like to see MySQL 8.0 perform better. Better performance […]

Read More

Managing Replication with Percona XtraDB Cluster

 | December 1, 2016 |  Posted In: GTID, High-availability, Percona XtraDB Cluster, Replication

Managing Replication

This blog post discusses managing replication with Percona XtraDB Cluster. Recently a customer asked me to setup replication between two distinct Percona XtraDB Clusters located in geographically separate data centers. The customer goal was to use one of the clusters only in case of disaster recovery. They tried extending the cluster, but because of the […]

Read More

Database Daily Ops Series: GTID Replication and Binary Logs Purge

 | December 1, 2016 |  Posted In: GTID, MySQL, Percona Managed Services

GTID replication

This blog continues the ongoing series on daily operations and GTID replication. In this blog, I’m going to investigate why the error below has been appearing in a special environment I’ve been working with on the last few days:

The error provides the right message, and explains what is going on. But sometimes, it can be a […]

Read More

Galera Cache (gcache) is finally recoverable on restart

 | November 30, 2016 |  Posted In: MySQL, Percona XtraDB Cluster, XtraDB Cluster

Gcache

This post describes how to recover Galera Cache (or gcache) on restart. Recently Codership introduced (with Galera 3.19) a very important and long awaited feature. Now users can recover Galera cache on restart. Need If you gracefully shutdown cluster nodes one after another, with some lag time between nodes, then the last node to shutdown holds […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.