Re: [WebDNA] backup / mirror website & databases
This WebDNA talk-list message is from 2018
It keeps the original formatting.
numero = 114191
interpreted = N
texte = 1794 Hi Donovan, In the past I've had 2 physical servers running. A primary and a backup.=20 They were joined by Gluster so that in the event the primary went down=20 for some reason the backup took over without the need of downtime to=20 restore from the last nightly backup that would be missing current days=20 activity. My 2 most powerful servers (16GB RAM & dual quad core processors) are=20 getting old.=C2=A0 I've recently upgraded drives to SSD's, replaced power= =20 supplies and batteries. I want to only have 1 powered up and the other=20 to be a cold spare. I want to run 2 virutal web servers running on one physical server. One=20 serving to the public and the other running and be an up to date copy=20 and in the event something such as a hack occurred on the primary=20 virtual server where I could just change the IP address in the router to=20 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=20 be minimal and the most data that would be lost would be the last hour.=20 Then after the 1:00AM rsync have a script create a tar backup file of=20 the directories and databases located on the backup server to a=20 directory on a NAS as the days backup. Do you see any issues with this? Thanks, Steve On 04/19/2018 01:38 PM, Donovan Brooke wrote: > It shouldn=E2=80=99t be necessary... but i think ultimately it depends = on your setup. If you are doing =E2=80=9Calmost real-time=E2=80=9D backup= s, their could be a performance impact, and at that point, you may want t= o consider RAID. Is there a reason you need =E2=80=9Creal-time=E2=80=9D b= ackups? > > D. Brooke Mobile > >> On Apr 19, 2018, at 12:03 PM, webdna
wrote: >> >> Hi Donovan, >> >> I've been using rsync but the guy who used to help me with my servers = insisted I had to stop webdna first so the databases were not being writt= en to and then run rsync. Once files were synced DNA was restarted. Is it= not necessary to stop WebDNA during the sync process ? >> >> Also, could you comment on this: >>> In the "User Submitted Tips & Tricks" section there is an example to >>> backup databases by a simple [COPYFILE]: >>> http://www.webdna.us/page.dna?numero=3D54 >>> ?? Does the example Lock the databases while being copied or is it >>> assumed the databases are not currently in use? >> Thanks! >> >> >>> On 04/19/2018 10:59 AM, dbrooke@euca.us wrote: >>> If all you want is a backup, One option is an RSYNC script. >>> >>> From the man page: >>> DESCRIPTION >>> Rsync is a fast and extraordinarily versatile file copyin= g tool. It can copy locally, to/from another host over any remote shell,= or >>> to/from a remote rsync daemon. It offers a large number of o= ptions that control every aspect of its behavior and permit very flexib= le >>> specification of the set of files to be copied. It is fa= mous for its delta-transfer algorithm, which reduces the amount of data s= ent >>> over the network by sending only the differences between the = source files and the existing files in the destination. Rsync is widel= y >>> used for backups and mirroring and as an improved copy comman= d for everyday use. >>> >>> Rsync finds files that need to be transferred using a "quick = check" algorithm (by default) that looks for files that have changed in s= ize >>> or in last-modified time. Any changes in the other preserved= attributes (as requested by options) are made on the destination fi= le >>> directly when the quick check indicates that the file=E2=80=99= s data does not need to be updated. >>> >>> >>> There are other paid versions of backup utilities, but this one is fr= ee. >>> >>> Donovan >>> >>> >>> >>>> On 2018-04-18 19:11, webdna wrote: >>>> Hi All, >>>> >>>> Looking for suggestions to backup and/or mirror website and WebDNA >>>> databases in real time if possible. >>>> >>>> In the "User Submitted Tips & Tricks" section there is an example to >>>> backup databases by a simple [COPYFILE]: >>>> http://www.webdna.us/page.dna?numero=3D54 >>>> ?? Does the example Lock the databases while being copied or is it >>>> assumed the databases are not currently in use? >>>> >>>> I've previously had 2 physical servers running using Gluster in our >>>> DMZ. I want to only have one physical machine running and having >>>> backups or synched copies of the site and databases reside on a NAS = or >>>> a server within our LAN. >>>> >>>> Thanks! >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list talk@webdna.us >>> To unsubscribe, E-mail to: talk-leave@webdna.us >>> archives: http://www.webdna.us/page.dna?numero=3D55 >>> Bug Reporting: support@webdna.us >> --=20 >> Steve Raslevich >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list talk@webdna.us >> To unsubscribe, E-mail to: talk-leave@webdna.us >> archives: http://www.webdna.us/page.dna?numero=3D55 >> Bug Reporting: support@webdna.us > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us > archives: http://www.webdna.us/page.dna?numero=3D55 > Bug Reporting: support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us .
Associated Messages, from the most recent to the oldest:
1794 Hi Donovan, In the past I've had 2 physical servers running. A primary and a backup.=20 They were joined by Gluster so that in the event the primary went down=20 for some reason the backup took over without the need of downtime to=20 restore from the last nightly backup that would be missing current days=20 activity. My 2 most powerful servers (16GB RAM & dual quad core processors) are=20 getting old.=C2=A0 I've recently upgraded drives to SSD's, replaced power= =20 supplies and batteries. I want to only have 1 powered up and the other=20 to be a cold spare. I want to run 2 virutal web servers running on one physical server. One=20 serving to the public and the other running and be an up to date copy=20 and in the event something such as a hack occurred on the primary=20 virtual server where I could just change the IP address in the router to=20 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=20 be minimal and the most data that would be lost would be the last hour.=20 Then after the 1:00AM rsync have a script create a tar backup file of=20 the directories and databases located on the backup server to a=20 directory on a NAS as the days backup. Do you see any issues with this? Thanks, Steve On 04/19/2018 01:38 PM, Donovan Brooke wrote: > It shouldn=E2=80=99t be necessary... but i think ultimately it depends = on your setup. If you are doing =E2=80=9Calmost real-time=E2=80=9D backup= s, their could be a performance impact, and at that point, you may want t= o consider RAID. Is there a reason you need =E2=80=9Creal-time=E2=80=9D b= ackups? > > D. Brooke Mobile > >> On Apr 19, 2018, at 12:03 PM, webdna wrote: >> >> Hi Donovan, >> >> I've been using rsync but the guy who used to help me with my servers = insisted I had to stop webdna first so the databases were not being writt= en to and then run rsync. Once files were synced DNA was restarted. Is it= not necessary to stop WebDNA during the sync process ? >> >> Also, could you comment on this: >>> In the "User Submitted Tips & Tricks" section there is an example to >>> backup databases by a simple [copyfile]: >>> http://www.webdna.us/page.dna?numero=3D54 >>> ?? Does the example Lock the databases while being copied or is it >>> assumed the databases are not currently in use? >> Thanks! >> >> >>> On 04/19/2018 10:59 AM, dbrooke@euca.us wrote: >>> If all you want is a backup, One option is an RSYNC script. >>> >>> From the man page: >>> DESCRIPTION >>> Rsync is a fast and extraordinarily versatile file copyin= g tool. It can copy locally, to/from another host over any remote shell,= or >>> to/from a remote rsync daemon. It offers a large number of o= ptions that control every aspect of its behavior and permit very flexib= le >>> specification of the set of files to be copied. It is fa= mous for its delta-transfer algorithm, which reduces the amount of data s= ent >>> over the network by sending only the differences between the = source files and the existing files in the destination. Rsync is widel= y >>> used for backups and mirroring and as an improved copy comman= d for everyday use. >>> >>> Rsync finds files that need to be transferred using a "quick = check" algorithm (by default) that looks for files that have changed in s= ize >>> or in last-modified time. Any changes in the other preserved= attributes (as requested by options) are made on the destination fi= le >>> directly when the quick check indicates that the file=E2=80=99= s data does not need to be updated. >>> >>> >>> There are other paid versions of backup utilities, but this one is fr= ee. >>> >>> Donovan >>> >>> >>> >>>> On 2018-04-18 19:11, webdna wrote: >>>> Hi All, >>>> >>>> Looking for suggestions to backup and/or mirror website and WebDNA >>>> databases in real time if possible. >>>> >>>> In the "User Submitted Tips & Tricks" section there is an example to >>>> backup databases by a simple [copyfile]: >>>> http://www.webdna.us/page.dna?numero=3D54 >>>> ?? Does the example Lock the databases while being copied or is it >>>> assumed the databases are not currently in use? >>>> >>>> I've previously had 2 physical servers running using Gluster in our >>>> DMZ. I want to only have one physical machine running and having >>>> backups or synched copies of the site and databases reside on a NAS = or >>>> a server within our LAN. >>>> >>>> Thanks! >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list talk@webdna.us >>> To unsubscribe, E-mail to: talk-leave@webdna.us >>> archives: http://www.webdna.us/page.dna?numero=3D55 >>> Bug Reporting: support@webdna.us >> --=20 >> Steve Raslevich >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list talk@webdna.us >> To unsubscribe, E-mail to: talk-leave@webdna.us >> archives: http://www.webdna.us/page.dna?numero=3D55 >> Bug Reporting: support@webdna.us > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us > archives: http://www.webdna.us/page.dna?numero=3D55 > Bug Reporting: support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us .
webdna
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:
Your Pay (2004)
WC2.0 Memory Requirements (1997)
Best way to add data to .db (1999)
WebDNA Developer Resource Center (2002)
Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
[WriteFile] problems (1997)
Somewhat OT: IE issues (2002)
Categories (2000)
web delivery (1997)
4.5 Upgrade (2003)
Where is f2? (1997)
RE: [redirect] w/o showing args? (1999)
Emailer choke (1997)
Writefile illegal characters ? (2004)
So many lookers, hey smith micro (2003)
WebCat2b13MacPlugIn - More limits on [include] (1997)
When to use [convertchars] ?!?!? (2000)
[WebDNA] PCI fubar (2012)
watch out for format_to_days on NT (1997)
FlushDatabase Suggestion (1998)