By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,903 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Master - Slave Replication on specific rows of table

P: 1
I am a not an expert in MySQL world and looking for a solution like

I have a table for example:

issue_table
=============
id, issue_from, details
1, machine1, "some details"
2, machine1, "some details again"
3, machine2, "some details"
4, machine2, "some details"

Is it possible to setup a master slave replication where, where I can
filter what data goes to which slave? In simple terms, after
replication I would like something like:

slave1.issue_table
===============
id, issue_from, details
1, machine1, "some details"
2, machine1, "some details again"

slave2.issue_table
=================
id, issue_from, details
3, machine2, "some details"
4, machine2, "some details"

Is replication the right tool to do this kind of work? Or there is a
better design to handle such problems.
I have read something that it is possible only by partitioning the table in the older versions of MySQL.
Is there any advancement in latest versions of MySQL ( 5.6 or 5.7 ) for such kind of replication.

Even a pointer to the right tutorial/document would be helpful.
Nov 19 '13 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 100+
P: 2,327
Replication will replicate all of the data. Master / Slave are basically full copies.

What you are talking about is more like sharding or partitioning. Where the data is stored across multiple machines. The best way to shard is to do in the application code.


MySQL offers partitioning built in. Here is more information
http://dev.mysql.com/doc/refman/5.1/...-overview.html

There info there on how to find out if your db supports partitioning
http://dev.mysql.com/doc/refman/5.1/...titioning.html
Nov 27 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.