Tungsten Replicator is the most advanced heterogeneous real-time data replication solution for MySQL, MariaDB & Percona Server, including Amazon RDS MySQL and Amazon Aurora. It provides high-performance and improved replication functionality over the native MySQL replication solution and into a range of target databases.
It is available as an AMI and can be accessed via AWS.
High Performance Replication with the Tungsten Replicator (AMI)
In the past few months we’ve published a number of blog posts that discuss some of these target databases and high-performance data analytics engines in more detail from a replication perspective. They also provide all the details you’ll need to get started with Tungsten Replicator (AMI) on the AWS Marketplace.
- Vertica Replication
- PostgreSQL Replication
- Kafka Replication
- MongoDB Replication
- Hadoop Replication
- Amazon Redshift Replication
- Amazon Aurora Replication
- Amazon RDS Replication
See below for more details on each of the resources we’ve published.
This blog starts off by taking a look at what real-time analytics is all about and what some common replication challenges are before diving into real-time data replication from MySQL, MariaDB or Percona Server to Vertica, a high-performance data analytics engine.
The second post on real-time data replication from MySQL, MariaDB or Percona Server looks at PostgreSQL replication.
‘The World's Most Advanced Open Source Relational Database’ has been continuously expanding its reach in the world of open source databases, hence it’s no surprise that it would regularly go head to head with the ‘World’s Most Popular Open Source Database’: MySQL.
Plenty of good content has been written about PostgreSQL vs MySQL, use case stories as to why companies choose to move from one to the other, etc. and this blog post doesn’t go into those discussions. It does, however, look at some of the scenarios where replication from one to the other comes into play.
This blog post looks at how real-time replication between MySQL and Kafka works.
Apache Kafka is a highly scalable messaging platform that provides a method for distributing information through a series of messages organised by a specified topic.
Replication allows the movement of data from the source database(s) to target database(s) in real time, keeping the target in sync with the source. In the case of Kafka, Tungsten Replicator posts data changes as messages to Kafka Topics which can be subscribed to, and processed by any compatible consumer, providing flexibility to utilise the data however your business requires.
Ever since MongoDB emerged on the open source database scene in 2009, comparisons with MySQL have kept the open source database community debating the pros and cons, some swearing by MySQL while others firmly rooting for MongoDB.
This blog looks at what some of the main differences are between MongoDB & MongoDB, what some of the similarities are and provides useful insights on MySQL to MongoDB replication (things to know and when to consider replication between the two).
Apache Hadoop is generally understood to be a system that provides a (distributed) file system, which in turn stores data to be used by applications without knowing about the structure of the data. Hadoop is designed to run on a large number of machines that hold massive amounts of data and that don’t share any memory or disks.
This blog walks you through some of the use cases that require replication from MySQL to Hadoop for real-time big data analytics.
As you’ll be aware, data analytics is a must-have business requirement nowadays; and you’ll also know that building an analytical data warehouse requires vast computing power to maintain performance and quick retrieval of data and results.
Amazon Redshift has been providing scalable, quick-to-access analytics platforms for many years, but the question remains: how do you get the data from your existing datastore into Redshift for processing?
This blog looks at that question by providing some background information on Redshift replication as well as details on how to easily replicate from MySQL to Redshift.
Amazon Aurora is the fastest growing service in the history of AWS and is a MySQL and PostgreSQL-compatible relational database built for the cloud. While it doesn’t appear to be hugely popular when looking at the DB-Engine rankings, it undeniably has made its mark on the MySQL & PostgreSQL ecosystems.
Read this blog post for information on how replication to and from Amazon Aurora works.
Still the world’s most popular open source database, MySQL is typically installed in on-premise data centers. However, there has been a major trend for MySQL in the cloud in recent years, with Amazon RDS being a leading option for that.
This blog looks at how replication to and from Amazon RDS works.
Free Trial - Get Started With the Tungsten Replicator (AMI)
Getting Started With a 14-Day Free Trial
We’ve made it easy to give Tungsten Replicator (AMI) a go: Users can try one instance of each type of the AMI for free for 14 days to get them started (AWS infrastructure charges still apply).
Please note that free trials will automatically convert to a paid hourly subscription upon expiration and the following then applies in the case of Aurora targets.
And if you’d first like some practical advice on how to get started, we’ve got you covered also with the free resource below.
Following the most recent releases of the Tungsten Replicator AMIs, our colleague Chris Parker, Customer Success Director - EMEA & APAC, recorded two getting started videos with some handy tips and tricks on how the AMIs work, how to avail of them … and how to get started with them!
Do let us know how you get on or if you have any questions by submitting a comment below.