AtlasOfLivingAustralia / logger-service

Atlas event logging
https://logger.ala.org.au
1 stars 8 forks source link

Add a status endpoint that attempts to connect to mysql and fails if the connection pool is full #16

Open ansell opened 6 years ago

ansell commented 6 years ago

Since caching the logger resources paths in nginx has been enabled, the ALA monitoring software will not show when the mysql connection pool fills up, hiding downtime. There needs to be a new status endpoint that attempts to connect to mysql without perform any queries, and immediately returns an error to the request if the connection failed, to enable the monitoring software to flag the events when the mysql connection pool gets full because of full table locks used by backup software.