I develop applications in my spare time. So, if the application requires a database, I use MariaDB by default.
Supervisor at GGoC1
Open-source and readily available
Pros and Cons
- "I am editing."
- "MariaDB has a straightforward initial setup with easy-to-understand documentation."
- "I am editing."
- "There is room for improvement in terms of security."
What is our primary use case?
What is most valuable?
It works fine. It's easy to set up.
What needs improvement?
There is room for improvement in terms of security.
For how long have I used the solution?
I have been using MariaDB since 2016. I started using it when I was in school. Moreover, I use the latest version available, depending on what I am doing.
Buyer's Guide
MariaDB
November 2024
Learn what your peers think about MariaDB. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
What do I think about the stability of the solution?
It is a very stable solution. I made a deployment for an internal IT service at one of the places I worked, and it's been seven years now, and it's still working perfectly.
I would rate the stability a solid nine out of ten. There is always room for improvement. Nothing is perfect, and maybe there are some issues that I'm not aware of.
What do I think about the scalability of the solution?
MariaDB is mainly a back-end application, so anyone using our service also uses the database. For example, if you use my monitoring service, which is used to monitor devices and appliances, then you'll be using the database. So, I'm not sure if that counts, but it's being extensively used in our company, and it's very helpful.
We plan to increase our usage of MariaDB in the future.
How are customer service and support?
I have never contacted the customer service and support team because our deployment is not very big; it's just something small. The data contained in it is not considered a big deal by my supervisor, so there hasn't been a need to contact tech support.
Moreover, we haven't faced any issues so far. It's been working smoothly for us.
How was the initial setup?
The initial setup is very straightforward. Mostly, I use MariaDB with Docker, so it's quite easy to set up and deploy. The documentation is also easy to understand and follow.
What about the implementation team?
I usually handle the deployment myself, without the need for any third-party help. I followed the documentation and steps provided. MariaDB can be deployed in-house, but mostly it's self-hosted, and I use it with Linux. I mostly use the package manager version or the bundle I get from the website and apply it myself.
What's my experience with pricing, setup cost, and licensing?
I haven't used the licensing model for MariaDB, but I would prefer to use it since I am familiar with the platform and find it easy to work with. I wouldn't want to switch to a different database management system.
Which other solutions did I evaluate?
I've used PostgreSQL before, but that was in a personal capacity just for my own personal projects. Using MariaDB depends on the application I'm trying to deploy or what I'm trying to use. That's what determines if I will use MariaDB or Postgres as SQL.
What other advice do I have?
If I am teaching somebody to program and write applications, I usually use MariaDB by default because it's open source, pretty available, and overall, I would rate MariaDB a ten out of ten.
But if I want to do a major deployment, I would have to get support. It's very stable. For example, I was using it to host a monitoring system, and it's been stable for a very long time. I haven't upgraded it yet, but it's working fine. It's been seven years since I did the last deployment, and it's still fine.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Operations Manager Uganda at a tech services company with 201-500 employees
A great language that has PL/SQL compatibility
Pros and Cons
- "The solution has PL/SQL compatibility."
- "The PL/SQL performance is slow if you have big batch jobs running overnight."
What is our primary use case?
We develop financial software such as credit management solutions for banks, financial institutions, and telcos, basically anyone who deals with credit. We are users of this product and resell to our customers. I'm the operations manager.
What is most valuable?
The solution is valuable because it has PL/SQL compatibility. Our base was previously on Oracle and we wanted to change our solution to a DBS which meant finding something compatible with that language. It's really a great language, especially as it's one that you can get for free. If we build our technical knowledge, then we won't need third-party support which is a strong plus.
What needs improvement?
The PL/SQL performance is slow. If you have big batch jobs running in the middle of the night for a bank doing its end-of-day audits, then MariaDB will take three times longer than using Oracle. The product lacks sufficient detail in its reports. MariaDB has many extra features that would help to optimize the DB in the enterprise version and it would be helpful if it were possible to add some of those features in the open source version.
For how long have I used the solution?
I've been using this solution for two years.
What do I think about the stability of the solution?
The solution is very stable in the right perameters. If I have a customer looking for something that's not batch job heavy, then we use MariaDB. If I have a core system that's going to take a ton of records and go through all these in the batch jobs at night, then we default to Oracle, because it's faster. We've proposed it to enterprise clients and we've proven to them that it's stable enough.
What do I think about the scalability of the solution?
It's probably one of the most used RDBMS's for scalability. We haven't really tested it on millions and millions of customers but there's no problem with scalability.
How are customer service and support?
We use the community for support. If we were to purchase support, the cost would be around 5k per year. It's a big difference. We usually just use the after-market support and haven't required any direct support from the company. We've been able to handle it internally.
Which solution did I use previously and why did I switch?
When I compare MariaDB to Oracle, an industry leader, the big difference we found is performance in the PL/SQL mode. With Oracle, regular queries get executed at the same level with no issues. For ease of use and the setup, they're pretty similar. We also looked at IBM DB2 but there were compatibility issues and it was significantly slower.
How was the initial setup?
The initial setup is really easy for our team. It's a quick download and configuration. We have set parameters.
What's my experience with pricing, setup cost, and licensing?
We use the open source edition which doesn't require licensing. We don't offer the enterprise edition, because if we're taking the customer off Oracle, for the additional benefits, we have to optimize the cost. If we have a customer with budget constraints, it's saving hundreds of thousands of dollars, sometimes millions, if we use MariaDB instead of Oracle.
What other advice do I have?
I rate this solution nine out of 10.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
MariaDB
November 2024
Learn what your peers think about MariaDB. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
Technical Staff at UNIFI-HOME-imse01.mc_rsh
A stable solution with good documentation and many online examples
Pros and Cons
- "The product has good documentation and you can find many examples online."
- "I would like to see a better user interface which would make the tool less complex."
What needs improvement?
I would like to see a better user interface which would make the tool less complex.
For how long have I used the solution?
I have been using the tool for three years.
What do I think about the stability of the solution?
The product is stable.
Which solution did I use previously and why did I switch?
We have used MongoDB and MySQL before.
How was the initial setup?
The solution was easy to setup.
What's my experience with pricing, setup cost, and licensing?
We use the solution's free version.
What other advice do I have?
I am satisfied with the overall product. I would rate the product an eight out of ten. The product has good documentation and you can find many examples online.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Owner at TRS
Works very well, easy to set up, and scalable
Pros and Cons
- "We use MariaDB for identity provider services. Most of the things that we are doing are deployed in the container mode. All such solutions require a database, and MariaDB is easier to use for these kinds of deployments."
- "It would be good if they can maybe improve the mass import in the database. Currently, for importing a large number of data, we create a CSV file and upload all the things in the system. The system does not activate them by default. We have to do this manually. This may be due to the version we are using, but this is something we would like to see improved."
What is our primary use case?
We are using MariaDB for our federation of identity system, which is used to record students, service providers, and many other things. This system uses MariaDB as a database.
What is most valuable?
We use MariaDB for identity provider services. Most of the things that we are doing are deployed in the container mode. All such solutions require a database, and MariaDB is easier to use for these kinds of deployments.
What needs improvement?
It would be good if they can maybe improve the mass import in the database. Currently, for importing a large number of data, we create a CSV file and upload all the things in the system. The system does not activate them by default. We have to do this manually. This may be due to the version we are using, but this is something we would like to see improved.
For how long have I used the solution?
I have been using this solution for five years.
What do I think about the stability of the solution?
It is stable. We have no issues.
What do I think about the scalability of the solution?
It is scalable. We are a regional research and education network. MariaDB is a part of the tools that we have deployed to provide services for such institutions. Three other national research and education institutes are also using it, and all of these institutions have many campus users. So, a large number of users are using it, but they don't even know that it is MariaDB because they are just using the tool or the application that has MariaDB as backend. We do plan to increase its usage in the future.
How are customer service and technical support?
We didn't contact them.
Which solution did I use previously and why did I switch?
I won't say we switched because we still have another system running PostgreSQL. We started using MariaDB because we were using some tools for identity federation, and these tools come with MariaDB by default. We did not choose MariaDB as a standalone product. If we stop using any of these tools tomorrow, we may no longer use MariaDB.
How was the initial setup?
The initial setup is very simple because we are using a container, which means that it is just a deployment. It is a part of the installation of other applications.
We didn't have to install MariaDB as a standalone product. We installed an identity management system, which automatically requires MariaDB, and all these things are done through containers. It is very easy these days when you are using a container. Everything is straightforward. It is just a matter of calling and installing them.
What about the implementation team?
The initial installation was done by a consultant. Since then, we have deployed many other instances of the same thing. It is the same container, and we keep on deploying it. We just change the configuration.
We have only one person for its deployment and maintenance. We have a network and system admin who deals with the installation for us. We are just using MariaDB behind our federation of identity system. So, we don't deal with it daily. When we want to connect a university or any university wants to join, we install the application that has MariaDB, and that's all.
What other advice do I have?
I would definitely recommend this solution. It has worked very well for us so far. I have no complaints about it.
I would rate MariaDB a nine out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Systems Administrator at Dairibord
Stable and simple to install
Pros and Cons
- "A valuable feature is that we can use it for quite a few things, all the things you'd expect from a server—along the lines of Linux's Lightweight Directory."
- "MariaDB could be improved by adding more automation."
What is our primary use case?
Our primary use cases of this solution are for emails and all the functions you would expect from a server. MariaDB is deployed on-prem, on one of our Linux servers.
What is most valuable?
A valuable feature is that we can use it for quite a few things, all the things you'd expect from a server—along the lines of Linux's Lightweight Directory.
What needs improvement?
MariaDB could be improved by adding more automation.
For how long have I used the solution?
We have been using this solution for the past five years or so.
What do I think about the stability of the solution?
This solution is stable. For deployment and maintenance, we have a team of four admins.
What do I think about the scalability of the solution?
This solution is scalable. There are about 100 people in my company using MariaDB.
Which solution did I use previously and why did I switch?
I didn't use a different solution before implementing MariaDB.
How was the initial setup?
It is very simple to install MariaDB. We did it ourselves and it took less than a day.
What about the implementation team?
We implemented through an in-house team.
What's my experience with pricing, setup cost, and licensing?
We pay for a yearly license. We don't currently have plans to increase the number of users in the foreseeable future, but we will do so if we need to.
Which other solutions did I evaluate?
I didn't evaluate other options before choosing.
What other advice do I have?
I rate MariaDB an eight out of ten. I recommend this solution to others considering implementation.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Engineer at a tech services company with 10,001+ employees
Simple to setup and stable with high availability
Pros and Cons
- "The solution's high availability is its most valuable aspect."
- "The stability could always continue to be improved upon."
What is our primary use case?
The solution is primarily used to store data and for our cloud platform backend database. I use the solution for many projects.
What is most valuable?
The solution's high availability is its most valuable aspect.
We have found the product to be stable.
The initial setup is pretty simple.
What needs improvement?
The stability could always continue to be improved upon.
For how long have I used the solution?
I've been using the solution for three years.
What do I think about the stability of the solution?
The solution is stable and the performance is good. There are no bugs or glitches. It doesn't crash or freeze. It's reliable.
What do I think about the scalability of the solution?
There are about 100 end-users in my organization that use this product.
How are customer service and support?
I've never dealt directly with technical support. When there has been an issue, I tend to work to solve the problem myself.
There is so much information available, you can easily just Google the problem and likely you are able to troubleshoot the problem yourself. It's easy to find what you need online.
How was the initial setup?
I found the initial setup to be very simple and straightforward.
The deployment was quick. It maybe only took one hour.
We have a DPA team that's able to deploy the solution. For my department, we have six people on it and they're able to handle both deployment and maintenance.
What about the implementation team?
The implementation was handled in-house. I did not need the assistance of an integrator or consultant.
What's my experience with pricing, setup cost, and licensing?
We don't use a license, however, it is possible to pay for a yearly license if necessary.
What other advice do I have?
I'd rate the solution at a ten out of ten. I'm very happy with it overall.
I would recommend the solution to others. It's easy to find details about the product online and to learn about it.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
It's a fast and flexible tool
Pros and Cons
- "MariaDB is a fast and flexible tool."
- "Integration with AWS could be improved."
What is our primary use case?
My company provides solutions for banks, credit card companies, and other enterprises in the financial industry.
What is most valuable?
MariaDB is a fast and flexible tool.
What needs improvement?
Integration with AWS could be improved.
What do I think about the stability of the solution?
I rate MariaDB nine out of 10 for stability.
What do I think about the scalability of the solution?
I rate MariaDB eight out of 10 for scalability. It's relatively good.
How are customer service and support?
We do not have paid support because we use the open-source version. If we have questions, we can look for answers online. MariaDB has an active user community.
How was the initial setup?
I rate MariaDB seven out of 10 for ease of setup. Deployment is easy. We deploy it on-prem and on AWS. I am on a team of seven people, but one person is sufficient to set it up in two hours.
What's my experience with pricing, setup cost, and licensing?
We use the community version of MariaDB. We don't have an enterprise license.
What other advice do I have?
I rate MariaDB eight out of 10. I recommend MariaDB depending on the use case.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Easy to set up, open-source, and simple to use
Pros and Cons
- "It's easy to set up."
- "The performance could be a bit better."
What is most valuable?
It's easy to use and open source. Currently, I use it more and more as it is easier than the other.
It's easy to set up.
The product is open-source.
What needs improvement?
I don't know what we want to improve about it, however, we don't use it for everything. We use it for specific projects. It can fit my project, and we don't know how we can use it more.
The performance could be a bit better.
They could make the solution stronger. It's not stronger than PostgreSQL, for example.
For how long have I used the solution?
I've used the solution for two years.
What do I think about the stability of the solution?
The stability is good for how we use it. We don't use the replication and cluster. We only really use the standalone server and that's it.
How are customer service and support?
We don't use technical support. I cannot speak to their services.
How was the initial setup?
It's not overly complex to set up. Maybe when we set up matters like replication, it's a little complicated, however, it's pretty easy.
We only need one person to maintain the product.
What about the implementation team?
We did not have the help of integrators or consultants. We installed the server and deployment did not take too much time. It was about 20 minutes or 30 minutes to deploy.
What's my experience with pricing, setup cost, and licensing?
The solution is open-source, therefore, it has no license.
What other advice do I have?
The product is easy to use and not hard to learn, therefore, when someone asks me for a good DB to use, then I tell them about MariaDB.
I'd rate the solution eight out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free MariaDB Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Popular Comparisons
MySQL
PostgreSQL
Firebird SQL
EDB Postgres Advanced Server
SQLite
Percona Server
ClickHouse
Buyer's Guide
Download our free MariaDB Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- When evaluating Open Source Databases, what aspect do you think is the most important to look for?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Which database is the best for session cashing?
- Which low-code (no-code) database solution do you prefer?
- Why is Open Source Databases important for companies?