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

Marco Sandrini (HiT Software, Inc.)
Products & Services
Location: Ballroom H

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
Photo of Marco Sandrini

Marco Sandrini

HiT Software, Inc.

Marco Sandrini has lead HiT Software’s Data Integration team as Manager/Lead Software Developer for nearly a decade. He is responsible for the creation of DBMoto, HiT’s proven data replication product for large-scale data integration and synchronization projects. Marco is also responsible for the development of Allora™, HiT Software’s bi-directional XML-RDBMS transformation solution. Marco’s expertise as project lead, programmer and software designer spans data access, connectivity and security products.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.