Re: Create new MySQL connections if read-only status is detected - AWS RDS failover

2016-08-26 Thread David Day
> How, in general, would you test to see if the database is in read-only > mode? > > - -chris This is what I'm hoping to learn, and perhaps is a question better for a MySQL list. I've found settings to add such as 'autoReconnect' and 'failOverReadOnly' for more classic cases using multiple MySQL

Create new MySQL connections if read-only status is detected - AWS RDS failover

2016-08-24 Thread David Day
Apache Tomcat/7.0.54 CentOS release 6.7 AWS RDS Aurora 5.6.10a Using RDS in a failover configuration, AWS directs requests to the write instance with a cluster CNAME e.g. dbname-cluster.cluster-id.us-west-2.rds.amazonaws.com, and the read-only instance to it's canonical name e.g.