【踩坑日记】Druid连接池在MySQL主备切换时引发高可用问题

背景由于MySQL供应商内部升级，线上数据库需要主动进行主备切换。切换基于SIP漂移，理论上是毫秒级闪断。但在实际模拟演练的过程中，除了预期内切换瞬间产生的连接异常外，后续半个小时仍不断地产生连接异常，导致问题不可控。
org.springframework.dao.RecoverableDataAccessException:### Error querying database.Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet sent successfully to the server was 11,603,448 milliseconds ago.; nested exception is java.lang.Throwableat org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:100)at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)······Caused by: java.io.IOException: Socket is closedat com.mysql.cj.protocol.AbstractSocketConnection.getMysqlInput(AbstractSocketConnection.java:72)at com.mysql.cj.protocol.a.NativeProtocol.clearInputStream(NativeProtocol.java:803)... 130 common frames omitted

文章插图