Why, What, and How of Data Warehouses for MySQL
Integrating MySQL's reliable transaction processing with a capable data warehouse is a best practice that gives users timely and comprehensive insight into business data. In this talk we will explain how data warehouses work and why you need one. We will next survey the classes of data warehouse products that you can combine with MySQL, such as Oracle, Vertica, InfiniDB, Hadoop, and NoSQL databases like MongoDB. Finally, we will show a practical example of how to deliver transactions from MySQL to a data warehouse in real-time using Tungsten Replicator. Implementation highlights include provisioning the data warehouse, filtering and transforming data during loading, and handling mundane but critical issues like timezones and character sets. You will leave the talk equipped with a practical toolset to select a data warehouse and begin moving in data from MySQL.