Mailing List Archive


Back to the month index Back to the list index
Carlos M. Gutierrez (carlos@gutierrez.com)
Fri, 13 Sep 1996 23:07:43 -0400 (AST) 

Date: Fri, 13 Sep 1996 23:07:43 -0400 (AST)
From: "Carlos M. Gutierrez" <carlos@gutierrez.com>
Subject: Re: [mSQL] Mirroring msql databases
Message-Id: <Pine.BSI.3.91.960913230511.2543A-100000@gaia.gutierrez.com>

How about using 'rdist' to distribute the relevant database files across
mirror sites, or perhaps even use a passworded ftp account?

cheers,

Carlos "Yes, I survived Hortense!" Gutierrez
Puerto Rico Internet Corp.
carlos@ipr.net
http://www.ipr.net/~carlos/hortense

On Sat, 14 Sep 1996 Kenneth.Holmlund@tp.umu.se wrote:

> Hi,
> Anyone got any experience with mirroring
> an mSQL database to some other mSQL
> server (or a dozen of them) ?
> We do scripting in PHP and I attempted
> to write a script to do the mirroring,
> but unfortunately you cannot first connect
> to one site, select relevant data,
> connect to next db and insert the data -
> PHP thrashes all records when opening
> a new connection :(
>
> Anyway, whether we'll use PHP, perl or C I
> need help with the protocol.
> How can a mirror site keep track on:
> new records
> updated records
> deleted records
>
> Any assistance greatly appreciated!
> Kenneth
>
> --
> _____________________________________
> / Kenneth Holmlund \
> | Dept. Theoretical Physics |
> | Umee University |
> | S-901 87 Umee |
> | Sweden |
> | phone: +46-(0)90-167717 |
> | fax: +46-(0)90-169556 |
> | email: Kenneth.Holmlund@TP.UmU.SE |
> | web: http://www.tp.umu.se/~holmlund/ |
> \___________________________ _________/
> --------------------------------------------------------------------------
> To remove yourself from the Mini SQL mailing list send a message containing
> "unsubscribe" to > "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
> "info msql-list" to majordomo@bunyip.com for info on monthly archives of
> the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!
>
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!