Blog

All the Resources You Need For High Performance MySQL, MariaDB & Percona Server Replication

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.

See below for more details on each of the resources we’ve published.

Vertica Replication

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.

Read More About Vertica Replication

PostgreSQL Replication

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.

Read More About PostgreSQL Replication

Kafka Replication

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.

Read More About Kafka Replication

MongoDB Replication

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).

Read More About MongoDB Replication

Hadoop Replication

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.

Read More About Hadoop Replication

Amazon Redshift Replication

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.

Read More About Amazon Redshift Replication

Amazon Aurora Replication

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.

Read More About Amazon Aurora Replication

Amazon RDS Replication

Since we looked at how to securely replicate from MySQL to Amazon Redshift and Amazon Aurora (and vice versa), when it comes to Amazon and MySQL it’d be amiss not to also look at Amazon RDS.

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.

Read More About Amazon RDS Replication

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.

Watch: How to Get Started With Tungsten Replicator AMIs

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.

About the Author

Continuent Team

Continuent, the MySQL Availability Company, since 2004 has provided solutions for continuous operations enabling business-critical MySQL applications to run on a global scale with zero downtime. Continuent provides geo-distributed MySQL high availability on-premises, in hybrid-cloud, and in multi-cloud environments.

Continuent customers are leading SaaS, e-commerce, financial services, gaming and telco companies who rely on MySQL and Continuent to cost-effectively safeguard billions of dollars in annual revenue.

Continuent’s database experts offer the industry's best 24/7 MySQL support services to ensure continuous client operations.

Add new comment