This reference architecture diagram shows the deployment of Application and MySQL Router Nodes and MySQL Server Nodes in Oracle Cloud Infrastructure.

The Oracle Cloud Infrastructure Region has an internet gateway, one Availability Domain and three Fault Domains. The VCN (10.0.0.0/16) has three Regional Subnets (10.0.3.0/24, 10.0.2.0/24, and 10.0.1.0/24). Each Subnet has a Security List and Route Table. Object Storage (Backups) is located in the region.

The first subnet contains a Public Load Balancer.

The second subnet is the Application Tier and contains three Application and MySQL Router Nodes (A1, A2, and A3). Data from the Public Load Balancer is distributed to A1, A2, and A3.

The third subnet is the Database Tier and contains an MySQL InnoDB Cluster with three MySQL Server Nodes (S1, S2, and S3). There is two way connectivity between Application Tier and the Database Tier. Data flows both ways between each of the server notes (S1 and S2, S2 and S3, and S1 and S3).