Jake Peavy wrote:
> On 5/24/06, *Dan Trainor* <dan@stripped <mailto: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
Hi, Jake -
This would certainly work. However, I'd like to do all of this as close
to real-time as I possibly can. I don't think that I can get an
accurate representation of load if I just throw it on the new machine
that way.
Thanks though!
-dant
