无法从 K8 中运行的 Spring Boot 应用程序连接到 Google Cloud MySQL DB

大佬教程收集整理的这篇文章主要介绍了无法从 K8 中运行的 Spring Boot 应用程序连接到 Google Cloud MySQL DB，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

如何解决无法从 K8 中运行的 Spring Boot 应用程序连接到 Google Cloud MySQL DB？

开发过程中遇到无法从 K8 中运行的 Spring Boot 应用程序连接到 Google Cloud MySQL DB的问题如何解决？下面主要结合日常开发的经验，给出你关于无法从 K8 中运行的 Spring Boot 应用程序连接到 Google Cloud MySQL DB的解决方法建议，希望对你解决无法从 K8 中运行的 Spring Boot 应用程序连接到 Google Cloud MySQL DB有所启发或帮助；

我有谷歌云 MysqL 实例。 这是我尝试连接到数据库的方式：

hibernate.hbm2ddl.auto=update
spring.datasource.driver=com.Mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:MysqL://${host}:3306/${database_namE}
spring.datasource.username=username
spring.datasource.password=password
hibernate.dialect=org.hibernate.dialect.MysqL5Dialect
hibernate.show_sql=false

当我在本地运行 Spring-boot 时（作为独立应用程序或在 Docker 容器中），它按预期工作并且我能够连接到 Google 实例。但是一旦我将它作为 k8 pod 部署到 Google k8 集群，我就会收到这个错误：

