MySQL intra-city multi-center multi-activity implementation method and system based on group replication
The invention provides a group replication-based MySQL intra-city multi-center multi-activity implementation method and system, and the method comprises the steps: deploying a group of MySQL cluster A instance groups with a group replication protocol in a data center A, deploying a group of MySQL cl...
Gespeichert in:
| Hauptverfasser: | , , , , , , |
|---|---|
| Format: | Patent |
| Sprache: | chi ; eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| container_end_page | |
|---|---|
| container_issue | |
| container_start_page | |
| container_title | |
| container_volume | |
| creator | DOU YAO HU JUAN LI SHENG ZHOU WEI WEI ZI'ANG HE BINGWEI HE ZHUOFAN |
| description | The invention provides a group replication-based MySQL intra-city multi-center multi-activity implementation method and system, and the method comprises the steps: deploying a group of MySQL cluster A instance groups with a group replication protocol in a data center A, deploying a group of MySQL cluster B instance groups with a group replication protocol in a data center B, deploying traffic distribution middleware in a traffic control region, and deploying traffic distribution middleware in a traffic control region; and service access is distributed to the data center A and the data center B through middleware, so that double-writing multi-activity of the service is realized. According to the invention, when a fault occurs, no data loss and strong business continuity can be ensured, so that the overall operation and maintenance efficiency is improved.
本发明提供了一种基于组复制的MySQL同城多中心的多活实现方法和系统，包括：在数据中心A中部署一组带有组复制协议的MySQL集群A实例组，在数据中心B中部署一组带有组复制协议的MySQL集群B实例组，在流量控制区部署流量分发中间件，业务访问通过中间件分发给数据中心A和数据中心B，实现业务的双写多活。本发明在发生故障 |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN116910147A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN116910147A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN116910147A3</originalsourceid><addsrcrecordid>eNqNjUsKwkAQBbNxIeod2gMMOCiKSwmKCxVE96GdtKZhfsx0hNzeKDmAq0dRBW9cNOfudj0Be0moDEsHrrXCypAXSgOgEX5_HbtoyfUKhYMHR9KEGtDXkLss5OCBmWro1SuFNkKiaNn84mkxeqLNNBt2UswP-3t5VBRDRTli_0hSlRet11u90KvNbvlP8wFD1UDl</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>MySQL intra-city multi-center multi-activity implementation method and system based on group replication</title><source>esp@cenet</source><creator>DOU YAO ; HU JUAN ; LI SHENG ; ZHOU WEI ; WEI ZI'ANG ; HE BINGWEI ; HE ZHUOFAN</creator><creatorcontrib>DOU YAO ; HU JUAN ; LI SHENG ; ZHOU WEI ; WEI ZI'ANG ; HE BINGWEI ; HE ZHUOFAN</creatorcontrib><description>The invention provides a group replication-based MySQL intra-city multi-center multi-activity implementation method and system, and the method comprises the steps: deploying a group of MySQL cluster A instance groups with a group replication protocol in a data center A, deploying a group of MySQL cluster B instance groups with a group replication protocol in a data center B, deploying traffic distribution middleware in a traffic control region, and deploying traffic distribution middleware in a traffic control region; and service access is distributed to the data center A and the data center B through middleware, so that double-writing multi-activity of the service is realized. According to the invention, when a fault occurs, no data loss and strong business continuity can be ensured, so that the overall operation and maintenance efficiency is improved.
本发明提供了一种基于组复制的MySQL同城多中心的多活实现方法和系统，包括：在数据中心A中部署一组带有组复制协议的MySQL集群A实例组，在数据中心B中部署一组带有组复制协议的MySQL集群B实例组，在流量控制区部署流量分发中间件，业务访问通过中间件分发给数据中心A和数据中心B，实现业务的双写多活。本发明在发生故障</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC COMMUNICATION TECHNIQUE ; ELECTRIC DIGITAL DATA PROCESSING ; ELECTRICITY ; PHYSICS ; TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHICCOMMUNICATION</subject><creationdate>2023</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20231020&DB=EPODOC&CC=CN&NR=116910147A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25543,76293</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20231020&DB=EPODOC&CC=CN&NR=116910147A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>DOU YAO</creatorcontrib><creatorcontrib>HU JUAN</creatorcontrib><creatorcontrib>LI SHENG</creatorcontrib><creatorcontrib>ZHOU WEI</creatorcontrib><creatorcontrib>WEI ZI'ANG</creatorcontrib><creatorcontrib>HE BINGWEI</creatorcontrib><creatorcontrib>HE ZHUOFAN</creatorcontrib><title>MySQL intra-city multi-center multi-activity implementation method and system based on group replication</title><description>The invention provides a group replication-based MySQL intra-city multi-center multi-activity implementation method and system, and the method comprises the steps: deploying a group of MySQL cluster A instance groups with a group replication protocol in a data center A, deploying a group of MySQL cluster B instance groups with a group replication protocol in a data center B, deploying traffic distribution middleware in a traffic control region, and deploying traffic distribution middleware in a traffic control region; and service access is distributed to the data center A and the data center B through middleware, so that double-writing multi-activity of the service is realized. According to the invention, when a fault occurs, no data loss and strong business continuity can be ensured, so that the overall operation and maintenance efficiency is improved.
本发明提供了一种基于组复制的MySQL同城多中心的多活实现方法和系统，包括：在数据中心A中部署一组带有组复制协议的MySQL集群A实例组，在数据中心B中部署一组带有组复制协议的MySQL集群B实例组，在流量控制区部署流量分发中间件，业务访问通过中间件分发给数据中心A和数据中心B，实现业务的双写多活。本发明在发生故障</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC COMMUNICATION TECHNIQUE</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>ELECTRICITY</subject><subject>PHYSICS</subject><subject>TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHICCOMMUNICATION</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2023</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNjUsKwkAQBbNxIeod2gMMOCiKSwmKCxVE96GdtKZhfsx0hNzeKDmAq0dRBW9cNOfudj0Be0moDEsHrrXCypAXSgOgEX5_HbtoyfUKhYMHR9KEGtDXkLss5OCBmWro1SuFNkKiaNn84mkxeqLNNBt2UswP-3t5VBRDRTli_0hSlRet11u90KvNbvlP8wFD1UDl</recordid><startdate>20231020</startdate><enddate>20231020</enddate><creator>DOU YAO</creator><creator>HU JUAN</creator><creator>LI SHENG</creator><creator>ZHOU WEI</creator><creator>WEI ZI'ANG</creator><creator>HE BINGWEI</creator><creator>HE ZHUOFAN</creator><scope>EVB</scope></search><sort><creationdate>20231020</creationdate><title>MySQL intra-city multi-center multi-activity implementation method and system based on group replication</title><author>DOU YAO ; HU JUAN ; LI SHENG ; ZHOU WEI ; WEI ZI'ANG ; HE BINGWEI ; HE ZHUOFAN</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN116910147A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2023</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC COMMUNICATION TECHNIQUE</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>ELECTRICITY</topic><topic>PHYSICS</topic><topic>TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHICCOMMUNICATION</topic><toplevel>online_resources</toplevel><creatorcontrib>DOU YAO</creatorcontrib><creatorcontrib>HU JUAN</creatorcontrib><creatorcontrib>LI SHENG</creatorcontrib><creatorcontrib>ZHOU WEI</creatorcontrib><creatorcontrib>WEI ZI'ANG</creatorcontrib><creatorcontrib>HE BINGWEI</creatorcontrib><creatorcontrib>HE ZHUOFAN</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>DOU YAO</au><au>HU JUAN</au><au>LI SHENG</au><au>ZHOU WEI</au><au>WEI ZI'ANG</au><au>HE BINGWEI</au><au>HE ZHUOFAN</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>MySQL intra-city multi-center multi-activity implementation method and system based on group replication</title><date>2023-10-20</date><risdate>2023</risdate><abstract>The invention provides a group replication-based MySQL intra-city multi-center multi-activity implementation method and system, and the method comprises the steps: deploying a group of MySQL cluster A instance groups with a group replication protocol in a data center A, deploying a group of MySQL cluster B instance groups with a group replication protocol in a data center B, deploying traffic distribution middleware in a traffic control region, and deploying traffic distribution middleware in a traffic control region; and service access is distributed to the data center A and the data center B through middleware, so that double-writing multi-activity of the service is realized. According to the invention, when a fault occurs, no data loss and strong business continuity can be ensured, so that the overall operation and maintenance efficiency is improved.
本发明提供了一种基于组复制的MySQL同城多中心的多活实现方法和系统，包括：在数据中心A中部署一组带有组复制协议的MySQL集群A实例组，在数据中心B中部署一组带有组复制协议的MySQL集群B实例组，在流量控制区部署流量分发中间件，业务访问通过中间件分发给数据中心A和数据中心B，实现业务的双写多活。本发明在发生故障</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | chi ; eng |
| recordid | cdi_epo_espacenet_CN116910147A |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC COMMUNICATION TECHNIQUE ELECTRIC DIGITAL DATA PROCESSING ELECTRICITY PHYSICS TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHICCOMMUNICATION |
| title | MySQL intra-city multi-center multi-activity implementation method and system based on group replication |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-25T20%3A45%3A23IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=DOU%20YAO&rft.date=2023-10-20&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN116910147A%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true |