users@cloudstack.apache.org
Subject: RE: Multi-master MySQL Setup
Hi All,
Just for your info, I have implemented MariaDB with Galera Clustering.
We are using CS 4.2 on 4 management servers with 7 MariaDB servers.
All management servers loaded with HA-Proxy to connect to MariaDB servers.
It's been running s
ssage-
From: Patrick Miller [mailto:patrick.mil...@sungard.com]
Sent: Wednesday, November 06, 2013 4:51 AM
To: users@cloudstack.apache.org
Subject: Re: Multi-master MySQL Setup
Take a look at the percona [1] implementation of mysql and there clustered
version.
Round robin reads and writes supporte
hether to
> > go
> > > > for replicating between two hosts using DRBD vs native MySQL
> > replication?
> > > > I get the impression that MySQL replication is an eventually-consistent
> > > > near-realtime kind of replication whereas DRBD can be set to be
>
cation just seems a lot less fiddly
> > > than using DRBD and DRBD would replicate file corruption that MySQL
> > > replication would be largely safe from.
> > >
> > > -Original Message-
> > > From: Patrick Miller [mailto:patrick.mil...@sungard.com
> > > now (still setting up) that I might appreciate later.
> > >
> > > Based on both your responses, I think I'll just leave it well alone!
> > > Need to get to grips with pacemaker/corosync anyway for other reasons
> > > so I'll just try that with either DRBD replicat
hat with either DRBD replication or MySQL replication.
>
> Cheers,
>
> Adrian
>
> -Original Message-
> From: Marty Sweet [mailto:msweet@gmail.com]
> Sent: 05 November 2013 17:23
> To: users@cloudstack.apache.org
> Subject: Re: Multi-master MySQL Setup
>
> Oth
msweet@gmail.com]
> Sent: Tuesday, November 05, 2013 5:43 PM
> To: users@cloudstack.apache.org
> Subject: Re: Multi-master MySQL Setup
>
> The issue with plain MySQL replication (espically in master-master) is that a
> failed query will stop replication. A good example of this is when
o I'll just try that with either DRBD replication or MySQL replication.
> >
> > Cheers,
> >
> > Adrian
> >
> > -Original Message-
> > From: Marty Sweet [mailto:msweet@gmail.com ]
> > Sent: 05 November 2013 17:23
> > To: users@cloudst
[mailto:patrick.mil...@sungard.com]
Sent: 05 November 2013 21:51
To: users@cloudstack.apache.org
Subject: Re: Multi-master MySQL Setup
Take a look at the percona [1] implementation of mysql and there clustered
version.
Round robin reads and writes supported.
1] http://www.percona.com/
Patrick
On Tue, Nov 5
On 05.11.2013 21:50, Patrick Miller wrote:
Take a look at the percona [1] implementation of mysql and there
clustered
version.
Round robin reads and writes supported.
1] http://www.percona.com/
They are using Galera I mentioned previously. It works with MariaDB
(which includes it now) and My
; Sent: 05 November 2013 17:23
> To: users@cloudstack.apache.org
> Subject: Re: Multi-master MySQL Setup
>
> Others may have had more success with this but from experience of MySQL in
> multi-master setups I would avoid this entirely.
>
> A common setup is using DRDB to provide
]
Sent: 05 November 2013 17:23
To: users@cloudstack.apache.org
Subject: Re: Multi-master MySQL Setup
Others may have had more success with this but from experience of MySQL in
multi-master setups I would avoid this entirely.
A common setup is using DRDB to provide a master/slave:
Management 1 (MySQL
Others may have had more success with this but from experience of MySQL in
multi-master setups I would avoid this entirely.
A common setup is using DRDB to provide a master/slave:
Management 1 (MySQL Master) w/ virtual IP
Management 2 (MySQL Slave)
HA IP Address (for agents/services requiring DB
On 05.11.2013 17:13, Adrian Lewis wrote:
Hi All,
Just wondering if anyone is using a MySQL multi-master configuration
with
auto_increment_offset (e.g.10) and auto_increment_increment (1 for
server
1, 2 for server 2 etc)? Does it work? Does anyone know a reason why it
doesn’t or wouldn’t wor
14 matches
Mail list logo