Research on distributed relational database based on MySQL

Lanying Shi; Kai Wang; Man Li; Jiangang Tong; Hongming Qiao; Yiquan Jiang

doi:10.1117/12.2681360

23 May 2023 Research on distributed relational database based on MySQL

Lanying Shi, Kai Wang, Man Li, Jiangang Tong, Hongming Qiao, Yiquan Jiang

Proceedings Volume 12645, International Conference on Computer, Artificial Intelligence, and Control Engineering (CAICE 2023); 126451I (2023) https://doi.org/10.1117/12.2681360
Event: International Conference on Computer, Artificial Intelligence, and Control Engineering (CAICE 2023), 2023, Hangzhou, China

Abstract

With the rapid development of big data, cloud computing, artificial intelligence and other technologies, the expansion of database application requirements and the change of computer hardware environment, especially the rapid development of computer network and digital communication technology, satellite communications, cellular communications, computer local area networks, wide area networks, and the proliferation of Intranet and Internet have been widely used, resulting in the emergence of distributed database systems. Especially for basic industries such as telecommunications, databases often carry thousands of business systems, and millions of queries and tens of millions of bills are carried out every day. In the face of such massive scale, high concurrency, data security, real-time analysis and other multi scenario problems, the processing capacity of traditional centralized databases is far from meeting the needs. For this reason, this paper proposes a distributed database based on MySQL transformation. Through research and implementation, it can solve the above problems, meet the requirements of distributed transaction processing, ensure data backup, high availability and high performance, and improve efficiency. This paper will also describe its modeling model and sharding algorithm in detail.

Citation Download Citation

Lanying Shi, Kai Wang, Man Li, Jiangang Tong, Hongming Qiao, and Yiquan Jiang "Research on distributed relational database based on MySQL", Proc. SPIE 12645, International Conference on Computer, Artificial Intelligence, and Control Engineering (CAICE 2023), 126451I (23 May 2023); https://doi.org/10.1117/12.2681360

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available