Tarantool DBMS Now Supports Replication from MySQL

Tarantool developers have revealed a MySQL-to-Tarantool replication system that allows decreasing the workload on MySQL databases. It is publicly available under the BSD license.

The replication mechanism enables users to automatically synchronize data between the two databases. A single Tarantool server can handle the workload that is too much for 20 MySQL servers [1]. The new replication system can help a MySQL administrator significantly cut the workload on the servers by rerouting read requests to Tarantool.

The system mainly targets Internet and IT companies heavily relying on MySQL and allows them to speed up their mobile and web-based applications for their end users.

“Migrating to a new DBMS often calls for serious changes to the existing infrastructure. Tarantool’s new replication system might be a solution for those who are not yet ready to take this step: by taking advantage of Tarantool’s functionality, companies will only need to make a few slight tweaks to their infrastructure. Any business actively using MySQL can easily set up MySQL-to-Tarantool replication to increase performance and expedite request processing. Incidentally, Yota has recently deployed an Oracle-to-Tarantool replication mechanism, which has significantly improved the speed of their services and reduced the workload on their Oracle servers. That said, Tarantool users can now replicate data from the two most popular DBMSs in the world: Oracle and MySQL,” commented Dennis Anikin, Engineering Director of Email & Cloud Services at Mail.Ru Group.

The system has been fully open-sourced.

Tarantool DBMS is developed by Mail.Ru Group and has been used in-house for almost nine years. It combines high processing speed typical of caching solutions (like Memcached or Redis) with the reliability of such industrial-level systems as Oracle, MySQL and PostgreSQL. It is open-source software distributed under the BSD license. Internal benchmarks run by Mail.Ru Group show that Tarantool is capable of processing one million transactions per second on the cheapest single-core commodity server. According to Mail.Ru Group’s internal report, one server running Tarantool can substitute 30 servers running a regular DBMS. Tarantool boasts a number of successful implementations by some of the largest Russian and international companies including VimpelCom, Yota, Badoo, Avito, QIWI and Wallarm.

 

[1] According to Mail.Ru Group’s internal report.