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...
by Dave Avery | Dec 16, 2016 | Cloud, Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL, Percona Events, Percona Live
We are excited to announce that the sneak peek schedule for the Percona Live 2017 Open Source Database Conference is up! The Percona Live Open Source Database Conference 2017 is April 24th – 27th, at the Hyatt Regency Santa Clara & The Santa Clara Convention...
by Dave Avery | Dec 15, 2016 | MongoDB, MySQL, Percona Live
Welcome to a new series of blogs: Percona Live featured tutorial speakers! 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...
by Rick Golba | Dec 14, 2016 | Insight for DBAs, MongoDB, MySQL
In this blog post, we’ll discuss the differences between row store and column store databases. Clients often ask us if they should or could be using columnar databases. For some applications, a columnar database is a great choice; for others, you should stick...
by Roman Vynar | Dec 12, 2016 | MongoDB, MySQL, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.0.7. The Percona Monitoring and Management Server (PMM) is distributed through Docker Hub, PMM Client – through tarball or system packages. The instructions for installing or upgrading PMM are...
by Roman Vynar | Dec 9, 2016 | MongoDB, MySQL, Percona Events
Percona announces the release of Percona Monitoring Plugins 1.1.7. Changelog New Nagios script pmp-check-mongo.py for MongoDB. Added MySQL socket and flag options to Cacti PHP script. Added disk volume check on “Mounted on” in addition to...
by Dave Avery | Dec 6, 2016 | MariaDB, MySQL, Webinars
Please join Federico Razzoli, Consultant at Percona, on Thursday, December 8, 2016, at 8 AM PT / 11 AM ET (UTC – 8) as he presents Virtual Columns in MySQL and MariaDB. MariaDB 5.2 and MySQL 5.7 introduced virtual columns, with different implementations.Their...
by Kortney Runyan | Dec 5, 2016 | MongoDB, MySQL, Open Source, Percona Live
We are excited to announce that the tutorial schedule for the Percona Live 2017 Open Source Database Conference is up! The Percona Live 2017 Open Source Database Conference 2017 is April 24th – 27th, at the Hyatt Regency Santa Clara & The Santa Clara...
by Wagner Bianchi | Dec 1, 2016 | Insight for DBAs, MySQL, Percona Services
This blog continues the ongoing series on daily operations and GTID replication and binary logs purge. In this blog, I’m going to investigate why the error below has been appearing in a special environment I’ve been working with on the last few days: MySQL...
by Hrvoje Matijakovic | Nov 28, 2016 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server 5.7.16-10 on November 28, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.7.16, including all the bug fixes in it, Percona Server 5.7.16-10 is the...
by Hrvoje Matijakovic | Nov 28, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.6.34-79.1 on November 28, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.34, including all the bug fixes in it, Percona Server 5.6.34-79.1 is the...
by Hrvoje Matijakovic | Nov 23, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server for MySQL 5.5.53-38.4 on November 23, 2016. Based on MySQL 5.5.53, including all the bug fixes in it, Percona Server for MySQL 5.5.53-38.5 is now the current stable release in the 5.5 series. Percona Server for MySQL is...
