From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
Cc: | ssinger(at)navtechinc(dot)com, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Conditional row grained replication with DBMirror |
Date: | 2003-08-11 03:00:01 |
Message-ID: | 200308110300.h7B301L04944@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Sure, send the patches to the patches list and we will get them applied.
I am not sure if I can get them into 7.4. It depends if the dbmirror
author can review them.
---------------------------------------------------------------------------
Achilleus Mantzios wrote:
>
>
> I made a modification on DBMirror.pl,
> an addition in the slavedatabase.conf file,
> and added another replication table "specialtables".
>
> The goal was to have a way of controlling
> when a row of table (if the table is present in specialtables),
> will be mirrored to the remote slave.
>
> Lets assume, we have a bank's central IT DEPT master DB
> and some branches abroad.
>
> Rows in some tables (e.g. personel, branches, statistics on transactions,
> etc...)
> have no reason to be replicated to all sites, but only
> those sites that these rows refer to:
>
> E.G.
> we have
> test=# \d personel
> Table "public.personel"
> Column | Type | Modifiers
> ---------------+------------------------+-----------
> id | integer | not null
> name | character varying(20) |
> branchid | integer |
> test=#
>
> or
> test=# \d branch
> Table "public.personel"
> Column | Type | Modifiers
> ---------------+------------------------+-----------
> id | integer | not null
> country | character varying(20) |
> address | text |
> test=#
>
> And we require that insert, updates on table branch with id = 1
> go only to remote site (the ip of) branch 1,
> and that inserts,updates on personel with branchid = 2,
> in the same fashion, go only to (the ip of) branch 2.
>
> I retain the table specialtables
> test=# \d specialtables
> Table "public.specialtables"
> Column | Type | Modifiers
> ---------------+------------------------+-----------
> tblname | character varying(100) | not null
> siteidkeyname | character varying(20) |
> Indexes: specialtables_pkey primary key btree (tblname)
>
> test=#
>
> in which for each conditional table, the corresponding
> column name (the value of siteidkeyname) is given
> which indicates against which column in the PendingData.Data
> column is to be examined for equality against the site id.
>
> The site id for each slave is defined in an additional field
> in slaveInfo struct in slavedatabase.conf.
>
> Please tell me if i should send the patches
> to DBMirror.pl, MirrorSetup.sql, and slavedatabase.conf.
>
> --
> ==================================================================
> Achilleus Mantzios
> S/W Engineer
> IT dept
> Dynacom Tankers Mngmt
> Nikis 4, Glyfada
> Athens 16610
> Greece
> tel: +30-210-8981112
> fax: +30-210-8981877
> email: achill at matrix dot gatewaynet dot com
> mantzios at softlab dot ece dot ntua dot gr
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-08-11 03:00:56 | Re: readline missing on linux |
Previous Message | Bruce Momjian | 2003-08-11 02:57:46 | Re: readline missing on linux |
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Litvinov | 2003-08-11 03:35:09 | Re: PostgreSQL |
Previous Message | Paul Schmidt | 2003-08-11 02:42:11 | Re: OT: Address Fields |