nigel wood wrote:
> Dan Trainor wrote:
>> Dan Trainor wrote:
>>> Hi -
>>> I would like to be able to replicate all queries from a live MySQL
>>> server, to a testing server at the office.
>>> The reason for doing this is to test load under [semi]real-world
>>> conditions with the new server.
>> Hi -
>> So I was thinking about this more, and then it dawned on me. This is
>> simple MySQL replication.
>> Sorry for wasting the time.
> No, it isn't. Selects aren't replicated nor is the timing true to catch
> contention problems. I've done this recently and whilst I don't have
> time now I'll post my solution tomorrow. Assuming:
> A) Your using *nux
> B) Your application(s) and database are hosted on different machines
> C) You have root access on one of the boxes
> D) You can take a live db snapshot
> It will let you record and playback your database server's load.
Hi, Nigel -
My situation does meet the above requirements, and I would be very
greatful if you were to spend a moment on this tomorrow when you get
time. I look forward to your reply.