Does EJBCA Community version Support Single-Primary (Master-Replica) MySQL Cluster Configuration?

[Manju-212]

Hi all,

I'm currently deploying EJBCA with a MySQL cluster and I'm trying to use a single-primary (master-replica) configuration. My JDBC URL looks like this:

-e DATABASE_JDBC_URL="jdbc:mysql://IP1:3306,IP2:3306/ejbca?multi_host=true&characterEncoding=UTF-8&allowPublicKeyRetrieval=true"
However, this setup doesn't seem to work as expected during failover .

I wanted to ask:
Does EJBCA support single-primary MySQL cluster configurations, or is it designed to work only with multi-primary clusters like Galera?

Any insights or recommendations would be greatly appreciated.

Thanks!

[primetomas]

EJCBA isn't designed to work with any specific type of database and you can use many different architectures. Simply, EJBCA uses a database, the database backend handles HA.
Your JDBC URL is consumed by WildFly, why provides EJBCA with a database connection pool. Or rather the JDBC driver that wildfly uses is of course a critical component in managing HA. The JDBC URL is not read by EJBCA itself.