CN104503965B - PostgreSQL高弹性的高可用及负载均衡实现方法 - Google Patents
PostgreSQL高弹性的高可用及负载均衡实现方法 Download PDFInfo
- Publication number
- CN104503965B CN104503965B CN201410548447.2A CN201410548447A CN104503965B CN 104503965 B CN104503965 B CN 104503965B CN 201410548447 A CN201410548447 A CN 201410548447A CN 104503965 B CN104503965 B CN 104503965B
- Authority
- CN
- China
- Prior art keywords
- database
- node
- mirror
- host node
- virtual
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 claims abstract description 31
- 238000012360 testing method Methods 0.000 claims description 15
- 230000006870 function Effects 0.000 claims description 13
- 238000011084 recovery Methods 0.000 claims description 12
- 230000002159 abnormal effect Effects 0.000 claims description 11
- 230000008569 process Effects 0.000 claims description 8
- 230000001360 synchronised effect Effects 0.000 claims description 8
- 230000003862 health status Effects 0.000 claims description 6
- 238000009434 installation Methods 0.000 claims description 6
- 230000004913 activation Effects 0.000 claims description 5
- 230000008859 change Effects 0.000 claims description 5
- 230000010076 replication Effects 0.000 claims description 5
- 230000036541 health Effects 0.000 claims description 4
- 210000004556 brain Anatomy 0.000 claims description 3
- 238000011217 control strategy Methods 0.000 claims description 3
- 238000001514 detection method Methods 0.000 claims description 3
- 238000007689 inspection Methods 0.000 claims description 3
- 230000009191 jumping Effects 0.000 claims description 3
- 238000012544 monitoring process Methods 0.000 claims description 3
- 230000002035 prolonged effect Effects 0.000 claims 1
- 238000004422 calculation algorithm Methods 0.000 abstract description 4
- 238000003780 insertion Methods 0.000 abstract description 4
- 230000037431 insertion Effects 0.000 abstract description 4
- 230000004044 response Effects 0.000 abstract description 4
- 230000006399 behavior Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 101100264195 Caenorhabditis elegans app-1 gene Proteins 0.000 description 2
- 230000007547 defect Effects 0.000 description 2
- 238000013467 fragmentation Methods 0.000 description 2
- 238000006062 fragmentation reaction Methods 0.000 description 2
- 230000008447 perception Effects 0.000 description 2
- 239000011800 void material Substances 0.000 description 2
- 238000007796 conventional method Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000004804 winding Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1001—Protocols in which an application is distributed across nodes in the network for accessing one among a plurality of replicated servers
Abstract
Description
Claims (5)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410548447.2A CN104503965B (zh) | 2014-10-16 | 2014-10-16 | PostgreSQL高弹性的高可用及负载均衡实现方法 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410548447.2A CN104503965B (zh) | 2014-10-16 | 2014-10-16 | PostgreSQL高弹性的高可用及负载均衡实现方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104503965A CN104503965A (zh) | 2015-04-08 |
CN104503965B true CN104503965B (zh) | 2017-08-29 |
Family
ID=52945363
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410548447.2A Active CN104503965B (zh) | 2014-10-16 | 2014-10-16 | PostgreSQL高弹性的高可用及负载均衡实现方法 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104503965B (zh) |
Families Citing this family (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104794026B (zh) * | 2015-04-29 | 2017-09-15 | 上海新炬网络信息技术有限公司 | 一种集群实例多数据源绑定的故障转移方法 |
CN105224637A (zh) * | 2015-09-24 | 2016-01-06 | 珠海许继芝电网自动化有限公司 | 一种基于PostgreSQL数据库的主备/集群应用的综合性方法 |
CN105389371A (zh) * | 2015-11-16 | 2016-03-09 | 天津南大通用数据技术股份有限公司 | 一种数据库集群建立连接高可用的方法和系统 |
CN109213827B (zh) * | 2017-07-03 | 2022-07-08 | 阿里云计算有限公司 | 一种数据处理系统、方法、路由器及从数据库 |
CN109947591B (zh) * | 2017-12-20 | 2023-03-24 | 腾讯科技(深圳)有限公司 | 数据库异地灾备系统及其部署方法、部署装置 |
CN109788032B (zh) * | 2018-12-17 | 2021-12-14 | 深圳壹账通智能科技有限公司 | 镜像文件的获取方法、装置、计算机设备和存储介质 |
CN109918439B (zh) * | 2019-03-14 | 2021-04-27 | 杭州数梦工场科技有限公司 | 数据同步方法及其应用的环路检测方法和相关装置 |
CN109947536A (zh) * | 2019-03-25 | 2019-06-28 | 山东浪潮云信息技术有限公司 | 一种基于Kubernetes的PostgreSQL自动化部署方法 |
CN110569303B (zh) * | 2019-08-19 | 2020-12-08 | 杭州衣科信息技术有限公司 | 一种适用于多种云环境的MySQL应用层高可用系统及方法 |
CN111552637B (zh) * | 2020-04-20 | 2023-05-19 | 北京顺达同行科技有限公司 | 数据库状态的检测方法、装置、电子设备及其存储介质 |
CN112084072B (zh) * | 2020-09-11 | 2021-05-28 | 重庆紫光华山智安科技有限公司 | 一种提高PostgreSQL集群容灾能力的方法、系统、介质及终端 |
CN112685234A (zh) * | 2020-11-26 | 2021-04-20 | 辽宁振兴银行股份有限公司 | 一种金融级两地三中心高可用MySQL数据库实现方法 |
CN112667353A (zh) * | 2020-12-28 | 2021-04-16 | 紫光云技术有限公司 | 一种解决postgresql高可用节点宕机恢复的方法 |
CN113111122A (zh) * | 2021-03-08 | 2021-07-13 | 北京世纪安图数码科技发展有限责任公司 | 一种面向rac集群的不动产登记数据读写分离方法 |
CN114116912A (zh) * | 2022-01-25 | 2022-03-01 | 北京浩瀚深度信息技术股份有限公司 | 一种基于Keepalived实现数据库高可用的方法 |
CN116150250B (zh) * | 2023-04-20 | 2023-07-11 | 瀚高基础软件股份有限公司 | 一种基于PostgreSQL的双端口解析方法及装置 |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102521389A (zh) * | 2011-12-23 | 2012-06-27 | 天津神舟通用数据技术有限公司 | 一种混合使用固态硬盘和传统硬盘的postgresql数据库集群系统及其优化方法 |
CN103049579A (zh) * | 2013-01-15 | 2013-04-17 | 太仓市同维电子有限公司 | 一种基于postgresql数据库的嵌入式系统管理方法 |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9836513B2 (en) * | 2012-03-12 | 2017-12-05 | Entit Software Llc | Page feed for efficient dataflow between distributed query engines |
-
2014
- 2014-10-16 CN CN201410548447.2A patent/CN104503965B/zh active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102521389A (zh) * | 2011-12-23 | 2012-06-27 | 天津神舟通用数据技术有限公司 | 一种混合使用固态硬盘和传统硬盘的postgresql数据库集群系统及其优化方法 |
CN103049579A (zh) * | 2013-01-15 | 2013-04-17 | 太仓市同维电子有限公司 | 一种基于postgresql数据库的嵌入式系统管理方法 |
Non-Patent Citations (1)
Title |
---|
PostgreSQL数据库集群基本技术分析与实现;纪红波;《吉林工商学院学报》;20100915;第26卷(第5期);第69-72页 * |
Also Published As
Publication number | Publication date |
---|---|
CN104503965A (zh) | 2015-04-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104503965B (zh) | PostgreSQL高弹性的高可用及负载均衡实现方法 | |
CN106341454B (zh) | 跨机房多活分布式数据库管理系统和方法 | |
US7640451B2 (en) | Failover processing in a storage system | |
JP5102901B2 (ja) | データセンタにわたる複数データサーバ間のデータ完全性を保持する方法およびシステム | |
JP6734866B2 (ja) | 第1のストレージ・システムをミラーリングする第2のストレージ・システムへのフェイルオーバ後の第1のストレージ・システムへの再同期 | |
US9817721B1 (en) | High availability management techniques for cluster resources | |
US9423956B2 (en) | Emulating a stretched storage device using a shared storage device | |
US20110289417A1 (en) | User interface for configuring and managing the cluster | |
US20080005288A1 (en) | Storage system and data replication method | |
CN103840961A (zh) | 双机热备份系统 | |
US9442811B2 (en) | Emulating a stretched storage device using a shared replicated storage device | |
CN106850315B (zh) | 一种自动化容灾系统 | |
CN111158955B (zh) | 一种基于卷复制的高可用系统以及多服务器数据同步方法 | |
CN113849136B (zh) | 一种基于国产平台的自动化fc块存储处理方法和系统 | |
Anderson et al. | Local recovery for high availability in strongly consistent cloud services | |
TWI756007B (zh) | 用以進行全快閃記憶體陣列伺服器的高可用性管理的方法與設備 | |
US11308122B2 (en) | Remote copy system | |
CN114416501A (zh) | 一种存储双活及测试系统和方法 | |
CN107104810A (zh) | 一种基于ha双机热备技术 | |
CN110266795A (zh) | 一种基于Openstack平台控制方法 | |
US11841734B1 (en) | Synchronous block level replication across availability zones | |
Read | Oracle solaris cluster essentials | |
Carter | SQL server AlwaysOn revealed | |
Vallath et al. | Testing for Availability | |
Raften | Availability benefits of Linux on z Systems |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP02 | Change in the address of a patent holder | ||
CP02 | Change in the address of a patent holder |
Address after: 310000 room 821, building 1, Xinjun building, 330 Internet of things street, Xixing street, Binjiang District, Hangzhou City, Zhejiang Province Patentee after: Hangzhou Sky-mobi Technology Co., Ltd. Address before: 10, building 2, block B, The Union Buildings, No. 310013, Bauhinia Road, Zhejiang, Hangzhou Patentee before: Hangzhou Sky-mobi Technology Co., Ltd. |
|
TR01 | Transfer of patent right |
Effective date of registration: 20210420 Address after: No. 181, erbatou, taimuyang village, Qinyu Town, Fuding City, Ningde City, Fujian Province Patentee after: Chen Ximei Address before: 310000 room 821, building 1, Xinjun building, 330 Internet of things street, Xixing street, Binjiang District, Hangzhou City, Zhejiang Province Patentee before: HANGZHOU SKY NETWORK TECHNOLOGY Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210712 Address after: Room 802, unit 1, building 03, 439 Changhong Road, Yuhuatai District, Nanjing City, Jiangsu Province, 210000 Patentee after: Nanjing dayifei Software Technology Co.,Ltd. Address before: 355200 no.181 erbatou, taimuyang village, Qinyu Town, Fuding City, Ningde City, Fujian Province Patentee before: Chen Ximei |
|
TR01 | Transfer of patent right | ||
CP03 | Change of name, title or address |
Address after: 211170 a205-73, zone a, university entrepreneurship Park, No. 99, Daxue Road, Xuzhou high tech Industrial Development Zone, Xuzhou City, Jiangsu Province Patentee after: Jiangsu dayifei Software Technology Co.,Ltd. Address before: Room 802, unit 1, building 03, 439 Changhong Road, Yuhuatai District, Nanjing City, Jiangsu Province, 210000 Patentee before: Nanjing dayifei Software Technology Co.,Ltd. |
|
CP03 | Change of name, title or address |