Can we use the same database instance for cluster setup?

Overview: This article describes why cluster setup requires separate databases for primary and secondary nodes, as using a single instance causes conflicts like "Database already exists" errors.

No, we cannot. We must use 2 dedicated databases for both primary and secondary nodes.

This would be the error received if a single database or mysql instance is used to set up cluster nodes.

Error: Database already exists: ezlogin_cmmtnn. You may want to update the primary first.

Related Articles:

Database connectivity credentials and configuration file.

Retrieve db credentials