cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Kinsella <...@stratosec.co>
Subject Re: what are folks using for replication?
Date Wed, 13 Mar 2013 15:55:02 GMT
Looks good, alas this particular use case needs MSSQL not MY :)

On Mar 12, 2013, at 7:21 PM, Jason Davis <scr512@gmail.com> wrote:

> Galera MySQL might be an option, depending on how fast the round trip is
> between the two sites.
> 
> I will confess that I am NOT a fan of Linux HA clustering. I would
> recommend doing replication at the MySQL layer. Linux HA clustering is
> complex and fragile... Our big LMS at the university runs on such a cluster
> (RHEL cluster + DRBD) and its more trouble than its worth. I am working to
> hopefully move this to Galera. In our testing it has been way easier and
> more resistant to fault.
> On Mar 12, 2013 9:00 PM, "Mathias Mullins" <mathias.mullins@citrix.com>
> wrote:
> 
>> Hi John,
>> 
>> So in a lot of the installations that we have worked with, we are seeing a
>> lot of work with DRBD (Active/Standby, Active/Active w/Pacemaker). So far
>> it's been one of the better solutions that we have seen installations
>> stable with. I think a lot of people would like to see this functionality
>> written into ACS to support something in addition to MySQL Master/Slave
>> replication.
>> 
>> Personally I like the DRBD solution because it deals with the replication
>> at a block level and gives us the flexibility of active/passive and
>> active/active ability versus having to do a lot of manual work to revert
>> the master/slave relationship.
>> 
>> Thanks,
>> Matt
>> 
>> 
>> On 3/12/13 9:32 PM, "John Kinsella" <jlk@stratosec.co> wrote:
>> 
>>> Thought I'd throw this question out on the list - we're working on
>>> geographically (1500 miles) replicated databases for customers who really
>>> don't want their stuff to go down.
>>> 
>>> In this particular case, how they've architected their DB schemas means
>>> they're really not friendly to the standard transactional replication
>>> (this is MSSQL server) so we're looking at replicating the whole block
>>> device the db is stored on.
>>> 
>>> We've tried usingÅ 
>>> * Ceph -  know it's not meant for geo-repÅ loving it locally, though!
>>> * Gluster - When clustering across the WAN, performance was weak. Don't
>>> have enough disks/nodes to create a gluster cluster to replicate with
>>> gluster-geo-replicate
>>> * drbd in active/standby - Fairly decent performance. I hear it'd be
>>> better with the drbd-proxy, but don't feel like spending the $$ yet. I've
>>> been previously shot in the foot enough times with drbd active/active
>>> that I won't try that again.
>>> 
>>> Currently using drbd (I'm pondering writing management of the
>>> primary/secondary stuff into ACS) but curious if others have found ways
>>> of doing this with ACS that they like?
>>> 
>>> John
>>> 
>>> Stratosec - Secure Infrastructure as a Service
>>> o: 415.315.9385
>>> @johnlkinsella
>>> 
>> 
>> 

Stratosec - Secure Infrastructure as a Service
o: 415.315.9385
@johnlkinsella


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message