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 :)
On Thu, Nov 4, 2010 at 17:26, Machiel Richards <machielr@stripped> 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.
Engineer @ Open Query (http://openquery.com)
Exceptional services for MariaDB and MySQL at a fixed budget