MariaDB on CentOS 10

My main use case for MariaDB on CentOS  is that we use MariaDB  MaxScale for proxies. A quick specific example of how I use MariaDB on CentOS  in my day-to-day work is that we install it using MaxScale.

MariaDB on CentOS works very well and provides high performance. The best features MariaDB on CentOS offers are global transaction IDs and GTID-based replication. Additionally, MariaDB  now owns Galera Clustering, which we are not currently using.

GTID-based replication has helped me significantly because it makes the replication very robust. If a node goes down, it can resume, especially with MariaDB MaxScale, allowing you to resume replication very easily.

MariaDB on CentOS has positively impacted my organization with some good features in terms of administration. One such feature is flashback, which not many people are aware of, allowing you to roll back DML transactions without having to restore from backup.

From these features, I have seen specific outcomes such as time savings and fewer errors. Because we use MariaDB MaxScale with MariaDB async replication, we have noticed very little intervention in terms of failovers and high availability support, which is very useful.

To improve MariaDB on CentOS, I believe it needs materialized views, as stored procedures in MariaDB are not as good as those in Postgres or Oracle.

I have been using MariaDB on CentOS for about ten years.

MariaDB on CentOS is very stable in my experience.

The scalability of MariaDB on CentOS is good.

Customer support for MariaDB on CentOS is excellent and very good.

I previously used MySQL  Enterprise Edition before MariaDB on CentOS. We switched because of the lack of support.

My experience with pricing, setup cost, and licensing for MariaDB on CentOS has been that we use MariaDB Enterprise Edition, so the cost and pricing are very competitive.

Before choosing MariaDB on CentOS, we needed a MySQL-like solution, and although we did consider Percona, we chose MariaDB.

My advice to others looking into using MariaDB on CentOS is to not treat it as a drop-in replacement for MySQL , as it is a completely separate database now with more features. You should look into the features and replication topology, which is quite different, and understand the storage engines and spider engine. You should definitely make sure you use Maria Backup for backups because it is a fork of Percona XtraBackup and understand the difference. The community is very good, and we need to see what direction they take on AI, as AI vector features look decent and very good so far. MariaDB on CentOS is very good, and they are looking at Kubernetes  Operator now that supports async replication, which is something we want to look at in the future. I would rate this product eight out of ten.

My main use case for MariaDB on CentOS  is as a database for my application.

A quick specific example of how I'm using MariaDB on CentOS  for my application includes Laravel-based applications and WordPress-based applications as a replacement for MySQL .

The best features that MariaDB on CentOS offers are a reliable, high-performance database and an open-source solution.

Being open source reduces licensing costs and allows me to install it anywhere I want on any type of environment, and high performance is absolutely critical and mandatory for any application.

MariaDB on CentOS has positively impacted my organization by enabling us to use more recent versions of frameworks and improve the performance of the application in general. Using newer frameworks and improved performance benefits my team and business by providing a newer framework that is more secured, has better performance optimization, and allows us to integrate more new features.

I have no suggestions on how MariaDB on CentOS can be improved. There are no specific areas or features where I would like to see improvements in MariaDB on CentOS.

I have been using MariaDB on CentOS for about five years.

MariaDB on CentOS is absolutely stable.

As with any database, there are some challenges for scalability, but from the software point of view, I have no issues with replication or adding resources.

I have never used customer support.

I previously used MySQL  and switched because the newest frameworks required MariaDB .

I have seen a return on investment through specific improvements in performance optimization for the application, resulting in a better user experience.

My experience with pricing, setup cost, and licensing has been positive since it is open source, and we did not have any issues with licensing and pricing. My costs are based on resource allocation for this database, which depends on the project.

I did not evaluate other options before choosing MariaDB on CentOS.

I would rate MariaDB on CentOS a nine on a scale of one to ten.

I choose a nine because there is always room for improvement for any software, but in general, it is a reliable, stable, and easy-to-use solution.

Regarding MariaDB on CentOS's security and governance, I think they are pretty secure if you configure it properly.

I have never used MariaDB on CentOS with artificial intelligence.

