如何在单个主机上运行 mysql 复制？
我想在单个主机上复制 mysql 数据库，然后拍摄复制数据库的快照以供开发，即：
Master -> Repslave（只读）->多个开发快照
快照应该只存储它们自己和repslave之间的差异，因为它是在拍摄快照的时间点。代表从站应继续向主站请求更新的操作，以便将来的快照是最新的。我以前见过这样做，发现它对开发非常有用，但我不太了解如何设置它。
这是怎么做到的？如果可能的话，我不想在同一主机上安装两个 mysql。这也可行吗？
I'd like to replicate a mysql database on a single host and then take snapshots of the replicated DB for development, ie:
Master -> Repslave (readonly) -> multiple development snapshots
The snapshots should only store the differences between themselves and the repslave as it was at the point in time that the snapshot was taken. The repslave should continue requesting updated actions from the master so that future snapshots are up to date. I've seen this done before and found it very useful to develop on but I don't know much about setting it up.
How is this done? I'd prefer not to place two installations of mysql on the same host if possible. Is this also feasible?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论