Nacos2.4.1版本适配人大金仓kingbase数据库

提示：文章写完后，目次可以自动天生，怎样天生可参考右边的帮助文档
  
  

---

前言

随着国家书息技术应用创新（信创）战略的深入推进，越来越多的关键技术和组件正徐徐被替换为国产化的产品与服务。这一变化不光是为了增强国家的信息安全，淘汰对外部技术的依赖，更是为了促进本土信息技术财产的自主创新本领和发展。在这一过程中，包括操纵体系、数据库、中心件、服务器硬件以及核心芯片在内的多个范畴都在经历着一场深刻的变革。
具体而言，国产化替换涉及以下几个方面：

• 操纵体系：推广利用如麒麟软件、统信UOS等国产操纵体系，以替换传统的Windows或Unix体系。
  
• 数据库管理体系：研发并部署达梦、人大金仓Kingbase等国产数据库，淘汰对Oracle、SQL Server等国外产品的依赖。
  
• 中心件：诸如东方通、中创中心件等国产产品正在逐渐取代IBM WebSphere和Oracle WebLogic等外资品牌。
  
• 服务器及PC终端：利用基于国产CPU架构（如龙芯、飞腾、兆芯等）的服务器和电脑，以替换Intel和AMD等厂商的产品。
  
• 基础软件与工具：包括办公软件、设计软件等，也在向WPS Office、中望CAD等国产化方向迁移。
  

此外，政策层面的支持也在不停加码，通过设立专项基金、制定行业标准、举行各类信创大赛等方式，激励企业和科研机构加快技术创新和产品迭代。同时，市场需求的增长也为国产信息技术产品和服务提供了广阔的市场空间，促进了整个财产链的成熟与发展。随着这些措施的有效实施，不光能够提拔国家书息基础办法的安全性和自主性，还将极大地推动中国信息技术财产的整体进步与国际竞争力的提拔。
提示：以下是本篇文章正文内容，下面案例可供参考
一、Nacos2.4.1版本适配人大金仓数据库

近期，Nacos爆出了任意文件读写毛病，Nacos2版本影响的为2.0.0-2.4.0.1，需要升级到2.4.1版本，为了相应国家号召，本次利用了人大金仓数据库，版本为8.6.0
二、适配步骤

1.修改Nacos最外层pom，参加人大金仓依赖版本

1.   <properties>
2.         <kingbase8-connector-java.version>8.6.0</kingbase8-connector-java.version>
3.   </properties>
4.   
5.     <dependencyManagement>
6.         <dependencies>            
7.             <dependency>
8.                 <groupId>com.kingbase8</groupId>
9.                 <artifactId>kingbase8</artifactId>
10.                 <version>${kingbase8-connector-java.version}</version>
11.             </dependency>
12.         </dependencies>
13.     </dependencyManagement>

复制代码

2.修改config模块下的pom，增加人大金仓依赖

1.         <dependency>
2.             <groupId>com.kingbase8</groupId>
3.             <artifactId>kingbase8</artifactId>
4.         </dependency>

复制代码

3.修改console模块下resources中的application.properties和distribution模块下conf包中的application.properties

注意，其中{}中的内容替换成本身的

