Flexible Replication: MySQL to PostgreSQL and (fresh!) PostgreSQL to MySQL and Oracle

Talk Type: 
45 Minute Talk
Track: 
Replication/HA
Technical Level: 
Intermediate
License: 
BSD

There are cases where a single DBMS vendor is not enough. In this talk we'll analyze how to painlessly solve the following real-world needs with an open source Tungsten Replicator: real-time integration, seamless migration, data warehousing and leveraging the power of a specific DBMS SQL dialect. Not only we will learn how to move data from MySQL to PostgreSQL in real time (yes, let's free those MySQL petabytes to PG users!), but we'll also discuss a fresh and important way of extracting data from PostgreSQL and making it available to other DBMSes. We’ll conclude with a demo of database updates moving in real time between different databases.