xDev Asia

安裝Python依賴項，透過pip設定Patroni，分析patroni.yml結構並在3個節點上建立systemd服務。

PostgreSQL 與 Patroni 和 PostgreSQL 高可用性etcd

第 2 部分：安裝與安裝設定

xdev.asia

目標____HTMLTAG_66__HTMLTAG_67_完成本課程後，您將：_HTMLTAG_68__HTMLTAG_69__HTMLTAG_70_安裝 Python 和必要的依賴項__HTMLTAG_71__HTMLTAG_72_透過 pip 安裝Patroni__HTMLTAG_73__HTMLTAG_74_了解檔案結構`patroni.yml_HTMLTAG_76__HTMLTAG_77__HTMLTAG_78`為Patroni建立systemd服務__HTMLTAG_79__HTMLTAG_80_在3個節點上安裝Patroni_HTMLTAG_81__HTMLTAG_82__HTMLTAG_83_1。簡介_HTMLTAG_84__HTMLTAG_85_Patroni 是一個 Python 應用程序，因此它需要 Python 運行時和依賴項。在本文中，我們將：HTMLTAG_86__HTMLTAG_87__HTMLTAG_88_安裝 Python 3 和 pip_HTMLTAG_89__HTMLTAG_90_安裝 Patroni 軟體包_HTMLTAG_91__HTMLTAG_92_Patroni 建立設定管理服務來管理服務 HTMLTAG_MLG Patroni守護程式___HTMLTAG_95__HTMLTAG_96__HTMLTAG_97__HTMLTAG_98_目標體系結構：_HTMLTAG_100__CODEBLOCK_0__HTMLTAG_101_2。安裝 Python 依賴項_HTMLTAG_102__HTMLTAG_103_2.1。在 Ubuntu/Debian 上安裝 Python_HTMLTAG_104__HTMLTAG_105_在所有 3 個節點上執行.HTMLTAG_108__HTMLTAG_109___步驟 1：安裝 Python 3 和 pip_HTHTMLTAG13010210 2：安裝系統相依性HTMLTAG_112__CODEBLOCK_2__HTMLTAG_113_2.2。在 CentOS/RHEL 上安裝 Python_HTMLTAG_114__CODEBLOCK_3__HTMLTAG_115___2.3。升級 pip（建議）HTMLTAG_116__CODEBLOCK_4__HTMLTAG_117_3。透過 pip 安裝 Patroni_HTMLTAG_118__HTMLTAG_119_3.1。安裝 Patroni__HTMLTAG_120__HTMLTAG_121___在所有 3個節點上執行. CODEBLOCK_5__HTMLTAG_125__HTMLTAG_126_解決方案像_HTML TAG_127[etcd]HTMLTAG_128__HTMLTAG_129:HTMLTAG_130__HTMLTAG_131__HTMLTAG_132___Patroni支援許多 DCS 後端（etcd、consul、 Zookeeper)HTMLTAG_133__HTMLTAG_134__HTMLTAG_135[etcd]安裝新增`python-etcd`客戶端庫___HTMLT AG_139__HTMLTAG_140___可以安裝多個後端：patroni[etcd、consul、zookeeper]HTMLTAG_142__HTMLTAG_143__HTMLTAG_144__HTMLTAG_145_3.2。已安裝的軟體包_HTMLTAG_146__CODEBLOCK_6__HTMLTAG_147_3.3。驗證 Patroni 指令_HTMLTAG_148__CODEBLOCK_7__HTMLTAG_149___輸出： CODEBLOCK_8__HTMLTAG_151_4。檔案結構 patoni.yml_HTMLTAG_152__HTMLTAG_153_4.1。 patroni.yml概述_HTMLTAG_154__HTMLTAG_155___檔案patroni.yml是Patroni的主要設定文件，包括：HTMLTAG_158__HTML TAG_159__HTMLTAG_160__HTMLTAG_161_範圍：叢集名稱__HTMLTAG_163__HTMLTAG_164__HTMLTAG_165_命名空間：DCS中鍵的前綴_HTMLTAG_167__HTMLTAG_168__HTMLTAG_169_節點資訊：節點名稱、REST API設定_HTMLTAG_171__HTMLTAG_172__HTMLTAG_173_DCS連線：etcd端點__HTMLTAG_175__HTMLTAG_176__HTMLTAG_177___引導 HTMLTAG_178：初始叢集設定____HTMLTAG_179__HTMLTAG_180__HTMLTAG_181_PostgreSQL：資料庫設定__HTMLTAG_183__HTMLTAG_184__HTMLTAG_185_標籤：節點元資料_HTMLTAG_187__HTMLTAG_188__HTMLTAG_189_看門狗：選用硬體看門狗_HTMLTAG_191__UMLTAG_190：可選的硬體看門狗_____MLTAG_191__HTTAG19191953_1914.G191192G191_基本結構_HTMLTAG_194__CODEBLOCK_9__HTMLTAG_195_4.3。主要部分說明__HTMLTAG_196__HTMLTAG_197_部分：全域__HTMLTAG_198__CODEBLOCK_10__HTMLTAG_199_部分：REST API__HTMLTAG_200__CODEBLOCK_11__HTMLTAG_2011] API端点:HTMLTAG_204__HTMLTAG_205__HTMLTAG_206__HTMLTAG_207_GET /：集群信息_HTMLTAG_209__HTMLTAG_210__HTMLTAG_211___GET /health：运行状况检查(200 = health)HTMLTAG_213__HTMLTAG_214__HTMLTAG_215_GET /primary：檢查節點是否為主__HTMLTAG_217__HTMLTAG_218：檢查節點是否為主____HTMLTAG_217__HTMLTAG_218__HTMLTAG_219 /replica：檢查節點是否為副本___HTMLTAG_221__HTMLTAG_222__HTMLTAG_223_POST /restart：重新啟動 PostgreSQL__HTMLTAG_225__HTMLTAG_224：重新啟動 PostgreSQL____HTMLTAG_225__HTMLTAG_22672726725HT /reload：重新載入設定_HTMLTAG_229__HTMLTAG_230__HTMLTAG_231_部分：etcd (DCS)_HTMLTAG_232__CODEBLOCK_12__HTMLTAG_233_部分：引導__HTMLTAG_234__CODEBLOCK_13__HTMLTAG_235__HTMLTAG_236_注意：引導部分適用於首次定義叢集時。 _HTMLTAG_238__HTMLTAG_239_部分： PostgreSQL_HTMLTAG_240__CODEBLOCK_14__HTMLTAG_241_部分：標籤_HTMLTAG_242__CODEBLOCK_15__HTMLTAG_243_部分：看門狗（可選）_HTMLTAG_244__CODEBLOCK_164555。建立 Patroni 設定檔___HTMLTAG_246__HTMLTAG_247_5.1。建立設定目錄_HTMLTAG_248__HTMLTAG_249_在所有 3 個節點:
_CODEBLOCK_17__HTMLTAG_253_5.2.節點 1 - /etc/patroni/patroni.yml_HTMLTAG_254__CODEBLOCK_18__HTMLTAG_255_5.3。節點 2 - /etc/patroni/patroni.yml_HTMLTAG_256__CODEBLOCK_19__HTMLTAG_257_5.4。節點 3 - /etc/patroni/patroni.yml_HTMLTAG_258__CODEBLOCK_20__HTMLTAG_259_5.5。設定權限_HTMLTAG_260__HTMLTAG_261_在所有 3 個節點:_HTMLTAG_264__CODEBLOCK_21__HTMLTAG_265_6。為 Patroni_HTMLTAG_266__HTMLTAG_267_6.1 建立 systemd 服務。建立 systemd 單元檔案_HTMLTAG_268__HTMLTAG_269_建立檔案`/etc/systemd/system/patroni.service` on ALL 3節點：_HTMLTAG_274__CODEBLOCK_22__HTMLTAG_275___6.2。解釋 systemd 單元檔

