My Coupon Database
  • which database to choose

MySQL / MariaDB

which database to choosePeople's DBMS, or "must have", is on almost any hosting. Easy to install, works normally without any special settings. With the right approach can flexibly adjust to your needs. But there are pitfalls, in some cases it will be a narrow neck and your project will be slow, no matter how you tuning DBMS and data structure.

MySQL for you, if:

  • - you are a conservative and do not want to go into the settings of the DBMS, just put and work (or on hosting use what you give);
  • - you're a conservative, so you think structurally, tabularly. MySQL can do it;
  • - in any programming language, framework, CMS, CMF and so on and so forth - there is integration with MySQL.
  • - you are a beginner and you need the DBMS to manage structural data, preferably small (up to 1 - 2 gigabytes).

What are the minuses? There are some and you should choose another DBMS if you see the important one.which database to choose

  • - mediocre performance. Really low, as not tuning. even the cluster will not help much (it still needs to be configured, yeah, the same dancing with a tambourine). We're talking about the figures of about 20 MB/sec. From personal experience, on SSD drives at such a flow MySQL rested on its limit, could not cope and slowed down, and the service was configured for several years, used optimal for the load settings. Out of the box configuration, I think it will have even less bar;
  • - changing the data structure can be quite a time-consuming process, especially with a large number of connections between the data in different tables, and even with simple addition of fields;
  • - sensitivity to server instability. This is especially true when using XtraDB from Percona. If you finish MySQL incorrectly, you can break tables and databases so much that you can only recover from a full backup, of course, if you make them regularly. And believe me, it always happens at the most unexpected moment. There are tools that will help you to recover in simple situations, but they are not a panacea. In the latest and current database performance versions they are actively fighting against it, much better stability and reliability is declared.