-
The Hiphopopotamus
- Rep Power
- 10
Re: RDMS Design Help
Sounds like you have computer A and B with server C. When able (the link is up), computer A & B do a bi-directional sync to server C. Man that REALLY sucks you have to work around the networking issue. I'd think one of the advantages of doing this whole new system would be to have just one database to do queries against, one place to maintain, etc. I guess you're just getting a system in place that's ready to be deployed into multiple locations around the world and there's no single point of failure.
What database server are you going to go with? MySQL, Postgres, Firebird, or something else?
Since you're in the planning stage, I'd start thinking of a way to store your db in the cloud online as the backup to the local backup. You got you grandfather, father, son thing going locally and then an offsite backup, and then your worst case scenario backup...the one in the cloud. One idea could be to export the db into a flat file, 7-zip it (LZMA compression), then encrypt it with PGP (or whatever) or use 7-zip's built-in AES256 encryption. Use SSH to copy it offsite or use something like Carbonite, Dropbox, etc.
http://en.wikipedia.org/wiki/List_of...ackup_services
Will the db server be running Linux? Sounds like you're on a budget so I assume the db is local on each machine and that third machine isn't a server, it's just another windows box in another room.
BuddhaMan -- Showin' the ladies his
"O" face since 1986
Similar Threads
-
By Hexum in forum General Discussion
Replies: 0
Last Post: 12-16-2002, 11:27 AM
-
By =[*NoXIous*]= in forum Graphic or Web Design and Programming
Replies: 1
Last Post: 08-26-2002, 10:41 PM
-
By Jazwana in forum Graphic or Web Design and Programming
Replies: 1
Last Post: 04-27-2002, 11:45 PM
-
By Nicole in forum Graphic or Web Design and Programming
Replies: 3
Last Post: 04-26-2002, 09:56 AM
-
By Jazwana in forum Graphic or Web Design and Programming
Replies: 2
Last Post: 04-22-2002, 01:42 AM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
< Contact Us -
>
Powered by: vBulletin Version
Copyright ©2000, 2001, Jelsoft Enterprises Limited.
Bookmarks