by Kortney Runyan | Nov 8, 2016 | MariaDB, MongoDB, MySQL, Percona Live
We’ve extended the Percona Live Open Source Database Conference 2017 call for papers deadline until November 13th! If you haven’t submitted already, please consider doing so. Speaking at Percona Live is a great way to build your personal and company brands, and...
by Daniel Guzmán Burgos | Nov 4, 2016 | MySQL, Percona Software
In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change. One of the most annoying situations in the life of a DBA is realizing that the disk where the datadir resides is running out of space. If you’re lucky enough to...
by David Busby | Nov 2, 2016 | MySQL, Percona Events, Percona Software
Percona has addressed CVE-2016-6663 and CVE-2016-6664 in releases of Percona Server for MySQL and Percona XtraDB Cluster. Percona is happy to announce that the following vulnerabilities are fixed in current releases of Percona Server for MySQL and Percona XtraDB...
by Dave Avery | Nov 2, 2016 | MySQL
Join Percona’s Chief Evangelist Colin Charles on Thursday, November 3, 2016, at 10 am PDT/ 1:00pm EDT (UTC-7) as he presents “The MySQL Ecosystem in 2016.” MySQL is a unique adult (now 21 years old) in many ways. It supports plugins. It supports...
by Peter Zaitsev | Nov 1, 2016 | MySQL
In this blog post, I’ll discuss the future of TokuDB at Percona. Spoiler: solid. As soon as we announced the fact that MyRocks was coming to Percona Server for MySQL at Percona Live Europe, rumors appeared that this means we’re going to phase out TokuDB at the...
by Tibor Korocz | Oct 27, 2016 | MySQL
MySQL 8.0 has a new feature called “invisible indexes,” which allow you to quickly enable/disable indexes from being used by the MySQL Optimizer. I wanted to share some of my first experiences and thoughts about this new feature. Why is it good for us?...
by Kortney Runyan | Oct 26, 2016 | MongoDB, MySQL, Percona Live
The Percona Live Open Source Database Conference 2017 call for papers is closing soon! Get in your submissions ASAP! After this past sold-out Percona Live Europe in Amsterdam, we’ve decided that expansion definitely works! The diverse list of topics at the...
by Peter Zaitsev | Oct 24, 2016 | MySQL, Percona Software
Announcing MyRocks in Percona Server for MySQL. RocksDB has been taking the world by the storm! RocksDB counts Facebook, LinkedIn, Pinterest, Airbnb and Netflix among its users. It is the storage engine for many open source database technologies, including...
by Alexander Rubin | Oct 20, 2016 | MySQL
In this blog, we’ll discuss descending indexes in MySQL 8.0. Summary The future MySQL 8.0 will (probably) have a great new feature: support for index sort order on disk (i.e., indexes can be physically sorted in descending order). In the MySQL 8.0 Labs release...
by Peter Zaitsev | Oct 19, 2016 | MongoDB, Monitoring, MySQL, Percona Software
As part of the release of Percona Monitoring and Management, we set up an extensive online Percona Monitoring and Management demo at pmmdemo.percona.com. The demo is pretty self-explanatory and easy to explore, but you will probably find it a lot more interesting with...
by Muhammad Irfan | Oct 18, 2016 | MySQL
In this blog, we’ll discuss things to watch out for during a MySQL downgrade. Previously, I wrote the blog MySQL upgrade best practices. Besides upgrading your MySQL version, sometimes you need to downgrade. When it comes to downgrading MySQL, there are two...
by Daniel Kowalewski | Oct 11, 2016 | MySQL
In this blog post, I’ll look at how to use the loose_ option prefix in my.cnf in MySQL. mysqld throws errors at startup – and refuses to start up – if a non-existent options are defined in the my.cnf file. For example: 2016-10-05 15:56:07 23864 [ERROR]...
by Dave Avery | Oct 10, 2016 | Cloud, Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL
Take Percona’s One-Click 2017 Top Database Concerns Poll. With 2017 coming quick around the corner, it’s time to start thinking about what next year is going to bring to the open source database community. We just finished Percona Live Europe 2017, and at the...
by Dave Avery | Oct 5, 2016 | MySQL, Percona Live
Hello again, from day two of the sold out Percona Live Europe Open Source Database Conference! There is still much excitement here at the conference, and today looks to be just as busy as yesterday. Day two of Percona Live Europe 2016 kicked off once again with a...
by Pablo Padua | Sep 27, 2016 | MySQL
This blog post will discuss how to use the MySQL super_read_only system variable. It is well known that replica servers in a master/slave configuration, to avoid breaking replication due to duplicate keys, missing rows or other similar issues, should not receive write...
by Kortney Runyan | Sep 22, 2016 | MySQL
The Call for Speakers for Percona Live Open Source Database Conference 2017 is open and accepting proposals through Oct. 31, 2016. The Percona Live Open Source Database Conference 2017 is the premier event for the diverse and active open source community, as well as...
by Miguel Angel Nieto | Sep 16, 2016 | Insight for DBAs, MySQL
In this blog post, we’ll look at what MySQL does under the hood to transform NoSQL requests to SQL (and then store them in InnoDB transactional engine) when using the X Plugin. X Plugin allows MySQL to function as a document store. We don’t need to define...
by Nik Vyzas | Sep 16, 2016 | MySQL
When it comes to “decision time” about which type of MySQL HA (high-availability) solution to implement, and how to architect the solution, many questions come to mind. The most important questions are: “What are the best tools to provide HA and Load...
by Bradley Mickel | Sep 14, 2016 | Insight for DBAs, MySQL
In this blog post, we’ll discuss the MySQL default configuration changes between 5.6 and 5.7. MySQL 5.7 has added a variety of new features that might excite you. However, there are also changes in the current variables that you might have overlooked. MySQL 5.7...
by Muhammad Irfan | Sep 14, 2016 | MySQL
Recently, I worked on a customer case where the customer needed to monitor the checksum via Nagios monitoring. The pmp-check-pt-table-checksum plugin from Percona Monitoring Plugins for MySQL achieves this goal. I thought it was worth a blogpost....
