Colin Charles Agenda

Managing MySQL with Percona Toolkit by Frédéric Descamps

Sun, 05 Feb 2012 15:58:15 +0000

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 re-written in Perl. There is also a tarball or RPM or DEB packages. Know your [...] Related posts:

1. Practical MySQL Indexing guidelines by Stéphane Combaudon
2. Replication features of 2011 by Sergey Petrunia
3. MySQL synchronous replication in practice with Galera by Oli Sennhauser

Replication features of 2011 by Sergey Petrunia

Sun, 05 Feb 2012 14:32:45 +0000

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 options, atuomatic relay log recovery, RBR slave type conversions (question if this is [...] Related posts:

1. MariaDB 5.3 query optimizer by Sergey Petrunia
2. Where is MariaDB today?
3. Building simple & complex replication clusters with Tungsten Replicator by Giuseppe Maxia

MySQL Creatively in a Sandbox by Giuseppe Maxia

Sun, 05 Feb 2012 13:57:47 +0000

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: make_sandbox foo.tar.gz. Then just do ./use. $SANDBOX_HOME is ~/sandboxes. You can also create [...] Related posts:

1. Building simple & complex replication clusters with Tungsten Replicator by Giuseppe Maxia
2. MySQL HA reloaded by Ivan Zoratti
3. MySQL synchronous replication in practice with Galera by Oli Sennhauser

Optimizing your InnoDB buffer pool usage by Steve Hardy

Sun, 05 Feb 2012 13:29:02 +0000

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 allows you to inspect your buffer pool (unsure if this is [...] Related posts:

1. Batched Key Access Join Previews available
2. MariaDB 5.3 query optimizer by Sergey Petrunia
3. MariaDB/MySQL users in Paris & Brussels

Practical MySQL Indexing guidelines by Stéphane Combaudon

Sun, 05 Feb 2012 13:01:06 +0000

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 fast. Secondary keys hold the PK values. Designing InnoDB PK’s with care is [...] Related posts:

1. Sphinx user stories by Stéphane Varoqui
2. Managing MySQL with Percona Toolkit by Frédéric Descamps
3. MySQL Full Text Search by Alex Rubin

MySQL synchronous replication in practice with Galera by Oli Sennhauser

Sun, 05 Feb 2012 12:30:42 +0000

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 can have even more. Scaling reads and also a little bit for scaling writes is what Galera [...] Related posts:

1. MySQL HA reloaded by Ivan Zoratti
2. Ticketmaster thrives on MySQL Replication
3. New MySQL 5.6 Features by Oli Sennhauser

Optimising SQL applications by using client side tools by Mark Riddoch

Sun, 05 Feb 2012 11:54:14 +0000

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 SQL debugger? Profilers addresses the “when”. SQL developer tools: [...] Related posts:

1. Open source tools to run a small-medium sized business
2. Practical MySQL Indexing guidelines by Stéphane Combaudon
3. Leaving Summer of Code applications to the last minute?

MySQL Cluster by Ralf Gebhardt

Sun, 05 Feb 2012 11:25:32 +0000

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 in-memory). Checkpointing to disk for durability. It supports two types of indexes – ordered T-trees, unique hash indexes. Online operations [...] Related posts:

1. MySQL synchronous replication in practice with Galera by Oli Sennhauser
2. Practical MySQL Indexing guidelines by Stéphane Combaudon
3. Managing MySQL with Percona Toolkit by Frédéric Descamps

Building simple & complex replication clusters with Tungsten Replicator by Giuseppe Maxia

Sun, 05 Feb 2012 11:01:26 +0000

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 transaction ID today also means you may have slaves that may not be synchronized fully. Finally, some people like [...] Related posts:

1. MySQL Creatively in a Sandbox by Giuseppe Maxia
2. MySQL HA reloaded by Ivan Zoratti
3. Replication features of 2011 by Sergey Petrunia

How to offload MySQL server with Sphinx by Vladimir Fedorkov

Sun, 05 Feb 2012 10:29:05 +0000

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 and SQL queries (SphinxQL). Some query examples are in the slides, here’s one about SphinxSE in [...] Related posts:

1. MySQL Full Text Search by Alex Rubin
2. Sphinx user stories by Stéphane Varoqui
3. Morning sessions at MySQL MiniConf

Comments (0) - Read and Add your own Comments