Hi guys, I'm about to figure out how setup a pacemaker cluster for MySQL
replication.
I'm super new about MySQL and also it's replication method but I'm very
experienced related postgres cluster using PAF.
Diggin the web I found out many different way to achieve.
I would like to know which is the m
On Tuesday 05 September 2023 at 22:20:36, Damiano Giuliani wrote:
> Hi guys, I'm about to figure out how setup a pacemaker cluster for MySQL
> replication.
Why do you need pacemaker?
Why not just set up several machines and configure Galera to handle DB
replication between them?
If you install
Thanks for helping.
Because I still don't know which version will be provided, probably MySQL
enterprise or community.
I was wondering about pacemaker because I know quite well how it works and
I need a vip/automatic failover
Galera seems a different approach that I have to study and test estens
On Wednesday 06 September 2023 at 11:23:54, Damiano Giuliani wrote:
> Thanks for helping.
>
> Because I still don't know which version will be provided, probably MySQL
> enterprise or community.
I believe both support Galera replication.
> I was wondering about pacemaker because I know quite we
Thanks for helping me.
I'm going to know more about Galera.
What I don't like is seems I need many nodes, at least 3 for the cluster
and then at least 2 other nodes for proxy.
Asking for 5 VM is quite consuming.
As you told drbd can work only in 2 node cluster and disk replication is
not dbms rep
On Wednesday 06 September 2023 at 12:10:23, Damiano Giuliani wrote:
> Thanks for helping me.
>
> I'm going to know more about Galera.
> What I don't like is seems I need many nodes, at least 3 for the cluster
> and then at least 2 other nodes for proxy.
You didn't mention anything about wanting
Unfortunately I move to a different company and they are stick to MySQL
For what I understand they have some mysql cluster without automatic
failover.
Probably also their customers have some kind of cluster without automatic
failover.
Looking at some Galera cluster designs on web seems a couple o
On Wednesday 06 September 2023 at 12:50:40, Damiano Giuliani wrote:
> Looking at some Galera cluster designs on web seems a couple of server
> proxy are placed in front.
You can certainly do it that way, although some people simply have a floating
virtual IP across the 3 nodes, and clients conne
Thanks for helping really appreciate.
What I miss is how my application can support the connection on a multi
master where 3 ips are available simultaneously.
JDBCmysql driver or similar support a list name/ip of clustered nodes?
Galera provide a unique cluster ip?
Whats the point to create anot
On Wednesday 06 September 2023 at 13:58:51, Damiano Giuliani wrote:
> What I miss is how my application can support the connection on a multi
> master where 3 ips are available simultaneously.
>
> JDBCmysql driver or similar support a list name/ip of clustered nodes?
> Galera provide a unique clu
Everything is clear now.
So the point is to use pacemaker and create the floating vip and bind it to
sqlproxy to health check and route the traffic to the available and healthy
galera nodes.
Am I right?
It could be useful let pacemaker manage also galera services?
Do you have any guide that pack
On Wednesday 06 September 2023 at 17:01:24, Damiano Giuliani wrote:
> Everything is clear now.
> So the point is to use pacemaker and create the floating vip and bind it to
> sqlproxy to health check and route the traffic to the available and healthy
> galera nodes.
Good summary.
> It could be u
Everything seems quite clear to me.
But, having single VIP makes a multimaster replica quite useless.
im thinking about using pacemaker to create a cloned VIP binded to a cloned
HA proxy which is health-checking the galera/mysql status to route the
traffic.
or more easily pacemaker with a singl
On Thursday 07 September 2023 at 22:06:25, Damiano Giuliani wrote:
> Everything seems quite clear to me.
>
> But, having single VIP makes a multimaster replica quite useless.
Why?
> im thinking about using pacemaker to create a cloned VIP binded to a cloned
> HA proxy which is health-checking t
Hello,
some years ago I wrote a wikki entry:
https://wiki.clusterlabs.org/wiki/DRBD_MySQL_HowTo
Maybe pacemaker is to complex and you should try heartbeat- drbd
Greets.
Stefan
Am 05.09.23 um 23:20 schrieb Damiano Giuliani:
Hi guys, I'm about to figure out how setup a pacemaker cluster
On Thu, 2023-09-07 at 10:27 +0100, Antony Stone wrote:
> On Wednesday 06 September 2023 at 17:01:24, Damiano Giuliani wrote:
>
> > Everything is clear now.
> > So the point is to use pacemaker and create the floating vip and
> > bind it to
> > sqlproxy to health check and route the traffic to the
thanks Ken,
could you point me in th right direction for a guide or some already
working configuration?
Thanks
Damiano
Il giorno lun 11 set 2023 alle ore 16:26 Ken Gaillot
ha scritto:
> On Thu, 2023-09-07 at 10:27 +0100, Antony Stone wrote:
> > On Wednesday 06 September 2023 at 17:01:24, Dami
On Tue, 2023-09-12 at 10:28 +0200, Damiano Giuliani wrote:
> thanks Ken,
>
> could you point me in th right direction for a guide or some already
> working configuration?
>
> Thanks
>
> Damiano
Nothing specific to galera, just the usual Pacemaker Explained
documentation about clones.
There are
i fired up a multimaster galera cluster.
i would now add it into pacemaker to let it mange and monitor the status.
reading the galera resource documentation seems is only support master
slave replica, is it true?
also mysql resource seems to support master slave replica and externally
managed repli
19 matches
Mail list logo