Introduction to Continuent Tungsten for MySQL: increasing MySQL performance with advanced high performance parallel replication. Presented by Robert Hodges, CTO at Continuent.

Lars Thalmann, now leading the MySQL Replication team, explains the architecture of MySQL Replication.

MySQL Sandbox is a tool to install a side server or a replication system in seconds, in complete isolation, without need to remember complex sequence of commands.Administrators, developers, QA and support engineers need to install and test several versions of MySQL database server. Performing this task safely, without affecting existing instances on the same host is not easy. Using MySQL Sandbox, users can: Install a new server in less than 10 seconds, just by pointing to a binary tarball; Install an system of master + slaves in replication in less than 15 seconds; Install 10 independent servers in one minute with just one command; Optionally, install the above items with complex options, using one command, without need of editing configuration files. This presentation explain how to install a server or a replication system with MySQL Sandbox, covering the basics and some advanced  []

In this talk, the developers behind MySQL Replication walk through some of the new Replication features of MySQL 5.1 and MySQL 6.0, such as: Row-based Replication (5.1) is used for MySQL Cluster replication and also provides a safer way to replicate non-deterministic statements. Row-based support for mysqlbinlog client (5.1) is used to analyze the row-based binlog entries. Row-based point-in-time recovery (5.1) is used to restore a server to a particular time point regardless of binlogging format. Heartbeating (6.0) is used to manage that the master and slave connection is always up. Semi-synchronous Replication (6.0) is used to ensure that any update of the master is on the slave before transaction is acknowleged to the user. Replication Server Filtering (6.0) ensures that the user can more easily replicate in a circle. Relay log synchronization (6.0) ensures that the slave is restartable without clearing the relay log in case of crashes.

This session describes investigations into performance and scalability of InnoDB when using the binlog for replication, focusing primarily on the replication master. The session will highlight tools and techniques used to reveal scalability bottlenecks within the MySQL and InnoDB code, approaches used to eliminate those bottlenecks, and current results. The discussion will focus on a current prototype patch that achieves substantial throughput increases for read/write workloads, and enables concurrent commits for InnoDB XA transactions. - Note that the video must be downloaded to be able to view it!

There are various setups and solutions to solve the problem of having redundant mysql masters and scaling writes on them. MySQL Cluster can be an alternative. MySQL Cluster can effectively do what DRBD and MySQL Replication do in a HA MySQL setup. But better.

An introduction to Gearman (a client/server infrastructure for distributed workers) and its practical application to replication setup. By combining the ease of use of MySQL Sandbox and the flexibility of Gearman, you can ger remote replication setup with low risk of mistakes.

This session describes investigations into performance and scalability of InnoDB when using the binlog for replication, focusing primarily on the replication master. The session will highlight tools and techniques used to reveal scalability bottlenecks within the MySQL and InnoDB code, approaches used to eliminate those bottlenecks, and current results. The discussion will focus on a current prototype patch that achieves substantial throughput increases for read/write workloads, and enables concurrent commits for InnoDB XA transactions. - Note that the video must be downloaded to be able to view it!

In this talk, the developers behind MySQL Replication walk through some of the new Replication features of MySQL 5.1 and MySQL 6.0, such as: Row-based Replication (5.1) is used for MySQL Cluster replication and also provides a safer way to replicate non-deterministic statements. Row-based support for mysqlbinlog client (5.1) is used to analyze the row-based binlog entries. Row-based point-in-time recovery (5.1) is used to restore a server to a particular time point regardless of binlogging format. Heartbeating (6.0) is used to manage that the master and slave connection is always up. Semi-synchronous Replication (6.0) is used to ensure that any update of the master is on the slave before transaction is acknowleged to the user. Replication Server Filtering (6.0) ensures that the user can more easily replicate in a circle. Relay log synchronization (6.0) ensures that the slave is restartable without clearing the relay log in case of crashes.

The MySQL Replication developers walk through some of the new Replication features of MySQL 5.1 and MySQL 6.0, such as row-based replication, heart-beating and semi-synchronous replication.

See the replication developers give you a fast-paced session of some of the more interesting, useful, and odd ticks available for the intermediate to advanced replication user.

How do you set up replication? What can you do with replication? If these are the kinds of questions you ask yourself, then you need to go to this replication tutorial. You will hear the replication developers explain the architecture and concepts behind replication, and learn how to configure and use replication for managing backups, handle high-availability, and performing scale-out.

There are many different ways of scaling up and scaling out using MySQL. You can take advantage of replication, DRBD, memcached, MySQL Proxy and many other solutions. This tutorial will take you through all of these solutions and their combinations to increase your database throughput.

This proposal is to highlight the integration of Open HA Cluster and MySQL. I will cover the various aspects of high availability and business continuity. In addition to the current features, the roadmap of Open HA Cluster will be discussed. There is a large focus on the integration with MySQL replication and MySQL cluster.

You don't have to read source code -- understanding how MySQL works can be achieved through the system data. Learn a wide range of topics in this 3-hour tutorial, and leave armed with tons of knowledge about how MySQL 5.0, 5.1 and 6.0 work. You will take home a healthy understanding of performance tuning, storage engines, replication and many tips and tricks to help you be a better DBA.

Do you use replication? Would you like to improve your data protection and recovery capabilities? If you do, chances are you would also like to improve your ability to recover from failures faster. In this session, we will show you how you can use backup to enhance your replication capabilities.

An updated overview of MySQL High Availability deployment options with DRBD. Covers DRBD for low-latency workloads (leveraging Dolphin Express interconnect technology), four-way replicated storage redundancy, end-to-end replication integrity checking, and more.

Binlogs are essential for the MySQL Replication. MySQL Proxy can unleash the full power of binlogs: filtering, rewriting, splitting and merging.

Insightful presentation giving an overview over MySQL HA Solutions.