MySQL

MySQL 8 and Security – Encryption of binary logs

As I discussed in some of my recent talks at conferences (at the DOAG for example), MySQL 8 came out with new features which bring lots of improvements in terms of security.

Deploy a MySQL Server in Docker containers

We hear about Docker every day. By working on MySQL Server, I am curious to test this platform which makes it possible to create containers independent of the OS to deploy virtualized applications. So let's try to deploy a MySQL(…)

Installing MAMP to play with PHP, MySQL and OpenFlights

By Franck Pachot . You may wonder what I'm doing with those technologies that are completely different from what I usually do. I'll detail in a future blog post but the idea is giving a short introduction to databases to(…)

OpenShift on my Windows 10 laptop with MiniShift

By Franck Pachot . If you want to play with OpenShift on your laptop, you can, in a Virtual Machine. I have VirtualBox installed on my laptop. I'll install Minishift here, which will create the VM to run OpenShift with(…)

MySQL – Foreign keys and “Cannot delete or update a parent row: a foreign key constraint fails” error

As you know, foreign keys establish a sort of relationship between 2 tables. MySQL requires InnoDB storage engine to support foreign keys. In our example, we have the following parent table in a MySQL 5.7.21 server: mysqld3-(root@localhost) [sakila]> show create(…)

2016 is over and it was great, 2017 will be even more exciting in the open source area

Disclaimer: This will not be a technical post at all. The goal is to provide a short overview of what we did in 2016 and what we plan to do in 2017 when it comes to our(…)

MySQL 8.0.0 DMR – First impression

Last week (09/12/2016) was announced the new MySQL 8.0.0 DMR (Development Milestone Release) It is now available for download at dev.mysql.com I downloaded and installed it Following are my first impression on some new features First(…)

The (almost) same sample schema for all major relational databases (3) – MySQL/MariaDB

Some time ago I blogged on how to get the "Dell DVD Store Database Test Suite" installed in PostgreSQL and Oracle. This time we'll do the same on a MariaDB instance.

MySQL versions performance comparison

This blog aims to make a performance comparison between the different MySQL versions/editions and also comparing the differents MySQL forks such as Percona Server and MariaDB.  Indeed number of improvements as been done to innodb storage engine in the last(…)

Security improvements in MySQL 5.7

If you have a look on the last mysql 5.7.4 version or later you will probably see that there are several security improvements. The list of added security features and improvements can be seen on the following page: http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html(…)