The complete Tungsten Replicator tutorial (part 2)

11 November 2:00pm - 5:00pm @ Sentosa 5-8
Experience level: 
6 hours tutorial
Modern business require complex data management, which result in complex problems. Although MySQL native replication offers a robust streaming in simple topologies, it is not up to the tasks required today: * seamless failover * multiple masters * fan-in replication * data transformation * replication from and to different database servers. All the above, and more, is solved by Tungsten Replicator. In this full day tutorial we will explore the possibilities that Tungsten Replicator can provide to solve complex replication problems. Tungsten Replicator ( is a high performance, open source, data replication engine for MySQL that is a drop in replacement for standard MySQL replication. In the first part we will cover * The Tungsten Replicator components. * Basic replication stream and THL Structure * Tungsten replicator administration tasks. * Setting up Master-Master Replication. * Conflict detection and prevention using Tungsten system of records. * Fan-In replication combining multiple datasources into a single instance. * Star Replication. * Using Parallel replication to speed up replication. * setting complex topologies (all-masters + fan-in + simple slaves) In the second part, we will cover advanced Filtering and Replication. Tungsten Replicator provides an alternative to native MySQL replication, while also provided replication to other databases. Not only that, but because we have control over the replication streams, we can use that to perform different filtering operations on the data. + Enabling security and encryption + Filter basics + Enabling filters and configuration + Standard built-in filters Heterogeneous Deployments + Creating new heterogeneous installations + Enabling replication from existing clusters + Replicating to MongoDB + Replicating to Vertica + Replicating to Oracle JavaScript Filters + JavaScript data structures + Writing JavaScript filters + Practical JavaScript filters + Fun JavaScript filters The tutorial will be hands on, demonstrating how advanced replication operates and how to use and enable different filters to massage the data.


QA Director, Continuent
QA Director at Continuent I am active member of the MySQL community and long timer open source enthusiast. During the past 25 years I have worked in various IT related fields, with focus on databases, object oriented programming, system administration. Fluent in Italian, English, Perl, Python, SQL, Lua, C, Bash, and good speaker of C , French, Spanish, Java. I work in cyberspace, with a virtual team.
Director of Documentation, Continuent
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, 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.