Hullo peoples,
I'm not usually an advocate of MySQL Proxy and the like, but I'm stuck with one
shitty application that utterly breaks whenever the database goes away
unexpectedly. I can't change the application itself, so I find myself looking
for options that allow the heathen contraption to
Hi Johan,
I wanted to love mysql-proxy for so many years, so I understand you :)
I have two main questions:
* am I remembering right that MySQL Proxy provides transparent failover ?
You need to use/create a lua failover script, I've never seen or tried one.
What kept me from investing too
Johan,
I don't think there's any need for the heavyness (and ugliness ;) ) of
MySQL Proxy. We're using haproxy for a similar setup (just with galera
behind it, but that shouldn't really matter. Have a look at this blog post
that explains most of it:
I like HAProxy as well as it simplifies many of the things you seem to be
looking for.
--
Wagner Bianchi
Mobile: +55.31.8654.9510
Em 09/07/2014, às 07:48, Heck, Walter walterh...@olindata.com escreveu:
Johan,
I don't think there's any need for the heavyness (and ugliness ;) ) of
MySQL
CC: vegiv...@tuxera.be; mysql@lists.mysql.com
From: wagnerbianch...@gmail.com
Subject: Re: Proxy / connected failover question
Date: Wed, 9 Jul 2014 08:31:05 -0300
To: walterh...@olindata.com
I like HAProxy as well as it simplifies many of the things you seem to be
looking for.
--
- Original Message -
From: Martin Gainty mgai...@hotmail.com
Subject: Proxy / connected failover question
I'm not usually an advocate of MySQL Proxy and the like, but I'm stuck
with one shitty application that utterly breaks whenever the database
goes
away unexpectedly. I
Hi.
mysql describe unions_data;
+-+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-++
| ID | int(11) | NO | PRI | NULL|
The AND in your UPDATE clause makes this a logical operator instead
of being a SQL keyword.
Your syntax is wrong:
UPDATE ...
SET mycol = value,
mycol2 = value
[WHERE ... ]
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL
Hi, all,
In the C API, we can call mysql_query(select 1; select 2);
which just send the command once to the server, and server
return two result sets, So i want to know if there is a command in the
mysqltest framework to do the job?
I want to write a test case like that.
Thank you for your