| List: | Replication | « Previous MessageNext Message » | |
| From: | shayne.alone@gmail.com | Date: | January 7 2013 8:28pm |
| Subject: | Replicating on multiple Slaves DB from one Master | ||
| View as plain text | |||
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 <a.taleghani@stripped>
| Thread | ||
|---|---|---|
| • Replicating on multiple Slaves DB from one Master | shayne.alone@gmail.com | 7 Jan 2013 |
| • RE: Replicating on multiple Slaves DB from one Master | Rick James | 7 Jan 2013 |
| • Re: Replicating on multiple Slaves DB from one Master | shayne.alone@gmail.com | 8 Jan 2013 |
| • Re: Replicating on multiple Slaves DB from one Master | Alex Yurchenko | 8 Jan 2013 |
| • Re: Replicating on multiple Slaves DB from one Master | shayne.alone@gmail.com | 8 Jan 2013 |
| • RE: Replicating on multiple Slaves DB from one Master | Rick James | 8 Jan 2013 |
| • Re: Replicating on multiple Slaves DB from one Master | Manuel Arostegui | 10 Jan 2013 |
| • Re: Replicating on multiple Slaves DB from one Master | Simon J Mudd | 10 Jan 2013 |