My advice to others looking into using MariaDB on CentOS is to not rely on default configuration and to secure it from the first minute of your work with MariaDB on CentOS. My overall review rating for MariaDB on CentOS is nine.

Regarding our use case, I find that it is quite a good database to use. It has all the MySQL  features that we want, and it is quite easy to deploy as well. The whole table is in MariaDB , and that is how we use it in our day-to-day work.

In comparison to other databases, MariaDB on CentOS has most of the features that I love to use, especially considering how easy it is to use. If I compare it with PostgreSQL , PostgreSQL  is quite a large database with many features. I would not say that MariaDB  has everything, but it has most of the features when compared to other normal databases such as MySQL  or any other small databases.

The positive impact of MariaDB on CentOS in our organization is that the overall deployment flow has been quite easier. We have MariaDB as one of the databases in our stack; we also use PostgreSQL and Redis , but MariaDB is a component in our database infrastructure. Installing it on CentOS  is quite easy as well. The specific outcomes, such as faster deployment and improved performance metrics, have been quite noticeable. Earlier, we were using MySQL Lite, which, although a light database, lacked some features and performance. We found MariaDB quite performant with our applications.

Regarding MariaDB on CentOS's AI capabilities, I think its governance and security are good. The AI capabilities are good, and the guardrails are also to the point, but there is still room for improvement in the AI part.

We deploy MariaDB on CentOS in our organization using a public cloud.

I would advise others looking into using MariaDB on CentOS to give it at least a try to see how it performs in their case, as it will really be helpful for them. I do not have any additional thoughts about MariaDB on CentOS at this time. My overall review rating for this product is 7.

MariaDB on CentOS  was used for basic managed WordPress hosting, having all the databases of customers with WordPress websites. Regarding my use case with MariaDB on CentOS , we also took MySQL  dumps, which is similar in MariaDB . We also used replication sometimes for those MariaDB  instances. Sometimes, we needed to use some queries to check the max connection on the database; these are a few things that we were doing.

The best features of MariaDB on CentOS, in my experience, are that it is mainly enterprise-friendly. We can also manage MariaDB on CentOS through systemd and systemctl, which runs on CentOS . It also has SELinux support, and the package management is easy and reliable through those package managers, YUM and DNF. MariaDB on CentOS is reliable and very good for production.

The reliability and ease of management of MariaDB on CentOS helped me day-to-day, for example, because the company I worked for used to host all the customers' databases under the cluster. It was not a single database for them; the customers could access their individual databases, but for us, it was very good to go into the big box and then enter the MariaDB on CentOS engine, where we could run queries on multiple databases. That made it easy to avoid going into single databases to do it, so multiple queries to update multiple databases for a single table were things that made it easy.

MariaDB on CentOS impacted my organization positively, helping in database redundancy. It helped to have MySQL  dumps, so if a customer removes their database entries, we could easily pull the dumps to provide the backups to the customer. That's how it was done, and it made things easy.

Regarding MariaDB on CentOS and reduced manual effort, there were scripts automating the backups. The MySQL dump feature in MariaDB on CentOS helps to take the dumps. Also, since it runs on systemd, when a big server reboots, the engine starts up, causing less downtime.

MariaDB on CentOS has older versions than the latest upstream releases, so package versions can be older, and that's something that should be improved. CentOS  is also at end of life, so I'm not sure; I have not run it on the latest RHEL  versions like AlmaLinux . Perhaps they have improved now. Also, since it is a fork of MySQL, repo management is a little tricky.

Regarding needed improvements for MariaDB on CentOS, the database version testing took time, so perhaps the provider could work on that.

I used MariaDB on CentOS for around two to three years when I was working for a web hosting company, where they used MariaDB on CentOS.

MariaDB on CentOS is pretty stable; I have not seen the engine going down.

Regarding the scalability of MariaDB on CentOS, if you're referring to allotting resources like increasing the max number of connections and things such as that, it's pretty scalable. The configuration file is available, and we can make the changes and restart the MariaDB on CentOS engine; it is pretty approachable once it is done.

