Poor performance in api portal/gateway 3.5

Products

• CA API Developer Portal
• CA API Gateway

Issue/Introduction

Under load testing api gateway fails with OutOfMemoryExecpetion when handling api portal requests.

Cause

Gettng list of the API's was a slow process, so to optimize a more direct JDBC connection to query the API's can be used in the API Gateway from API Portal 3.5 CR2 onwards. 
 

Environment

API Portal 3.5 CR2 + 
API Gateway 9.3 

Resolution

1. Login to your API Gateway via Policy Manager 

2. Create a JDBC connection with the following details: 

Connection Name: Local 
Driver Class: com.l7tech.jdbc.mysql.MySQLDriver 
JDBC URL: jdbc:mysql://<Primary DB Server Hostname-OR-IPaddy>,<Secondary DB Server Hostname-OR-IPaddy>:3306/ssg 
Username: gateway 
Password: <gateway user password set during initial setup> 

3. Click “Test” button to ensure your configuration is valid 

4. Open line 355 of the portalman policy (Perform JDBC Query Assertion) and set the drop down to: 
JDBC Connection = Local 

5. Save and Activate the policy. 

6. Go to "Manage Cluster-Wide Properties" and create a new cluster-wide property named: 
portal.useJDBCToQueryAPIs 
and set the value to: true 

***Note: make sure there isn't any white space in the cluster-wide property name or value*** 

7. Test the API Portal by going to Dashboard > APIs and ensure that you're getting a list of APIs returned. 

If it returns a list of APIs, you should be seeing a noticeable performance improvement when retrieving the list of APIs. Let me know if you have any questions.