Plenty of tutorials & talks at this year’s edition of the Percona Live Conference covering Galera Cluster
We’re delighted to see the great coverage that Galera Cluster is getting at this year’s Percona Live MySQL Conference & Expo!
Thank you to all the speakers who, alongside our very own Seppo Jaakola (Galera Cluster – New Features & Write Conflicts in Multi-Master Replication Topologies), have prepared topics that cover and/or include Galera Cluster.
This is a shout out to them all and a heads up to everyone who’s attending Percona Live in Santa Clara this April to check out these talks & tutorials.
If you have done so yet, you can still register for the conference here: http://www.percona.com/live/mysql-conference-2014/
The following tutorials & talks covering or including Galera Cluster are part of the conference program (you can find extracts of the descriptions further below; if we’ve missed any talks or tutorials that should also be mentionned here, please do let us know).
We look forward to seeing you all in Santa Clara and to lots of insightful discussions!
- Percona XtraDB Cluster / Galera in Practice – 2014 edition
- MariaDB 10 – The complete tutorial
- ACIDic Clusters: Review of current relational databases with synchronous replication
- Galera Cluster New Features
- Migrate an infrastructure to Galera Cluster
- Percona Server and Percona XtraBackup
- Write Conflicts in Multi-Master Replication Topologies
Percona XtraDB Cluster / Galera in Practice – 2014 edition
Speaker: Jay Janssen
Replication and High Availability Strategies
1 April 9:30AM – 12:30PM @ Ballroom H
This is a full day tutorial
This tutorial will utilize laptop-based VMs to guide attendees through the basics of setup and administration of XtraDB cluster. Covered topics will be:
• Migration from standard mysql to xtradb cluster
• Configuration differences between standard mysql and xtradb cluster
• Monitoring cluster node states
• Adding nodes to the cluster and various SST methods
• Cluster maintenance
• Examples of the types of locking different clients can expect to see in Xtradb cluster if writing to multiple nodes.
This talk will require attendees have a reasonably powerful laptop and Virtualbox installed.
Full description: http://www.percona.com/live/mysql-conference-2014/sessions/percona-xtradb-cluster-galera-practice-2014-edition
MariaDB 10 – The complete tutorial
Speakers: Ivan Zoratti & Colin Charles
1 April 9:30AM – 12:30PM @ Ballroom D
MariaDB 10 is loaded with lots of new features to increase data integration, performance, availability, scalability and orchestration.
This is a hands-on tutorial. The attendees will receive a USB key with handout material, software, examples and a VM that can be used to explore the functionalities of MariaDB 10.
Full description: http://www.percona.com/live/mysql-conference-2014/sessions/mariadb-10-complete-tutorial
ACIDic Clusters: Review of current relational databases with synchronous replication
Speaker: Raghavendra Prabhu
Replication and High Availability Strategies
2 April 1:20PM – 2:10PM @ Ballroom C
This talk reviews database clusters of our time which employ synchronous
replication while being ACID compliant. ACID compliance implies ability
to support transactions across nodes. As part of this talk, PXC (Percona
XtraDB Cluster)/Galera, Google F1 based on Spanner/CFS and MySQL Cluster
will be considered. Primary objective here is to expound features of
each in order to highlight differentiating factors and commonality
between them.
Full description: http://www.percona.com/live/mysql-conference-2014/sessions/acidic-clusters-review-current-relational-databases-synchronous-replication
Galera Cluster New Features
Speaker: Seppo Jaakola
Replication and High Availability Strategies
2 April 2:20PM – 3:10PM @ Ballroom C
Galera Cluster for MySQL is a revolutionary step forward in MySQL high-availability. It provides synchronous, multi-master, active-active clustering for InnoDB. No longer do you have to make tradeoffs between data integrity/durability and failover time, nor do you have to accept a performance hit because you need high-availability.
Galera Cluster version 3 was released in November 2013 and since then the work for next generation Galera Clustering has started. In this presentation we give an overview of Galera Cluster features and benefits and walk through the version 3 and later new features.
Full description: http://www.percona.com/live/mysql-conference-2014/sessions/galera-cluster-new-features
Migrate an infrastructure to Galera Cluster
Speaker: Art van Scheppingen
Replication and High Availability Strategies
2 April 3:50PM – 4:40PM @ Ballroom H
Galera Cluster is a synchronous multi-master cluster for MySQL that allows you to synchronously replicate your data to every node in the cluster. Galera Cluster makes the life of a DBA easier with features like automatic node joining, electing donor nodes and automatic node removal once a node has failed. There is also no need to distinguish master and slave relations in your application as all nodes in the cluster are writable. Consider all nodes in the cluster as one big MySQL database server.
In this talk I will explain how Spil Games strives to have their entire MySQL environment running on Galera Cluster. The session will include design choices, learnings and the pitfalls we fell into.
Full description: http://www.percona.com/live/mysql-conference-2014/sessions/migrate-infrastructure-galera-cluster
Percona Server and Percona XtraBackup
Speakers: Peter Schwaller, Laurynas Biveinis, Alexey Pokytov
2 April 6:00PM – 7:00PM @ Ballroom B
Discuss all topics related to Percona Server and Percona XtraBackup with members of the development team.
Full description: http://www.percona.com/live/mysql-conference-2014/sessions/percona-server-and-percona-xtrabackup
Write Conflicts in Multi-Master Replication Topologies
Speaker: Seppo Jaakola
Replication and High Availability Strategies
3 April 4:30PM – 5:20PM @ Ballroom H
Galera Cluster is synchronous multi-master cluster, which allows clients to read and write to any cluster node, without any limitations.
When two or several clients happen to write to same data element at the same time, the cluster must decide how to resolve the conflict – the bottom line is that only one write can be accepted. Galera will resolve this by letting the first committing transaction to succeed and latter transaction will rollback and receive deadlock error. This protocol will make sure that data is consistent at all times, but the toll is that transaction throughput will degrade if conflict rate grows too high.
In this presentation, we will focus on:
• How to detect multi-master conflicts in Galera Cluster and what to learn of them
• How big conflict rate is acceptable before you get to experience performance degradation
• If deadlocks cause performance problems, how to minimize the conflicts
Full description: http://www.percona.com/live/mysql-conference-2014/sessions/write-conflicts-multi-master-replication-topologies