In a message dated 2/11/2004 2:26:09 PM Eastern Standard Time, [EMAIL PROTECTED] writes: I read this over and over.. I am curious why replication is such high finance?? I run it here. The Production system is a high finance machine and the replicated box is a old clunker basically.. It doesn't take much for the stuff to be replicated over.. The high dollar has queries, this and that. The replicated machine is just simply keeping up with the changes.. That's it.
You could do that with just about any decent machine.. I would think.. sure, there is going to be the few that load and change data constantly.. But I still think that would be ok.. (have to test it). Do you guys agree? Hmmm...not in all cases. While I'll agree that this would be a cost-effective method for many MySQL installations, I use MySQL for in a data warehousing environment which typically has few, but extremely large bulk updates. We are in the multi-TB range, so this would not work for us.