本地mysql数据库和AWS RDS之间的两种同步方式 [英] Two way syncing between local mysql database and AWS RDS
问题描述
我的问题与但是我希望它在我的本地mysql和AWS RDS实例之间.
but i want it between my on premises mysql and AWS RDS instance.
所以功能上的需要是，当我处于连接到本地服务器(没有Internet)的组织内部时，我将访问localhost数据库(托管在本地服务器上)，而从组织外部，我将访问ec2和ec2上托管的websize与RDS数据库.因此这两个数据库都需要以连续2种方式进行同步.我检查了AWS DMS，但我认为它遵循主数据库和从数据库的方法，在该方法中，我可以从本地更新RDS.有什么解决方案，如果只能通过AWS DMS使用，请指导我.
So functional need is when i am within organization connected to local server (without internet) i will access localhost database (hosted on premises server) and from outside of organization i will access websize which is hosted on ec2 and ec2 will be connected with RDS database. so this both database needs to be in continues 2 way synchronization. i checked AWS DMS but i think it follows master db and slave db approach in which i can update RDS from on premises. what could be the solution, if it is possible with AWS DMS only than please guide me.
推荐答案
您的问题涵盖了一个非常复杂的主题，其中包含许多问题，因此需要决定解决方案.诸如每时间间隔的数据更改量，网络连接带宽和延迟，网络连接可靠性，数据安全性，身份验证，授权，备份和恢复过程，故障转移和容错性等因素只是开始.
Your question covers a very complex subject with many issues that need to be considered before deciding on a solution. Factors such as the amount of data changing per interval of time, network connection bandwidth and latency, network connection reliability, data security, authentication, authorization, backup and recovery procedures, fail over and fault tolerance are just the start.
Amazon的这篇文章讨论了将本地托管的MySQL数据库复制到RDS.本文有趣的花絮是:
This article from Amazon discusses replicating a MySQL database hosted on-premises to RDS. An interesting tidbit from this article is:
复制之路. 拥有MySQL复制的经验，您可能会想很酷-我可以 设置从现有数据库到云的复制，创建一个 热备用，可轻松进行故障转移."
The Road to Replication If you have read this far and you have some experience with MySQL replication, you may be thinking "Cool — I can set up replication from my existing database to the cloud, creating a hot spare for easy failover."
最好将复制视为故障转移云的组成部分 模型，而不是作为其本身的完整解决方案.因为 主站和从站之间存在网络连接，您 需要监视和维护连接，跟踪复制 延迟等等，以创建可靠的解决方案.
It is best to think of replication as a component of a fail-to-cloud model, rather than as a complete solution in and of itself. Because there’s a network connection in between the master and the slave, you would need to monitor and maintains the connection, track replication delays, and so forth in order to create a robust solution.
这篇关于本地mysql数据库和AWS RDS之间的两种同步方式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
