On Thu, Jun 7, 2012 at 12:59 PM, Yves Dorfsman <[email protected]> wrote: > On 2012-06-07 06:37, Jonathan Bayer wrote: >> >> We are trying to set up a load-test environment, which will replicate our >> production environment as much as possible. A problem we are having is how >> to >> simulate 4 MySql replicated slaves off of a single master. Due to expense, >> we >> are trying to avoid having to get 4 additional database boxes. Due to the >> size >> of the database, we can't have multiple copies on a single server and run >> multiple instances. >> >> Is there any easy way to simulate multiple slaves, in that the load the >> slaves >> put on the master is replicated? > > > Do you guys have a VM infrastructure? > Could you burst out to an external VM infrastructure (EC2, linode etc..)?
If you don't have the external bandwidth to do that, you might look into replicating/replaying the TCP traffic of a single slave against the master. I've never used this technique for MySQL, but something like tcprelay (http://tcpreplay.synfin.net/) might work. You would clearly have to use the included tool tcpreplay-edit tool in order to mimic multiple slaves. I suspect there might be some state related issues in the MySQL protocol as well that would make doing this problematic, but it might be worth a look. If you do get it to work, writing it up for the rest of us would be appreciated... Good Luck, Bill Bogstad _______________________________________________ Discuss mailing list [email protected] https://lists.lopsa.org/cgi-bin/mailman/listinfo/discuss This list provided by the League of Professional System Administrators http://lopsa.org/
