物探化探计算技术2024，Vol.46Issue(2)：235-241,7.DOI:10.3969/j.issn.1001-1749.2024.02.13
面向大规模集群作业并发规模的数据库连接池优化技术
Application of database pool technology for job concurrent scale in large-scale cluster environment
摘要
Abstract
As the core component of multidisciplinary data storage and management of seismic exploration processing soft-ware system,the database supports the reading and writing access requirements of processing jobs at the bottom.With the rapid development of seismic exploration processing technology,the concurrent scale of processing jobs under large-scale clus-ters is also expanding rapidly.The e's conventional read-write integrated deployment mode makes it challenging to support the read-write requests of large-scale concurrent jobs.This paper presents a concurrent scenario for data processing of large-scale cluster seismic exploration,The database adopts"1+N"The connection pool optimization technology of"read-write separation deployment mode"designs a resource allocator based on the node information of the database server,reasonably optimizes the database read-write requests of concurrent jobs,and has been verified in the laboratory environment and actual seismic explora-tion data processing production.It can support processing long things and high concurrency under large-scale cluster Database access requests.关键词
数据库/读写请求/集群作业/并发规模Key words
database/read write request/cluster job/concurrent scale分类
天文与地球科学引用本文复制引用
师伟,王向辉,林茂春,侯红军,程实..面向大规模集群作业并发规模的数据库连接池优化技术[J].物探化探计算技术,2024,46(2):235-241,7.基金项目
中国石油集团科学研究与技术开发项目(2021ZG03) （2021ZG03）
