Blog This!   Lee Geistlinger's Web Log

Blog Home
Blog Archives
LittleGhost Home

E-mail: geistlinger AT gmail.com

Everyone loves lists Books, Movies and so on

My Online Aggregator

Break All the Windows

For reasons that escape me, timed processes on my Windows box(es) just stop for no good reason. I've mentioned this before; the latest casualty was mySQL replication (Linux box => Windoze box).

I've been using the Windows box mySQL server just for backups, and to get my hand in how to run mySQL on Windows. Useful skill; one of the big pluses of mySQL is that there are native Windows binaries for it.

OK. And replication - which ran fine for over a month - just crapped out.

I couldn't figure it out. Still can't.

So I did what every Windows user does: Re-install the damn code.

Actually, I didn't have the binaries for mySQL, so I got the latest v3 binaries (3.23.58) from a mirror. (I'm running v3.23 on Linux, so just trying to keep conflicts down.)

Installed, did all the set-up - which, since I just did it recently, was a breeze.

But the damn Windows mySQL server kept crashing every time I turned on replication.

After hours of poking and prodding, a Google (thank god for Google and their ilk) search gave me the knowledge that I needed: v3.23.58 on Windoze has, um, replication issues.

There's a work around - don't start as service, make it a stand-alone, set account with privileges for this yada yada yada.

That's bullshit. That's a huge bug (and I don't really know if it's a mySQL or Windows issue).

So I downloaded a v4 binary, installed, turned on replication and ... damn! It works.

Sweet.

And aggravating - once I knew of this replication issue, the entire process - from downloading the 12M (or so) binary file, installing, setting up permissions, cutting data over etc - took about 15 minutes.

I spent hours trying to get something that couldn't work to work.

Who do I bill those hours to???