O'Reilly Open Source Convention - August 1-5, 2005

Session
MySQL Snapshots and Replication from Oracle
Theo Schlossnagle, Chief Technology Officer, OmniTI Computer Consulting, Inc.

Track: Databases
Date: Wednesday, August 3rd, 2005
Time: 10:45am - 11:30am
Location: D136
Many enterprise architectures currently deploy RDBMS solutions other than MySQL. While they are very useful and reliable, scaling such solutions is often not economically feasible. As time goes on, MySQL approaches the feature set of commercial RDBMS solutions such as Oracle and will soon be an adequate replacement. In the mean time, many companies rely on enterprise features only found in their RDMBS and their supporting products (such as block-level-incremental backups, table partitioning, materialized views, etc.).

When data needs to be disseminated across the enterprise or to clients, requiring an Oracle instance at each replica can quickly saturate any IT budget. Never fear! MySQL saves the day yet again. 1, 10, or 100 MySQL replicas can be maintained off an Oracle "master," allowing for excellent and economically conservative horizontal scaling of read intensive applications.

This session demonstrates the creation of consistent "point-in-time" snapshots of Oracle tables in MySQL and a technique to keep them up-to-date in real time. All techniques presented are equally applicable to Postgres, Sybase, Informix, SQLServer, and many others.