CoderTakeout - MySQL

(SUMMARY) Frédéric Descamps of Percona . Percona Toolkit is Maatkit & Aspersa combined. Opensource and the tools are very useful for a DBA. You need Perl, DBI, DBD::mysql, Term::ReadKey. Most tools are written in Perl, and whatever is in Bash is being...

(SUMMARY) Sergey Petrunia of the  MariaDB project & Monty Program . MySQL 5.5 GA at the end of 2010. MariaDB 5.3 RC towards the end of 2011 (beta in June 2011). MySQL 5.5 is merged to Percona Server 5.5 which included semi-sync replication, slave fsync...

(SUMMARY) Giuseppe Maxia of Continuent and long time creator of MySQL Sandbox . Only works on Unix-like servers. Works with MySQL, Percona & MariaDB servers. MySQL server has the data directory, the port and the socket you can t share these. To use it:...

(SUMMARY) Steve Hardy of Zarafa . Work that has been done to make Zarafa better. Why do you optimise your buffer pool? To decrease your I/O load. How can you do it? Buy more RAM, page compression, less (smaller) data, rearrange data. MariaDB or Percona Server...

(SUMMARY) Stéphane Combaudon of Dailymotion. Index: separate data structure to speed up SELECTs. Think of index in a book. In MySQL, key=index. Consider that indexes are trees. InnoDB s clustered index data is stored with the Primary Key (PK) so PK lookups are...

(SUMMARY) Oli Sennhauser of FromDual . Synchronous multi-master replication with the Galera plugin. Your application connects to the load balancer and it redirects read/write traffic to the various MySQL Galera nodes. Tested a setup with 17 SQL nodes and you...

(SUMMARY) Mark Riddoch of SkySQL . This was a talk about the future in general. What people would like. Etc. Not about something that exists yet, hence the sparse notes. Trace statements are good for the why . You move on to the debugger, but what is a useful...

(SUMMARY) Ralf Gebhardt of SkySQL . Cluster: shared nothing architecture (no single point of failure), synchronous replication between nodes, ACID transactions, row level locking. In-memory storage (some data can be stored on disk, but indexes must be...

(SUMMARY) Giuseppe Maxia of Continuent . MySQL replication is single threaded. Multi-master replication is complex with MySQL. Circular replication works but is very fragile. Once you ve achieved the feat, how do you avoid conflicts? The lack of global...

(SUMMARY) Vladimir Fedorkov of Sphinx . Presentation started out with a very nice presentation of candies to all the audience members. What is Sphinx? Another (C++) daemon on your boxes. Can be queried via API (PHP, Python, etc.) or MySQL-compatible protocol...