blocks|key|2201783|text|以下是你可以尝试的两种可能的设置|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2201784|拓扑#1|header-two|2201785|具有两个(2)+DB服务器(DB1、DB2)的数据中心#1|unordered-list-item|2201786|数据中心#2与两个(2)+DB服务器(DB3，DB4)|2201787|用每个数据中心设置DRBD|2201788|在DRBD主服务器之间设置MySQL复制|2201789|安装DBVIP+(Linux心跳/心脏起搏器/+ucarp)|2201790|此设置提供了什么？|2201791|每个数据中心内的同步磁盘级复制|2201792|数据中心之间的异步复制|2201793|拓扑#2|2201794|数据中心#1+|2201795|三个数据库服务器(DB1、DB2、DB3)|2201796|三(3)+DB服务器中的Percona+XtraDB簇|offset|length|2201797|2201798|数据中心#2+|2201799|三个数据库服务器(DB4、DB5、DB6)|2201800|三(3)+DB服务器中的Percona+XtraDB簇|2201801|2201802|MySQL循环复制|2201803|DB3用作DB6的主从|2201804|DB3作为DB6的奴隶|2201805|在母机和从机之间使用半同步复制|2201806|2201807|2201808|在每个数据中心内几乎同步复制|2201809|2201810|我以前也讨论过这样的设置|2201811|Feb+10,+2014：MySQL对InnoDB的高可用性|style|CODE|2201812|Jul+11,+2013：数据中心之间的MySQL复制|2201813|Dec+26,+2012：MySQL复制与高可用性|2201814|Oct+25,+2012：mysql读取从从开始获取整个数据库|2201815|Aug+20,+2012：跨数据中心MySQL主从复制的最佳解决方案|2201816|Mar+26,+2012：3数据库，最佳复制设置？|2201817|Dec+19,+2011：将主复制设置为多主复制的最佳方法|2201818|Mar+29,+2011：具有延迟的MySQL高可用性、故障转移和复制|2201819|试试看！|entityMap|0|LINK|mutability|MUTABLE|url|https://dba.stackexchange.com/questions/23148/mirroring-databases-in-mysql/25759#25759|1|2|https://dba.stackexchange.com/questions/58594/mysql-high-availability-for-innodb/58606#58606|3|https://dba.stackexchange.com/questions/46158/mysql-replication-between-datacenters/46159#46159|4|https://dba.stackexchange.com/questions/31031/mysql-replication-and-high-availability/31035#31035|5|https://dba.stackexchange.com/questions/27582/mysql-read-slave-to-fetch-entire-database-on-start/27611#27611|6|https://dba.stackexchange.com/questions/22788/best-solution-for-cross-datacenter-mysql-master-slave-replication/22790#22790|7|https://dba.stackexchange.com/questions/15573/3-databases-best-replication-setup/15577#15577|8|https://dba.stackexchange.com/questions/9424/best-way-to-setup-master-to-multi-master-replication/9425#9425|9|https://dba.stackexchange.com/questions/1974/mysql-high-availability-failover-and-replication-with-latency/1983#1983^0|0|0|0|0|0|0|0|0|0|0|0|1|1|C|F|0|1|0|1|1|C|F|1|1|0|1|1|1|1|0|0|0|0|0|0|C|D|H|2|0|0|C|D|E|3|0|0|C|D|C|4|0|0|C|D|I|5|0|0|C|D|L|6|0|0|C|D|C|7|0|0|C|D|G|8|0|0|C|D|M|9|0^^$0|@$1|2|3|4|5|6|7|30|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|31|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|32|8|@]|9|@]|A|$]]|$1|H|3|I|5|G|7|33|8|@]|9|@]|A|$]]|$1|J|3|K|5|G|7|34|8|@]|9|@]|A|$]]|$1|L|3|M|5|G|7|35|8|@]|9|@]|A|$]]|$1|N|3|O|5|G|7|36|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|37|8|@]|9|@]|A|$]]|$1|R|3|S|5|G|7|38|8|@]|9|@]|A|$]]|$1|T|3|U|5|G|7|39|8|@]|9|@]|A|$]]|$1|V|3|W|5|D|7|3A|8|@]|9|@]|A|$]]|$1|X|3|Y|5|G|7|3B|8|@]|9|@]|A|$]]|$1|Z|3|10|5|G|7|3C|8|@]|9|@]|A|$]]|$1|11|3|12|5|G|7|3D|8|@]|9|@$13|3E|14|3F|1|3G]]|A|$]]|$1|15|3|-4|5|6|7|3H|8|@]|9|@]|A|$]]|$1|16|3|17|5|G|7|3I|8|@]|9|@]|A|$]]|$1|18|3|19|5|G|7|3J|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|G|7|3K|8|@]|9|@$13|3L|14|3M|1|3N]]|A|$]]|$1|1C|3|-4|5|6|7|3O|8|@]|9|@]|A|$]]|$1|1D|3|1E|5|G|7|3P|8|@]|9|@]|A|$]]|$1|1F|3|1G|5|G|7|3Q|8|@]|9|@]|A|$]]|$1|1H|3|1I|5|G|7|3R|8|@]|9|@]|A|$]]|$1|1J|3|1K|5|G|7|3S|8|@]|9|@]|A|$]]|$1|1L|3|-4|5|6|7|3T|8|@]|9|@]|A|$]]|$1|1M|3|Q|5|6|7|3U|8|@]|9|@]|A|$]]|$1|1N|3|1O|5|G|7|3V|8|@]|9|@]|A|$]]|$1|1P|3|U|5|G|7|3W|8|@]|9|@]|A|$]]|$1|1Q|3|1R|5|6|7|3X|8|@]|9|@]|A|$]]|$1|1S|3|1T|5|G|7|3Y|8|@$13|3Z|14|40|1U|1V]]|9|@$13|41|14|42|1|43]]|A|$]]|$1|1W|3|1X|5|G|7|44|8|@$13|45|14|46|1U|1V]]|9|@$13|47|14|48|1|49]]|A|$]]|$1|1Y|3|1Z|5|G|7|4A|8|@$13|4B|14|4C|1U|1V]]|9|@$13|4D|14|4E|1|4F]]|A|$]]|$1|20|3|21|5|G|7|4G|8|@$13|4H|14|4I|1U|1V]]|9|@$13|4J|14|4K|1|4L]]|A|$]]|$1|22|3|23|5|G|7|4M|8|@$13|4N|14|4O|1U|1V]]|9|@$13|4P|14|4Q|1|4R]]|A|$]]|$1|24|3|25|5|G|7|4S|8|@$13|4T|14|4U|1U|1V]]|9|@$13|4V|14|4W|1|4X]]|A|$]]|$1|26|3|27|5|G|7|4Y|8|@$13|4Z|14|50|1U|1V]]|9|@$13|51|14|52|1|53]]|A|$]]|$1|28|3|29|5|G|7|54|8|@$13|55|14|56|1U|1V]]|9|@$13|57|14|58|1|59]]|A|$]]|$1|2A|3|2B|5|D|7|5A|8|@]|9|@]|A|$]]]|2C|$2D|$5|2E|2F|2G|A|$2H|2I]]|2J|$5|2E|2F|2G|A|$2H|2I]]|2K|$5|2E|2F|2G|A|$2H|2L]]|2M|$5|2E|2F|2G|A|$2H|2N]]|2O|$5|2E|2F|2G|A|$2H|2P]]|2Q|$5|2E|2F|2G|A|$2H|2R]]|2S|$5|2E|2F|2G|A|$2H|2T]]|2U|$5|2E|2F|2G|A|$2H|2V]]|2W|$5|2E|2F|2G|A|$2H|2X]]|2Y|$5|2E|2F|2G|A|$2H|2Z]]]]

