Art van Scheppingen
Senior Database Administrator (freelance), DBArt
Has worked over nine years at Spil Games and contributed as a developer, IT Architect, Database Administrator, Database Specialist and Head of Database Engineering to the growth of the company. Recently he has started his own company that enables him to work on various MySQL and database performance related projects.
Slave prefetchers can speed up replication but only work within very limited boundaries. As Domas described it two years ago: "Please don’t use mk-slave-prefetch on MySQL unless you are Facebook. Or at least don’t tell your friends, so they won’t use it." We are not Facebook, but we certainly like to stand in their shadow! Besides that we were suffering from slave lag on a slave that... [read more]
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... [read more]
More than two years ago Spil Games started building a global cross datacenter storage solution with MySQL as one its key components. This session will focus on our road to get there and share some of the best practices we got out of this. To give our users the best experience possible we needed to expand our datacenters globally and bring sharded data closer to our end users using a storage... [read more]