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=
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
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, ... noticed
> 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
que
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
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é
Dies
Miguel,
On Sun, Dec 20, 2009 at 6:21 PM, Miguel Angel Nieto
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 out of
the box. As pre
Dante,
On Tue, Dec 22, 2009 at 3:53 PM, Dante Lorenso 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 mycolumn;
I
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
