Layer7 API Management

Hi,

We have a clustered environment of API Gtaeway v8.3 with MySQL DB in local host (2 gateway appliance in cluster with a primary and secondary DB node) for our Prod and Pre-Prod environment and we have a standalone gateway wth MySQL DB for our non prod environment.

I need to install the OTK 3.0 and MAG 2.3 in our gateways. We don't have seperate "internal-DMZ" configuration in our gateways. All our gateways are in DMZ. Hence we need only 1 MAG per environment/cluster.

For the standalone gateway I have installed the OTK 3.0 and created a otk_db in the inbuilt MySQL DB in local host. I have installed the MAG 2.3 as well. When I have to proceed with OTK and MAG installation in our Clustered environment, I have a doubt on how to do the installation.

1) Once I install the OTK 3.0 in a cluster and create a otk_db, will this otk_db be created in my secondary database node as well?

2) Can I give the "MySQL Database Server Host" as "localhost"?

3) Do I need to install the PRM file of the MAG installer in both the nodes in my cluster or should I install it only in my primary node?

4) Do I need to run the DB scripts for MAG schema in both primary and secondary MySQL database nodes or just in primary database node?

5) Any other advise on how to install a single MAG in a clustered environment (2 gateways) will be much appreciated (Other than the standard procedures to install it in a standalone gateway).

Thank You!

Hi

Answer to your questions:

1)      Well the connection to the db is connected from both nodes in the cluster.  But there is only one otk db that gets created.  In a cluster scenario and when in a production environment we state that you should be setting up a database externally for maintaining the access tokens.

2)      As stated above, when in a production environment, the otk db should be off box as the gateway db and otk db will fight for resources in order to function properly.  This could cause slowness or responsiveness to actual requests going through the gateway.

3)      For the MAG install, yes you need to install the rpm on both nodes

4)      No you don’t need to run these scripts for both nodes.  It will already have been done on the primary, if the setup is correct and your pointing to a database.

5)      The OTK database gets set up first (on a database external to the gateway) and then install the RPM on both nodes.  Then run the scripts.

How have you set up the cluster?

Thanks,

Derek Orr

CA Technologies |885 West Georgia Street Ste 500 | Vancouver, BC V6C 3G1

Office: 1-778-328-5285 | Mobile: +1 778 980 0029 | Derek.Orr@ca.com

<mailto:>[CA]

<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[Google]<https://plus.google.com/CATechnologies>[Slideshare]<http://www.slideshare.net/cainc>

Hi,

My cluster setup is basic with 2 gateway nodes (Primary and secondary database nodes). The SSG DB is hosted in the internal MySQL. So, I hope I need to find an oracle or MySQL database server external to the gateway so that I can install the OTK DB instance there.

Thanks for the info

Hello,

So to answer your questions:

1) Yes it should. You can test this by creating a database in the primary and checking whether it has replicated to the secondary.

2) Yes you can, if you are using the localhost db. Furthermore I would suggest that you also use the JDBC failover URL for the datasource. You can find more info here: MySQL :: MySQL Connector/J Developer Guide :: 5.1 Driver/Datasource Class Names, URL Syntax and Configuration Properti…

3) The rpm should be installed in both nodes. Otherwise the secondary processing node will not be able to find some basic assertions that are installed by the rpm.

4) If replication is active between the two nodes then you should not need to run the scripts on the secondary. Replication should propagate those changes to the secondary node.

5) DO NOT use the same mysql servers, that you use to host the ssg database (the database that stores the gateway policies and configuration), in order to store the OTK and MAG databases. The OTK and MAG produce a lot of traffic to the MySQL database. This can have adverse effects in the performance of the gateway processing nodes. So if for example, you are using the MySQL servers that come with our appliances, to store the gateway policies and configuration, then I would suggest that you use a different off boxed MySQL server to store the OTK and MAG databases.

I hope you find this information useful.

Hello George,

Yes...This info was very much useful. Thanks

If this issue is addressed then please take a moment to mark the desired response as resolved. Thanks!         

Done