question Re: Cloudera Manager Installation using a clustered external MySQL database in Archives of Support Questions (Read Only)

Cloudera Manager Installation using a clustered external MySQL database

Anudas — Fri, 16 Sep 2022 13:27:20 GMT

Hi,

I have a plan to use the exisitng mysql galera cluster as an external database for the cloudera manager installation. I was going through the cloudera documentation and some where it states "Cloudera Manager installation fails if GTID-based replication is enabled in MySQL"

So wanted to know if it will install and work properly using a Galera/mysql cluster. Can some one please clarify this ? Also is there any script or steps I need to follow if I am going to use the above said mysql galera cluster managed by our DBAs (Database Administrators) ?

Re: Cloudera Manager Installation using a clustered external MySQL database

bgooley — Thu, 12 Jul 2018 16:26:09 GMT

@Anudas,

Thank you for asking.

At this time we do not support it and recommend against using Galera.

This is mainly due to the way Galera implements optimimstic locking. At the least, we have noted problems where the following error occurs "Deadlock found when trying to get lock; try restarting transaction".

We are also concerned that a simple retry could introduce the possibility of out-of-order events.

Bottom line is that we would need to code and test extensively to certify Galera. That may happen in the future, but, for now, I'd say avoid it as we know there are locking problems.

Regards,

Ben

Re: Cloudera Manager Installation using a clustered external MySQL database

Anudas — Fri, 13 Jul 2018 06:42:42 GMT

@bgooley

Thank you so much for the prompt reply Ben ! I really appreciate that.