![]() Tungsten Replicator provides high-performance and improved replication functionality over the native MySQL replication solution and into a range of target databases, such as PostgreSQL of course… as well as MySQL (all versions), Oracle, Vertica, AWS RedShift, ClickHouse, Hadoop, MongoDB & Kafka. This is where Tungsten Replicator comes in, and in particular, the Tungsten Replicator AMI on the Amazon Marketplace, which is the focus of this post. In the case of MySQL and PostgreSQL, replication is built between two heterogeneous databases where changes may need to continuously replicate from a MySQL database to a PostgreSQL database. Although most databases support some sort of replication, rarely is heterogeneous replication supported, where source and target are different database technologies altogether. 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. However, this discussion is often also where the need to replicate from the one to the other comes into play. If you’d like to read more about it, there’s a handy blog post on hackr.io to get you started on this topic without taking sides. and this blog post here won’t go into that discussion. 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. ‘The World's Most Advanced Open Source Relational Database’ just keeps on expanding its reach in the world of open source databases and it’s no surprise that it would regularly go head to head with the ‘World’s Most Popular Open Source Database’: MySQL. ![]() It is currently the reigning champion in that category and also ranks 4th on db-engines’ database management systems popularity rankings. It has noticeably and consistently gained in popularity in recent years so much so that it is the only RDBMS to have won db-engines’ DBMS of the Year Award three times. In this second post on real-time data replication from MySQL, MariaDB or Percona Server we’re looking at PostgreSQL replication.Įven though PostgreSQL celebrates its 24th anniversary this year, it’s almost like it’s never been more current than it is today.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |