{"id":16230,"date":"2024-10-14T11:19:38","date_gmt":"2024-10-14T03:19:38","guid":{"rendered":"http:\/\/www.rao-bing.cn\/?p=16230"},"modified":"2024-10-14T11:19:38","modified_gmt":"2024-10-14T03:19:38","slug":"pacemakercorosynckingbase-8-6","status":"publish","type":"post","link":"http:\/\/www.rao-bing.cn\/index.php\/2024\/10\/14\/16230\/","title":{"rendered":"pacemaker+corosync+kingbase 8.6"},"content":{"rendered":"

\u5728pacemaker\u4e2d\u5982\u679c\u7528systemd agent\u65b9\u5f0f\u521b\u5efakingbase\u8d44\u6e90\uff0c\u65e0\u6cd5\u68c0\u6d4b\u5230kingbase\u7684\u5f02\u5e38\u7ec8\u6b62\uff08\u5176\u4ed6\u8d44\u6e90\u5b8c\u597d\u7684\u60c5\u51b5\u4e0b\uff09\uff0c
\n\u6240\u4ee5\u6539\u7528ocf:heartbeat:pgsql agent\u7684\u65b9\u5f0f\u521b\u5efa\u8d44\u6e90\uff0c\u56e0\u4e3aocf:heartbeat:pgsql\u662f\u9488\u5bf9postgreSQL\u7684\uff0c\u6240\u4ee5\u9700\u8981\u5c11\u8bb8\u4fee\u6539\u3002
\n\u73af\u5883\uff1aOS\uff1a\u9e92\u9e9fV10 SP3\uff0ccorosync 3.1.8\uff0cpacemaker 2.1.6 \uff0ccrmsh 4.5 \uff0c resource-agents 4.2.0\uff0c fence-agents 4.2.1<\/p>\n

\n1. \/usr\/lib\/ocf\/resource.d\/heartbeat\/pgsql\u79cd\u7684postmaster.pid\u6539\u6210kingbase.pid,\u5c06 PG_VERSION\u6539\u6210SYS_VERSION<\/p>\n

2. \u7ed9\u6570\u636e\u5e93\u521b\u5efa\u7528\u6237kingbase,\u9700\u8981\u548cpgdba\uff08OS\u7528\u6237\u540d\uff09\u4e00\u6837\uff1a<\/p>\n

create user kingbase with password ‘123456’;<\/p>\n

\u6b63\u5e38\u60c5\u51b5\u4e0b\u5e94\u8be5\u7ed9\u8d44\u6e90\u8bbe\u7f6eocf:heartbeat:pgsql\u7684monitor_user\u548cmonitor_password\uff0c\u6307\u5b9a\u76d1\u63a7\u7528\u6237\u548c\u53e3\u4ee4\uff0c\u4f46\u662f\u8bbe\u7f6e\u4e86\u4e5f\u4e0d\u8d77\u4f5c\u7528\uff0c\u4e00\u76f4\u7528kingbase\uff08pgdba\uff09\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u5e94\u8be5\u662fpgsql agent\u7684bug\uff0c\u540e\u7eed\u7814\u7a76\u770b\u5347\u7ea7resource agent\u662f\u5426\u80fd\u89e3\u51b3\u95ee\u9898\u3002<\/p>\n

3.\u8bbe\u7f6e\u514d\u5bc6\u767b\u9646\uff1a<\/p>\n

ocf:heartbeat:pgsql agent\u8fde\u63a5\u6570\u636e\u5e93\u65f6\uff0c\u9700\u8981\u514d\u5bc6\u767b\u9646\uff0c\u672c\u6765\u662f\u7528PGUSER\uff0cPGPASSWORD\u73af\u5883\u53d8\u91cf\u7684\u65b9\u5f0f\uff0c\u4f7f\u547d\u4ee4\u884c\u4e0d\u9700\u8981\u4ea4\u4e92\uff0c\u4f46\u662f\u8fd9\u79cd\u65b9\u5f0f\uff0c\u5728kingbase\u9ad8\u7248\u672c\u4e0d\u8d77\u4f5c\u7528\uff0c\u6240\u4ee5\u9700\u8981\u7528encpwd\u5de5\u5177\u8bbe\u7f6e\u514d\u5bc6\u767b\u9646\u3002<\/p>\n

\/opt\/Kingbase\/ES\/V8\/Server\/bin\/sys_encpwd -H \\* -P \\* -D \\* -U kingbase -W 123456 <\/p>\n

\u5de5\u5177\u4f1a\u751f\u6210\/home\/kingbase\/.encpwd\u6587\u4ef6\uff0c\u53e3\u4ee4\u52a0\u5bc6\u5b58\u50a8\u5728\u8fd9\u4e2a\u6587\u4ef6\u91cc; \u661f\u53f7\u662f\u901a\u914d\u7b26\uff0c\u9700\u8981\u7528\\\u8f6c\u4e49\uff0c\u4f7f\u7528\u901a\u914d\u7b26\u4e0d\u5b89\u5168\u3002<\/p>\n

\/opt\/Kingbase\/ES\/V8\/Server\/bin\/sys_encpwd -H 192.168.0.181 -P 54321 -D template1 -U kingbase -W 123456<\/p>\n

\u6d4b\u8bd5\u514d\u5bc6\u767b\u9646\uff1a<\/p>\n

\/opt\/Kingbase\/ES\/V8\/Server\/bin\/ksql -p 54321 -U kingbase template1<\/p>\n

\n4. \u7528crmsh\u521b\u5efapacemaker\u8d44\u6e90\uff1a<\/p>\n

crm configure primitive kingbasedb1 ocf:heartbeat:pgsql \\
     params pgctl=”\/opt\/Kingbase\/ES\/V8\/Server\/bin\/sys_ctl” \\
     ctl_opt=”-w” \\
     psql=”\/opt\/Kingbase\/ES\/V8\/Server\/bin\/ksql” \\
     pgdata=”\/data01\/kbdb” \\
     pgdba=”kingbase” \\
     pghost=”0.0.0.0″ \\
     config=”\/data01\/kbdb\/kingbase.conf” \\
     pgport=”54321″ \\
     pglibs=”\/opt\/Kingbase\/ES\/V8\/Server\/lib” \\
     pgdb=”template1″ \\
     logfile=”\/data01\/kbdb\/sys_log\/kingbasedb1.log” \\
     op start interval=”0″ timeout=”120″ \\
     op stop interval=”0″ timeout=”120″ \\
     op monitor interval=”9s” timeout=”30″ <\/p>\n","protected":false},"excerpt":{"rendered":"

\u5728pacemaker\u4e2d\u5982\u679c\u7528systemd agent\u65b9\u5f0f\u521b\u5efakingbase\u8d44\u6e90\uff0c\u65e0\u6cd5\u68c0\u6d4b\u5230kingbase\u7684\u5f02\u5e38\u7ec8\u6b62\uff08\u5176\u4ed6\u8d44\u6e90\u5b8c\u597d\u7684\u60c5\u51b5\u4e0b\uff09\uff0c \u6240\u4ee5\u6539\u7528oc…<\/p>\n

Read More Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"aside","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1],"tags":[],"class_list":["post-16230","post","type-post","status-publish","format-aside","hentry","category-uncategorized","post_format-post-format-aside"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p8gSFq-4dM","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":848,"url":"http:\/\/www.rao-bing.cn\/index.php\/2018\/01\/11\/848\/","url_meta":{"origin":16230,"position":0},"title":"\u4f7f\u7528Oracle EM13c\u7ba1\u7406\u6570\u636e\u5e93\u79c1\u6709\u4e91","author":"raobing","date":"2018-01-11","format":"aside","excerpt":"\u5b9e\u73b0Oracle\u6570\u636e\u5e93\u79c1\u6709\u4e91\u7684\u65b9\u5f0f\u6709\u4e24\u7c7b\uff1aIaaS\u548cPaaS\uff0c\u56e0\u4e3aIaaS\u4f1a\u4f7f\u7528\u57fa\u7840\u67b6\u6784\u865a\u62df\u5316\u6280\u672f\uff0c\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2018\/01\/clip_image044_thumb.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2018\/01\/clip_image044_thumb.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2018\/01\/clip_image044_thumb.jpg?resize=525%2C300 1.5x"},"classes":[]},{"id":16123,"url":"http:\/\/www.rao-bing.cn\/index.php\/2020\/06\/23\/16123\/","url_meta":{"origin":16230,"position":1},"title":"\u795e\u821f\u901a\u7528\u6570\u636e\u5e93\u53cc\u673a\u5207\u6362\u73af\u5883\u642d\u5efa","author":"raobing","date":"2020-06-23","format":"aside","excerpt":"\u795e\u821f\u901a\u7528\u7684\u53cc\u673a\u5207\u6362\u73af\u5883\u539f\u7406\u793a\u610f\u56fe\uff1a \u795e\u901a\u6570\u636e\u5e93\u7684\u53cc\u673a\u70ed\u5907\u539f\u7406\uff0c\u4eceOracle DBA\u7684\u89d2\u5ea6\uff0c\u5176\u5b9e\u4e0d\u96be\u2026","rel":"","context":"\u5728\u201c\u53bbO\u201d\u4e2d","block_context":{"text":"\u53bbO","link":"http:\/\/www.rao-bing.cn\/index.php\/tag\/de-oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/lio_thumb.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/lio_thumb.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/lio_thumb.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/lio_thumb.png?resize=700%2C400 2x"},"classes":[]},{"id":182,"url":"http:\/\/www.rao-bing.cn\/index.php\/2017\/01\/07\/182\/","url_meta":{"origin":16230,"position":2},"title":"Database Replay\u548cConsolidated Database replay","author":"raobing","date":"2017-01-07","format":false,"excerpt":"\u7b80\u4ecb \u5728\u6570\u636e\u5e93\u7684\u8fc1\u79fb\u548c\u5347\u7ea7\u573a\u666f\u4e2d\uff0c\u6211\u4eec\u7ecf\u5e38\u4f1a\u9047\u5230\u4e00\u4e2a\u95ee\u9898\uff1a\u5728\u505a\u538b\u529b\u6d4b\u8bd5\u65f6\uff0c\u5982\u4f55\u6a21\u62df\u771f\u5b9e\u7684\u4e1a\u52a1\u538b\u529b\uff0c\u89e3\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1407_DatabaseRep1.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1407_DatabaseRep1.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1407_DatabaseRep1.png?resize=525%2C300 1.5x"},"classes":[]},{"id":518,"url":"http:\/\/www.rao-bing.cn\/index.php\/2017\/01\/22\/518\/","url_meta":{"origin":16230,"position":3},"title":"Oracle Database 12c Data Redaction","author":"raobing","date":"2017-01-22","format":"aside","excerpt":"\u00a0 \u4ec0\u4e48\u662fData Redaction Data Redaction\u662fOracle Dat\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image034_thumb-1.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image034_thumb-1.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/clip_image034_thumb-1.jpg?resize=525%2C300 1.5x"},"classes":[]},{"id":136,"url":"http:\/\/www.rao-bing.cn\/index.php\/2017\/01\/07\/136\/","url_meta":{"origin":16230,"position":4},"title":"\u4f7f\u7528\u6280\u672f\u624b\u6bb5\u9650\u5236DBA\u7684\u5371\u9669\u64cd\u4f5c","author":"raobing","date":"2017-01-07","format":"aside","excerpt":"\u6982\u8ff0 \u4f17\u6240\u5468\u77e5\uff0c\u5728\u4e1a\u52a1\u9ad8\u5cf0\u671f\uff0c\u67d0\u4e9b\u9488\u5bf9Oracle\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u5177\u6709\u5f88\u9ad8\u7684\u98ce\u9669\uff0c\u6bd4\u5982\u4fee\u6539\u8868\u7ed3\u6784\u3001\u4fee\u6539\u5b9e\u2026","rel":"","context":"\u5728\u201cOracle\u201d\u4e2d","block_context":{"text":"Oracle","link":"http:\/\/www.rao-bing.cn\/index.php\/category\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2017\/01\/010717_1123_1.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":16136,"url":"http:\/\/www.rao-bing.cn\/index.php\/2020\/06\/28\/16136\/","url_meta":{"origin":16230,"position":5},"title":"\u795e\u821f\u901a\u7528\u6570\u636e\u5e93\u8bfb\u5199\u5206\u79bb\uff08RW\uff09\u96c6\u7fa4","author":"raobing","date":"2020-06-28","format":"aside","excerpt":"\u795e\u821f\u901a\u7528\u6570\u636e\u5e93\u8bfb\u5199\u5206\u79bb\uff08RW\uff09\u96c6\u7fa4\u7684\u67b6\u6784\u56fe\u5982\u4e0b\u6240\u793a\uff0c \u548c\u795e\u901aDB\u7684HA\u67b6\u6784\u4e0d\u540c\uff0cRW\u96c6\u7fa4\u662fshare\u2026","rel":"","context":"\u5728\u201c\u53bbO\u201d\u4e2d","block_context":{"text":"\u53bbO","link":"http:\/\/www.rao-bing.cn\/index.php\/tag\/de-oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/image_thumb-2.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/image_thumb-2.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/image_thumb-2.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.rao-bing.cn\/wp-content\/uploads\/2020\/06\/image_thumb-2.png?resize=700%2C400 2x"},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/posts\/16230","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/comments?post=16230"}],"version-history":[{"count":1,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/posts\/16230\/revisions"}],"predecessor-version":[{"id":16231,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/posts\/16230\/revisions\/16231"}],"wp:attachment":[{"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/media?parent=16230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/categories?post=16230"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.rao-bing.cn\/index.php\/wp-json\/wp\/v2\/tags?post=16230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}