EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL Sharding Models for SaaS Applications

 | January 30, 2017 |  Posted In: Insight for DBAs, MySQL

MySQL Sharding Models

In this blog post, I’ll discuss MySQL sharding models, and how they apply to SaaS application environments. MySQL is one of the most popular database technologies used to build many modern SaaS applications, ranging from simple productivity tools to business-critical applications for the financial and healthcare industries. Pretty much any large scale SaaS application powered […]

Read More

MariaDB ColumnStore

 | January 30, 2017 |  Posted In: MySQL

MariaDB ColumnStore

Last month, MariaDB officially released MariaDB ColumnStore, their column store engine for MySQL. This post discusses what it is (and isn’t), why it matters and how you can approach a test of it. What is ColumnStore? ColumnStore is a storage engine that turns traditional MySQL storage concepts on their head. Instead of storing the data […]

Read More

Percona Software News and Roadmap Update with CEO Peter Zaitsev: Q1 2017

 | January 27, 2017 |  Posted In: Docker, Events and Announcements, MongoDB, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona Software, Percona Support, Percona XtraBackup, Percona XtraDB Cluster, PMM, Technical Webinars, XtraDB Cluster

Percona Software News and Roadmap Update

This blog post is a summary of the webinar Percona Software News and Roadmap Update – Q1 2017 given by Peter Zaitsev on January 12, 2017. Over the last few months, I’ve had the opportunity to meet and talk with many of Percona’s customers. I love these meetings, and I always get a bunch of questions […]

Read More

When MySQL Lies: Wrong seconds_behind_master with slave_parallel_workers > 0

 | January 27, 2017 |  Posted In: Insight for DBAs, MySQL

super_read_only

In today’s blog, I will show an issue with seconds_behind_master that one of our clients faced when running slave_parallel_works > 0. We found out that the reported seconds_behind_master from SHOW SLAVE STATUS was lying. To be more specific, I’m talking about bugs #84415 and #1654091. The Issue MySQL will not report the correct slave lag if you have slave_parallel_workers> […]

Read More

Percona Live Featured Tutorial with Frédéric Descamps — MySQL InnoDB Cluster & Group Replication in a Nutshell: Hands-On Tutorial

 | January 26, 2017 |  Posted In: High-availability, MySQL, Percona Live

Percona Live Featured Tutorial

Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your database environment. Make sure to read to the end to get a special Percona […]

Read More

Performance Schema Benchmarks: OLTP RW

 | January 26, 2017 |  Posted In: MySQL, open source databases, OpenSource Databases on big machines

Performance Schema Benchmarks

In this blog post, we’ll look at Performance Schema benchmarks for OLTP Read/Write workloads. I am in love with Performance Schema and talk a lot about it. Performance Schema is a revolutionary MySQL troubleshooting instrument, but earlier versions had performance issues. Many of these issues are fixed now, and the default options work quickly and […]

Read More

Webinar Thursday January 26, 2017: Overcoming the Challenges of Databases in the Cloud

 | January 24, 2017 |  Posted In: MySQL, Technical Webinars

Databases in the Cloud

Please join Percona’s Jon Tobin, Director of Solution Engineering at Percona, and Rob Masson, Solutions Architect Manager at ScaleArc, on Thursday, January 26, 2017, at 9:00 am PST / 12:00 pm EST (UTC-8) for their webinar “Overcoming the Challenges of Databases in the Cloud.” Enterprises enjoy the flexibility and simplified operations of using the cloud, […]

Read More

Webinar Wednesday January 25, 2017: Percona Server for MySQL 5.7 Key Performance Algorithms

 | January 23, 2017 |  Posted In: MySQL, Technical Webinars

Percona Server for MySQL 5.5.54-38.6

Please join Laurynas Biveinis, Percona’s Technical Director – Engineering, on January 25, 2017, at 7 am EST (UTC-8) as he discusses “Percona Server for MySQL 5.7: Key Performance Algorithms.” In this webinar, Laurynas will discuss selected areas of InnoDB and Percona Server for MySQL 5.7 internals as they relate to buffer pool management and flushing […]

Read More

MySQL and MongoDB Alerting with PMM and Grafana

 | January 23, 2017 |  Posted In: MySQL

Alerting

This blog post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana. As a Solutions Engineer at Percona, I get to speak with a lot of the early adopters of Percona’s new PMM software. One of the frequent feature requests from them was the need for alerts at certain […]

Read More

How to Manually Build Percona Server for MySQL RPM Packages

and  | January 20, 2017 |  Posted In: Insight for Developers, MySQL

In this blog, we’ll look at how to manually build Percona Server for MySQL RPM packages. Several customers and other people from the open source community have asked us how they could make their own Percona Server for MySQL RPM binaries from scratch. This request is often made by companies that want to add custom patches […]

Read More

Percona’s widely read Percona Database 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.