MySQL Proxy应用:读写分离

前一阵子看到了MySQL Proxy这个东西出世，就推断将会从这个玩艺发展出很多架构方面翻新的花样，还没来得及研究，这就有人有研究成果了。

如下图：

Mysql proxy r/w split

通过MySQL Proxy实现一个连接池，并在其中分辩客户端连接为读或写操作，将不同操作导向到不同的后端数据库服务器，来实现性能的提升。

具体实现方法和步骤参考原文：

http://jan.kneschke.de/2007/8/1/mysql-proxy-learns-r-w-splitting

This entry was written by dawnh, posted on October 18, 2007 at 4:09 pm, filed under Networking and tagged , , . Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

One Comment

  1. fcicq CHINA
    Posted October 19, 2007 at 10:00 pm | Permalink

    ms还有篇中文翻译,from infoq

    http://www.infoq.com/cn/news/2007/10/mysqlproxyrwsplitting

One Trackback

  1. By How To Start A Blog UNITED STATES on October 31, 2007 at 11:00 pm

    How To Start A Blog…

    I couldn’t understand some parts of this article, but it sounds interesting…

Post a Comment

Your email is never published nor shared.