Golang 实现的 mysql-proxy
Golang1.1昨天发布，性能提升不少。让我想起去年写的mysql-proxy，于是拿出来又改了一下调用最为频繁的一个函数，发现性能已经非常理想。这里放出来给有兴趣的朋友试用。 目前支持的功能是读写分离（非事务，如果用事务的话不会分发到slave上）和slave的负载
Golang1.1昨天发布，性能提升不少。让我想起去年写的mysql-proxy，于是拿出来又改了一下调用最为频繁的一个函数，发现性能已经非常理想。这里放出来给有兴趣的朋友试用。
目前支持的功能是读写分离（非事务，如果用事务的话不会分发到slave上）和slave的负载均衡，未做失效检查。另外prepare可能会有问题。
如果有什么需求可以后续添加，golang改起来非常方便，当初这个proxy我也就1个礼拜完成的。
下载地址：http://www.mysqlab.net/products/mysql-proxy/lbproxy64.tar.gz （linux 64位）
(有需要win版本的可以密我)
配置：
1. 需要配置用于连接proxy的用户名和密码（sha1(plain password)）
2. 需要配置连接后端master和slave的用户和密码（sha1(plain password))
3. slaves需要按照proxy.ini 格式写，因为解析ini文件的目前还没有容错
(本来是打算配置用web界面来做的，被其他事情给耽搁了)
启动：
目前启动方式很山寨
cd /path/to/proxy && ./proxy
(这个容易改，我已经有现成的python manager，套用过来就行)
大家有什么反馈可以q我或者这里留言（第一次需要审核，防止垃圾广告。）
Related posts:
- A new MySQL proxy written in Go — LegendBase Proxy for MySQL
- 由CSDN泄密想到的:MySQL数据库验证过程的改进、密码存储及验证方法的总结
- Go(golang) FastCGI Client
- daemon function for Go language(golang)(fixed for mac/darwin)
? 谭俊青 发布在 MySQL性能、MySQL Cluster集群、MySQL HA高可用等研究 - MySQL实验室, 2013.
可以任意转载, 但转载时务必以超链接形式标明文章原始出处 和 作者信息。
链接: http://www.mysqlab.net/blog/2013/05/golang-mysql-proxy/
标签:
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to safely read and write files using Golang?
Jun 06, 2024 pm 05:14 PM
Reading and writing files safely in Go is crucial. Guidelines include: Checking file permissions Closing files using defer Validating file paths Using context timeouts Following these guidelines ensures the security of your data and the robustness of your application.
How to configure connection pool for Golang database connection?
Jun 06, 2024 am 11:21 AM
How to configure connection pooling for Go database connections? Use the DB type in the database/sql package to create a database connection; set MaxOpenConns to control the maximum number of concurrent connections; set MaxIdleConns to set the maximum number of idle connections; set ConnMaxLifetime to control the maximum life cycle of the connection.
How to save JSON data to database in Golang?
Jun 06, 2024 am 11:24 AM
JSON data can be saved into a MySQL database by using the gjson library or the json.Unmarshal function. The gjson library provides convenience methods to parse JSON fields, and the json.Unmarshal function requires a target type pointer to unmarshal JSON data. Both methods require preparing SQL statements and performing insert operations to persist the data into the database.
Golang framework vs. Go framework: Comparison of internal architecture and external features
Jun 06, 2024 pm 12:37 PM
The difference between the GoLang framework and the Go framework is reflected in the internal architecture and external features. The GoLang framework is based on the Go standard library and extends its functionality, while the Go framework consists of independent libraries to achieve specific purposes. The GoLang framework is more flexible and the Go framework is easier to use. The GoLang framework has a slight advantage in performance, and the Go framework is more scalable. Case: gin-gonic (Go framework) is used to build REST API, while Echo (GoLang framework) is used to build web applications.
Transforming from front-end to back-end development, is it more promising to learn Java or Golang?
Apr 02, 2025 am 09:12 AM
Backend learning path: The exploration journey from front-end to back-end As a back-end beginner who transforms from front-end development, you already have the foundation of nodejs,...
How to find the first substring matched by a Golang regular expression?
Jun 06, 2024 am 10:51 AM
The FindStringSubmatch function finds the first substring matched by a regular expression: the function returns a slice containing the matching substring, with the first element being the entire matched string and subsequent elements being individual substrings. Code example: regexp.FindStringSubmatch(text,pattern) returns a slice of matching substrings. Practical case: It can be used to match the domain name in the email address, for example: email:="user@example.com", pattern:=@([^\s]+)$ to get the domain name match[1].
Golang framework development practical tutorial: FAQs
Jun 06, 2024 am 11:02 AM
Go framework development FAQ: Framework selection: Depends on application requirements and developer preferences, such as Gin (API), Echo (extensible), Beego (ORM), Iris (performance). Installation and use: Use the gomod command to install, import the framework and use it. Database interaction: Use ORM libraries, such as gorm, to establish database connections and operations. Authentication and authorization: Use session management and authentication middleware such as gin-contrib/sessions. Practical case: Use the Gin framework to build a simple blog API that provides POST, GET and other functions.
How to use predefined time zone with Golang?
Jun 06, 2024 pm 01:02 PM
Using predefined time zones in Go includes the following steps: Import the "time" package. Load a specific time zone through the LoadLocation function. Use the loaded time zone in operations such as creating Time objects, parsing time strings, and performing date and time conversions. Compare dates using different time zones to illustrate the application of the predefined time zone feature.
