Indeed Brian did :)
But, to your point, I suppose that method does work, although it seems
a bit more complicated. Another nice thing is that the scheduled tasks
are attached to the database, making a migration much more trivial. Of
course, there's plenty of other things to schedule other than DB
maintenance so it doesn't completely solve the problem (nor should it
really) but I like it.
To each one's own, though. Brian seems to think that it would be a
fairly easy add-on to implement as a plugin. Man I love plugins! :)
On Apr 27, 2009, at 9:34 AM, Jeremy Zawodny wrote:
Hi Tim,
It's interesting to see the variety of ways people solve that
problem. The
most common one I've seen is for cron jobs to run on both (assuming
two)
hosts and for the passive one ot exit early on once it realizes that
it's
not running on the active master.
But I can certainly see your point. I'm sure Brian or someone else
will
chime in and say whether it'd be reasonable to implement some sort of
scheduler plug-in.
Jeremy
On Mon, Apr 27, 2009 at 7:26 AM, Tim Soderstrom
<[email protected]>wrote:
Awe I like the Event Scheduler :P That's one of my favorite MySQL 5.1
features. I know, I know, "it's called cron". Yes, I know that :)
But if the
task is database specific, it would make sense to use the event
scheduler.
Consider the case of a hot/cold cluster (ie DRBD). You cannot run the
cron-jobs on the passive node. So you either need to disable cron,
or push
the scheduled tasks to your web-server or even your application.
*shrug* I dunno how much the event scheduler slows things down, but I
definitely find it useful. Note that I would expect Drizzle to
implement it
(at least in the core) but just my $0.02 since you dissed it in
your slides
:)
Tim S.
On Apr 27, 2009, at 8:59 AM, Jeremy Zawodny wrote:
A few folks asked about this on Friday. I've posted the slides
from my
talk
"What Craigslist wants and needs from Drizzle" on my blog:
http://jeremy.zawodny.com/blog/archives/011104.html
and they're on Google Docs too:
http://docs.google.com/Presentation?id=d4bggd2_27ccs7kqfn
Thanks for a good developer day... I had a good time and learned a
lot
too.
Jeremy
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss
>
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss
>
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
