On 6/7/12 2:16 PM, Nathan Hruby wrote:
Hi,
If you don't need the data on the slaves at all you can probably use
the blackhole storage engine on the slaves to pull but discard the
data. In earlier version of mysql this would still make it to the
relay log and be available for pullage by other slaves in a chain or
ring. That's not doable anymore, but the blackhole trick to just
emulate replication load should still work.
This sounds like what we need. Basicly, we don't care about the
replicated data, just want to put the load on the master server.
Thanks
JBB
HTH,
-n
On Thu, Jun 7, 2012 at 5:37 AM, Jonathan Bayer
<[email protected]> 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?
Thanks.
JBB
_______________________________________________
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/
_______________________________________________
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/
