Aurora Serverless Connection - Using jdbc

Question

Is it possible to connect Aurora ( MySQL ) using the jdbc driver endpoint using workbench or any other tool from my local machine.

Answer 1

Of course, yes. It is same as a usual Aurora database but is serverless. You can connect it by using workbench or any JDBC driver. However, the serverless Aurora cannot be assigned by a public ip, which means that the DB is not accessible from the outside of VPC. Since it is private, you cannot access it directly.

In order to access a private DB, you need a proxy instance, EC2 instance inside of the same VPC with public ip or you can use AWS Direct Connect.

There is some explanation about AWS Direct Connect that can be used to resolve your case. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/aurora-serverless.html

This will explain how to connect the private RDS from local by pass the public EC2. https://medium.com/@carlos.ribeiro/connecting-on-rds-server-that-is-not-publicly-accessible-1aee9e43b870 .