I have not needed to reach out for help regarding customer support for MariaDB on CentOS; I think it was done by the admins.

The organization was using MariaDB on CentOS only. I used some other products, such as PostgreSQL , which I think is better for backup products, but for WordPress and things, MariaDB on CentOS is better.

I have seen a return on investment with MariaDB on CentOS; the management is easy. The support engineers could run queries without needing DBA admin level knowledge to perform some functions, so you do not need to hire MySQL admins every time. It was good, and it also saves time with the easy deployment; everything is good.

This was an organizational decision, and it wasn't on me; I did not evaluate other options before choosing MariaDB on CentOS.

I would rate MariaDB on CentOS a seven out of ten.

I chose seven out of ten because it needs some improvements related to optimization and the upstream packages. However, seven is a very good number because it also has the feasibility of MySQL dumps, and it's a fork of MySQL. The configuration is very easy; you can configure the ports and things such as that, and it's compatible with SELinux, so that's why.

Regarding MariaDB on CentOS's AI capabilities, I'm not sure how it works with AI, but the governance and security capabilities of MariaDB on CentOS are good. We can set the root password for it, and the governance is also easy; we can automate it or have different users. The different user roles, levels, and permissions make it a good product to govern.

The output of MariaDB on CentOS is very reliable; the queries are similar to MySQL. Because it's also a fork of MySQL, the queries are reliable, providing very accurate results. You can use all the operations of MySQL and it gives very accurate results.

For others looking into using MariaDB on CentOS, I would say they should be very familiar with SQL queries, as you can run any complex queries on it. However, they should also not expose some open ports and ensure that the configuration is good to avoid outrunning the RAM.

The major use case for MariaDB on CentOS  is that we are working in IoT; we have installed some NFC meters on the network towers, basically mobile towers, for collecting metrics such as voltage, current, load, and everything that consumes electricity, which we are storing in MariaDB on CentOS . It is a small project, so we directly went with it.

MariaDB on CentOS is effective in handling large data volumes; I have installed approximately 10,000 devices and it is working well. I have put MariaDB on CentOS behind a few systems and it is working for my 10,000 devices easily with no issues.

The biggest advantages of MariaDB on CentOS, from my perspective, are that it looks similar to MySQL , making it slightly lightweight and easy to install. We need to set up many things for MySQL , but I find MariaDB on CentOS lightweight, which is a main feature.

MariaDB on CentOS is easy to use and easy to install. The setup is straightforward and everything is the same as MySQL, so nothing is different.

I have seen a return on investment with MariaDB on CentOS in terms of time savings because time is money; saving time is also saving money. I have saved a lot of time due to its easy installation and use case.

For potential improvements that could be made in the future for MariaDB on CentOS, I think two or three things are needed; one is AI to support rewriting queries because at this stage every database supports AI. Another thing I have not seen in any database is an AI engine that analyzes a query and suggests a better way to write it. If I write any query, an AI engine could suggest that the same result can be obtained with a better query. This is something that could help me write better queries.

I have been working with MariaDB on CentOS for approximately one year.

Regarding stability, I have been working on my project for the last year and, while the project has run for four to five years, I have not seen any technical glitches from MariaDB on CentOS that caused downtime; it is working fine.

I have not run MariaDB on CentOS in cluster mode, so I cannot comment on its scalability.

I have used the community support and I can easily find answers to almost all my queries from there. The community is pretty good, so I got all the solutions I needed.

MariaDB on CentOS is easy to use and easy to install. The setup is straightforward and everything is the same as MySQL, so nothing is different.

I have saved approximately 10 to 20 percent of time and money due to MariaDB on CentOS.

I have not integrated MariaDB on CentOS with MySQL; I am running purely MariaDB on CentOS.

Regarding the security aspect of MariaDB on CentOS, I have used SSL, and I also use RBAC, role-based access control. I mainly use these two. I am satisfied with the security aspect.

Regarding any negatives in MariaDB on CentOS, there may be some minor improvements, but I have not seen anything significant that I consider negative. As per my use case, it is working fine and I have not seen a need for improvement.

I rate this product nine out of ten.