Solved

MySQL Synchronisation

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Creating and Managing Databases with phpMyAdmin in cPanel.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

805 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