Oli Sennhauser

The MariaDB Connection ID exists since "ever". So why bother about such a boring thing? Because you can get many interesting information out of it...

Many say: Galera or Master/Slave replication. What about Galera AND Master/Slave Replication? In this presentation we look at different scenarios where it makes sense to use both technologies together...

Backup is typically done once a a day. But if you destroy your data hours later: What about the changes between your backup and the catastrophic event? In this presentation I will show you how you can recover your data between your backup until a specific point in time before the incident.

Mariabackup is another backup tool for MariaDB. But it is still not used very frequently. In this presentation we will have a short look how this backup works and what we can do with it.

Mariabackup full backup is a fast and reliable backup/restore method for a whole instance. With the partial restore we can also restore one table or several tables together (aka schema). Point-in-Time-Recovery is also possible with Mariabackup (do not confuse this with incremental backup). But it becomes more tricky for one schema or table only. And finally this can also be done on a MariaDB Galera Cluster.

MySQL introduced PERFORMANCESCHEMA in v5.5. In v5.6 it became useful and interesting. Later the SYS Schema was added to make it easier to use the PS. In this presentation we will have a short look how you enable PS, how you configure it and what you can get out of the PS with and without the SYS Schema.

MySQL introduced PERFORMANCESCHEMA in v5.5. In v5.6 it became useful and interesting. Later the SYS Schema was added to make it easier to use the PS. In this presentation we will have a short look how you enable PS, how you configure it and what you can get out of the PS with and without the SYS Schema.

Everywhere here and there you hear about MySQL synchronous Replication with Galera as a replacement for MySQL Master-Master Replication. But nobody has seen it yet in practice. In this talk we look at the architecture, the installation, the configuration and the pitfalls you have to expect with synchronous Galera Replication for MySQL during operation

Many MySQL users have already put MySQL 5.5 in place and soon (2012) MySQL 5.6 will be GA! In this talk we will have a look at the New MySQL 5.6 Features which will come: InnoDB enhancements, Partitioning, Performance Schema and the new even more stable binary logging...