Going in to this most recent gig, it was thought that it was
going to be a heavy user of MySQL Proxy, which thus would involve
a fair amount of custom Lua programming.
As the client and I talked and whiteboarded out the design, it
evolved into being very complex. It was going to be a challenge,
and had a lot of moving parts.
As big and expensive as it was becoming, it still was much
simpler and cheaper than what *r*cl* had quoted, they wanted a
mid seven digits, PER YEAR, in license fees, for their
proposal.
Anyway, as this thing grew on the board, something started
itching in my head, and I sat back, looked at it again, and said
"we're recreating the binlogs and the replication threads".
The client was very familiar with replication in Oracle and in MS
SQL, but not at all so for MySQL, especially it's robustness in
the face of lag and link failure. E.G, just let them lag, and let
the …
[Read more]