Thu May 31 06:02:53 PDT 2007
- Previous message: [Slony1-general] how can i clean sl_events?
- Next message: [Slony1-general] how can i clean sl_events?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On 5/31/2007 7:42 AM, open wrote: > thx for the answer. > > 1) the"engineer" fix it yesterday, but it was broken about 6 day. > 2) I have 5 slave, and I don't wont (and it's impossible) setup the > connect between all slaves, > i think that enough have a direct connect between master and each > slaves, and from each slave to master. That would only be true if all subscribers are direct subscribers that use the origin as data provider. The problem with this setup is that if you ever need to switchover or failover to one of the subscribers, you will have to abandon all others (of fix the network connectivity before doing so). > So now we have connect about a day, but number of event (sl_event) is > grow.... Check the output of the sl_status view over a couple of minutes. If the column st_last_event for any of your subscribers is not advancing, the event confirmations from that node still don't make it back to the origin and your engineer has more to fix. Jan > > > > > > Andrew Sullivan wrote: >> On Thu, May 31, 2007 at 09:33:48AM +0400, open wrote: >> >>> when i setup the replication (with the slon_tools) everything be OK, >>> but after then, the engineer of the our partner setup firerwall, and we >>> have connection only from slave to master, and no connection from master >>> to slave.... >>> >> >> Then it's broken. Tell the "engineer" to fix the network so that it >> works the way it needs to. It is well-documented that every active >> node in a Slony cluster must be able to talk to the other nodes. As >> far as Slony knows, the events haven't arrived on the replica. If >> you fix the firewall, the problem should go away on its own. >> >> A >> >> >> > > _______________________________________________ > Slony1-general mailing list > Slony1-general at lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck at Yahoo.com #
- Previous message: [Slony1-general] how can i clean sl_events?
- Next message: [Slony1-general] how can i clean sl_events?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list