Configure Portal Database Clustering for API-Portal 4.2
book
Article ID: 92391
calendar_today
Updated On:
Products
CA API Developer PortalCA 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.