Configuring MySQL on AWS EC2 for Syncari Connector Access via NLB

These instructions describe how to expose a MySQL database (running on an EC2 instance) to Syncari, using an internet-facing Network Load Balancer.
 

Prerequisites

• A VPC with an internet gateway attached
• A public subnet in this VPC that allows inbound TCP traffic on port 3306 and all outbound TCP traffic (via a security group)
• An EC2 instance running MySQL in the above VPC, with:
  • MySQL listening on port 3306 (verify with netstat -tlnp | grep 3306 or ss -tlnp | grep 3306)
  • bind-address in my.cnf set to 0.0.0.0 (or the instance’s private IP), not 127.0.0.1
  • A MySQL user account configured to allow remote connections (e.g., 'user'@'%')
  • The instance’s security group permitting inbound TCP on port 3306 from the NLB’s subnet CIDR (or from the security group used by the NLB)

Steps

1. Note the private IP address of the EC2 instance hosting MySQL. You can find this in the EC2 Console under Instances → your instance → Details → Private IPv4 address.
2. Create a new EC2 Target Group. Choose Instances as the target type (or IP addresses if you prefer to register by IP). Set the protocol to TCP and the port to 3306. Select the VPC from the prerequisites.
3. Configure the health check to use TCP on port 3306.
4. In the next step of target group creation, register the MySQL EC2 instance (or its private IP if you chose IP target type). Click the Include as pending below button under the Port section.
5. Create the target group.
6. Create a Network Load Balancer from EC2 → Load Balancers, selecting Internet-facing. Under Network mapping, choose the VPC and public subnet from the prerequisites.
7. Choose the security group created in prerequisites (the one allowing inbound TCP on port 3306).
8. Add a listener: change the protocol to TCP and the port to 3306.
9. Select the target group created in the previous step in the Forward to target group configuration.
10. Review and create the NLB.

Configuring the Syncari MySQL Synapse

Once the NLB is created you can use the DNS name shown on the details panel as the “Host name” configuration on the Syncari MySQL synapse. Reference the MySQL Setup article for the Synapse configuration steps.