5 October 2:40 PM - 3:05 PM
MySQL is a unique adult (now 21 years old) in many ways. It supports plugins. It supports storage engines. It is also owned by Oracle, thus birthing two branches of the popular opensource database: Percona Server and MariaDB Server. It also once spawned a fork: Drizzle. Lately a consortium of web scale users (think a chunk of the top 10 sites out there) have spawned WebScaleSQL.
You're a... [read more]
5 October 11:20 AM - 12:10 PM
at Zürich 2
This presentation will discuss the features of MySQL/MariaDB that when enabled and used improve the default usage of MySQL.
Many cloud-based applications fail to
- Using appropriate filesystem permissions
- Using TLS/SSL for connections
- Using TLS/SSL with MySQL replication
- Using external authentication plugins (LDAP, PAM, Kerberos)
- Encrypting all your data at rest
- Monitoring... [read more]
5 October 4:25 PM - 5:15 PM
at Matterhorn 2
Lets learn from MySQL failures at scale, because we tie in the topic of High Availability, in where people are thinking about geographical redundancy, and even things like automatic failover. In the talk there will be case study material, e.g. where automatic failure caused Github to go offline, where Facebook doesn’t use fully automated failover but assisted failover, etc.
3 October 9:00 AM - 12:00 PM
at Matterhorn 2
The MySQL world is full of tradeoffs and choosing a High Availability (HA) solution is no exception. This session aims to look at all of the alternatives in an unbiased nature. Preference is of course only given to opensource solutions.
How do you choose between: MySQL replication, MHA, DRBD, Tungsten, Galera Cluster? Do you integrate Pacemaker and Heartbeat like Percona Replication Manager?... [read more]