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.
At this time we only support using MySQL for the Gateway database. It can be off-boxed, but must be MySQL.
Does this also include MariaDB? Or will that not work either considering it is a forked version of MYSQL?
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.
I would suggest you not to use MariaDB, we have some reports about the issues of using MariaDB.
Thank you for your recommendation. Have you had any issues with Galera clustering with MySQL? Is this supported by CA?
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)
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?
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.
There're 4 editions of MySQL.
Which edition, version should I choose as a gateway external database?
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
As Mark mentioned, besides the MySQL version which should match the Gateway version, we support the Enterprise and the Community editions.
Hope this helps,
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.