Layer7 API Management

  • Private Community
Back to discussions
Expand all | Collapse all

Does CA API Gateway support other than MySQL as external DB?

  • 1.  Does CA API Gateway support other than MySQL as external DB?

    Posted Oct 24, 2018 10:41 AM

    We are upgrading CA API Gateway from version 9.2 to 9.3.  So far we have been using the embedded database. With this upgrade we are looking into moving to an external database.  I have been looking into the documentation for possible databases CA API Gateway supports.  So far what I have seen is only MySQL.  Does CA API Gateway support other databases?  More importantly does it support Oracle 11/12 databases as this would be our preferred DB?  I am asking about the database type of the Gateway and not about databases we can access using JDBC in policy assertions.



  • 2.  Re: Does CA API Gateway support other than MySQL as external DB?
    Best Answer

    Broadcom Employee
    Posted Oct 24, 2018 10:56 AM

    Hi Abraham,

     

    At this time we only support using MySQL for the Gateway database. It can be off-boxed, but must be MySQL.

     

    Regards,

    Joe



  • 3.  Re: Does CA API Gateway support other than MySQL as external DB?

    Posted Oct 25, 2018 06:28 AM

    Hi dasjo02,

     

    Does this also include MariaDB? Or will that not work either considering it is a forked version of MYSQL?

     

    Thanks,

    Jake



  • 4.  Re: Does CA API Gateway support other than MySQL as external DB?

    Broadcom Employee
    Posted Oct 25, 2018 03:42 PM

    Hi Jake,

     

    While I am not aware of any specific issues with MariaDB it is not officially supported for the Gateway database and has not been tested.

     

    Regards,

    Joe



  • 5.  Re: Does CA API Gateway support other than MySQL as external DB?

    Broadcom Employee
    Posted Oct 25, 2018 07:06 PM

    No, Jake,

    I would suggest you not to use MariaDB, we have some reports about the issues of using MariaDB.

     

    Regards,

    Mark



  • 6.  Re: Does CA API Gateway support other than MySQL as external DB?

    Posted Nov 05, 2018 10:46 AM

    Hi,

     

    Thank you for your recommendation. Have you had any issues with Galera clustering with MySQL? Is this supported by CA?

     

    Thanks,

    Jake



  • 7.  Re: Does CA API Gateway support other than MySQL as external DB?

    Broadcom Employee
    Posted Nov 05, 2018 04:49 PM

    No.

    We only support the mysql master-slave replication.

     

    (from my point of view, the gateway cluster only need an accessible mysql database, if you have DBA to take full responsibility of the database, if you don't use gateway failover feature, it should be fine for you to do anything to ensure the database availability. Particularly for software gateway)

     

    Regards,

    Mark



  • 8.  Re: Does CA API Gateway support other than MySQL as external DB?

    Posted Nov 23, 2018 05:04 AM

    Hi,

     

    We are using the api software gateway and not the api appliance gateway and looking at the database replication guide it is only applicable for the appliance gateway.

     

    Does this mean that for the software gateway we would use a single instance of MySQL? and for backups use something like mysqldump?

     

    Regards,

    Jon



  • 9.  Re: Does CA API Gateway support other than MySQL as external DB?

    Broadcom Employee
    Posted Nov 25, 2018 05:49 PM

    Dear Jon,

    For software gateway, you will take full control of the database. 

    In another word, your database is not in the scope of gateway support, but you can go to mysql support.

    (we expect you have a mysql DBA)

    And still, you can follow the the mysql document, MySQL :: MySQL 5.5 Reference Manual :: 17 Replication , to setup replication.

     

    Regards,

    Mark



  • 10.  Re: Does CA API Gateway support other than MySQL as external DB?

    Posted Nov 29, 2018 11:33 PM

    Hi Mark,

    There're 4 editions of MySQL.

    Which edition, version should I choose as a gateway external database?

     

    Regards,



  • 11.  Re: Does CA API Gateway support other than MySQL as external DB?

    Broadcom Employee
    Posted Dec 02, 2018 04:56 PM

    Dear Gary,

    It depends on the gateway version, for gw9.3, it's MySQL Enterprise Edition 5.7

    Requirements and Compatibility - CA API Gateway - 9.3 - CA Technologies Documentation 

     

    Regards,

    Mark



  • 12.  Re: Does CA API Gateway support other than MySQL as external DB?

    Posted Dec 02, 2018 05:28 PM

    Hi Gary,

     

    As Mark mentioned, besides the MySQL version which should match the Gateway version, we support the Enterprise and the Community editions.

     

    Hope this helps,

     

    Regards,

     

    Amit.

     

     



  • 13.  Re: Does CA API Gateway support other than MySQL as external DB?

    Posted Dec 02, 2018 10:08 PM

    Hi,

    Thank you, Mark and Amit.

    My client provides Oracle DB and MS SQL DB for CA APIM project but we can only support MySQL 

    If community edition is supported, it's a good choice because the client doesn't want to pay any additional fee for DB.

     

    Regards,