BE SHARING

Elisa Usai

Deploy a MySQL Server in Docker containers

08.10.2018 by Elisa Usai

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(…)

Database Administration & Monitoring

MySQL 8.0 – Roles are finally there

22.06.2018 by Elisa Usai

Roles have been existing on many RDBMS for a long time by now. Starting from version 8.0, this functionality is finally there for MySQL. The most important advantage is to define only once a role that includes a “set(…)

Database Administration & Monitoring

MySQL – Time mismatch between system and log files

13.04.2018 by Elisa Usai

I was working on MySQL upgrades to version 5.7 at a customer, when I found out that for my instance, time in the error log file didn’t correspond to local system time: mysql@test1:/u01/app/mysql/admin/mysqld1/log/ [mysqld1] mysql -uroot -p Enter password: ERROR(…)

Database Administration & Monitoring

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

08.03.2018 by Elisa Usai

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(…)