CA API Gateway 9.1

9.4 9.1

Connect the Container Gateway to an Existing MySQL Database

This topic describes how to connect a Container Gateway to a configured gateway MySQL database. This procedure works for Gateway v9.0 and higher. If you're looking to deploy a 'database-less' or 'migration-less' ephemeral Gateway, please see Container Gateway in a CI/CD Pipeline.
gateway94
This topic describes how to connect a Container Gateway to a configured 
CA API Gateway
 MySQL database. This procedure works for Gateway v9.0 and higher. If you're looking to deploy a 'database-less' or 'migration-less' ephemeral Gateway, please see Container Gateway in a CI/CD Pipeline.
 Back up your database before making any changes.
To configure the connectivity, simply ensure that the 
SSG_CLUSTER_HOST
 and 
SSG_CLUSTER_PASSWORD
 values match those set in the configured MySQL database. 
After connecting to the existing Gateway database, the Container Gateway automatically upgrades the database if the database version is lower than the version of the Container Gateway.  
  • Ensure the 
    SSG_DATABASE_JDBC_URL
     environment variable is set.
  • If you encounter problems connecting to a remote MySQL database, check that the 
    SSG_DATABASE_USER
     and 
    SSG_DATABASE_PASSWORD
     have the right privileges to access/modify the MySQL database.
  • Do not attempt to connect to a MySQL database on a Gateway earlier than version 9.0.00, as the automated upgrade will not work.

Content feedback and comments