List:General Discussion« Previous MessageNext Message »
From:Walter Heck Date:November 5 2010 12:18am
Subject:Re: Replication on MySQL databases
View as plain text  
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 <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.

-- 
Walter Heck
Engineer @ Open Query (http://openquery.com)
Exceptional services for MariaDB and MySQL at a fixed budget
Thread
Replication on MySQL databasesMachiel Richards4 Nov
  • Re: Replication on MySQL databasesJohan De Meersman4 Nov
    • Re: Replication on MySQL databasesMachiel Richards4 Nov
      • Re: Replication on MySQL databasesWalter Heck5 Nov