Real-time Replication Between MySQL and Oracle

MySQL is great for front-end web facing applications. Oracle has proven itself in the demanding back-end data warehouse and reporting solutions. But how to bridge MySQL and Oracle together without paying an arm and a leg for Oracle's GoldenGate replication solution?

In this webcast we describe how to design real-time cross-database replication using Tungsten Replicator (http://code.google.com/p/tungsten-replicator). We cover some of the pitfalls and corner cases like SQL dialect differences, data types, character sets, MySQL and Oracle peculiarities. Tungsten Replicator with some expert help from Continuent makes implementation fast and real time replication operations reliable, even for the high volume environment.

Lee Margulin, Database Administrator at Zappos.com, speaks about how Zappos uses Tungsten to replicate data between Oracle and MySQL. Established in 1999, Zappos.com has quickly become a leader in online apparel and footwear sales by striving to provide shoppers with the best possible service and selection, with gross merchandise sales exceeding $1 billion annually. Zappos.com currently stocks millions of products from over 1000 clothing and shoe brands. Zappos.com was recognized in 2009 and 2010 by FORTUNE MAGAZINE as one of the "100 BEST COMPANIES TO WORK FOR".

Category:

Science & Technology

Tags:

• Continuent Tungsten Replicator
• MySQL
• Oracle
• DBMS
• replication