Sorry,
I should mention that this is Postgres 8.2.4, and Slony 1.2.14
Martin Eriksson wrote:
Hi everyone.
I've been using slonly for a while now and feel pretty confident with
what im doing but I can not understand what is going now!
current setup:
1 Master
2 slave1 (provider = 1)
3 slave2 (provider = 1)
adding a new node 4 (provider = 1)
machines on same hardware, all machines are pretty nice machines, 8
gigs of ram in each machine
master got 6 gigs allocated to postgres, slave machines got 3.2 gigs
allocated. all running ubuntu 64 bit
database is a total of 7.9 gigs (including the slony schema, total
data that need to be replicated around 3.5 gigs)
master and slave 1 are sitting next to each other connected with a 1
GB/s line on a separate interface.
now node 4, I created a new postgres installation on slave 1 machine,
running on different port same memory allocation (3.2 gigs) so total
usage of memory on that machine by the two postgres servers is 6.4 gig
(still 1.4 gig free)
On saturday I did sync up node 2 from scratch and it toke a total of
20 minutes.
Sunday afternoon database was put in production and being used, its
not a overly used database around 18000, slony event per 24h with a
total of 2000-3000 db commits on Master per 24h
So yesterday morning I started to sync node 4, and now 22h later it is
still running!!! and its only 1/3rd done!!!
does anyone got a good explination for this?
I look on the slave 2 machine, 0.2-0.4 load, memory is available, only
using a fraction of the bandwidth, io-stats are down. It is more or
less the same for the Master as low cpu load and low io load, and low
bandwidth usage.
looking on the db, it appear that its trying to do EVERYTHING in a
single transaction as tables that have been copied are still showing
up as count(*) = 0, is there a way to not do everything in a single
transaction??
or anyone got some other idea??
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
