Complex normalized schemas can make database systems slow and inefficient. This presentation explores a storage layer that eliminates most joins in such systems by pre-joining the data. Data in this storage layer can be accessed using an object API without the overhead of an object-relational mapping layer. It can also be accessed using standard SQL for efficient complex multi-table reporting.
Aside from traditional master-slave setup used mostly for HA and read scale-out, there is an established history of attempts at multi-master replication with MySQL. In this presentation we will look at what multi-master replication can do for us and compare different approaches of doing it.
In this session, I will talk about tough DBA tasks - how to automate failover under non-trivial crash situations (i.e. promoting one of slaves to new master), and about how to eliminate downtime for difficult maintenance tasks (i.e sharding). If you have spent too much time for these tasks, this session will help your DBA life easier.
This talk will cover forecasting and planning future growth for high volume mysql instances occupying many (500+) servers. Will include metrics tracked (and how to filter through noise), when and how to migrate, operational optimizations such as upgrades that can be incorporated, and how to deal with server technology that evolves faster than server lifetimes
Want to really scale PostgreSQL using the new binary replication? Learn how to set up hot standby, streaming replication, failover, non-persistant databases and cloning to scale PostgreSQL 9 for reads.
In the midst of many attempts to "solve" the RDBMS high availability problems, the vast majority of Yahoo sites are still using plain old boring MySQL replication to accomplish HA. This talk will cover the principles of this architecture, it's advantages and disadvantages, as well what we see as needed for future HA advances. It's old-school, it's crude, but somehow it solves most HA problems.
MySQL replication is the backbone of web scalability principles.
This tutorial tells you how to go beyond the basics, to using MySQL replication more productively, by combining existing techniques and adopting new ones.
After covering the basics, we will explore failover techniques, several performance boosting tricks, and emerging technologies that you can adopt in house and in the cloud.