2021-05-29T10:58:53.509609037Zcom.Mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
Info
2021-05-29T10:58:53.509624634ZThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Info
2021-05-29T10:58:53.509634325Z at com.Mysql.cj.jdbc.exceptions.sqlError.createCommunicationsException(sqlError.java:174) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.509641816Z at com.Mysql.cj.jdbc.exceptions.sqlExceptionsmapPing.translateException(sqlExceptionsmapPing.java:64) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.509650943Z at com.Mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.509660187Z at com.Mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.509667583Z at com.Mysql.cj.jdbc.ConnectionImpl.geTinstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.509674049Z at com.Mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.509681366Z at java.sql.DriveRMANager.getConnection(DriveRMANager.java:664) ~[na:1.8.0_212]
Info
2021-05-29T10:58:53.509689163Z at java.sql.DriveRMANager.getConnection(DriveRMANager.java:208) ~[na:1.8.0_212]
2021-05-29T10:58:53.509695511Z at org.springframework.jdbc.datasource.DriveRMANagerDatasource.getConnectionFromDriveRMANager(DriveRMANagerDatasource.java:155) ~[spring-jdbc-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509711714Z at org.springframework.jdbc.datasource.DriveRMANagerDatasource.getConnectionFromDriver(DriveRMANagerDatasource.java:146) ~[spring-jdbc-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509718794Z at org.springframework.jdbc.datasource.AbstractDriverBasedDatasource.getConnectionFromDriver(AbstractDriverBasedDatasource.java:205) ~[spring-jdbc-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509725553Z at org.springframework.jdbc.datasource.AbstractDriverBasedDatasource.getConnection(AbstractDriverBasedDatasource.java:169) ~[spring-jdbc-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509732733Z at org.hibernate.ENGIne.jdbc.connections.internal.DatasourceConnectionProvIDerImpl.getConnection(DatasourceConnectionProvIDerImpl.java:122) ~[hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509740924Z at org.hibernate.ENGIne.jdbc.env.internal.JdbcEnvironmenTinitiator$ConnectionProvIDerJdbcConnectionAccess.obtainConnection(JdbcEnvironmenTinitiator.java:180) ~[hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509749641Z at org.hibernate.ENGIne.jdbc.env.internal.JdbcEnvironmenTinitiator.initiateservice(JdbcEnvironmenTinitiator.java:68) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509756783Z at org.hibernate.ENGIne.jdbc.env.internal.JdbcEnvironmenTinitiator.initiateservice(JdbcEnvironmenTinitiator.java:35) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509763753Z at org.hibernate.boot.registry.internal.StandardserviceRegistryImpl.initiateservice(StandardserviceRegistryImpl.java:101) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509770623Z at org.hibernate.service.internal.AbstractserviceRegistryImpl.createservice(AbstractserviceRegistryImpl.java:263) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509796702Z at org.hibernate.service.internal.AbstractserviceRegistryImpl.initializeservice(AbstractserviceRegistryImpl.java:237) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509802689Z at org.hibernate.service.internal.AbstractserviceRegistryImpl.getservice(AbstractserviceRegistryImpl.java:214) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509808731Z at org.hibernate.ID.factory.internal.DefaultIDentifIErGeneratorFactory.injectservices(DefaultIDentifIErGeneratorFactory.java:152) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509815653Z at org.hibernate.service.internal.AbstractserviceRegistryImpl.injectDependencIEs(AbstractserviceRegistryImpl.java:286) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509822479Z at org.hibernate.service.internal.AbstractserviceRegistryImpl.initializeservice(AbstractserviceRegistryImpl.java:243) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509829318Z at org.hibernate.service.internal.AbstractserviceRegistryImpl.getservice(AbstractserviceRegistryImpl.java:214) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509843010Z at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:176) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509849856Z at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:127) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509856595Z at org.hibernate.jpa.boot.internal.EntitymanagerFactoryBuilderImpl.Metadata(EntitymanagerFactoryBuilderImpl.java:1224) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509863586Z at org.hibernate.jpa.boot.internal.EntitymanagerFactoryBuilderImpl.build(EntitymanagerFactoryBuilderImpl.java:1255) [hibernate-core-5.4.30.Final.jar!/:5.4.30.Final]
Info
2021-05-29T10:58:53.509872075Z at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvIDer.createContainerEntitymanagerFactory(SpringHibernateJpaPersistenceProvIDer.java:58) [spring-orm-5.3.5.jar!/:5.3.5]
Info
2021-05-29T10:58:53.509878468Z at org.springframework.orm.jpa.LocalContainerEntitymanagerfactorybean.createNativeEntitymanagerFactory(LocalContainerEntitymanagerfactorybean.java:365) [spring-orm-5.3.5.jar!/:5.3.5]
Info
2021-05-29T10:58:53.509884538Z at org.springframework.orm.jpa.AbstractEntitymanagerfactorybean.buildNativeEntitymanagerFactory(AbstractEntitymanagerfactorybean.java:40
Info
2021-05-29T10:58:53.509905668Z at org.springframework.orm.jpa.AbstractEntitymanagerfactorybean.afterPropertIEsSet(AbstractEntitymanagerfactorybean.java:396) [spring-orm-5.3.5.jar!/:5.3.5]
Info
2021-05-29T10:58:53.509914159Z at org.springframework.orm.jpa.LocalContainerEntitymanagerfactorybean.afterPropertIEsSet(LocalContainerEntitymanagerfactorybean.java:341) [spring-orm-5.3.5.jar!/:5.3.5]
Info
2021-05-29T10:58:53.509920884Z at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.invokeInitMethods(AbstractautowireCapablebeanfactory.java:1853) [spring-beans-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509927455Z at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.initializeBean(AbstractautowireCapablebeanfactory.java:1790) [spring-beans-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509933694Z at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.doCreateBean(AbstractautowireCapablebeanfactory.java:594) [spring-beans-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509939206Z at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.createBean(AbstractautowireCapablebeanfactory.java:516) [spring-beans-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509945426Z at org.springframework.beans.factory.support.Abstractbeanfactory.lambda$doGetBean$0(Abstractbeanfactory.java:324) [spring-beans-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509959520Z at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509966550Z at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:322) [spring-beans-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509973044Z at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:202) [spring-beans-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509982819Z at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1109) ~[spring-context-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.509989186Z at org.springframework.context.support.AbstractApplicationContext.finishbeanfactoryInitialization(AbstractApplicationContext.java:869) ~[
2021-05-29T10:58:53.509995584Z at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) ~[spring-context-5.2.8.RELEASE.jar!/:5.2.8.RELEASE]
Info
2021-05-29T10:58:53.510004994Z at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) ~[spring-boot-2.3.3.RELEASE.jar!/:2.3.3.RELEASE]
Info
2021-05-29T10:58:53.510011525Z at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) ~[spring-boot-2.3.3.RELEASE.jar!/:2.3.3.RELEASE]
Info
2021-05-29T10:58:53.510018006Z at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) ~[spring-boot-2.3.3.RELEASE.jar!/:2.3.3.RELEASE]
Info
2021-05-29T10:58:53.510023845Z at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) ~[spring-boot-2.3.3.RELEASE.jar!/:2.3.3.RELEASE]
Info
2021-05-29T10:58:53.510033258Z at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-2.3.3.RELEASE.jar!/:2.3.3.RELEASE]
Info
2021-05-29T10:58:53.510039845Z at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) ~[spring-boot-2.3.3.RELEASE.jar!/:2.3.3.RELEASE]
Info
2021-05-29T10:58:53.510046040Z at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) ~[spring-boot-2.3.3.RELEASE.jar!/:2.3.3.RELEASE]
Info
2021-05-29T10:58:53.510052673Z at com.alekseytyan.logiweb.Logiwebservice.main(Logiwebservice.java:9) ~[classes!/:1.0-SNAPSHOT]
Info
2021-05-29T10:58:53.510060800Z at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_212]
Info
2021-05-29T10:58:53.510067072Z at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_212]
Info
2021-05-29T10:58:53.510073383Z at sun.reflect.DelegaTingMethodAccessorImpl.invoke(DelegaTingMethodAccessorImpl.java:43) ~[na:1.8.0_212]
Info
2021-05-29T10:58:53.510079940Z at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_212]
2021-05-29T10:58:53.510086547Z at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) ~[logiweb-service.war:1.0-SNAPSHOT]
Info
2021-05-29T10:58:53.510092467Z at org.springframework.boot.loader.Launcher.launch(Launcher.java:109) ~[logiweb-service.war:1.0-SNAPSHOT]
Info
2021-05-29T10:58:53.510098016Z at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[logiweb-service.war:1.0-SNAPSHOT]
Info
2021-05-29T10:58:53.510105920Z at org.springframework.boot.loader.WarLauncher.main(WarLauncher.java:59) ~[logiweb-service.war:1.0-SNAPSHOT]
Info
2021-05-29T10:58:53.510113410ZCaused by: com.Mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Info
2021-05-29T10:58:53.510126973ZThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Info
2021-05-29T10:58:53.510154628Z at sun.reflect.NativeConstructOraccessorImpl.newInstance0(Native Method) ~[na:1.8.0_212]
Info
2021-05-29T10:58:53.510162460Z at sun.reflect.NativeConstructOraccessorImpl.newInstance(NativeConstructOraccessorImpl.java:62) ~[na:1.8.0_212]
Info
2021-05-29T10:58:53.510179730Z at sun.reflect.DelegaTingConstructOraccessorImpl.newInstance(DelegaTingConstructOraccessorImpl.java:45) ~[na:1.8.0_212]
Info
2021-05-29T10:58:53.510187599Z at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_212]
2021-05-29T10:58:53.510194600Z at com.Mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.510200781Z at com.Mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.510207172Z at com.Mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.510214725Z at com.Mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.510221716Z at com.Mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.510228880Z at com.Mysql.cj.NativeSession.connect(NativeSession.java:144) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.510236037Z at com.Mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:953) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.510242239Z at com.Mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) ~[mysql-connector-java-8.0.23.jar!/:8.0.23]
Info
2021-05-29T10:58:53.510248946Z ... 57 common frames omitted
Info
2021-05-29T10:58:53.510255264ZCaused by: java.net.ConnectException: Operation timed out (Connection timed out) at java.net.PlainSocketImpl.socketConnect(Native Method) ~

我认为它与外部访问和 IP 相关，但这只是我的假设

解决方法

暂无找到可以解决该程序问题的有效方法，小编努力寻找整理中！

如果你已经找到好的解决方法，欢迎将解决方案带上本链接一起发送给小编。

小编邮箱:dio#foxmail.com (将#修改为@）

大佬总结

以上是大佬教程为你收集整理的无法从 K8 中运行的 Spring Boot 应用程序连接到 Google Cloud MySQL DB全部内容，希望文章能够帮你解决无法从 K8 中运行的 Spring Boot 应用程序连接到 Google Cloud MySQL DB所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。