There is no clustering in MySQL. Replication features allow something similar.
In my opinion, the reason I prefer MySQL is the fact that the basics are there to do what ever you need to. You are responsible for making the solution, not the vendor. Multiple MySQL slave servers, and multiple webservers with heartbeat or something similar to spread the web load, and some nifty programming can usually solve high load problems with MySQL. The lack of all the "advanced features" in MySQL is what makes it a joy to work with. (you get to be creative:) plus.... the people hear on the lists are really good at helping in those "clustering" situations, when you get specific. As for people with wxperience in this, I do high load stuff alot, you just have to read the manual thouroghly and try out different techniques. I hope this helps at least somewhat. brian -----Original Message----- From: Dietrich Speer [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 07, 2002 6:20 PM To: [EMAIL PROTECTED] Subject: E-Commerce, db-clustering and MySQL? Hello: We are running a large e-commerce site currently with ASP/MSSQL. The ever increasing number of hits, complexity of the site and request for reporting is slowly but surely bringing us to the point were the current database application is getting tired. Now we're thinking Linux, MySQL and clustering. I have been looking around a little and don't like the fact that there are no stored procedures and no triggers. However - if we cluster several quad processor machines we should be fine without. Right now it's all theory, and there don't seem to be a lot of articles on the web about this. At least I had no luck finding any. Does anybody have real life experiences with this kind of a setup? Does anybody know where to find reports about this? I'd be greatful for any link or hint! Dietrich Speer --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
