Pgxc_ctl_primer.pdf - 墨天轮文档

Pgxc_ctl_primer.pdf

56页

0次

2022-12-18

免费下载

PGXC_CTL Primer

Configuring and operating Postgres-XC database cluster

May 7th, 2014

Koichi Suzuki

1. Introduction

ThisdocumentisanoutlineofPostgresXCdatabaseclusterconfigurationandoperation

usingpgxc_ctl.Pgxc_ctlwillbefoundinthecontribmoduleofpostgresxcdistribution.

ThismodulehelpstoconfigureandoperateyourPostgresXCdatabaseclustereasily.This

savesmuchofthesmallbutimportantthings.

2. Plannings you Postgres-XC cluster

2.1 Postgres-XC overview

BeforegoingintoPostgresXCconfiguration,pleasetakeabittoconsiderifPostgresXC

clusterisusefultoyourapplication.UnlikeanyotherPostgreSQLreplicationcluster,

PostgresXCiswritescalablePostgreSQLcluster.Moreserversyouhave,more

throughputyouget,bothinreadandwrite.Ofcourse,youcanhandlebiggerdatabsaeif

youhavemoreserversandstorages.

Toachievethis,youshouldconsidereachtabletobedistributed(sharded)orreplicated.If

tablesareupdatedveryfrequently,youshouldconsiderthemtobedistributed.Iftheyare

relativelystaticandarereferedbydistributedtableorotherreplicatedtables,youshould

considerthemtobereplicated.Thismixturewillmakemostoftheupdatelocaltooneofthe

datanode.Becauseeachdatanodeoperatesinparalle,youcangetbothreadandwrite

scalability.

Youcanconnecttoanyofthecoordinators ,eachofwhichprovidesfulltransactionACID

capabiliyandtransparentviewtothedatabase.Thatis,anyupdateyoumakeatany

coordinatorisvisibletoanyotherapplicationsconnectedtoanycoordinatorswithoutdelay.

Itbehavesjustlikesingledatabase.

Fromyourapplication,PostgresXCclusterwillbeseenasshowninFigure1.

Coordinatorisacomponentyourapplicationshouldconnectto.XChasseveralothercomponent

suchasdatanode,GTMandGTMproxy.Theywillbedescribedsomemoreindatailinthenext

section.

-1/56 -



Figure1.HowPostgresXCisseenfromyourapplication.

WhileconventionalPostgresSQLhotstandbyconfigurationwillbeseenasinFigure2.



Figure2.PostgreSQLHotStandby

-2/56 -

of 56

免费下载

关注