We primarily use the solution for SaaS applications, where it is an integral part of our data management system.
The solution's features have effectively met our operational requirements as a standard SQL database.
There could be a command-line prompt for repairing the database and fixing indexes, similar to what was available in the old MyISAM storage engine.
I have been working with MariaDB for ten years.
I haven’t had any performance issues with MariaDB. Any problems we’ve encountered are typically related to the operating system or external factors like internet disruptions, not the database itself.
We have a small team of about three or four developers working with MariaDB. As for end users, the number varies depending on the application. Some of our SaaS applications support a few hundred users, while others might have thousands of users, depending on the client and project.
We transitioned to MariaDB after Oracle acquired MySQL. We continued using it just as we did with MySQL before the acquisition.
One issue I have experienced is with the InnoDB storage system. When a database crashes in InnoDB, it's essential to have a backup in a text file for restoration, but this is a common issue with MariaDB.
MariaDB differs from MySQL in several ways. Over the years, MariaDB has introduced many unique features that are not present in MySQL. It’s more open and community-driven, which allows for quicker adoption of new features and patches. Performance, especially in terms of scalability and handling large volumes of data, is a key difference. Additionally, MariaDB has better compatibility with some of the tools we use, making it a more attractive choice for our organization.
The setup was generally fine, but the configuration can be scattered across directories, which slightly complicates things. A more streamlined configuration process would be beneficial.
I set up the product's functionality replication on a virtual private network with a separate database server, which has significantly improved our data management. Although we have not yet scaled to the point of needing multiple clusters, the replication setup serves as a real-time backup for disaster recovery purposes. The product has been highly reliable, and regular updates as part of our server maintenance routine ensure smooth operation.
My overall experience with the product has been very positive. It has consistently delivered excellent performance and stability across our various projects. We have encountered very few issues over the years, and when we have, the community support has been strong, assisting us in resolving problems quickly. Its reliability is crucial for the critical applications we run.
The learning curve is quite manageable, especially for those already familiar with MySQL. The two products share many similarities, so transitioning from MySQL to this solution was relatively seamless for our team. Comprehensive documentation and active community support further simplify the learning process, making it easier for developers to get up to speed.
We have used it for a long time, proven very stable. Additionally, it is an excellent alternative to MySQL, especially considering the changes after Oracle's acquisition. The strong community support and integration with our existing infrastructure enhance its value.
I rate it a ten out of ten.