What will be the performance of the database with a volume of 100 GB?

Question

MySQL

I'm going to make a web application with a database that stores articles. Several million articles, but each weighs a little, about 10 Kb. That is, a database of ~ 100 GB.
1) Will the database work more or less quickly if you do a search on it, say, like the LIKE function in mysql to search for the presence of a phrase in the text? If not, how is a search in the database for a given phrase done in such situations?
2) What is the best database to choose? mysql or postgresql or what?
3) How do admins work with large databases and where do they host them (on their purchased hosting or separate cloud servers)? Backup can be done in phpMyAdmin or where is it better?

Answer 1

1 like on such volumes no one uses
2 postgres
3 on dedicated hardware. You should forget about phpmyadmin - there is a console

Answer 2

read
https://www.ibm.com/developerworks/ru/library/os-s...
Muscle 5.7 is better, of course, but the general idea is still the same today