Solved

MySQL Synchronisation

Posted on 2012-04-01
2
284 Views
Last Modified: 2012-06-27
I have a client with a MySQL DB running on his local office server. He needs to give some remote users access to certain info on this DB but doesnt wish to give them direct access to the DB.
Instead, he wishes, if possible, to synchronise the DB to a remote location and give them access to this instead. Is it possible to sync MySQL DB's like this? (preferably having a live copy of his office db on a remote location with each change at his local db - or alternatively, synchronise every hour / day / whatever the case)
0
Comment
Question by:osirion
2 Comments
 
LVL 11

Accepted Solution

by:
SANDY_SK earned 500 total points
ID: 37793333
yes you can do that using replication in mysql...

have a look at this link http://dev.mysql.com/doc/refman/5.0/en/replication.html
0
 

Author Closing Comment

by:osirion
ID: 37793378
Sounds like exactly what I need - thanks.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now