lio bod liobod.slony at gmail.com
Wed Feb 27 09:22:28 PST 2008
2008/2/27, Christopher Browne <cbbrowne at ca.afilias.info>:
>
> "lio bod" <liobod.slony at gmail.com> writes:
> > I got a metaphysical question.;-)
> >
> > In fact, it's more an internal architeture slony question :
> >
> >
> >
> > I replicate my first db following documenation ' 2. Replicating Your
> First Database' (http://slony.info/documentation/firstdb.html)
> >
> > This sample is not very precise on what command should be performed on
> master or slave host.
> >
> > I tried 'slon_start 2' on master host. I was quite sure it would failed.
> >
> > Nope. I'm surprised : my replication seems to be ok. Magic!
> >
> >
> >
> > What would be a good recommandation?
> >
> > Run 'slon_start 2' on master or on salve host?
>
> Well, I have two answers to that, and they may differ from what you expect
> :-).
>
> 1.  On our systems, at Afilias, we never run slon processes on
>    database servers.  We instead run all the slons centrally on an
>    application server.

2.  If the choice is between master and slave, I'd be somewhat
>    inclined to run both slons on the "master" server, as...
>
>    - Life tends to be simpler if they both run on one server, as
>      you can more readily manage processes on one host, and as
>      log files will naturally be on one server.


Agree. It's always obvious once it's written.

   - It is essential that a slon be kept running against the master
>      node, as if it is not, for a period of time, then when it
>      is restarted, that entire period of time will be treated as
>      One Big Long SYNC, and having such a huge SYNC is likely to
>      turn out badly :-(.


I don't catch the point
The big sync may also turn badly if the slon 2 start and restart after a
long time occures on the salve node.
?
Thx anyway

--
> (reverse (concatenate 'string "ofni.sesabatadxunil" "@" "enworbbc"))
> http://linuxdatabases.info/info/internet.html
> "... The book [CLtL1] is about  400 pages of 8.5" by 11" Dover output.
> Apparently  the publisher and  typesetter decided  that this  made the
> lines too wide for  easy reading, so they will use a  6" by 9" format.
> This  will make  the shape  of the  book approximately  cubical.  Now,
> there are  26 chapters counting the  index, and a Rubik's  cube has 26
> exterior cubies.  I'll let  you individually extrapolate and fantasize
> from there."  -- GLS
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080227/=
34b29985/attachment.htm


More information about the Slony1-general mailing list