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.


Quality Assurance Architect, VMware
Quality Assurance Architect at VMware. Formerly at MySQL AB, and then through acquisitions at Sun Microsystems and Oracle. Then at Continuent, Inc and currently at VMware through a merge. I am active member of the MySQL community and long timer open source enthusiast. During the past decades I have worked in various IT related fields, with focus on databases, object oriented programming, system administration, quality assurance. Fluent in Italian, English, Perl, Python, SQL, Spanish, C, Bash, and good speaker of C , French, Java. I work in cyberspace, with a virtual team.
Senior Product Line Manager, VMware
A professional writer and technologist for over 20 years, MC Brown is the author and contributor to over 26 books covering an array of topics, including programming, system management, networking, data centres and web technologies. His expertise spans myriad development languages and platforms, with Systems using Perl, Python, Java, JavaScript, C, C++, Shellscript, Windows, Solaris, Unix, HP-UX, Open Source, Linux, BeOS, Mac OS/X and many more. 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 for Windows Server and server 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. Most recently he has concentrated on building high quality user-focused information and products through his books, articles, and MySQL and the MySQL groups within Sun and Oracle. In addition to producing the content and the content-delivery systems, including building documentation, white papers, and marketing materials. Throughout his career he has acted as architectural advisor to a wide variety of products, focused on user-centric functionality and use cases with an eye on enhancing current feature-sets with an eye to future functionality and requirements in a flexible way to ensure both ease of use and development. These activities have led to a keen eye and experience in Big Data, Hadoop, MySQL, NoSQL, Oracle, virtualisation, datacentres, content delivery, data migration and replication technology for heterogeneous databases.