Personal schedule for Dennis Allard
subscribe to Dennis Allard's
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.
This tutorial focuses on the diagnostic tools you can turn to when confronted with an unexplained performance problem. Tools explained include iostat, vmstat, and mk-query-digest. The emphasis is on practical usage under pressure, and less on performance theory.
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.
mysql> EXPLAIN SELECT * FROM CLOUDSQLDB
AND COUNT (CloudProviders)>1;
Come see a live demonstration of a highly-available and scalable cloud database – with self-healing, auto-scaling and pay-per-use – all with a click of a button.
Moving rarely accessed data out of your main database can have a big impact on speed and cost. This session covers techniques to analyze the granularity of your data and implement an archival strategy that allows you to recall archived data on demand.
Need quick ad-hoc reports with sharp graphics from you MySQL instances? There are several open source reporting tools from Penatho, Actuate, Jaspersoft and others that can make a DBAs lies much easier. This session covers the more popular reporting tools and reommendations for for their use in your environment.
MySQL ubiquity is expanding from the online world to many other areas. Data Warehousing is one of the hottest and fast growing sectors for MySQL, due to its reduced TCO and ease of use.
In this session we will present what's new in the DW market around MySQL and how MySQL Server can be used to achieve success in Data Warehousing, Business Intelligence, OLAP and Reporting Projects.
This is a DBA or Data Architect perspective session which covers designing MySQL as data warehouse solution to handle tera bytes of data which compromises OLTP, ETL, OLAP and reporting
This presentation provides architectural guidance, design patterns, and specific suggestions for deploying and administering Data Warehouses using Mysql. It is based on lessons learned building and operating a Multi-Terabyte Mysql 5 Data warehouse over a period of 5 years.
This talk describes using summary tables to improve application performance. It focuses on Flexviews, an open source toolkit based on MySQL stored procedures. Flexviews maintains summary tables and supports joins and aggregation.
I'll show at a high level how Flexviews works and how it can be used to improve application performance. Examples will be provided for both OLTP and OLAP workloads.
Most MySQL deployments use some form of replication. Whether the reason is availability, scalability, backup, disaster recovery or archiving, understanding the performance characterization and trade-offs is critical to design and planning.
If you have always wondered when and why to choose async/semi-sync/sync MySQL replication, DRBD or other interoperable technologies, this session is for you.