Classic scenario where MMM will be your best bet. Check out http://mysql-mmm.org for more information. Setup two masters and 2 or more slaves for full High Availability. It scales extremely well if your application is read-heavy (which most applications are).
If you need help implementing this, I work for OpenQuery and we do this kind of setup almost on a weekly basis. Check out the website in the signature and let me/us know if you need our professional help. Otherwise: feel free to ask questions here :) kind regards, On Thu, Nov 4, 2010 at 17:26, Machiel Richards <machi...@rdc.co.za> wrote: > Thank you for the quick response.... > > just to answer one of the things here, the load is mostly reads as > writes only happen in batches every so often. > > When I am saying reads I am talking of up to 2000-5000 concurrently at > any given time during high load. -- Walter Heck Engineer @ Open Query (http://openquery.com) Exceptional services for MariaDB and MySQL at a fixed budget -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org