current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free.
up vote -1 down vote favorite

my IT boss wanted this scenario to be undertaken: First, we develop an Alumni program using PHP and deploy this in the web server which can be accessed by that school alumni in the web to update their personal data anytime. Then, using exactly that SAME program we must also deploy this locally, thru the LAN in its satellite campus which is far and have a very erratic and unreliable internet connection. The purpose is that that the latter system (in LAN) can still be used to add new alumni data even during "offline" periods, and then, once the internet signal is OK, or now being "online" to just upload these offline-generated data in MySQL to the web server hosting THE SAME software program. How do we do a seamless data transfer then of this MySQL database - from the LAN to the web server - once the online signal is now steady? Thanks for any advice...

share|improve this question
    
this post is rather hard to read (wall of text). Would you mind editing it into a better shape? –  gnat Apr 4 '14 at 17:19

1 Answer 1

up vote -1 down vote

A good start might be to look at MySQL replication.

Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous - slaves need not be connected permanently to receive updates from the master. This means that updates can occur over long-distance connections and even over temporary or intermittent connections such as a dial-up service. Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database.

For more info, see https://dev.mysql.com/doc/refman/5.0/en/replication.html

share|improve this answer
    
Hi Reaan, please advice further: will this process overwrite the MySQL data in the master-server or will it only ADD the new records in the master-server as inputted from the slave server? –  user125868 Apr 4 '14 at 17:29
1  
Doesn't the question indicate that "synchronous" replication is required since the internet site needs to be completely replaced by the LAN site when not unavailable? According to your link, MySQL only does this with their Cluster. –  JeffO Apr 4 '14 at 17:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.