Re: [PERFORM] Master/Slave, DB separation or just spend $$$?

2009-07-22 Thread Kelvin Quee
will go look at Slony now. Scott, one question though - If my master is constantly changing, wouldn't the updates from the master to the slave also slow down the slave? Kelvin Quee +65 9177 3635 On Wed, Jul 22, 2009 at 1:42 PM, Scott Marlowe wrote: > On Tue, Jul 21, 2009 at 9:47 PM

[PERFORM] Master/Slave, DB separation or just spend $$$?

2009-07-21 Thread Kelvin Quee
x27;s performance. Anyone with more experience here? (3) seems ideal but is a very very painful solution! We can possibly use a message queue system but again I am not familiar with MQ. Will need to do more research. If you were me, how would you solve this problem? Thanks! Kelvin Quee +65 9177