CA API Gateway 9.1

9.4 9.1

Using the Gateway Embedded Database

When creating a new gateway database, you have the option of configuring a connection to a MySQL database or using the built-in embedded (non-MySQL) database on the Gateway.
gateway
When creating a new
CA API Gateway
 database, you have the option of configuring a connection to a MySQL database or using the built-in embedded (non-MySQL) database on the Gateway.
The embedded database is designed for environments where it is not possible to have a separate MySQL instance. For example, your security policy may forbid operating MySQL or any other network-accessible SQL database, even on
localhost
.
The embedded database is also ideal for testing or evaluating the Gateway, as it can be set up quickly, without relying on an external database.
Note the following limitations when an embedded database is in effect:
Changing to a MySQL Database
It is possible to change to a MySQL database after an embedded database is place. For example, you want to switch to avoid the limitations  of the embedded database.
The steps to switch differ depending on whether you are using an Appliance or Software Gateway.
Appliance Gateways
To change an embedded database to a MySQL database on an appliance Gateway:
  1. Use the migrateOut command in the Gateway Migration Utility to migrate the data out.
  2. Stop the Gateway.
  3. Access the Gateway main menu.
  4. Remove the existing node:
    1. Select option
      2
       (Display CA API Gateway configuration menu).
    2. Select option
      5
       (Delete the CA API Gateway) and respond to the prompts as follows:
      • Delete node:
        yes
      • Delete database:
        no
  5. Create the new MySQL database:
    • Select option
      2
       (Create a new CA API Gateway database).
      • Database connection:
        yes
  6. Start the Gateway.
  7. Install the license for the Gateway.
  9. Use the migrateIn command to migrate the data back in.
  10. Review the list of migration limitations to see if any apply to you. If so, make the appropriate corrections.
For detailed information about migration, see Gateway Migration.
Software Gateways
To change an embedded database to a MySQL database on a Software Gateway:
  1. Use the migrateOut command in the Gateway Migration Utility to migrate the data out.
  2. Stop the Gateway.
  3. Open a privileged shell and delete the following file:
    /opt/SecureSpan/Gateway/node/default/etc/conf/node.properties
  5. Select option
    2
     (Configure the CA API Gateway). Follow the steps in the configurator. Make sure you choose to configure a MySQL database.
  6. Start the Gateway.
  7. Install the license for the Gateway.
  9. Use the migrateIn command to migrate the data back in.
  10. Review the list of migration limitations to see if any apply to you. If so, make the appropriate corrections.
For detailed information about migration, see Gateway Migration.
 
 

Content feedback and comments