On 5/24/06, Dan Trainor <dan@stripped> 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. I think that by doing something like
> this, I would be able to fine-tune the new server in preparation for
> replacing the original server.
>
> So what I can't figure out right now is how to set up a situation like
> this, where the live server would replicate every one of it's queries to
> the testing machine, and have the testing machine not respond with
> anything - just simply mow through the queries.
>
> The testing server will have a snapshot of the live database, so I will
> ahve data to work with. However, the testing machine is on a private
> internal subnet, and I don't see how this type of setup would work from
> a logical MySQL standpoint.
>
> Keeping all this in mind, also remember that I cannot change any of the
> code which references the MySQL server. I need to be able to do this
> using some native MySQL function.
>
> Any feedback would be greatly appreciated. I look forward to all your
> responses.
>
> Thanks!
> -dant
>
Big Dan T?
I haven't done it, but I think what you need to do is
1. enable binlog on the live DB
2. transfer the binlogs from some period of time over to your test
server
3. pipe the queries contained in the binlog into your test server,
something along the lines of: $ mysqlbinlog bin_file_from_live_db.0001 |
mysql
HTH,
--
-jp
Filming on location for Walker: Texas Ranger, Chuck Norris brought a
stillborn baby lamb back to life by giving it a prolonged beard rub. Shortly
after the farm animal sprang back to life and a crowd had gathered, Chuck
Norris roundhouse kicked the animal, breaking its neck, to remind the crew
once more that Chuck giveth, and the good Chuck, he taketh away.
