Monthly Archives - October 2016

Update the Signing Key for Percona Debian and Ubuntu Packages

signing key for Percona Debian and Ubuntu

In this blog post, we’ll explain how to update the signing key for Percona Debian and Ubuntu packages.
Some of the users might have already noticed following warning on Ubuntu 16.04 (Xenial Xerus):
W: Signature by key 430BDF5C56E7C94E848EE60C1C4CBDCDCD2EFD2A uses weak digest algorithm (SHA1)
when running apt-get update.
Percona .deb packages are signed with a key that uses an algorithm […]

Read more

MySQL 5.7 Performance Tuning Immediately After Installation

MySQL 5.7 Performance Tuning

This blog updates Stephane Combaudon’s blog on MySQL performance tuning, and covers MySQL 5.7 performance tuning immediately after installation.
A few years ago, Stephane Combaudon wrote a blog post on Ten MySQL performance tuning settings after installation that covers the (now) older versions of MySQL: 5.1, 5.5 and 5.6. In this post, I will look […]

Read more

Encrypt your –defaults-file


Encrypt your credentials using GPG
This blog post will look how to use encryption to secure your database credentials.
In the recent blog post Use MySQL Shell Securely from Bash, there are some good examples of how you might avoid using a ~/.my.cnf – but you still need to put that password down on disk in the script. MySQL […]

Read more

Using the loose_ option prefix in my.cnf

MySQL Grants and Users

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] /usr/sbin/mysqld: unknown variable ‘bogus_option=1’


2016-10-05 15:56:07 23864 [ERROR] /usr/sbin/mysqld: unknown variable ‘bogus_option=1’

The MySQL manual has a solution: use the loose_ prefix […]

Read more

Take Percona’s One-Click 2017 Top Database Concerns Poll

2017 top database concerns

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 conference we looked at new technologies, new techniques, and new ideas. […]

Read more

Percona Database Security Poll Results

This blog reports the results of Percona’s database security poll.
As Peter Zaitsev mentioned recently in his blog post on database support, the data breach costs can hit both your business reputation and your bottom line. Costs vary depending on the company size and market, but recent studies estimate direct costs ranging in average from $1.6M to 7.01M. […]

Read more

Consul Architecture


In this blog post, I’ll provide my thoughts about Consul for ProxySQL service discovery and automation.
I approached Consul recently while looking for a service discovery and configuration automation solution for ProxySQL. My colleague Nik Vyzas wrote a great post on this topic, and I suggest you read it. I wrote this article to share my first impressions […]

Read more

Why Percona didn’t participate in the 2016 Gartner Operational DBMS MQ

Gartner Operational DBMS MQ

Around this time last year, Gartner named Percona a Challenger in the 2015 Magic Quadrant for Operational Database Management Systems (Gartner Operational DBMS MQ). For those not familiar with these, Magic Quadrants (MQ) are a set of market research reports published by Gartner that provide qualitative analysis into a market by highlighting its participants, relevant […]

Read more

From Percona Live Europe 2016: Thank You, Attendees!

From everyone at Percona, we’d like to send a big thank you to all our sponsors, exhibitors, and attendees at this year’s Percona Live Europe Open Source Database Conference.
The conference was an outstanding success! The sold-out event brought the European open source database community together, with a technical emphasis on the core topics of MySQL, […]

Read more