This is a discussion on Synchronise DBs within the Coding Help forums, part of the Webmaster Help category; Hi folks, I have two sites with their own DBs. When something happens on one site, i want to update ...
| |||||||
| Register | Forum Rules | FAQ | Donate | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi folks, I have two sites with their own DBs. When something happens on one site, i want to update the DB on the other site. Trouble is the DBs seem to be on different servers. What are my options? Ideally I would like the update to occur instantly, but I could live with it if it were to happen daily. How can I do this? Get site 1 to write a db script and set up a chron job on the other to suck it in? That seems messy. But how would I get the file from account 1 on server A to account 2 on server B? Thanks in advance folks |
| |||||
| So is one of the databases always sending data to the other or is it going in both directions? |
| ||||
| Going in both directions actually... I've been thinking... I've probably been making this more complicated than it needs to be... I guess there's no reason I can't have both sites talking to both databases... I assume it's just a matter of the db server accepting connections from the ip address of both sites? |
| ||||
| Any chance you could get away with just one database which both sites access? It seems that most of the complication comes from having 2 DBs! I suppose this would only be an option if there were a lot of shared data between the two... Which DBMS are you using? some have special tools for syncing DBs - but it's always going to be rather complicated! |
| Tags |
| dbs, synchronise |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| | ![]() | |||
| | ||||