Bug #47501 don't set the database read only

• Submitted: 22 Sep 2009 2:23
• Modified: 7 Feb 2010 17:11
• Reporter: Liu Lizhi
• Status: Closed
• Category: MySQL Proxy: Install/Config
• Severity: S5 (Performance)
• Version: 0.6.0, 0.8.0
• OS: Other
• Assigned to: MC Brown
• CPU Architecture: Any

[22 Sep 2009 2:23] Liu Lizhi

Description:
i use mysql-proxy version is 0.6.0,when i use mysql-proxy --proxy-read-only-backend-addresses=127.0.0.1:3306 is don't control is mysql read only.please tell me how config the mysql-proxy database,thanks

system :ubuntu 9.0
mysql-proxy:0.6.0
mysql:5.0.7

How to repeat:
i use mysql-proxy version is 0.6.0,when i use mysql-proxy --proxy-read-only-backend-addresses=127.0.0.1:3306 is don't control is mysql read only.please tell me how config the mysql-proxy database,thanks

system :ubuntu 9.0
mysql-proxy:0.6.0
mysql:5.0.7

[23 Sep 2009 7:08] Sveta Smirnova

Thank you for the report.

I think documentation should be updated: you still has proxy-backend-addresses which is default to 127.0.0.1:3306, but from documentation is not clear how to proxy-read-only-backend-address works exactly.

[25 Nov 2009 16:13] Enterprise Tools JIRA Robot

Mark Leith writes: 
Please document that this option can not be used without extra scripting, along with the variable documentation

[7 Feb 2010 17:11] MC Brown

The documentation has been updated to explain the use of this option and the role of the type in scripts.