EmergencyEMERGENCY? Get 24/7 Help Now!

Gh-ost benchmark against pt-online-schema-change performance

 | July 12, 2017 |  Posted In: Benchmarks, Insight for DBAs, MySQL

gh-ost-benchmark

In this blog post, I will run a gh-ost benchmark against the performance of pt-online-schema-change. When gh-ost came out, I was very excited. As MySQL ROW replication became commonplace, you could use it to track changes instead of triggers. This practice is cleaner and safer compared to Percona Toolkit’s pt-online-schema-change. Since gh-ost doesn’t need triggers, I assumed it would […]

Read More

Webinar Wednesday July 12, 2017: MongoDB Index Types – How, When and Where Should They Be Used?

 | July 11, 2017 |  Posted In: Insight for DBAs, MongoDB, Technical Webinars

MongoDB Index Types

Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents MongoDB Index Types: How, When and Where Should They Be Used? on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now MongoDB has 12 index types. Do you know how each works, or when you should use each […]

Read More

Percona Server for MongoDB 3.4.5-1.5 is Now Available

 | July 10, 2017 |  Posted In: Events and Announcements, MongoDB, Percona Server for MongoDB, Percona Software

Percona Server for MongoDB 3.2

Percona announces the release of Percona Server for MongoDB 3.4.5-1.5 on July 10, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, fully compatible, highly-scalable, zero-maintenance downtime database supporting the MongoDB v3.4 protocol and drivers. It extends MongoDB with Percona Memory Engine and MongoRocks storage engine, as well as several enterprise-grade features: External […]

Read More

Webinar Tuesday July 11, 2017: Securing Your MySQL/MariaDB Data

 | July 10, 2017 |  Posted In: MariaDB, MySQL, Security, SSL, Technical Webinars

Securing Your MySQL/MariaDB Data

Join Percona’s Chief Evangelist, Colin Charles as he presents Securing Your MySQL/MariaDB Data on Tuesday, July 11, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7). Register Now This webinar will discuss the features of MySQL/MariaDB that when enabled and used improve the default usage of MySQL. Many cloud-based applications fail to: Use appropriate filesystem […]

Read More

Differences in PREPARE Statement Error Handling with Binary and Text Protocol (Percona XtraDB Cluster / Galera)

 | July 5, 2017 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster

PREPARE Statement

In this blog, we’ll look at the differences in how a PREPARE statement handles errors in binary and text protocols. Introduction Since Percona XtraDB Cluster is a multi-master solution, when an application executes conflicting workloads one of the workloads gets rolled back with a DEADLOCK error. While the same holds true even if you fire […]

Read More