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

2016-08-27 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 David, On 8/26/16 2:45 PM, David Day wrote: >> 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

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

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

2016-08-25 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 David, On 8/24/16 5:22 PM, David Day wrote: > 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. >

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.