469,282 Members | 1,606 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

Master - Slave Replication on specific rows of table

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
1 1067
Niheel
2,429 Expert Mod 2GB
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.

Similar topics

reply views Thread by Tom Roos | last post: by
reply views Thread by flubdgub | last post: by
reply views Thread by Winston Ng | last post: by
reply views Thread by stefanjohansson_2005 | last post: by
1 post views Thread by Ambica Jain | last post: by
ram09
3 posts views Thread by ram09 | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.