<div dir="auto">Thanks for helping me.<div dir="auto"><br></div><div dir="auto">I'm going to know more about Galera.</div><div dir="auto">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.</div><div dir="auto">Asking for 5 VM is quite consuming.</div><div dir="auto"><br></div><div dir="auto">As you told drbd can work only in 2 node cluster and disk replication is not dbms replication.</div><div dir="auto">Probably I'm going to try drbd on very small and low usage db.</div><div dir="auto"><br></div><div dir="auto">Thanks for sharing the doc.</div><div dir="auto"><br></div><div dir="auto">More I know about MySQL more postgresql seems have better replication at least for me.</div><br><br><div class="gmail_quote" dir="auto"><div dir="ltr" class="gmail_attr">On Wed, Sep 6, 2023, 12:40 PM Antony Stone <<a href="mailto:Antony.Stone@ha.open.source.it">Antony.Stone@ha.open.source.it</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On Wednesday 06 September 2023 at 11:23:54, Damiano Giuliani wrote:<br>
<br>
> Thanks for helping.<br>
> <br>
> Because I still don't know which version will be provided, probably MySQL<br>
> enterprise or community.<br>
<br>
I believe both support Galera replication.<br>
<br>
> I was wondering about pacemaker because I know quite well how it works and<br>
> I need a vip/automatic failover<br>
<br>
I regard a VIP as being entirely independent of replicating database content.<br>
<br>
> Galera seems a different approach that I have to study and test estensively<br>
> before place in production, instead pacemaker is a well know solution to<br>
> me.<br>
<br>
Yes, but if you are trying to replicate database content, how does pacemaker <br>
help with this? Pacemaker can quite happily provide you with a floating <br>
virtual IP address which is guarenteed to be on one of your database servers, <br>
but it doesn't (as far as I know) have any mechanism for replicating the <br>
database content between those servers.<br>
<br>
> Is drbd approach obsolete or solid?<br>
<br>
I would say that DRBD is a solid solution provided you only have two nodes and <br>
they have very good connectivity between them.<br>
<br>
However, replicating the data at disk level is a very different matter from <br>
having a DBMS such as MySQL understanding what is on the disk (and for that <br>
matter, what it has cached in RAM).<br>
<br>
> About the degraded status I read on web there is a specific configuration?<br>
<br>
I cannot comment on that; maybe someone else can.<br>
<br>
> There is also a good Galera documentation to study?<br>
<br>
I used <a href="https://mariadb.com/kb/en/getting-started-with-mariadb-galera-cluster" rel="noreferrer noreferrer" target="_blank">https://mariadb.com/kb/en/getting-started-with-mariadb-galera-cluster</a><br>
<br>
<br>
Antony.<br>
<br>
-- <br>
"In fact I wanted to be John Cleese and it took me some time to realise that <br>
the job was already taken."<br>
<br>
- Douglas Adams<br>
<br>
Please reply to the list;<br>
please *don't* CC me.<br>
_______________________________________________<br>
Manage your subscription:<br>
<a href="https://lists.clusterlabs.org/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">https://lists.clusterlabs.org/mailman/listinfo/users</a><br>
<br>
ClusterLabs home: <a href="https://www.clusterlabs.org/" rel="noreferrer noreferrer" target="_blank">https://www.clusterlabs.org/</a><br>
</blockquote></div></div>