Data Integration and Real-time Replication for Heterogeneous Databases: Connecting MySQL to Oracle, DB2, SQL Server, and Others

HiT Software provides DBMoto™, a powerful data replication engine that synchronizes data among heterogeneous databases for migration and bi-directional real-time updates. In this session, DBMoto’s architect, Marco Sandrini, will walk attendees through a technical review and customer implementation example of mirroring between MySQL and other major databases. DBMoto’s functionality includes support for remote replication, fast CSV loading, replication grouping, recovery, and visual error-checking. Used today by enterprises worldwide, DBMoto gives MySQL database administrators a quick and programming-free solution for large-scale database replication requirements.

Session Details:

• Data Replication “Mirroring” – heterogeneous database benefits and considerations
• Architectural examples
• Demonstration: Oracle to MySQL example – multi-threaded processing and performance tuning
  • Remote replication, installing on a remote system to avoid impact on source or target databases
  • Fast loading via CSV (20 times faster than standard inserts)
  • Log-based mirroring – usage of binary logs in replications
  • Replication grouping. Advantages of multi-connections in parallel and single connections in a series, and the impact on performance versus resources.
  • Advanced scripting options in Mirroring
  • Recovery features
  • Error Management. DBMoto’s GUI interface for easy, visual error checking and resolution.
• Q&A