title: Unable to connect to Aurora MySql with Aws ECS fargate container
body: <p>I have a .net core 3.1 application which is deployed as docker container on AWS Ecs with fargate. I'd created 2 new Aurora MySql dbs and tried to connect to one of the db cluster by using the writer endpoint. Now the issue is when I try to call the POST method through postman by calling load balancer DNS, I am getting the following exception:</p>
  
  <blockquote>
    <p>"An exception has been raised that is likely due to a transient
    failure. Consider enabling transient error resiliency by adding
    'EnableRetryOnFailure()' to the 'UseMySql' call."</p>
  </blockquote>
  
  <p>I'd also tried adding retry pattern as mentioned in the exception but no luck.
  I've allowed Aurora/MySql on port 3306 from anywhere in my security group which I created for RDS. I'd also added Aurora/MySql on port 3306 for source "My cluster service security group and also load balancer security group" but even then no luck. Finally I added All traffic on all ports from anywhere but even then the error was same. So I suspect it's something different.
  I've then tried running the application through the docker desktop on my windows but I still got the same error there.</p>
  
  <blockquote>
    <p>An error occurred using the connection to database '' on server
    'db-cluster.cluster-cqb2jskhx78p.us-east-2.rds.amazonaws.com'.</p>
  </blockquote>
  
  <p>My Connection string is:</p>
  
  <pre><code>"DefaultConnection": "Data Source=db-cluster.cluster-cqb2jskhx78p.us-east-2.rds.amazonaws.com;Initial Catalog=demodb;User ID=admin;Password=MyPassword;port=3306"
  </code></pre>
  
  <p>Any help?</p>