MySQL NDB集群在“住建一张图”建设中的应用

Application of MySQL NDB Cluster in construction of“OneMap of Housing”

随着互联网及移动通讯网络不断完善和提速,数据访问量和数据体量爆炸式增长,单机数据库所支持的并发数、吞吐量难以满足这一要求。文中根据济南市“住建一张图”现状和“智慧住建”的建设需求,设计了MySQL NDB集群逻辑架构、部署架构和负载均衡方案,采用MySQL NDB分布式存储引擎的集群技术和负载均衡技术,使用一组普通性能服务器,搭建一套高吞吐、高性能和可动态扩展的MySQL NDB集群数据库。结果表明MySQL NDB集群在高并发、高吞吐、高可用、易扩展性能和经济可行性上,具有明显优势,可在相关行业中推广使用。

As the internet and mobile communication networks improved and accelerated continuously,the amount of the data access and the data volume had exploded,and the number of concurrency and throughput supported by the single-machine database couldn’t meet this requirement.According to the status quo of"OneMap of Housing"and the construction requirements of"Smart Housing"in Jinan,the logical architecture,the deployment architecture and the load balancing scheme of MySQL NDB Cluster were designed,the high-throughput,high-performance and expandable dynamically MySQL NDB Cluster database was built by using the cluster technology and the load balancing technology of MySQL NDB distributed storage engine,and the group of the ordinary servers.Results showed that MySQL NDB Cluster had obvious advantages in terms of the high concurrency,the high throughput,the high availability,the easy scalability,and the economic feasibility,and it could be promoted and used in the related industries.