MySQL Proxy
am 05.02.2010 23:32:34 von Wagner Bianchi--0016e6d77de92bad94047ee20751
Content-Type: text/plain; charset=ISO-8859-1
Hi friends,
Recently I accept an idea of testing a MySQL Proxy to concept an environment
that will use two slave servers below it.Ok, the theory is good and I decide
to try this, but, when I began to test step-by-step the MySQL Proxy manual I
felt that somenthing was wrong.
In first time, I started MySQL proxy with "mysql-proxy
--proxy-read-only-backend-addresses=localhost:3306" and connected with mysql
server using "mysql -u root -p -P 4042" only to test readOnly behavior...so,
I had inserted some lines and updated too - I read on the manual that port
4042 is a readOnly port that filters UPDATE and INSERT and I didn't saw this
behavior.
Ok, I looking forward on the manual yet, I read about the "mc.lua", Is that
script exists? I don't know, cause I going on with tests, in this time,
starting mysql-proxy with "mysql-proxy
--proxy-read-only-backend-addresses=localhost:3306
--proxy-lua-script=mc.lua" and made all tests again with port 4042. Once my
tests fail.
Anybody here use this and MySQL-Proxy function?
Anybody can give some explanation how does it works?
Thanks in advanced.
Wagner Bianchi
--0016e6d77de92bad94047ee20751--