Profile cover photo
Profile photo
Giuseppe Maxia
679 followers -
The Data Charmer
The Data Charmer

679 followers
About
Giuseppe's posts

Post has attachment
Frictionless MySQL installation
I saw an interesting post about the ability of installing MySQL 5.7 without changing existing tools and procedures. The post is a plea to make MySQL installation frictionless. That post was followed by a conversation on Twitter , where the recent security e...

Post has attachment
MySQL replication in action - Part 1: GTID & Co
In the theoretical part of this series, we have seen the basics of monitoring. In that article, though, we have barely mentioned the new tools available in MySQL 5.7 and MariaDB 10. Let’s start from something that has the potential of dramatically changing ...

Post has attachment
MySQL::Sandbox 3.0.66 - improved usability and support for newest releases
The latest MySQL Sandbox , version 3.0.66 is out. It has a few new features (as always, when I find myself doing the same thing many times, I script it) and improved support for latest releases of MySQL. You can now install, among other versions, MySQL 5.7....

Post has attachment
Changed defaults between MySQL 5.6 and 5.7
MySQL 5.7 comes with many changes . Some of them are better explained than others. I wanted to see how many changes I could get by comparing SHOW VARIABLES in MySQL 5.6 and 5.7. The most notable ones are: binlog_format : the default is now ROW. This variabl...

Post has attachment
In search of cleanliness : the elusive silent installation
A clean installation of a database server is one where everything goes according to the expectations. It used to be easy: you only had to do what the manual says, and, presto! you would see your database server installed and ready to use. If something went ...

Post has attachment
Yet another MySQL 5.7 silent change
When a new version of MySQL appears, the first source of information for the brave experimenter is a page in the manual named What is new in MySQL X.X , also known as MySQL in a nutshell . For MySQL 5.7, the in-a-nutshell page lists quite a lot of changes. ...

Post has attachment
MySQL 5.7.8 : features, bugs and rumors
I’ve had a look at a preview release of MySQL 5.7.8, some time before it became available to the general public (perks and duties of an Oracle ACE ) and I found a few interesting things among the release notes and the tarball itself: There is a new tool nam...

Post has attachment
MySQL replication monitoring 101
Replication is the process that transfers data from an active master to a slave server, which reproduces the data stream to achieve, as best as possible, a faithful copy of the data in the master. To check replication health, you may start with sampling the...

Post has attachment
Yet another MySQL 5.7 silent change
When a new version of MySQL appears, the first source of information for the brave experimenter is a page in the manual named What is new in MySQL X.X , also known as MySQL in a nutshell . For MySQL 5.7, the in-a-nutshell page lists quite a lot of changes. ...

Post has attachment
MySQL 5.7 : no more password column!
Maintaining a project like MySQL::Sandbox is sometimes tiring, but it has its advantages. One of them is that everything related to the server setup comes to my attention rather earlier than if I were an average DBA or developer. I try to keep MySQL Sandbox...
Wait while more posts are being loaded