17 March 2015, Lysaker, Oslo
It was a database conference at Oracle building about MySQL and MySQL News and the rest.
They develop more InnoDB for a better transactional operations.
Replication for a better scalability.
Swedish Police uses MySQL; also, Facebook, Booking.com, Linkedin, CISCO and others.
They, I mean these two guys, brought infos about MEM (MySQL Enterprise Monitor). I have to admit that I didn't know about that.
And, also, they said something about MySQL Query Analiser.
MySQL has a developers team at Trondheim.
MEM (MySQL Enterprise Monitor)
MEM (MySQL Enterprise Monitor) works on Apache. It is a Java Application. To monitorize a
MySQL Server you need to put an agent on your Database Server.
HADOOP
I have to see what they did about this. (80% big data platform).MAX 2 TB for MySQL
SQL and NoSQL access to data.
SSD optimization
DUMP and RESTORE
mysql> SET innodb_buffer_pool_dump_at_shutdown=ON;
Transportable TABLES
FLUSH date for EXPORT;
Optimizer
EXPLAIN (this is used at the beginning and is not so precise)
….
OPTIMISER ( this is used at the end of a query and it has a better presentation as a result)
EXPLAIN [FORMAT=____] FOR CONNECTION
SERVER-SIDE STATEMENT TIMEOUT;
SELECT M;
MySQL Fabric
This is for using more databases, using mirrors. This is helping us not to do manual work when one of the servers is down. :(There is a farm of MySQL Servers and they work like a team.
I'll be back with documentation. Here I've put only a short sketch of mine made into Conference.