Has your database grown to hundreds of gigabytes in size, with no limit in sight? Are you considering moving to an expensive proprietary database system do deal with your huge database? PostgreSQL is an excellent database for small to medium sized data warehouses in the 0.5 to 5 terabyte range.
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
Apache Hadoop is a distributed, batch-processing system for large data sets. It can be used alongside relational databases to enable more effective reporting and injestion of large amounts of raw or unstructured data.
Size can creep up on you. Some day you may wake up to a multi-terabyte Postgres system handling over 3000 tps staring you down. Learn the best ways to manage these systems as they grow, and find out what new features in 9.0 have made life easier for administrators and application developers working with big data.
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.
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.