Mysql Clustering Vs Scalr

Dear all,

I researched on a link that describes that Mysql to use with scalr for
fault-tolerance and high availability.

http://scottmartin.net/2009/07/11/creating-a-virtual-datacen ter-with-scalr-and-amazon-web-services/

Is it mandatory to use Scalr in our Mysql Production Servers.

What are the limitations that we faced if we don't use Scalr for
auto-scaling . I think mysql -Clustering Provides HA Cluster and is
sufficient to handle PB's of storage.

Steps that I folow:

1. We use Mysql Replication for having day to day backups of our
Production Database Servers despite it doesn't provide HA and fault
tolerance behaviour i.e if Master fails , it takes time to switch to
Replicated Node and act as Master.

2. Mysql Clustering handled this limitation well.

But I need points to understand for Scalr usage and if it is not
worthful, points to reject it.


Thanks & best regards,
Adarsh Sharma



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Mysql Clustering Vs Scalr

--bcaec51d224e5bd75a049f10a695
Content-Type: text/plain; charset=UTF-8

Take a look at mmm for mysql. Easy and robust.

sent from my mobile phone
On Mar 22, 2011 12:07 PM, "Adarsh Sharma" wrote:
> Dear all,
>
> I researched on a link that describes that Mysql to use with scalr for
> fault-tolerance and high availability.
>
>
http://scottmartin.net/2009/07/11/creating-a-virtual-datacen ter-with-scalr-and-amazon-web-services/
>
> Is it mandatory to use Scalr in our Mysql Production Servers.
>
> What are the limitations that we faced if we don't use Scalr for
> auto-scaling . I think mysql -Clustering Provides HA Cluster and is
> sufficient to handle PB's of storage.
>
> Steps that I folow:
>
> 1. We use Mysql Replication for having day to day backups of our
> Production Database Servers despite it doesn't provide HA and fault
> tolerance behaviour i.e if Master fails , it takes time to switch to
> Replicated Node and act as Master.
>
> 2. Mysql Clustering handled this limitation well.
>
> But I need points to understand for Scalr usage and if it is not
> worthful, points to reject it.
>
>
> Thanks & best regards,
> Adarsh Sharma
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@olindata.com
>

--bcaec51d224e5bd75a049f10a695--