MySQL Tech Tour 18/02/2014

I took part in the MySQL Tech Tour, organized by Oracle in Rome on 18 February, 2014. Here are the most important Tips and Tricks :

• The new MySQL Enterprise Console 3.0 doesn't need anymore the agent's installation into the database to be monitored. The main component are these : 

• Web console
• Service manager
• Repository database

• It's still possible to install the agent and obtain host's statistics for example. Attention, the version of database has to be version 5.6 otherwise the agent is still necessary. It's also possible to enable and activate agent and advisor, those similar to Oracle database. The repository of EM Console is the PERFORMANCE_SCHEMA inside the mysql database repository.

• MYSQL Enterprise Backup is now 49 times faster than the mysqldump command.

• Purchasing an Enterprise license you can get mysql support, news features like thread pool or external authentication and also utility tools like Enterprise Console and Backup, Audit, etc.

• The Master/Slave replication is always asynchronous but it's now possible to start in a semisynchrous mode. Information about master/slave's configuration is now stored in tables and not in text files. It's possible to enable a 'Time Delay Replication' in the cluster's setting and with this option  you can kepp an older copy of the database , useful in case ok human error like 'DROP TABLE' to restore the lost data.
• Another useful utility is the mysqlreplicate command that can be applied to build a master/slave cluster with only one command. The mysqlfailover command that is able to identify a crash of the master server database and promote the slave server as a new master. Look out for client's IP address, you still have to change manually.
• The mysql release 5.6 is now Generally Available (GA) instead the release 5.7 is still in a Beta Version. 
• The sharding of the tables is a mysql's cluster option, now has reached at 7.3 version,  that is automatically able to partition a table across the nodes of the cluster. Be careful the tables are only stored in memory between the nodes of the cluster.
• Mysql cluster can now implement 'Foreign key' and it's ACID compliance and 9 times faster during insert sql command.

Finally I would like to say hello to two people met at the Event which I took part in, their names are Elias and ....I'm afraid I can't remember the name of the second one, but he lives in Passoscuro, really likes the sea like me and I'm sure I'll meet him one day.

See you in my next blog !