Re: [WebDNA] backup / mirror website & databases
This WebDNA talk-list message is from 2018
It keeps the original formatting.
numero = 114194
interpreted = N
texte = 1797I'm currently setting up two servers for one of my clients, a mainserver and a clone that I will call the backup server. They willreside in different data centers, one East Coast, one West.I'll run a WebDNA script via trigger on the backup that flushesdbs on the main, then duplicates the main dbs to a separate folderevery hour. Rsync then pulls the main dbs from this folder.If rsync can't connect to the main my script will text me. ThenI'll check to see if the main has gone down. If so I'll point myDNS to the backup until the main is online again.Since the main is not expected to go down very often, an houroffline for server switching and DNS propagation doesn't bother myclient, especially when I can implement this solution at low cost.The benefit are (1) constant backups in native file format, (2) abackup that's ready to take over for the main 24/7, and (3) abackup that's immune to physical disaster on the main.Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server Administration> In the past I've had 2 physical servers running. A primary and> a backup. They were joined by Gluster so that in the event the> primary went down for some reason the backup took over without> the need of downtime to restore from the last nightly backup> that would be missing current days activity.> > My 2 most powerful servers (16GB RAM & dual quad core> processors) are getting old. I've recently upgraded drives to> SSD's, replaced power supplies and batteries. I want to only> have 1 powered up and the other to be a cold spare.> > I want to run 2 virutal web servers running on one physical> server. One serving to the public and the other running and be> an up to date copy and in the event something such as a hack> occurred on the primary virtual server where I could just> change the IP address in the router to send all web traffic to> the backup server's IP.> > I would like to have rsync run once every hour so the process> time will be minimal and the most data that would be lost would> be the last hour. Then after the 1:00AM rsync have a script> create a tar backup file of the directories and databases> located on the backup server to a directory on a NAS as the> days backup.---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=55Bug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
1797I'm currently setting up two servers for one of my clients, a mainserver and a clone that I will call the backup server. They willreside in different data centers, one East Coast, one West.I'll run a WebDNA script via trigger on the backup that flushesdbs on the main, then duplicates the main dbs to a separate folderevery hour. Rsync then pulls the main dbs from this folder.If rsync can't connect to the main my script will text me. ThenI'll check to see if the main has gone down. If so I'll point myDNS to the backup until the main is online again.Since the main is not expected to go down very often, an houroffline for server switching and DNS propagation doesn't bother myclient, especially when I can implement this solution at low cost.The benefit are (1) constant backups in native file format, (2) abackup that's ready to take over for the main 24/7, and (3) abackup that's immune to physical disaster on the main.Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server Administration> In the past I've had 2 physical servers running. A primary and> a backup. They were joined by Gluster so that in the event the> primary went down for some reason the backup took over without> the need of downtime to restore from the last nightly backup> that would be missing current days activity.> > My 2 most powerful servers (16GB RAM & dual quad core> processors) are getting old. I've recently upgraded drives to> SSD's, replaced power supplies and batteries. I want to only> have 1 powered up and the other to be a cold spare.> > I want to run 2 virutal web servers running on one physical> server. One serving to the public and the other running and be> an up to date copy and in the event something such as a hack> occurred on the primary virtual server where I could just> change the IP address in the router to send all web traffic to> the backup server's IP.> > I would like to have rsync run once every hour so the process> time will be minimal and the most data that would be lost would> be the last hour. Then after the 1:00AM rsync have a script> create a tar backup file of the directories and databases> located on the backup server to a directory on a NAS as the> days backup.---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=55Bug Reporting: support@webdna.us.
Kenneth Grome
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
using WebCat for Associate Programs? (1998)
PCS search results page (1998)
XML version of WebDNA docs? (2000)
WebCatalog [FoundItems] Problem - LONG - (1997)
What am I missing (1997)
[WebDNA] showif/sendmail question (2008)
Where's Cart Created ? (1997)
how do we turn off staticpages page creation? (2003)
service stop and restart (1997)
Next X hits (1996)
Location of Browser Info.txt file (1997)
Date search - yes or no (1997)
WebCatalog [FoundItems] Problem - LONG - (1997)
[WebDNA] html email.. should be a no-brainer.. but it is not parsing. (?) (2010)
WebCat for Site Search? (1997)
ODBC-Interface (2000)
Follow-up to listfiles bug report ... (2003)
The IBC root beer has arrived! (1997)
!@#$$@@# formulas database, tax and freight. (2002)
form data submission gets truncated (1997)