Overall Satisfaction with MariaDB
Initially we just use it as in place upgrade for MySQL as part of system regeneration, later it turned out that its performance was far better than the original MySQL that we replaced. Our system was designed to be low maintenance and less human interaction, therefore we need a database system that quite simple and practically maintenance-free.
- Aria engine support, the improved MyISAM, it deliver faster performance with less required buffer than InnoDB, also almost a maintenance free table that less fragmented, no need to optimize so often.
- Based on out experience, having smaller memory requirement.
- With proper setup, it is fast.
- It will nice to have Aria engine be able to perform concurrent SELECT and INSERT/UPDATE like in InnoDB.
- None directly, only simplify the complexities as the engineers like it.
We tried Percona also, but we sometimes having trouble with it and on some cases it having lesser performance than MariaDB.
MySQL is the the facto standard, we use this only in scenario that it cannot be replaced by MariaDB.
MSSQL is used only if the client ask for Windows environment database system.
MySQL is the the facto standard, we use this only in scenario that it cannot be replaced by MariaDB.
MSSQL is used only if the client ask for Windows environment database system.