1. #
2. # Copyright 1999-2021 Alibaba Group Holding Ltd.
3. #
4. # Licensed under the Apache License, Version 2.0 (the "License");
5. # you may not use this file except in compliance with the License.
6. # You may obtain a copy of the License at
7. #
8. #      http://www.apache.org/licenses/LICENSE-2.0
9. #
10. # Unless required by applicable law or agreed to in writing, software
11. # distributed under the License is distributed on an "AS IS" BASIS,
12. # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13. # See the License for the specific language governing permissions and
14. # limitations under the License.
15. #
17. #*************** Spring Boot Related Configurations ***************#
18. ### Default web context path:
19. server.servlet.contextPath=/nacos
20. ### Default web server port:
21. server.port=8858
23. #*************** Network Related Configurations ***************#
24. ### If prefer hostname over ip for Nacos server addresses in cluster.conf:
25. # nacos.inetutils.prefer-hostname-over-ip=false
27. ### Specify local server's IP:
28. # nacos.inetutils.ip-address=
31. #*************** Config Module Related Configurations ***************#
32. ### If use MySQL or KingbaseES as datasource:
33. spring.datasource.platform=mysql
35. ### Count of DB:
36. db.num=1
38. ### Connect URL of DB:
39. # db.url.0=jdbc:mysql://127.0.0.1:3306/nacos?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&useUnicode=true&useSSL=false&serverTimezone=UTC
40. # db.user.0=nacos
41. # db.password.0=nacos
43. ### KingbaseES
44. db.jdbcDriverName=com.kingbase8.Driver
45. db.url.0=jdbc:kingbase8://{ip}:{port}/{dataSourceName}
46. db.user.0={username}
47. db.password.0={password}
49. ### Connection pool configuration: hikariCP
50. db.pool.config.connectionTimeout=30000
51. db.pool.config.validationTimeout=10000
52. db.pool.config.maximumPoolSize=20
53. db.pool.config.minimumIdle=2
55. #*************** Naming Module Related Configurations ***************#
56. ### Data dispatch task execution period in milliseconds: Will removed on v2.1.X, replace with nacos.core.protocol.distro.data.sync.delayMs
57. # nacos.naming.distro.taskDispatchPeriod=200
59. ### Data count of batch sync task: Will removed on v2.1.X. Deprecated
60. # nacos.naming.distro.batchSyncKeyCount=1000
62. ### Retry delay in milliseconds if sync task failed: Will removed on v2.1.X, replace with nacos.core.protocol.distro.data.sync.retryDelayMs
63. # nacos.naming.distro.syncRetryDelay=5000
65. ### If enable data warmup. If set to false, the server would accept request without local data preparation:
66. # nacos.naming.data.warmup=true
68. ### If enable the instance auto expiration, kind like of health check of instance:
69. # nacos.naming.expireInstance=true
71. ### will be removed and replaced by `nacos.naming.clean` properties
72. nacos.naming.empty-service.auto-clean=true
73. nacos.naming.empty-service.clean.initial-delay-ms=50000
74. nacos.naming.empty-service.clean.period-time-ms=30000
76. ### Add in 2.0.0
77. ### The interval to clean empty service, unit: milliseconds.
78. # nacos.naming.clean.empty-service.interval=60000
80. ### The expired time to clean empty service, unit: milliseconds.
81. # nacos.naming.clean.empty-service.expired-time=60000
83. ### The interval to clean expired metadata, unit: milliseconds.
84. # nacos.naming.clean.expired-metadata.interval=5000
86. ### The expired time to clean metadata, unit: milliseconds.
87. # nacos.naming.clean.expired-metadata.expired-time=60000
89. ### The delay time before push task to execute from service changed, unit: milliseconds.
90. # nacos.naming.push.pushTaskDelay=500
92. ### The timeout for push task execute, unit: milliseconds.
93. # nacos.naming.push.pushTaskTimeout=5000
95. ### The delay time for retrying failed push task, unit: milliseconds.
96. # nacos.naming.push.pushTaskRetryDelay=1000
98. ### Since 2.0.3
99. ### The expired time for inactive client, unit: milliseconds.
100. # nacos.naming.client.expired.time=180000
102. #*************** CMDB Module Related Configurations ***************#
103. ### The interval to dump external CMDB in seconds:
104. # nacos.cmdb.dumpTaskInterval=3600
106. ### The interval of polling data change event in seconds:
107. # nacos.cmdb.eventTaskInterval=10
109. ### The interval of loading labels in seconds:
110. # nacos.cmdb.labelTaskInterval=300
112. ### If turn on data loading task:
113. # nacos.cmdb.loadDataAtStart=false
116. #*************** Metrics Related Configurations ***************#
117. ### Metrics for prometheus
118. #management.endpoints.web.exposure.include=*
120. ### Metrics for elastic search
121. management.metrics.export.elastic.enabled=false
122. #management.metrics.export.elastic.host=http://localhost:9200
124. ### Metrics for influx
125. management.metrics.export.influx.enabled=false
126. #management.metrics.export.influx.db=springboot
127. #management.metrics.export.influx.uri=http://localhost:8086
128. #management.metrics.export.influx.auto-create-db=true
129. #management.metrics.export.influx.consistency=one
130. #management.metrics.export.influx.compressed=true
132. #*************** Access Log Related Configurations ***************#
133. ### If turn on the access log:
134. server.tomcat.accesslog.enabled=true
136. ### The access log pattern:
137. server.tomcat.accesslog.pattern=%h %l %u %t "%r" %s %b %D %{User-Agent}i %{Request-Source}i
139. ### The directory of access log:
140. server.tomcat.basedir=file:.
142. #*************** Access Control Related Configurations ***************#
143. ### If enable spring security, this option is deprecated in 1.2.0:
144. #spring.security.enabled=false
146. ### The ignore urls of auth, is deprecated in 1.2.0:
147. nacos.security.ignore.urls=/,/error,/**/*.css,/**/*.js,/**/*.html,/**/*.map,/**/*.svg,/**/*.png,/**/*.ico,/console-ui/public/**,/v1/auth/**,/v1/console/health/**,/actuator/**,/v1/console/server/**
149. ### The auth system to use, currently only 'nacos' and 'ldap' is supported:
150. nacos.core.auth.system.type=nacos
152. ### If turn on auth system:
153. nacos.core.auth.enabled=true
155. ### Turn on/off caching of auth information. By turning on this switch, the update of auth information would have a 15 seconds delay.
156. nacos.core.auth.caching.enabled=true
158. ### Since 1.4.1, Turn on/off white auth for user-agent: nacos-server, only for upgrade from old version.
159. nacos.core.auth.enable.userAgentAuthWhite=false
161. ### Since 1.4.1, worked when nacos.core.auth.enabled=true and nacos.core.auth.enable.userAgentAuthWhite=false.
162. ### The two properties is the white list for auth and used by identity the request from other server.
163. nacos.core.auth.server.identity.key=serverIdentity
164. nacos.core.auth.server.identity.value=security
166. ### worked when nacos.core.auth.system.type=nacos
167. ### The token expiration in seconds:
168. nacos.core.auth.plugin.nacos.token.expire.seconds=18000
169. ### The default token:
170. nacos.core.auth.plugin.nacos.token.secret.key=SecretKey012345678901234567890123456789012345678901234567890123456789
172. ### worked when nacos.core.auth.system.type=ldap?{0} is Placeholder,replace login username
173. #nacos.core.auth.ldap.url=ldap://localhost:389
174. #nacos.core.auth.ldap.basedc=dc=example,dc=org
175. #nacos.core.auth.ldap.userDn=cn=admin,${nacos.core.auth.ldap.basedc}
176. #nacos.core.auth.ldap.password=admin
177. #nacos.core.auth.ldap.userdn=cn={0},dc=example,dc=org
180. #*************** Istio Related Configurations ***************#
181. ### If turn on the MCP server:
182. nacos.istio.mcp.server.enabled=false
184. #*************** Core Related Configurations ***************#
186. ### set the WorkerID manually
187. # nacos.core.snowflake.worker-id=
189. ### Member-MetaData
190. # nacos.core.member.meta.site=
191. # nacos.core.member.meta.adweight=
192. # nacos.core.member.meta.weight=
194. ### MemberLookup
195. ### Addressing pattern category, If set, the priority is highest
196. # nacos.core.member.lookup.type=[file,address-server]
197. ## Set the cluster list with a configuration file or command-line argument
198. # nacos.member.list=192.168.16.101:8847?raft_port=8807,192.168.16.101?raft_port=8808,192.168.16.101:8849?raft_port=8809
199. ## for AddressServerMemberLookup
200. # Maximum number of retries to query the address server upon initialization
201. # nacos.core.address-server.retry=5
202. ## Server domain name address of [address-server] mode
203. # address.server.domain=jmenv.tbsite.net
204. ## Server port of [address-server] mode
205. # address.server.port=8080
206. ## Request address of [address-server] mode
207. # address.server.url=/nacos/serverlist
209. #*************** JRaft Related Configurations ***************#
211. ### Sets the Raft cluster election timeout, default value is 5 second
212. # nacos.core.protocol.raft.data.election_timeout_ms=5000
213. ### Sets the amount of time the Raft snapshot will execute periodically, default is 30 minute
214. # nacos.core.protocol.raft.data.snapshot_interval_secs=30
215. ### raft internal worker threads
216. # nacos.core.protocol.raft.data.core_thread_num=8
217. ### Number of threads required for raft business request processing
218. # nacos.core.protocol.raft.data.cli_service_thread_num=4
219. ### raft linear read strategy. Safe linear reads are used by default, that is, the Leader tenure is confirmed by heartbeat
220. # nacos.core.protocol.raft.data.read_index_type=ReadOnlySafe
221. ### rpc request timeout, default 5 seconds
222. # nacos.core.protocol.raft.data.rpc_request_timeout_ms=5000
224. #*************** Distro Related Configurations ***************#
226. ### Distro data sync delay time, when sync task delayed, task will be merged for same data key. Default 1 second.
227. # nacos.core.protocol.distro.data.sync.delayMs=1000
229. ### Distro data sync timeout for one sync data, default 3 seconds.
230. # nacos.core.protocol.distro.data.sync.timeoutMs=3000
232. ### Distro data sync retry delay time when sync data failed or timeout, same behavior with delayMs, default 3 seconds.
233. # nacos.core.protocol.distro.data.sync.retryDelayMs=3000
235. ### Distro data verify interval time, verify synced data whether expired for a interval. Default 5 seconds.
236. # nacos.core.protocol.distro.data.verify.intervalMs=5000
238. ### Distro data verify timeout for one verify, default 3 seconds.
239. # nacos.core.protocol.distro.data.verify.timeoutMs=3000
241. ### Distro data load retry delay when load snapshot data failed, default 30 seconds.
242. # nacos.core.protocol.distro.data.load.retryDelayMs=30000

复制代码

3.修改persistence模块下com/alibaba/nacos/persistence/datasource包中ExternalDataSourceProperties类的JDBC_DRIVER_NAME常量

1.     // private static final String JDBC_DRIVER_NAME = "com.mysql.cj.jdbc.Driver";
2.     private static final String JDBC_DRIVER_NAME = "com.kingbase8.Driver";

复制代码

4.修改plugin模块下datasource子模块下com/alibaba/nacos/plugin/datasource/enums/mysql包中的TrustedMysqlFunctionEnum枚举类

1.         //人大金仓中NOW()函数没有入参，该入参是mysql的now（integer）函数为了设置毫秒位数使用，而人大金仓中NOW()函数默认是带着毫秒的
2.    // NOW("NOW()", "NOW(3)");
3.    NOW("NOW()", "NOW()");

复制代码

5.利用命令打包

1. mvn -Prelease-nacos "-Dmaven.test.skip=true" clean install -U --settings {自己的settings.xml路径}

复制代码

至此，全部完成，天生的jar会存放在项目的distribution模块的target中

---

总结

本次升级完成，由原来的mysql支持替换成人大金仓kingbase，2.4.1版本适配人大金仓相对比较简单，如需要前期其他版本，可以留言给我，谢谢。

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。