by Jon Tobin | Oct 19, 2016 | Cloud, Hardware and Storage, MySQL
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . . How did this...
by Alexander Rubin | Oct 18, 2016 | MySQL
This blog post discusses the ramifications of STRICT mode in MySQL 5.7. In short By default, MySQL 5.7 is much “stricter” than older versions of MySQL. That can make your application fail. To temporarily fix this, change the SQL_MODE to...
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 Hrvoje Matijakovic | Oct 18, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.6.33-79.0 on October 18th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.33, including all the bug fixes in it, Percona Server 5.6.33-79.0 is the...
by Roman Vynar | Oct 14, 2016 | Percona Events, Percona Software
Percona is glad to announce the release of Percona Monitoring and Management 1.0.5. PMM Server is distributed through Docker Hub, PMM Client – through tarball or system packages. The instructions for installing or upgrading PMM are available in the...
by Hrvoje Matijakovic | Oct 13, 2016 | MySQL, Percona Software
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 the following warning on Ubuntu 16.04 (Xenial Xerus): W: http://repo.percona.com/apt/dists/xenial/InRelease:...
by Alexander Rubin | Oct 12, 2016 | MySQL
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...
by Ceri Williams | Oct 12, 2016 | Insight for DBAs, MySQL, Percona Software
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 5.6.6 and later introduced the...
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 10, 2016 | MySQL
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...
by Federico Razzoli | Oct 10, 2016 | MySQL, Percona Software
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...
by Peter Zaitsev | Oct 7, 2016 | MongoDB, MySQL, Percona Events
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 Dave Avery | Oct 7, 2016 | MySQL
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...
by David Bennett | Oct 6, 2016 | MySQL
This blog post discusses how to use MySQL shell securely from Bash. The Bourne shell is everywhere. It is part of the most basic Linux install. You will find it on the biggest SPARC machines down to a Raspberry Pi. It is nice to know it will always be there. Unlike...
by Dave Avery | Oct 5, 2016 | Cloud, Percona Live
We’re winding down here at the Percona Live Europe Open Source Database Conference 2016, but there are still talks going on. The conference has a technical focus with an emphasis on the core topics of MySQL, MongoDB, PostgreSQL and other open source databases....
by Dave Avery | Oct 5, 2016 | Percona Live
The Percona Live Europe 2016 conference is moving along quickly, and today we saw a lot of presentations on open source database that AREN’T MySQL or MongoDB. There are more than 100 open source databases in the world, each with their own design and use case...
by Dave Avery | Oct 5, 2016 | MongoDB, Percona Live
Lots of talks and presentations going on at the Percona Live Europe Open Source Database Conference 2016 on day two! Today is just as packed as yesterday, and we were able to attend some more of the talks. MongoDB has had an increasing presence at Percona Live Europe,...
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 Hrvoje Matijakovic | Oct 5, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.5.52-38.3 on October 5, 2016. Based on MySQL 5.5.52, including all the bug fixes in it, Percona Server 5.5.52-38.3 is now the current stable release in the 5.5 series. Percona Server is open-source and free. You can...