HTMLTAG_278__HTMLTAG_279__HTMLTAG_280__HTMLTAG_281____指令___HTMLTAG_282__HTMLTAG_283___解決方案例如____HTMLTAG_284__HTMLTAG_285__HTMLTAG_286HT MLTAG_287__HTMLTAG_288__HTMLTAG_289__HTMLTAG_290___After=etcd.service____HTMLTAG_291__HTMLTAG_292__HTMLTAG_293___在etcd之後啟動就緒___HTMLTAG_294__H TMLTAG_295__HTMLTAG_296__HTMLTAG_297__HTMLTAG_298___類型=簡單____HTMLTAG_299__HTMLTAG_300__HTMLTAG_301___程序正在執行前台___HTMLTAG_302__HTMLTAGTM_303__H LTAG_304__HTMLTAG_305__HTMLTAG_306___User=postgres____HTMLTAG_307__HTMLTAG_308__HTMLTAG_309____與使用者postgres一起執行___HTMLTAG_310__HTMLTAG_311______HTMLTAG_312__HTMLTAG_313__HTMLTAG_314___ExecStart___HTMLTAG_315__HTMLTAG_316__HTMLTAG_317___啟動指令PatroniHTM LTAG_319ExecReloadSend HUP signal to reload configRestart=on-failure___HTTAG_331uto_____332 failRestartSec=5Wait 5 seconds before restartLimitNOFILE=65536__HTMLTAG_348HTHTMLTAG_349___Up filesStandardOutput=journal___HTMLTAG_357dLogto) journal

