by Hrvoje Matijakovic | Feb 1, 2017 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server for MySQL 5.5.54-38.6 on February 1, 2017. Based on MySQL 5.5.54, including all the bug fixes in it, Percona Server for MySQL 5.5.54-38.6 is now the current stable release in the 5.5 series. Percona Server for MySQL is...
by Peter Zaitsev | Jan 30, 2017 | Insight for DBAs, MySQL
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...
by Peter Zaitsev | Jan 27, 2017 | Cloud, MongoDB, MySQL, Percona Events, Percona Services, Percona Software, Webinars
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,...
by Marcelo Altmann | Jan 27, 2017 | Insight for DBAs, MySQL
In today’s blog, I will show an issue with seconds_behind_master that one of our clients faced when running slave_parallel_workers > 0. We found out that the reported seconds_behind_master from SHOW SLAVE STATUS was lying. To be more specific, I’m talking...
by Dave Avery | Jan 24, 2017 | MySQL, Webinars
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...
by Barrett Chambers | Jan 23, 2017 | MySQL
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...
by Evgeniy Patlan | Jan 20, 2017 | 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...
by Marco Tusa | Jan 19, 2017 | Insight for DBAs, MySQL, ProxySQL
In this blog post, we’ll look at how to set up ProxySQL for high availability. During the last few months, we’ve had a lot of opportunities to present and discuss a very powerful tool that will become more and more used in the architectures supporting...
by Dave Avery | Jan 17, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s Chief Evangelist Colin Charles on Wednesday, January 18, 2017, at 7:00 am (PST) / 10:00 am (EST) (UTC-8) as he presents “Lessons from Database Failures.” MySQL failures at scale can teach a great deal. MySQL failures can lead to a...
by Dave Avery | Jan 16, 2017 | MySQL, Percona Live
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...
by Peter Zaitsev | Jan 13, 2017 | Insight for DBAs, MySQL
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...
by Dave Avery | Jan 12, 2017 | MongoDB, MySQL, Percona Services
We are proud to announce the new Percona online store! Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping...
by Manjot Singh | Jan 11, 2017 | Hardware and Storage, MySQL, Percona Software
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...
by Peter Zaitsev | Jan 11, 2017 | Insight for DBAs, MySQL
In this blog post, we’ll look at how to preserve all MySQL grants and users after reinstalling MySQL. Every so often, I need to reinstall a MySQL version from scratch and preserve all the user accounts and their permissions (or move the same users and privileges...
by Dave Avery | Jan 10, 2017 | MongoDB, MySQL, Percona Services, Percona Software, Webinars
Please join Percona CEO Peter Zaitsev for a webinar on Thursday, January 12, 2017 at 11 am PST/ 2 pm EST (UTC-8) for a discussion on the Percona Software News and Roadmap Update for Q1 2017. In this webinar, Peter will discuss what’s new in Percona open source...
by Pablo Padua | Jan 10, 2017 | Insight for DBAs, MySQL
In this blog post we’ll look at how to move a MySQL partition from one table to another, for MySQL versions before 5.7. Up to version 5.7, MySQL had a limitation that made it impossible to directly exchange partitions between partitioned tables. Now and then, we...
by Rick Golba | Jan 6, 2017 | Insight for DBAs, MongoDB, MySQL
This post discusses archiving MySQL and MongoDB data and determining what, when and how to archive data. Many people store infrequently used data. This data is taking up storage space and might make your database slower than it could be. Archiving data can be a huge...
by Daniel Guzmán Burgos | Jan 3, 2017 | Insight for DBAs, MySQL
This post discusses enabling and disabling jemalloc on Percona Server for MySQL. The benefits of jemalloc versus glibc for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) you have less memory fragmentation, and...
by Dimitri Vanoverbeke | Dec 29, 2016 | MySQL
This blog provides a query language type overview. The idea for this blog originated from some customers asking me questions. When working in a particular field, you often a dedicated vocabulary that makes sense to your peers. It often includes phrases and...
by Dave Avery | Dec 27, 2016 | MySQL, Webinars
Please join Percona’s Consultant David Ducos on Thursday, December 29, 2016 at 10 am PST/ 1:00 pm EST (UTC-8) as he presents JSON in MySQL 5.7. Since it was implemented in MySQL 5.7, we can use JSON as a data type. In this webinar, we will review some of the...
