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
AI Hentai Generator
Generate AI Hentai for free.
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
1376
52
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.
Comparison of advantages and disadvantages of golang framework
Jun 05, 2024 pm 09:32 PM
The Go framework stands out due to its high performance and concurrency advantages, but it also has some disadvantages, such as being relatively new, having a small developer ecosystem, and lacking some features. Additionally, rapid changes and learning curves can vary from framework to framework. The Gin framework is a popular choice for building RESTful APIs due to its efficient routing, built-in JSON support, and powerful error handling.
What are the best practices for error handling in Golang framework?
Jun 05, 2024 pm 10:39 PM
Best practices: Create custom errors using well-defined error types (errors package) Provide more details Log errors appropriately Propagate errors correctly and avoid hiding or suppressing Wrap errors as needed to add context
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.
How to solve common security problems in golang framework?
Jun 05, 2024 pm 10:38 PM
How to address common security issues in the Go framework With the widespread adoption of the Go framework in web development, ensuring its security is crucial. The following is a practical guide to solving common security problems, with sample code: 1. SQL Injection Use prepared statements or parameterized queries to prevent SQL injection attacks. For example: constquery="SELECT*FROMusersWHEREusername=?"stmt,err:=db.Prepare(query)iferr!=nil{//Handleerror}err=stmt.QueryR
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].
