MySQL Forums
Forum List  »  Utilities

Re: Fabric project status
Posted by: Nick Swenson
Date: November 23, 2016 12:20PM

Yes, I've had a lot of "fun" working around the HA aspect of fabric with Pacemaker and Corosync. It definitely could be a lot easier than it is - there are a ton of gotchas I had to work through. I see the appeal of multi-master.

https://dev.mysql.com/doc/mysql-utilities/1.5/en/fabric-pacemaker.html

The main database I was considering when I wrote my questions is part of a vendor application and, yes, it is read heavy. We have very little control over the database and have been discouraged from making changes in the past by being told they would no longer support us even if we just made some index changes. We can suggest those changes to them, but there is no guarantee they'll be implemented.

Unfortunately for horizontal scaling, 1) the application has not and will not be tested with (certified for use with) the fabric-aware connectors and 2) there is no option within the application to direct read/write traffic differently than read-only.

So, my only real option right now is to improve HA (failover right now is manual, with brief downtime). I've been testing mysql fabric with mysql router to allow for automated failover. It seems to work well, but I was concerned that fabric may no longer be supported and I'd have to rework my clusters as InnoDB Clusters in the relatively near future.

Options: ReplyQuote


Subject
Views
Written By
Posted
869
October 02, 2016 03:52AM
363
October 03, 2016 09:09AM
382
October 05, 2016 12:44PM
387
October 06, 2016 06:51PM
334
November 23, 2016 11:30AM
272
November 30, 2016 01:04PM
321
October 07, 2016 12:54PM
Re: Fabric project status
268
November 23, 2016 12:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.