From: Mat Keep
Date: October 11 2012 2:24pm
Subject: Re: Best solution for a HA without shared storage
List-Archive: http://lists.mysql.com/replication/2391
Message-Id: <5076D68D.5000808@oracle.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi
this process of failure detection with slave promotion is now automated 
in MySQL 5.6 (release candidate) with the use of Global Transaction IDs 
and the HA utilities

This recent blog and video tutorial are good places to learn more:
http://www.clusterdb.com/mysql/replication-and-auto-failover-made-easy-with-mysql-utilities/ 


Video tutorial:
http://dev.mysql.com/tech-resources/articles/mysql-replication-utilities.html 


On 11/10/2012 15:17, Oriol Martí wrote:
> Hello,
>
> I've to make a HA mysql, for me the scalability it's not important 
> because it's not an environment with a lot of queries.
>
> I've thinked about, and I think that the best solution is to mount an 
> master-slave arquitecture, and if the master goes down, promote the 
> slave to master. Monitoring this case, after manually we can put the 
> master with slave status and recover the environment.
>
> What do you think that's the best tool to do this? Pacemaker or Red 
> Hat Cluster Suite? Does anybody knows some example of configurations?
>
> Thanks!
>

-- 
Regards

Mat Keep
MySQL Cluster & HA Programs
Oracle Corp.
+44 (0)7765 898-605