Hope you are all having a Happy Christmas.
Regards
Peter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Dante,
On Tue, Dec 22, 2009 at 3:53 PM, Dante Lorenso da...@lorenso.com wrote:
All,
There was a feature of another DB that I have grown extremely accustomed to
and would like to find the equivalent in MySQL:
UPDATE mytable SET
mycolumn = mycolumn + 1
WHERE mykey = 'dante'
RETURNING
Miguel,
On Sun, Dec 20, 2009 at 6:21 PM, Miguel Angel Nieto
cor...@miguelangelnieto.net wrote:
Hi,
I am searching fot a Mysql Load Balacing tool. I read about mysql
proxy, sqlrelay, haproxy...
Load balancing, or high availability?
I do not think there is anything good and simple AND generic
Guten Tag/Bonjour/Hello Pete
Haben Sie ein gutes Weihnachten/Ayez bon Noël/Have a good Christmas
Staaten von Amerika/Etats Unis/United States of America
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
On Fri, 25 Dec 2009 15:41:40 +0800 Eva said:
Hello,
I have a table, say its stru is like:
domain ip noticed
The column noticed is an enum value (eigher 0 or 1).
When process one update ip, it will set noticed to 0.
Then process two know the status changed, it will do
Load balancing, or high availability?
I do not think there is anything good and simple AND generic out of
the box. As previous posters have noted, you generally have to build
something on top of other tools.
Hi,
I have the HA solved with MMM. Now, I want load balacing, sending read
queries
2009-12-26 2:36, Don Read :
Change noticed to enum('new', 'scan', 'done') not null default 'new';
When proc two runs, it should
UPDATE noticed='scan' WHERE noticed='new'
Then repeat the scan with SELECT ... WHERE noticed='scan'
...
and finally it should UPDATE domain=whatever, ...
Baron:
Load balancing, or high availability?
I do not think there is anything good and simple
We use MySQL master-master replication to keep
geographically separated databases in sync.
It works very well.
We built a management layer on top of it to allow
the endpoints (Web servers) to talk
On Sat, 26 Dec 2009 10:43:55 +0800 Eva said:
2009-12-26 2:36, Don Read :
Change noticed to enum('new', 'scan', 'done') not null default 'new';
When proc two runs, it should
UPDATE noticed='scan' WHERE noticed='new'
Then repeat the scan with SELECT ... WHERE noticed='scan'
...