EmergencyEMERGENCY? Get 24/7 Help Now!

Webinar Friday, December 15, 2017: Capacity Planning for Your Data Stores

and  | December 13, 2017 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Hardware and Storage, Insight for DBAs, Percona Monitoring and Management, Percona Toolkit, Technical Webinars

Capacity Planning

Join Percona’s Chief Evangelist, Colin Charles as he presents Capacity Planning for Your Data Stores on Friday, December 15, 2017, at 7:00 am PST / 10:00 am EST (UTC-8). In this webinar, Colin uses a ticket sales website that does “normal” events like an M2M concert, but also occasionally also sells tickets to the Harry […]

Read More

ZFS from a MySQL perspective

 | November 15, 2017 |  Posted In: Hardware and Storage, Insight for DBAs, MySQL

Open ZFS logo

Since the purpose of a database system is to store data, there is close relationship with the filesystem. As MySQL consultants, we always look at the filesystems for performance tuning opportunities. The most common choices in term of filesystems are XFS and EXT4, on Linux it is exceptional to encounter another filesystem. Both XFS and […]

Read More

Webinar Wednesday, October 18, 2017: How to Scale with MongoDB

and  | October 17, 2017 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MongoDB

Scale with MongoDB

Join Percona’s Senior Technical Services Engineer Adamo Tonete as he presents How To Scale with MongoDB on Wednesday, October 18, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now In this webinar, we will talk about how to scale with MongoDB, up to thousands of writes and reads per second. What are […]

Read More

Looking at Disk Utilization and Saturation

 | August 28, 2017 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL

DIsk Utilization and Saturation small

In this blog post, I will look at disk utilization and saturation. In my previous blog post, I wrote about CPU utilization and saturation, the practical difference between them and how different CPU utilization and saturation impact response times. Now we will look at another critical component of database performance: the storage subsystem. In this post, I […]

Read More

Better Than Linear Scaling

 | April 22, 2017 |  Posted In: Hardware and Storage, High-availability, Insight for DBAs, Insight for Developers, MySQL

Scalability

In this blog, we’ll look at how to achieve better-than-linear scaling. Scalability is the capability of a system, network or process to handle a growing amount of work, or its potential to be enlarged to accommodate that growth. For example, we consider a system scalable if it is capable of increasing its total output under […]

Read More

Using NVMe Command Line Tools to Check NVMe Flash Health

 | February 9, 2017 |  Posted In: Hardware and Storage, Insight for DBAs, MongoDB, MySQL

NVME

In this blog post, I’ll look at the types of NVMe flash health information you can get from using the NVMe command line tools. Checking SATA-based drive health is easy. Whether it’s an SSD or older spinning drive, you can use the smartctl command to get a wealth of information about the device’s performance and health. […]

Read More

How to Replace MySQL with Percona Server on a CPanel, WHM VPS or Dedicated Server

 | January 11, 2017 |  Posted In: Hardware and Storage, MySQL, Percona Server for MySQL, Percona Software, Percona Toolkit, Percona XtraBackup

Percona Server for MySQL 5.7.20-18

In this blog post, we’ll look at how to replace MySQL with Percona Server for MySQL on a CPanel, WHM VPS or dedicated server. In general, CPanel and WHM have been leaning towards support of MariaDB over other flavors. This is partly due to the upstream repos replacing the MySQL package with MariaDB (for example, […]

Read More

Three Things to Consider When Thinking About Containers

 | October 19, 2016 |  Posted In: Docker, Hardware and Storage, MySQL, Solutions Engineering

containers

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . . How did this happen? From what I understand, containers grew out of Google’s (and others’) […]

Read More