Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.

Percona Live Amsterdam is just finished… there was an entire room full day about MySQL 8.0 which is wonderful but there was also another product that everybody was talking about: ProxySQL (great job René).

Ronald Bradford and the MySQL engineering team were discussing about what tool was missing in the MySQL ecosystem and Mark Leith highlighted that a datamasking utility was really missing.

Having used already ProxySQL for Group Replication and other tests, I knew that it would be possible to use it also for this purpose. After a very short discussion and a nightly chat with …

Good news ! The MySQL & Friends Devroom has been accepted for Fosdem’s 2017 edition !

This event is a real success story for the MySQL ecosystem, the content, the speakers and the attendees are growing every year.

Fosdem’s organization left out som e long time participants to give other projects a chance as welll to be present at this massive event. Hopefully we were accepted as MySQL is present at Fosdem since the very first editions.

The 2017’s edition will take place 4th & 5th February in Brussels.

I’m currently forming the committee for this new edition and the CfP should open in some days. Stay tuned and prepare your trip to Belgium for the winter !

lefred.

MySQL 5.7 improved as compare to previous releases in terms of transnational capabilities, performance with high load, high Availability, Security and it’s defaults.

Check my blog post : MySQL 5.7 features

This blog post will describe End to End implementation of MySQL on Linux distributions Which will cover MySQL Installation, configuration and administration in production environment with proper configuration. So you can start using your application by implementing following setup and in future you can change it if requires.

• Database Installation
• MySQL Variables and Configuration
• …

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 other, more complex scripting environments such as Perl and Python, it doesn’t require any additional dependencies to be installed.

Anyone that has automated a MySQL task using a Bourne shell such as Bash will be familiar with the following message:

Warning: Using a password on the command line interface can be insecure.

This semi-ominous warning describes a security flaw in passing credentials on a process command line. Any unprivileged user on the system can use a command …

How does an application configure its database connection?  I find this to be a pretty interesting question. As the application moves from a developer’s workstation to a test harness, then to staging, and on to production, the database connection properties can change each time. …

In MySQL 5.7 we introduced JSON functionality into the MySQL Server. This work included the introduction of a JSON data type, virtual columns and a set of approximately 20 SQL functions that allow you to manipulate and search JSON data on the server side.…

I’m pleased to announce the newest MySQL Connector/J 5.1 Maintenance Release.

As usual, MySQL Connector/J 5.1 can be downloaded from the official distribution channels MySQL Downloads and The Central Repository. The commercially licensed version is available for download at My Oracle Support.

Please don’t forget to consult the CHANGES file in the download archive and/or the release notes page to know what is new and if there are any changes that might affect your applications.

MySQL Connector/J 5.1.40 is the official JDBC driver for MySQL …

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 keynote presentation by Percona co-founder and CEO Peter Zaitsev on Percona Contributions to the Open Source Database Ecosystem, which highlighted Percona’s focus, approach and contributions to the open source database community. Peter talked about his passion for open source software, database technology and finding the best …

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 find release details of the release in the 5.5.52-38.3 milestone on Launchpad. Downloads are available here and from the Percona Software Repositories.

Bugs Fixed: …