Hardware configuration:
Xen Server virtual Machine
Two-core CPU model: Intel (R) Xeon (r) CPU e5-2620 v2 @ 2.10GHz
Memory Buffer_pool 1G
Table Data Volume 10,000 rows
LoadRunner tool pressure measurement, short connection, Percona5.6+thread_pool+jemalloc
---------------------------------------------------------------------------------------------------
Scoring indicator one: CPU usage of the server running both
CPU Usage for running HAproxy
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6E/DD/wKiom1WKIa3yunzQAANy2Zzuul8226.jpg "title=" Haproxy-cpu.jpg "alt=" Wkiom1wkia3yunzqaany2zzuul8226.jpg "/>
CPU Usage for running Oneproxy
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6E/DA/wKioL1WKI43xsi5EAAMv6E3w1Bc036.jpg "title=" Oneproxy-cpu.jpg "alt=" Wkiol1wki43xsi5eaamv6e3w1bc036.jpg "/>
Score Indicator two: CPU usage of MySQL service (very obvious contrast)
Haproxy Distributed MySQL CPU utilization
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6E/DD/wKiom1WKIfPTMRurAAIxFxYLmZ8374.jpg "title=" Haproxy_mysql_cpu.jpg "alt=" Wkiom1wkifptmruraaixfxylmz8374.jpg "/>
Oneproxy Distributed MySQL CPU utilization
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6E/DA/wKioL1WKI8_i5UUfAAIOKU4Venk246.jpg "title=" Oneproxy_mysql_cpu.jpg "alt=" Wkiol1wki8_i5uufaaioku4venk246.jpg "/>
TPS values for 3:2 of the rating indicators (almost)
TPS for pressure measurement at Haproxy
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6E/DA/wKioL1WKI_HwDHw5AAGGuhmAld8704.jpg "title=" Haproxy_tps.jpg "alt=" Wkiol1wki_hwdhw5aagguhmald8704.jpg "/>
TPS for pressure measurement at Oneproxy
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6E/DA/wKioL1WKJA_yLAKaAAF15mvfC8I094.jpg "title=" Oneproxy_tps.jpg "alt=" Wkiol1wkja_ylakaaaf15mvfc8i094.jpg "/>
Attach the test results with the mydbtest pressure measuring tool. Concurrent 100, pressure measurement 3 minutes.
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6E/DE/wKiom1WKIofSTppeAAL1SEenx2o098.jpg "title=" 111. PNG "alt=" wkiom1wkiofstppeaal1seenx2o098.jpg "/>
A word summed up: Oneproxy better understand the database, Haproxy better understand the application.
This article is from the "Spring Yang Technical column" blog, please be sure to keep this source http://hcymysql.blog.51cto.com/5223301/1664983
HAproxy VS oneproxy pressure test Report comparison chart