Skip to content
CA API Developer Portal 3.5
Documentation powered by DocOps

Configure Portal Database Clustering

Last update January 31, 2018

If you have a MySQL Cluster, then you can setup the lrs and lrsdata databases for the API Portal on the cluster. Clustering improves database performance and redundancy. There are four main steps to do this:

  • Step 1: Create the API Portal databases on the MySQL Cluster.
  • Step 2: Direct the API Portal to the cluster databases.
  • Step 3: Direct the API Portal Metrics Sync Utility to the cluster databases.
  • Step 4: Migrate the API Portal data to the Cluster.

Prerequisites:

  • A MySQL Cluster
  • Installed CA API Developer Portal v3.0 (or later) with an integrated CA API Gateway.
  • The Gateway Plugin passwords (see Configure the Gateway Plugin)
  • An up-to-date snapshot of your API Portal
  • Access to the following files in /opt/Deployments/lrs/tools/layer7-ndb-support:
    setup_ndb.sh
    lrs_db.sql
    lrsdata_db.sql
    lrsdata-pregoid_db.sql
    lrsdata_views_db.sql
    lrsdata-pregoid_views_db.sql
    replication.sql
Was this helpful?

Please log in to post comments.

  1. RYOJI KADOTA
    2016-08-30 08:03

    There is no description of the supported version of MySQL(MySQL Cluster). Add information of the supported version of MySQL(MySQL Cluster).

    1. Satyavati Telu
      2016-09-07 04:04

      Thank you for your feedback. We will update the documentation.

  2. RYOJI KADOTA
    2016-10-04 11:51

    About "A Gateway and API Portal v3.0" of Prerequisites:
    The above means the API Portal environment that installation is completed. (Portal and Gateway are Integration .) But, the meaning is hard to understand.

    So, please change as the following. "Installed API Portal v3.0(or later) with Integrated API Gateway"

    1. Satyavati Telu
      2016-10-06 03:04

      Thanks for the feedback. We will revise the content.

  3. Provida Burusu
    2017-02-24 05:00

    There is a typo in 'lrs_db.sq' file name and the location of these scripts are not specified here.

    1. Provida Burusu
      2017-02-24 05:01

      Please provide path for these scripts here.

      1. Andrea Tejokusumo
        2018-02-01 12:11

        Hi Provida, thank you and apologies for the delay in responding. We have updated the documentation and included the location of the scripts.