Chip, Your redundancy here is impressive but I don’t see anything about cloud backup. Weekly off site backup is nice, but it could be up to a week old when you have fire in your data center. A cloud backup (continuous or other interval) would address that risk.
Another redundancy design which many larger 4D installations use is mirroring via “log shipping” where the 4D .journal file is periodically sent to another 4D server where it is integrated. It can be "almost real time" by using a short period. Then you have a fully functional “warm failover” for very little cost and a tiny bit of management. It requires a server license and a machine. But the machine costs can be mitigated these days by using a VM. And the mirror machine can be anywhere (in the local data center, the building next door, across town, across the continent, on a different continent, planet etc..) Mike mentions mechanical disks for data. Is that because of cost? Maybe his data file is very large (terabytes+)? Tom Benedict > On Sep 12, 2020, at 07:14, nug via 4D_Tech <[email protected]> wrote: > > The setup I was using: > <computer> with whatever specs make you happy. :) > 2x RAID 5 boxes - these to boxes are mirrored (results in RAID 51) > Nightly backup (whole system) to the RAID 51 setup using whatever backup > software you are comfortable with. > > This gives you: > A backup if the system disk fails > A backup if the database disk fails > A backup if one of 1 RAID 5 disks fail > A backup if one disk (in each RAID box) fails > Actually you still have a functioning backup if ALL of the above happens! At > once! > > You an also look for a RAID 6 box (extra protection for disk failure) or RAID > 5 with ‘hot’ spare. > > When you buy disks for the RAID boxes it might be a good idea to buy at least > 1 spare for each box so that they are on hand in case… > > To cover the rest of best practice, 5 external drives with capacity large > enough to hold a copy of the (latest) full backup and updates, which are > updated once weekly, cycled, and moved off site, and 1 to be cycled and moved > off site monthly. > > N.B. : in most cases you can use SSDs as the RAID drives. > > Chip > >> On Sep 12, 2020, at 8:48 AM, Mike Kerner via 4D_Tech <[email protected]> >> wrote: >> >> I just ordered a new server, Win, because we are using ODBC. I ordered it >> like the gaming setups - SSD for the OS and mechanical for data. I hadn't >> thought about adding a third drive for the backups and journal. Any other >> thoughts/tips? >> >> On Fri, Sep 11, 2020 at 7:40 PM Randy Kaempen via 4D_Tech < >> [email protected]> wrote: >> >>> John, >>> >>>> On Sep 11, 2020, at 5:27 PM, John DeSoi via 4D_Tech < >>> [email protected]> wrote: >>>> >>>> >>>>> On Sep 11, 2020, at 3:38 PM, Randy Kaempen via 4D_Tech < >>> [email protected]> wrote: >>>>> >>>>> I have a client with about a dozen users and a 230GB data file. They >>> upgraded their server and we got a top of the line Mac Mini. Since we >>> expect to use it for a number of years, we got the best processor and maxed >>> out the memory. You can never have too much memory. We also got the SSD >>> drive so there won’t be any issues with drives crashing. >>>> >>>> I think SSDs are way more reliable, but I have never heard they are so >>> reliable that a second disk is no longer necessary. Any serious database >>> application needs to keep the database on a different disk from the backup >>> and journal files. I have a similar Mac Mini setup but added the fastest >>> external thunderbolt disk I could find for the journal file and backup >>> files. >>> >>> Agreed. For the record, the client that uses the external SSD has their >>> backups and journals on the SSD on the Mac itself, so they _are_ on >>> separate drives. We also have an offsite backup to Backblaze. I also have >>> a client who has their Time Machine backup on a Drobo, which gives double >>> backup. >>> >>> >>> Randy Kaempen >>> Intellex Corporation >>> >>> ********************************************************************** >>> 4D Internet Users Group (4D iNUG) >>> New Forum: https://discuss.4D.com >>> Archive: http://lists.4d.com/archives.html >>> Options: https://lists.4d.com/mailman/options/4d_tech >>> Unsub: mailto:[email protected] >>> ********************************************************************** >> >> >> >> -- >> On the first day, God created the heavens and the Earth >> On the second day, God created the oceans. >> On the third day, God put the animals on hold for a few hours, >> and did a little diving. >> And God said, "This is good." >> ********************************************************************** >> 4D Internet Users Group (4D iNUG) >> New Forum: https://discuss.4D.com >> Archive: http://lists.4d.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:[email protected] >> ********************************************************************** > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > New Forum: https://discuss.4D.com > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
