利用JDBC和MySQL Replication实现数据库集群  

Realization of Clustering Database by Using JDBC and MySQL Replication

作　　者：柳刚[1] 

机构地区：[1]西昌学院网络管理中心,四川西昌615013

出　　处：《煤炭技术》2011年第4期204-206,共3页Coal Technology

摘　　要：数据急剧增长会导致数据库性能下降,当数据库层出现瓶颈时,就得在硬件上花费高额的费用。针对这一情况,提出在现有硬件的基础上利用JDBC规范与MySQL Replication实现数据库集群从而解决数据访问瓶颈。其主要方法是在进行JDBC连接之前实现负载均衡,所有SQL请求由负载均衡器进行统一调度。在数据库端利用MySQL Replication实现数据高并发读写。With the rapid growth of data,database performance will descended,when a bottleneck was occurred at the database layer,you have to spend the high cost of hardware.This paper puts forward the usage of criterion of JDBC and MySQL Replication on the existing hardware,which will realize the Clustering database and solve the problems of data access.A load balancer is made before JDBC connection,which is the main idea for this paper,all of SQL requires will be controlled by the load equalizer.The concurrent reading and writing of data are come true in the database with MySQL Replication.

关 键 词：数据库连接 数据库同步 数据库集群 负载均衡器 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]