EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Blog Poll Results: What Programming Languages Are You Using for Backend Development?

 | February 16, 2017 |  Posted In: Database Poll, MySQL

Programming Languages

In this blog we’ll look at the results from Percona’s blog poll on what programming languages you’re using for backend development. Late last year we started a poll on what backend programming languages are being used by the open source community. The three components of the backend – server, application, and database – are what makes […]

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

PMM Alerting with Grafana: Working with Templated Dashboards

 | February 2, 2017 |  Posted In: MongoDB, MySQL, Percona Monitoring and Management

PMM Alerting

In this blog post, we will look into more intricate details of PMM alerting. More specifically, we’ll look at how to set up alerting based on templated dashboards. Percona Monitoring and Management (PMM) 1.0.7 includes Grafana 4.0, which comes with the Alerting feature. Barrett Chambers shared how to enable alerting in general. This blog post looks at […]

Read More

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

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

The Impact of Swapping on MySQL Performance

 | January 13, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, PMM

In this blog, I’ll look at the impact of swapping on MySQL performance.  It’s common sense that when you’re running MySQL (or really any other DBMS) you don’t want to see any I/O in your swap space. Scaling the cache size (using innodb_buffer_pool_size in MySQL’s case) is standard practice to make sure there is enough free […]

Read More

Using Percona XtraBackup on a MySQL Instance with a Large Number of Tables

 | December 28, 2016 |  Posted In: Insight for DBAs, MySQL, Percona XtraBackup

CVE-2016-6225

In this blog post, we’ll find out how to use Percona XtraBackup on a MySQL instance with a large number of tables. As of Percona Xtrabackup 2.4.5, you are required to have enough open files to open every single InnoDB tablespace in the instance you’re trying to back up. So if you’re running innodb_file_per_table=1, and […]

Read More

Percona Poll Results: What Database Technologies Are You Using?

 | December 21, 2016 |  Posted In: Database Poll, MongoDB, MySQL

This blog shows the results from Percona’s poll on what database technologies our readers use in their environment. We design different databases for different scenarios. Using one database technology for every situation doesn’t make sense, and can lead to non-optimal solutions for common issues. Big data and IoT applications, high availability, secure backups, security, cloud vs. on-premises deployment: each […]

Read More