MySQL Replication Mix and Match

Replication and High Availability Strategies
1 April 1:30PM - 4:30PM @ Ballroom C

Experience level: 
Intermediate
Duration: 
3 hours tutorial
Tungsten Replicator enables you to communicate and exchange information between a number of different database services. Not only can we replicated between MySQL, but we can also replicate to/from Oracle, and to MongoDB, Vertica and others. This functionality is provided through a combination of advanced appliers and filters. We can mix and match the replicators, extractors and appliers together to provide live replication between different services. We can also mix and match the filters and transformations on the different data streams to provide complex, but usable replication to a variety of different sources and targets. In this hands-on tutorial we will examine how replicator can be used to setup different filters, how this provides replication services between different environments, and ultimately how to build your own filters using JavaScript to provide custom filter functionality. + Filter basics + Enabling filters and configuration + Standard built-in filters + Creating new heterogeneous installations + Enabling replication from existing clusters + Replicating to MongoDB, Vertica, and Oracle JavaScript Filters + JavaScript data structures + Writing JavaScript filters + Practical JavaScript filters + Fun JavaScript filters


Speakers

Director of Documentation, Continuent
Biography: 
A professional writer for over 15 years, Martin 'MC' Brown is the author and contributor to over 26 books covering an array of topics, including programming, system management and web technologies. His expertise spans myriad development languages and platforms – Perl, Python, Java, JavaScript, C, C++, Shellscript, Windows, Solaris, Linux, BeOS, Mac OS and more. The combination has resulted in expertise in web programming, systems management and integration, and XML and DocBook technologies for writing and publishing documentation. A former LAMP Technologies Editor for LinuxWorld magazine, and a regular contributor to ServerWatch.com, LinuxPlanet, ComputerWorld and IBM developerWorks. As a Subject Matter Expert for Microsoft he provided technical input to their Windows Server and certification projects. He draws on a rich and varied background as founder member of a leading UK ISP, systems manager and IT consultant for an advertising agency and Internet solutions group, technical specialist for an intercontinental ISP network, and database designer and programmer – and as a self-confessed compulsive consumer of computing hardware and software. In his pre-writing life he spent more than 10 years designing and managing mixed platform environments, developing the rare talent of being able to convey the benefits and intricacies of his subject with equal measures of enthusiasm, professionalism, in-depth knowledge and insight. Most recently he has concentrated on building high quality user-focused information through his books, articles, and MySQL and the MySQL groups within Sun and Oracle. In addition to producing the content, he has also developed the documentation systems to improve he quality and efficiency of the documentation being written. MC is currently the Director of Documentation for Continuent and is responsible for building the documentation and supporting information.
Senior Software Engineer, Continuent Inc.
Biography: 
Linas has extensive experience in developing heterogeneous replication solutions between MySQL, Oracle and PostgreSQL. Implemented support for MySQL to Oracle/PostgreSQL/Greenplum replication and, also, replication POC from PostgreSQL to other DBMS. In addition to developing, he's helping heterogeneous replication customers get deployed. Before joining Continuent, Linas was Head of IT at FBC "Finasta".

Slides