On Thu, Oct 30, 2003 at 03:35:51PM -0500, [EMAIL PROTECTED] wrote: > Hi everyone. > > I've got a web app that I'm getting ready to make public and I'm to > figure out how well MySQL will utilize multiple processors. Has > anyone seen how MySQL would scale from 1 to 8 processors? Is it > even remotely close to linear?
Evidence I've heard is that things start to fall off quite a bit after 4 CPUs. > My reasoning is this: > 1) if it scales somewhat linearly, I could start with a 2-CPU box and > upgrade to an IBM440 8-CPU box or similar later when the site membership > <prayer> really takes off </prayer>. What makes you think your application will be CPU-bound at all? > 2) Otherwise, spray queries over a cluster of 2-CPU boxes. Does this make > sense?? You'll find that it's *much* less expensive, I think. > If I go with option 2, and have one master (for inserts/updates/deletes) > rep to a cluster of slaves(optimized for reads only), how often will the > master rep to the slaves? Is it near real-time? I couldn't find where you > specify the rep interval. It's done real-time in a an asynchronous fashion. > Does that setup make sense for an app that does more reads than writes?? Yes. > I've searched this forum and the web, but couldn't find much info. > Sorry if I missed anything obvious. Really? What did you search for? "mysql replication" should have turned up a number of relevant documents. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 49 days, processed 1,858,412,190 queries (432/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
