From: shayne.alone@gmail.com Date: January 7 2013 8:28pm Subject: Replicating on multiple Slaves DB from one Master List-Archive: http://lists.mysql.com/replication/2406 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=14dae9cfcea4a08ea404d2b8aeb7 --14dae9cfcea4a08ea404d2b8aeb7 Content-Type: text/plain; charset=UTF-8 Dears; I have been faced with a case of replication which may most of you had been faced before... I did some checks and test to find out the ways to solve, but I'm not pretty sure about the cons and pron. problems is as fallow: Master: Single Mysql with about ~30K QPS, mainly just work as AAA data back end. not all but lots of these queries are writes (INSERT/UPDATE). the matter is that when the slave wants to execute Transactions with one thread! this will lead to a lots of replication delay... I'm looking for a way to rewrite DB user for queries depend on table name and not just rename whole of statements. is such away! i hope be able to use Multi thread replication ability of mysql5.6 for a single DB and multiple independent tables. -- Regards, Ali R. Taleghani --14dae9cfcea4a08ea404d2b8aeb7--