6.3. Enable and verify service

On ALL 3 nodes:

# Reload systemd sudo systemctl daemon-reload Enable Patroni service (auto-start on boot) sudo systemctl enable patroni Verify service file systemctl cat patroni Check status (should be inactive/dead - not started yet)

systemctl status patroni

7.驗證安裝___HTMLTAG_370__HTMLTAG_371___7.1。 Check Patroni installation

On ALL 3 nodes:

# Check Patroni version
patroni --version
Check patronictl
patronictl --help
Verify config file
sudo -u postgres cat /etc/patroni/patroni.yml
Validate YAML syntax
python3 -c "import yaml; yaml.safe_load(open('/etc/patroni/patroni.yml'))"
No output = valid YAML

HTMLTAG_377.2.2.2.連結性___HTMLTAG_378__CODEBLOCK_25__HTMLTAG_379___7.3。飛行前檢查清單___HTMLTAG_380__HTMLTAG_381___在啟動 Patroni 之前，請先驗證：
CODEBLOCK_26__HTMLTAG_383___8。疑难解答___HTMLTAG_384__HTMLTAG_385___8.1。問題：pip 安裝失敗___HTMLTAG_386__CODEBLOCK_27__HTMLTAG_387___8.2。問題：找不到 PostgreSQL 二進位檔案____HTMLTAG_388__CODEBLOCK_28__HTMLTAG_389___8.3。問題：資料目錄的權限被拒絕____HTMLTAG_390__CODEBLOCK_29__HTMLTAG_391___8.4。問題：YAML 語法錯誤___HTMLTAG_392__CODEBLOCK_30__HTMLTAG_393___9。 Summary
Key Takeaways
✅ Patroni: Python application, install pip___HTMLTAG_400__HTMLTAG_401✅ 相依性：Python 3、pip、psycopg2、 python-etcd

✅ Configuration: patroni.yml___HTMLTAG: patroni.yml&nbspconconntain; settings

✅ systemd service: Patroni daemon management

✅ Security: The config file has permissions 600 (contains passwords)

`Checklist after Lab___HTMLTAG_420HTMLTAG_421_ Python 3 and pip 38 _ Python 3 and pip 3lled on nodes Patroni 3.2.0+ installed on all 3 nodes File /patc/Umwm/Umm&nb create on each node with its own config`
`systemd service patroni.service created and enable_patroni.service created and enable_patroni.service`&nbsp； (600, owner postgres)
etcd 叢集運作正常___HTMLTAG_437__HTMLTAG_438__HTMLTAG_439_目前架構__HTMLTAG_440__CODEBLOCK_31__HTMLTAG_441_準備第 8 課__HTMLTAG_442 11442 的詳細課Patroni設定：HTMLTAG_444__HTMLTAG_445__HTMLTAG_446_分析`patroni.yml中的每個部分_HTMLTAG_448__HTMLTAG_449__HTMLTAG_450____引導設定選項` `451HTMLTAG_452_PostgreSQL參數調整_HTMLTAG_453__HTMLTAG_454_驗證設定__HTMLTAG_455__HTMLTAG_456_標籤與約束__HTMLTAG_457__HTMLTAG_458HT 9 課：引導叢集_HTMLTAG_460__HTMLTAG_461___安裝並設定 Patroni 後，第 9課將指南：_HTMLTAG_462__HTMLTAG_463__HTMLTAG_464_首次啟動Patroni__HTMLTAG_465__HTMLTAG_466_自動引導進程動態_HTMLTAG_467__HTMLTAG_468_檢查叢集狀態_HTMLTAG_469__HTMLTAG_470_故障排除_HTMLTAG_471__HTMLTAG_472`

第 7 課：安裝 Patroni

6.3. Enable and verify service

Enable Patroni service (auto-start on boot)

Verify service file

Check status (should be inactive/dead - not started yet)

7.驗證安裝___HTMLTAG_370__HTMLTAG_371___7.1。 Check Patroni installation

Check patronictl

Verify config file

Validate YAML syntax

No output = valid YAML

Key Takeaways