Jake Peavy wrote:
On 5/24/06, *Dan Trainor* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]