Configure Portal Database Clustering for API-Portal 4.2
search cancel

Configure Portal Database Clustering for API-Portal 4.2

book

Article ID: 92391

calendar_today

Updated On:

Products

CA API Developer Portal CA API Gateway

Issue/Introduction



Does API Portal 4.2 support Database Clustering? 
For example, 
API Portal 3.5 supports MySQL Cluster. 
Is the same configuration supported by API Portal 4.2? 
If so, which MySQL Cluster version is supported? 
And  please let me know that detailed configure method.

Also, does API Portal 4.2 support clustered PostgreSQL Database? 
If so,  please let me know that detailed configure method.

Environment

CA API Developer Portal - 4.2

Resolution

From the perspective of the Application, it does not matter whether or not there is a single MySQL database machine or a cluster, the configuration is exactly the same.

If the customer wants to configure a cluster, it is up to them to have sufficiently knowledgeable database administrators who are capable of configuring such a cluster.

CA support cannot provide any advice for 3rd party products like MySQL.

The internally provided postgresql database is not clustered.

Additional Information

API Portal doesn't support "Replication with Global Transaction Identifiers"(GTID) of MySQL.