Post AXmdJANYZq1SxPd2lU by noidea@boerdica.de
 (DIR) More posts by noidea@boerdica.de
 (DIR) Post #AXmdJ9UFtRmqBtksZE by choyer@venera.social
       2023-07-17T09:30:42Z
       
       0 likes, 0 repeats
       
       Hi,I am working on a Friendica instance (elsica.social) for a community of plant, wildlife and sciences enthusiasts, will probably be a few hundred members at best, more likely around 100, but those may be quite active posting including media. I have two interlinked questions to #Friendica admins and experts in this regard:What’s the recommended way to configure the backend for file storage? Database is what was selected post install, would I keep this or move to file system storage? What’s the advantages and disadvantages for both solutions?In terms of regular backup, is it enough to create dumps of the database regularly or what do fellow admins do, is there an example backup script you can recommend or do you use borg backup for all or parts of the server?Thanks all for your help,. 😀@admins @helpers @friendicatips
       
 (DIR) Post #AXmdJANYZq1SxPd2lU by noidea@boerdica.de
       2023-07-17T10:05:39Z
       
       0 likes, 0 repeats
       
       I use mariabackup and everyday I download the latest backup with rsync. takes some time. (10gb) from time to time I also download the friendica and the storage directory with rsync.
       
 (DIR) Post #AXmdJAvaXJFEexYDoG by nanook@friendica.eskimo.com
       2023-07-17T11:08:25Z
       
       0 likes, 0 repeats
       
       @noidea @choyer I've got about 2400+ users, been running for about 2-1/2 years, file system backend storage, only using about 4.4GB, the database is a lot larger, friendica is using about 24GB in the mariadb database.  Hubzilla is much worse, 70gb backend storage and about same in database for same period of operation, but hubzilla has been a lot less buggy.  I backup the file system with dump, and the database with mysqldump.  I have the datebase on raided NVME flash and the backend storage on raided 14TB hard drives.  Main machine is a i9-10900x machine (10core 20thread) with 256GB of RAM clocked at 4.8Ghz.  Even though hubzilla eats a lot more space it's a lot easier on the CPU.
       
 (DIR) Post #AXnQ9tZga6uPzGVjhw by nanook@friendica.eskimo.com
       2023-07-17T20:15:16Z
       
       0 likes, 0 repeats
       
       I don't have any downtime with mysqldump because it runs concurrently with normal database operation and since the whole thing is raided, a restore is not that likely anyway.