Re: Replicating queries to testing server

2006-06-14 Thread Atle Veka
Replicating a live setup, especially one running on the web is extremely difficult if not near impossible. Assuming you don't have the freedom to stop/start your mysqld for tuning/tweaking, here are some things you can do: - Enable slow-query-log - Enable query log - Query processlist periodically

Re: Replicating queries to testing server

2006-06-14 Thread Dan Trainor
Atle Veka wrote: Replicating a live setup, especially one running on the web is extremely difficult if not near impossible. Assuming you don't have the freedom to stop/start your mysqld for tuning/tweaking, here are some things you can do: - Enable slow-query-log - Enable query log - Query

Re: Replicating queries to testing server

2006-06-13 Thread Dan Trainor
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

Re: Replicating queries to testing server

2006-06-13 Thread Jake Peavy
On 5/24/06, Dan Trainor [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

Re: Replicating queries to testing server

2006-06-13 Thread Dan Trainor
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

Re: Replicating queries to testing server

2006-06-13 Thread Scott Tanner
On Tue, 2006-06-13 at 19:04, Dan Trainor wrote: 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.

Replicating queries to testing server

2006-05-24 Thread Dan Trainor
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

Re: Replicating queries to testing server

2006-05-24 Thread Dan Trainor
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. I think that by doing something like this, I would be able

Re: Replicating queries to testing server

2006-05-24 Thread nigel wood
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

Re: Replicating queries to testing server

2006-05-24 Thread Dan Trainor
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