Work is carried out with text data, pieces of text from 1 KB to several MB, the average length is now 16 KB.

With each change, you must save the previous version of the text for the version history. The reference to the version history will not be frequent, but I would still like to be quick.

Accordingly, the stored data has the format {id | text}

In what form is it better to store this story, in which database? According to the plans, the story will very quickly grow to tens and hundreds of GB, and it must be backed up periodically (ideally daily).

  • > ... will grow to tens and hundreds of GB ... ... backup (ideally daily) ... @ Anton Smurov, I could be wrong, but in my opinion, here we need to think more about the configuration of the server's iron. By the way, not least about disk space ... Let it not be a hundred, but backing up a dozen hectares a day - a serious number will increase in a year. - Deonis
  • Nobody talks about storing all daily backups. The standard 6/3/3 scheme is quite enough. The task is to have the most up-to-date backup in case of a server crash, a sprinkled disk, attacks by intruders, an unsuccessful service update ... - Anton Smurov
  • @ Anton Smurov, in fact, I did not focus on the screw. For quick processing, as you understand, RAM is important, percent, maybe RAID 10 . Again, I repeat that I could be wrong, but with a powerful server configuration, even MySQL will cope with this task normally. But on such issues, I think that Bole will answer correctly to [RutCode] [1] [1]: admin.hashcode.ru - Deonis
  • @Deonis main service runs on its own physical server is not the weakest configuration and the data is stored just in MySQL, but in relation to the problem under discussion, I worry about backups. Dumping a sign weighing 10-100 GB will be very difficult. Of course, you can backup the database files, but there, too, there are pitfalls. - Anton Smurov
  • @ Anton Smurov, please note that in simple cases (without tweaks), the base should be stopped for the time of the backup. For hundreds of gigabytes, even with a very decent backup speed of 20 MB / sec, it will take a couple of hours. I advise you to carefully consider the scheme of operation of your system and the composition of iron (maybe this problem can not be solved at all?). - avp

0