The latest from the MySQL community

In this posting we will look at currently recommended ways of managing passwords in MySQL Docker containers and explore whether the recently introduced concept of Docker Secrets could play a role in this area. Managing runtime secrets in Docker has traditionally been hard to do securely. The MySQL Docker images have typically offered various ways […]

In this post, we are going to explore the way of how to import a .csv file through the command line in dbForge Studio for MySQL. You will not have to waste your valuable time on manually specifying properties each time you need to create a new MySQL table. With this option, you can forget […]

In one of my previous posts, I shared InnoDB table compression statistics for a read-only dataset using the default value of innodb_compression_level (6).  In it, I claimed, without giving much detail, that using the maximum value for the compression level (9) would not make a big difference.  In this post, I will share more details about this claim.

TL;DR: tuning innodb_compression_level is not

In this post I’ll answer questions I received in my Wednesday, July 19, 2017, webinar Learning MySQL 5.7!

First, thank you all who attended the webinar. The link to the slides and the webinar recording can be found here.

I received a number of interesting questions in the webinar that I’ve followed up with below.

Would there be a big difference on passing from 5.1 to 5.6 before going to 5.7 or, at this point, would it be roughly the same?

The biggest risk of jumping between versions, in this case 5.1 to 5.6, is reverting in case of problems. Rollbacks don’t happen often, but they do happen and you have to make …

Airvantage is a Value Added Service Provider for mobile telecommunication networks. Airvantage offers various gaming platforms, and subscriber retention initiatives like emergency airtime, mobile money integration, etc.

A simple solution for staying compliant

Airvantage host each customer’s database on its server (virtual) as they are bound to do so from a legislative perspective. They are presently monitoring several production servers that are spread over various countries in Africa and the Caribbean. Looking at many tools, including ManageEngine and some open source alternatives, Airvantage opted for Monyog for its simplicity, ease of config, and relatively affordable price-tag.

Liam described what he needed was “a complete MySQL monitoring system with early-warning mechanisms which allow him to sleep much better”.  With Monyog, Liam instantly started relying on the 600+ monitors and alerts to become better at …

Airvantage is a Value Added Service Provider for mobile telecommunication networks. Airvantage offers various gaming platforms, and subscriber retention initiatives like emergency airtime, mobile money integration, etc.

A simple solution for staying compliant

Airvantage host each customer’s database on its server (virtual) as they are bound to do so from a legislative perspective. They are presently monitoring several production servers that are spread over various countries in Africa and the Caribbean. Looking at many tools, including ManageEngine and some open source alternatives, Airvantage opted for Monyog for its simplicity, ease of config, and relatively affordable price-tag.

Liam described what he needed was “a complete MySQL monitoring system with early-warning mechanisms which allow him to sleep much better”.  With Monyog, Liam instantly started relying on the 600+ monitors and alerts to become better at …

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.26. See the release notes and changelogs for details. Download MariaDB 10.1.26 Release Notes Changelog What is MariaDB 10.1? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

The post MariaDB 10.1.26 now available appeared first on MariaDB.org.

JSON in Flat File to MySQL DatabaseSo how do you load that JSON data file into MySQL. Recently I had this question presented to me and I thought I would share a handy script I use to do such work. For this example I will use the US Zip (postal) codes from JSONAR. Download and unzip the file. The data file is named zips.json and it can not be bread directly into MySQL using the SOURCE command. It needs to have the information wrapped in a more palatable fashion.

head zips.json 
{ "city" : "AGAWAM", "loc" : [ -72.622739, 42.070206 ], "pop" : 15338, "state" : "MA", "_id" : "01001" }
{ "city" : "CUSHMAN", "loc" : [ -72.51564999999999, 42.377017 ], "pop" : 36963, "state" : "MA", "_id" : "01002" }
{ "city" : "BARRE", "loc" : [ -72.10835400000001, 42.409698 ], "pop" : 4546, "state" : "MA", "_id" : "01005" }
{ "city" : "BELCHERTOWN", "loc" : [ -72.41095300000001, …

Welcome to a new weekly column on the Percona blog. My name is Colin Charles, Percona Chief Evangelist, and I have been involved in MySQL, MariaDB Server and the open source community for over a decade. Now I am at Percona, and this is my weekly column.

When you start a column, you have ask yourself what you’ll be writing about. Keeping the focus on the reader is what’s crucial. With this in mind, I plan to cover happenings, pointers and maybe even musings in this column. It’s August, and while many are away on summer vacations, there’s still plenty happening in the database world. So maybe this will be a little like the now-defunct, Weekly MySQL News. It will be broader than just MySQL, however, and focus on open source databases (after all, Percona’s mission is to …

TL;DR: we still need MyISAM and myisampack because it uses less space on disk (half of compressed InnoDB) !

In the previous post, I shared my experience with InnoDB table compression on a read-only dataset.  In it, I claimed, without giving much detail, that using MyISAM and myisampack would result is a more compact storage on disk.  In this post, I will share more details about this claim.