89578
Using MySQL Proxy
There are a number of different ways to use MySQL Proxy. At the most basie level, you can allow
MySQL Proxy to pass queries from clients to a single server. To use MySQL Proxy in this modę, you
just have to specify on the command linę the backend server to which the proxy should connect:
3hell>mysql-proxy —proxy-backend-addresses=sakila: 3306
If you specify multiple backend MySQL servers, the proxy connects each Client to each server in a
round-robin fashion. Suppose that you have two MySQL servers, A and B. The first Client to connect is
connected to server A, the second to server B, the third to server A. For example:
3hell>niy3ql-proxy \
—proxy-backend-addresses=narcissus:3306 \
—proxy-backend-addresses=nostrorr»: 3306
When you specify multiple servers in this way, the proxy automatically identifies when a MySQL server
has become unavailable and marks it accordingly. New connections are automatically attached to a
sen/er that is available, and a warning is reported to the standard output from
mysql-proxy:
netwórk-mysqld.c.367: connect(nostromo:3306) failed: Connection refused network-mysqld-proxy.c.2405: connecting to backend (nostromo:3306) failed, marking it as down for ...
Lua Scripts enable a finer level of control, both over the connections and their distribution and how
queries and result sets are processed. When using an Lua script, you must specify the name of the
script on the command linę using the —proxy-lua-script [1937] option:
shell>mysql-proxy —proxy-lua-script=mc.lua —proxy-backend-addresses=sakila:3306
When you specify a script, the script is not executed until a connection is madę. This means that faults
with the script are not raised until the script is executed. Script faults will not affect the distribution of
queries to backend MySQL servers.
Wyszukiwarka
Podobne podstrony:
Using MySQL and memcached with Ruby There are a number of different modules for interfacing to memca
Using GTlDs for Failover and Scaleout There are a number of techniques when using MySQL Replication
Step Four STEP FOURPost YourJob While there are a couple of different Online sites to hire V.A.s, on
tape-recorded conversations. In excerpt (4), for instance, there are a number of markings which are
work on national or regional issues. WWF works witli a large number of different groups to achieve i
TOWN OF WEJHEROWO Owing to its suitable location at the Gdynia-Szczecin route and its connection wit
PG038 76 FoodJapanese Food There are a great number of different kinds of eating places in Japan. Am
Installing MySQL on HP-UX MySQL for HP-UX is available in a number of differenl forms: •
memcached Deployment When using memcached you can use a number of different potential deployment str
IB0 4. Kicking to The Head - Upper Level Kicks There are a variety of kicks depending on the t
memcached Hashing/Distribution Types The memcached Client interface supports a number of different
421 (10) 394 IJress Accessories Variations between/within object categories A number of different ob
physics and relashioships topic-specific vocabularyPhysical appearance Taik 2. There are loti of Eng
Even a Monkey?n Draw Manga v01 p037 M A N GV I C E JudgementOO Misusing Idens? There are a lot of ma
attachment (2) - Daily FOREX B=138.36 A=138.40 Hi=138.46 Lo=138.28 there are a t
NutsóVolts Zetecs - there are thousands of them around. but most are pretty slow. Check out this gui
individual lives; and there are pockets of severe deprivation within the United States) but the U.S.
więcej podobnych podstron