MariaDB implemetation first phase
Use Cases and Deployment Scope
Pros
- Gives us the flexibility to design data structures which can be joined to give data served by our APIs.
- Provides us options to use multiple storage engines based on the data being stored.
Cons
- Replication technology can definitely improve. Currently we face lot of issues with replication causing table locks.
- Provide better troubleshooting tools out of the box, for example a comprehensive GUI like SSMS for SQL Server.
- Alter table and add indexing is an overhead on large tables which causes replication and storage issues.
Likelihood to Recommend
- Well suited for medium scale read and write systems
- Not suited for systems where write workloads are high and require multiple masters to support the volume
