Re: Replication for a large database

Here's something interesting: http://www.objectweb.org/c-jdbc/index.html

It's alpha quality, and it's not "true" replication, but it might be
interesting to keep an eye on.  I've only read about it, so I can't claim any
personal experience.  Sounds like a good solution for this situation, if it
works as advertised.

MT

--- Ryan <pgsql-sql@seahat.com> wrote:
> Ok, mabye this is just because I'm coming from a layman's perspective
> regarding enterprise level databases, but couldn't you fake replication
> by inserting the data into both databases?  (granted this involves
> having source access to the program doing the insertion.)
> 
> It may be a kludge, but it would work until something better came along.
> 
> Ryan
> 
> > Hello all,
> >
> > I apologize if this has already been covered in the past, but I
> > couldn't seem  to find an adequate solution to my problem in the
> > archives.
> >
> > I have a database that is used for a bandwidth tracking system at a
> > broadband  ISP.  To make a long story short, I'm inserting over
> > 800,000 records per day  into this database.  Suffice to say, the
> > uptime of this database is of  paramount importance, so I would like
> > to have a more up-to-date backup copy  of my database in the event of
> > a failure (more recent than my twice-per-day  db_dump backup).
> >
> > I have two servers, both Dual Xeon-2G with 4G of RAM, and would like
> > to replicate between the two.  I would like to have "live"
> > replication, but I  couldn't seem to find a solution for that for
> > PostgreSQL.  I tried RServ but,  after attempting it, I saw a mailing
> > list posting saying that it is  more-or-less useless for databases
> > that have a large number of inserts (like  mine).
> >
> > When I perform a replication after a batch of data is inserted, the
> > query runs  literally for hours before it returns.  I have never
> > actually been present  during the whole replication duration since it
> > takes longer than my 8-12 hour  days here at work.
> >
> > Is there any replication solution that would fit my needs?  I'm taking
> > advantage of some PG7.2 features so "downgrading" to the 6.x version
> > of postgres that has replication support isn't an option.
> >
> > Thanks.
> >
> > --man
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com