Solved

MySQL Synchronisation

Posted on 2012-04-01
2
291 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
move records one table to another 14 58
how to get total ticket count on days wise using mysql 24 54
mysql left join sentence 7 36
MySql hide the stored procedures 2 40
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 …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

863 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

24 Experts available now in Live!

Get 1:1 Help Now