Compatibility API gateway with mysql 8.0.30 -innodb cluster - group replication

Products

• CA API Gateway

Issue/Introduction

The customer would like to install and deploy a new API GW environment in form factor RPM (software) mode.

The customer asks if it is possible to host the db ssg and the db otk by creating two separate mysql clusters external to the two machine where is running L7 service and specifically, the clusters of mysql have these characteristics:

• MySQL 8.0.30 or greater
• tables only in innoDB format
• One primary key for each table

here a doc of the kind of cluster with group replication that they would like to connect to L7

https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-introduction.html

Is this architecture compatible with Layer7 API GW 10.1 or is only compatible with (old replication style) master-master procedure?

 

Environment

Release : 10.1

Component :

Resolution

At the moment the MySQL group replication is not supported it may be in the future using this new GIPKs   feature but this is up to product management to plan and test this .