<p>Here are two possible setups you could try</p>

<h1>TOPOLOGY #1</h1>

<ul>
<li>Data Center #1 with two(2) DB Servers (DB1, DB2)</li>
<li>Data Center #2 with two(2) DB Servers (DB3, DB4)</li>
<li>Setup DRBD with Each Data Center</li>
<li>Setup MySQL Replication Between the DRBD Primaries</li>
<li>Setup DBVIP (Linux Heartbeat/ Pacemaker / ucarp)</li>
</ul>

<p>What this setup provides</p>

<ul>
<li>Synchronous Disk-Level Replication Within Each Data Center</li>
<li>Asynchronous Replication Between Data Centers</li>
</ul>

<h1>TOPOLOGY #2</h1>

<ul>
<li>Data Center #1

<ul>
<li>Three(3) DB Servers (DB1, DB2, DB3)</li>
<li><a href="https://dba.stackexchange.com/questions/23148/mirroring-databases-in-mysql/25759#25759">Percona XtraDB Cluster</a> among the three(3) DB Servers</li>
</ul></li>
<li>Data Center #2

<ul>
<li>Three(3) DB Servers (DB4, DB5, DB6)</li>
<li><a href="https://dba.stackexchange.com/questions/23148/mirroring-databases-in-mysql/25759#25759">Percona XtraDB Cluster</a> among the three(3) DB Servers</li>
</ul></li>
<li>MySQL Circular Replication

