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] **********************************************************************
