MYSQL Help

waso_dude · 17 Feb 2014 at 11:53

Being a bit of a noob at mysql I'm looking for some help.

I want to be able to replicate data between 2 data bases.

The 2 databases have the same structure. I want to be able to replicate some of the data from 1 table in 1 DB to another DB with a table of same name.

This will start off with 2 databases, and soon be expanded to more databases.

I'd like to be able to make it so if 1 database gets a change this data that is replicated is transferred between all of the databases.

Anyone know if this is possible?

Makhaira · 17 Feb 2014 at 12:08

You want to run a periodic script, possibly via cronjob, which will do a simple MySQL copy statement.

shine · 17 Feb 2014 at 12:11

Have a look at MySQL replication:

http://dev.mysql.com/doc/refman/5.6/en/replication.html

Tutorial:

http://www.howtoforge.com/mysql_database_replication

planty · 17 Feb 2014 at 12:54

As shine says, MySQL already has some replication features, so use them.

waso_dude · 17 Feb 2014 at 15:38

shine said:
Have a look at MySQL replication:

http://dev.mysql.com/doc/refman/5.6/en/replication.html

Tutorial:

http://www.howtoforge.com/mysql_database_replication

how hard is this to implement? Does this work like linking access databases so data is instant replication?

shine · 17 Feb 2014 at 16:43

Have a read of the tutorial and manual - IMHO is it fairly straightforward. It sounds like you may have multiple instances of a DB you want to keep in sync. If that is the case MySQL has extended this functionality in the latest dev version.

http://www.mysqlperformanceblog.com/2013/10/02/mysql-5-7-multi-source-replication/

Frank_Rizzo · 23 Feb 2014 at 21:01

If only one is a master and the other are slaves and you do not need realtime updates than keep it simple.

As suggested earlier just copy the the master table to the slave(s) all at once at regular intervals.