<ul>
<li>DB3 used as Master to DB6</li>
<li>DB3 used as Slave to DB6</li>
<li>Use Semisync Replication Between Master and Slave</li>
</ul></li>
</ul>

<p>What this setup provides</p>

<ul>
<li>Virtually Synchronous Replication Within Each Data Center</li>
<li>Asynchronous Replication Between Data Centers</li>
</ul>

<p>I have discussed setups like this before</p>

<ul>
<li><code>Feb 10, 2014</code> : <a href="https://dba.stackexchange.com/questions/58594/mysql-high-availability-for-innodb/58606#58606">MySQL High Availability for InnoDB</a></li>
<li><code>Jul 11, 2013</code> : <a href="https://dba.stackexchange.com/questions/46158/mysql-replication-between-datacenters/46159#46159">MySQL replication between datacenters</a></li>
<li><code>Dec 26, 2012</code> : <a href="https://dba.stackexchange.com/questions/31031/mysql-replication-and-high-availability/31035#31035">MySQL Replication and High Availability</a></li>
<li><code>Oct 25, 2012</code> : <a href="https://dba.stackexchange.com/questions/27582/mysql-read-slave-to-fetch-entire-database-on-start/27611#27611">mysql read slave to fetch entire database on start</a></li>
<li><code>Aug 20, 2012</code> : <a href="https://dba.stackexchange.com/questions/22788/best-solution-for-cross-datacenter-mysql-master-slave-replication/22790#22790">Best solution for cross-datacenter MySQL master-slave replication</a></li>
<li><code>Mar 26, 2012</code> : <a href="https://dba.stackexchange.com/questions/15573/3-databases-best-replication-setup/15577#15577">3 Databases, Best Replication Setup?</a></li>
<li><code>Dec 19, 2011</code> : <a href="https://dba.stackexchange.com/questions/9424/best-way-to-setup-master-to-multi-master-replication/9425#9425">Best way to setup master to multi master replication</a></li>
<li><code>Mar 29, 2011</code> : <a href="https://dba.stackexchange.com/questions/1974/mysql-high-availability-failover-and-replication-with-latency/1983#1983">MySQL high availability, failover and replication with Latency</a></li>
</ul>

<h1>GIVE IT A TRY !!!</h1>


<p>We'd like to have two MySQL cluster groups, and at the same time have replication set up between them.  Is that possible? </p>


MySQL Cluster Replication Merge

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我们希望有两个MySQL集群组，同时在它们之间设置复制。这有可能吗？

问MySQL集群复制合并
EN

回答 1

Database Administration用户

拓扑#1

拓扑#2

试试看！

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL集群复制合并EN