I use MariaDB in my company to build simple web applications.
Laboratory Assistant at Strathmore University
A stable tool that offers an out-of-the-box setup option
Pros and Cons
- "I haven't faced any technical issues with the product, and it works fine."
- "MariaDB's GUI is an area with certain shortcomings where improvements are required."
What is our primary use case?
What is most valuable?
The most valuable feature of the solution is its interface, including the web interface and the CLI.
What needs improvement?
There is no guide provided to first-time users by the solution. For first-time users, there should be some sort of guide provided by the solution explaining what the product offers so that they don't have to search for it on Google. The very first time that users use the product, they should be able to use the database server and move it to phpMyAdmin.
MariaDB's GUI is an area with certain shortcomings where improvements are required.
For how long have I used the solution?
I have been using MariaDB for more than a year.
Buyer's Guide
MariaDB
January 2025
Learn what your peers think about MariaDB. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,265 professionals have used our research since 2012.
What do I think about the stability of the solution?
I haven't faced any technical issues with the product, and it works fine. Suppose users have some other databases running in the environment apart from MariaDB. In that case, it might occupy the port that MariaDB's server is trying to use, so you might not be able to access it. There are no technical issues related to the solution unless there is another database in the same environment where MariaDB functions, making it an area where users must be careful.
What do I think about the scalability of the solution?
The product has scalability features, but I haven't reached the level where I have to use them. If you know where to change the tool's configurations, it can scale up.
Which solution did I use previously and why did I switch?
Though I still work with MariaDB, I have moved to Firebase and MySQL.
I have experience with some other tools in the past. The interface areas offered by other tools in the market are much better than the ones offered by MariaDB. The interface offered by MySQL databases is better than MariaDB's GUI.
How was the initial setup?
The product's initial setup phase can be done straight out of the box, as it works fine.
The product's initial setup phase didn't require much time because MariaDB was already embedded within XAMPP, so it was easy to use and access since I only had to launch it. You may want to change the user credentials for the password before you can access it and use it from the CLI.
What's my experience with pricing, setup cost, and licensing?
Price-wise, the product is affordable. The product is not expensive.
What other advice do I have?
I rate the overall product an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Associate, Software Developer (Appian) at The European Bank for Reconstruction and Development
A cloud-based tool that offers great speed with a need to improve in the area of document caching
Pros and Cons
- "The most valuable features of the solution stem from the fact that it is a cloud-based tool, so it is pretty fast."
- "Document caching is an area of concern in the product, where improvements are required to help MariaDB improve on the previous queries as they are retained, and you can roll back to them."
What is our primary use case?
I use MariaDB in my company to process the data for the database, so it is just for storage and analytics-related areas.
What is most valuable?
The most valuable features of the solution stem from the fact that it is a cloud-based tool, so it is pretty fast. The product is also considered to be an SQL-compliant solution.
What needs improvement?
Document caching is an area of concern in the product, where improvements are required to help MariaDB improve on the previous queries as they are retained, and you can roll back to them.
For how long have I used the solution?
A cloud-based tool that offers great speed with a need to improve in the area of document caching.
What do I think about the stability of the solution?
Stability-wise, I rate the solution a ten out of ten.
What do I think about the scalability of the solution?
Scalability-wise, I rate the solution an eight out of ten.
Around 300 people in my company use the solution on a daily basis.
How are customer service and support?
I rate the technical support a five out of ten.
How would you rate customer service and support?
Neutral
Which solution did I use previously and why did I switch?
There was another solution in our company before MariaDB was introduced. My company moved to MariaDB as it was imposed or forced on us by the vendor named Appian since they prefer MariaDB for databases.
How was the initial setup?
The product's initial setup phase was easy.
The solution is deployed on a public cloud by AWS.
The solution can be deployed in a few hours.
What about the implementation team?
The product's setup phase was taken care of by a third party, Appian.
What was our ROI?
I have seen a return on investment from the use of the product since it helps my company save time.
What's my experience with pricing, setup cost, and licensing?
I rate the product's price a three on a scale of one to ten, where one is low price, and ten is high price since there are some support costs involved, even though it isn't an open-source solution.
What other advice do I have?
One person, who is the database administrator, is required to maintain the product.
I rate the overall solution a seven out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
MariaDB
January 2025
Learn what your peers think about MariaDB. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,265 professionals have used our research since 2012.
Director - Software Development at PRI
Is very simple to install, and the commands are exactly the same as MySQL
Pros and Cons
- "It is very simple to install, and the commands are exactly the same as MySQL."
- "It should work across all fields like SQLite, as it is the basis of any application, even apps for phones and the like."
What is our primary use case?
We use MariaDB for industrial automation. We log some tags, and we keep the tags in the database or historical storage.
What is most valuable?
It is very simple to install, and the commands are exactly the same as MySQL.
The learning curve is small and standardized, and not anything complicated. Other than that, it isn’t much different than other solutions. It's very similar to MySQL, but a little bit more light-weighted compared to it. Unless you do a very heavy login of data, it will be fine. It is based on AWS, and MariaDB is good for certain things.
What needs improvement?
It should work across all fields like SQLite, as it is the basis of any application, even apps for phones and the like.
How are customer service and support?
Usually, we are capable of handling our programs. We rarely use customer support. One time I got in touch with Oracle's customer service, but it was just one time. In general, we can handle the issues by ourselves. We are not really lower-level users and are all skilled with the programs.
Which solution did I use previously and why did I switch?
I have used PostgreSQL and Oracle. PostgreSQL and MariaDB are quite similar and we still use it.
How was the initial setup?
The initial setup is very simple. The deployment was done within a few minutes.
What's my experience with pricing, setup cost, and licensing?
I always use the free version.
What other advice do I have?
I would rate MariaDB almost an eight out of ten.
I think it's a pretty useful database. It's very simple to install and that's one of the very positive things about it because sometimes if you go into tools like Oracle, it is more difficult. It is not just the downloading of the installer on any computer from Linux or Mac or Windows. MariaDB works in a blink of an eye, and the database runs right away.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Site Reliability Engineer at a computer software company with 10,001+ employees
Not very complicated to maintain and offers an open-source version
Pros and Cons
- "A well-known issue for a lot of different users is associated with write-intensive applications."
What is our primary use case?
MariaDB is used like any other relational database where we need complex join queries as well as tasks like read and write using the tool. The tool also offers support in terms of sharding, which is why we use MariaDB. Every time we use the tool, we have some kind of a reason, or, I would say, a requirement of asset compliance, which is atomicity, consistency, isolation, and durability, which is only provided by a relational database. Companies usually go towards open-source databases. Oracle is very costly. Oracle is not an open-source tool, which is why people tend to go towards open-source. The databases are doing pretty well in different applications.
What needs improvement?
A well-known issue for a lot of different users is associated with write-intensive applications. There are so many write-intensive applications. Usually, the applications are designed as read-intensive ones, where the number of reads is way more than the write operations. I would say MariaDB or any other relational database is designed by default to be for read-intensive applications. There are a lot of features being added to the tool, such as something called Galera Cluster, which supports write-intensive applications and sharding. People have to come up with their own way to share their applications, and that is the only way they can come up with a better performance tool for write-intensive applications.
For how long have I used the solution?
I have been using MariaDB for two years. I am not a customer of the product, but my company does cater to the needs of multiple customers. My company uses the tool at work, and it is a part of our product.
What do I think about the scalability of the solution?
As a part of the NDA, I cannot discuss the number of users of the product since it is a public company, but I can say that we have thousands and thousands of customers, and every one of them has products that are on their own databases.
How are customer service and support?
The technical side of the solution is there, and they have been doing this for a very long time. The solution's technical support team is responsive. I rate the technical support an eight out of ten.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
I work with MariaDB and PostgreSQL.
How was the initial setup?
The product's initial setup phase was not at all challenging, and the reason for that is there is so much community support. You could face any issues which are not properly discussed in the community. Almost every issue has been discussed in the community, so there is no way you could be stuck somewhere, and you are trying to figure out what you can do next since it will not happen when you use MariaDB.
The solution is deployed on a hybrid cloud model.
What was our ROI?
The community support offered by the product is good. There is one specific thing about community support, and it is that it doesn't matter if it is a relational database or any other code that is public and open source. If it is open-source, the tool gets enhanced multiple times in a better way because every company has its own requirements. As per the requirement, people are merging codes in the main branch, and I am specifically talking about GitHub for now. MariaDB has so much flexibility and features, like data compression, audit plugins, and tablespace encryption, and it supports discrete encryption. Because of the tool's community support, it has varied functions and can be used almost anywhere or wherever you want as a relational database.
What other advice do I have?
In terms of data management efficiency, I would say that it is pretty efficient. The tool is simpler to support if you talk from an engineer's perspective, and it is easier to provide any assistance to the customer who needs some kind of data from their product. The tool provides its own high availability, which means a 99.99 percent high availability. The biggest thing about the tool is that it is an open-source product, and it is supported by a community, which is pretty nice, especially because the community improves the product pretty well. If the product was available at a certain price, there are very few requirements in such scenarios. For open-source products, there are multiple requirements, so the product is enhanced way faster, and that is why people prefer an open-source tool. MariaDB or MySQL are some of the most used relational databases.
It is not very complicated to maintain the tool.
I rate the tool an eight out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Jul 24, 2024
Flag as inappropriateSystem Engineer at a financial services firm with 1,001-5,000 employees
Offers certain unique features that distinguish it from other databases but requires improvement in materialized views
Pros and Cons
- "I like the global transaction IDs (GTIDs) feature. It's quite reliable for replication between a master and a replica server, and it's a feature that MySQL also has but implemented differently."
- "I'd like to see improved materialized views, like the ability to save select queries. This feature is missing in MariaDB compared to other relational databases like Oracle and SQL Server."
What is our primary use case?
It's a relational database, so it's mainly used for structured data. We use it for some of our in-house applications.
How has it helped my organization?
For us the benefit is that the system is very stable, so we don't have many outages. We also have a lot of experience with MariaDB, so we can optimally configure MariaDB and deploy a well-tuned environment.
What is most valuable?
I like the global transaction IDs (GTIDs) feature. It's quite reliable for replication between a master and a replica server, and it's a feature that MySQL also has but implemented differently.
Another thing I like is the flashback feature, which allows you to roll back a transaction from the binary logs, so you can retrieve data. If someone deleted data, you can flash it back. That's a feature I really appreciate.
What needs improvement?
I'm interested in witnessing the integration of materialized views, which would enable the preservation of select queries. This particular functionality seems to be absent in MariaDB when compared to rival relational databases such as Oracle and SQL Server. The inclusion of this feature, akin to the offering from PostgreSQL, would be a valuable addition to MariaDB's capabilities.
For how long have I used the solution?
I have nearly 13 years of experience working extensively with MySQL, and in recent years, I've also gained proficiency with MariaDB. Since MariaDB is closely related to MySQL, my combined experience with both platforms spans over a decade. Currently, we're utilizing version 10.4, although it's a few iterations behind the most recent release. We're actively preparing to undertake an upgrade in the near future.
What do I think about the stability of the solution?
It is a quite stable solution.
What do I think about the scalability of the solution?
If you want to scale it for larger use cases, like sharding, you'd need to consider MariaDB SkySQL or Xpand, which is a separate product designed for cloud deployments. So, for realistic scalability, especially in the cloud, you might need to use MariaDB SkySQL.
We have a couple of hundred users currently working with the database. It's probably around 400.
How was the initial setup?
It's currently deployed on-premises, but we're planning to move it to the cloud in the future.
What about the implementation team?
It's not difficult to maintain. It does require some maintenance, but it's very stable. You don't really need to intervene much, so it's quite stable. The main maintenance we do is patching and upgrading once a year. So it's not too taxing to maintain.
Which other solutions did I evaluate?
I have used MySQL or Oracle products.
MariaDB, being open source, is a significant advantage, especially considering we use the enterprise edition. It's considerably much cheaper than Oracle, which is a proprietary database with high licensing costs. So, from a financial perspective, MariaDB is far more economical.
Another advantage lies in its robust online community, simplifying troubleshooting and assistance. While we do have enterprise support, the online community and resources are quite valuable.
As for cons, due to fewer contributors compared to other databases like MariaDB, certain features might experience slower development. Amazon and MariaDB Corporation are among the contributors, but it's an area that could use more attention. However, overall, MariaDB remains a strong choice.
What other advice do I have?
MariaDB emerged as a distinct entity originating from MySQL, rather than being an inherent part of it. Formed in 2009 due to apprehensions that Oracle Corporation might negatively impact MySQL, which they acquired in 2010.
When deciding between MySQL and MariaDB, the feature disparity is minimal. MySQL has adeptly upheld compatibility since the transition, making it primarily a matter of personal preference. Some features differ between MariaDB and MySQL, catering to unique preferences.
In essence, MariaDB is a highly favored relational database, a commendable choice within the relational database realm. For those seeking a relational database, MariaDB stands as a solid option. As for purchasing a database, MariaDB comes highly recommended. It claims the second-highest rank globally and holds the second spot in the DB-Engines ranking. MongoDB ranks a bit lower, but the choice between the two is essentially equivalent.
On the whole, I would assign a rating of seven out of ten to this solution.
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.
Works at a tech services company with 10,001+ employees
Solid and reliable database server with excellent multi-master setups
Pros and Cons
- "The initial setup of MariaDB is simple enough."
- "The only potential area for improvement could be the pricing model, which might benefit from being more flexible or a bit cheaper."
What is our primary use case?
We use MariaDB for small and middle-sized applications of all kinds. It is primarily used for database operations and functions as a database server.
What is most valuable?
We use some asynchronous master-slave implementations and synchronous multi-master Galera setups.
What needs improvement?
The only potential area for improvement could be the pricing model, which might benefit from being more flexible or a bit cheaper.
For how long have I used the solution?
I have been working with MariaDB for five years.
What do I think about the stability of the solution?
MariaDB is very stable. I would rate its stability a nine out of ten.
What do I think about the scalability of the solution?
MariaDB is fine for small and middle-sized databases. However, for very large environments, I would hesitate as I don't think that MariaDB is limitless scalable. There is a decisive difference between MariaDB and larger databases like Oracle.
How was the initial setup?
The initial setup of MariaDB is simple enough.
What about the implementation team?
My colleagues or I usually do the setup. We install and configure everything, and once it's running, the client takes over with the application setup.
What's my experience with pricing, setup cost, and licensing?
I have found the price of commercial MariaDB to be pretty steep, although not as high as Oracle. Customers often prefer the Community Edition because it's free.
Which other solutions did I evaluate?
MariaDB's main competitors are MySQL, Oracle, and Postgres. I think Postgres is the sharpest competitor to MariaDB.
What other advice do I have?
I would fully recommend MariaDB. It is stable, performs well, and is relatively easy to handle. Overall, it has good basic functionality.
I'd rate the solution eight out of ten.
Which deployment model are you using for this solution?
On-premises
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Other
Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator/Partner
Last updated: Sep 29, 2024
Flag as inappropriateGeneral Manager at Xurpas Software, Inc.
Offers good query speed to users
Pros and Cons
- "The most valuable feature of the solution is the query speed it offers."
- "The ability to create stored procedures in MariaDB is an area where the tool lacks a bit."
What is our primary use case?
Around 90 percent of our clients are using MariaDB.
My company sells, implements, and supports ERP systems, and our particular ERP offering runs on MariaDB.
Our ERP solution runs on MariaDB by default. The second database that MariaDB also supports is not a tool we actively promote, but some of our clients prefer it and it is known as PostgreSQL.
What is most valuable?
The most valuable feature of the solution is the query speed it offers. It can really process queries, and essentially, every field that you add to a table is automatically indexed and can be queried.
What needs improvement?
The ability to create stored procedures in MariaDB is an area where the tool lacks a bit. It is an area where improvements are required. MariaDB is not as powerful as Microsoft SQL Server, which is a tool that I don't use because, in my opinion, putting a processing load on the database is not a good architecture.
For how long have I used the solution?
I have been using MariaDB since 2018. My company has a partnership with MariaDB.
How are customer service and support?
MariaDB is open-source and free to use. We do not need external support when we can support ourselves in terms of the technicalities surrounding its use or even help our clients who use it.
Which solution did I use previously and why did I switch?
I actually use MariaDB, and I used PeerSpot's website to search for and compare the performance between MariaDB and MySQL for our company's marketing efforts. Now, we are pushing MariaDB in our company.
Over PostgreSQL, I can say MariaDB is comparatively easier to use. PostgreSQL is ideal for larger datasets as the processing works faster. The hardware requirements for PostgreSQL are slightly higher than those for MariaDB, which means our hosting services will incur more costs if we use it. MariaDB and PostgreSQL are more or less the same. PostgreSQL is slightly more scalable than MariaDB. There are some tech people who, because of even that small margin, even if they are really not going to be maximizing the power behind PostgreSQL fields, believe that it will work better for them.
How was the initial setup?
My company helps the customers implement the product.
I have had no problems configuring the tool. There was one highly technical problem I had with it, but I have found a solution for it.
What's my experience with pricing, setup cost, and licensing?
MariaDB is available for free.
What other advice do I have?
In terms of AI or machine learning, we are actually developing predictive AI capabilities using MariaDB. Essentially, we have segmented our market into small, medium, and large. The data model we need for small is okay, so using MariaDB for small to medium businesses is fine. For large businesses, we prefer to go with MongoDB.
It is not my department to look into the AI part. We have our company's own AI labs, but it is not under my control. There are a couple of AI projects, but I am not completely aware of the details of the projects that my company's team is working on currently.
It can impact the operational costs of our customers compared to other databases. The tool obviously lowers the customer's total cost of ownership of the software because they don't need to pay a separate fee for the database.
My company doesn't offer that we don't charge separately for the database. It is really transparent to the end user to the client. When it comes to the cost of the database, it is free. We charge if our customers prefer it because it has a configurable option whether they want to keep the application server and the database server separate. If they want a separate database server, then we charge for the server but not for the database.
I recommend the tool to others. The main and primary reason why I even encountered PeerSpot website is to look for information and find data that will support my claim that MariaDB is as good or even better than some database solutions out there.
I rate the tool an eight or nine out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Sep 13, 2024
Flag as inappropriateProduct Manager at Hyundai Autoever Company
Lightweight application, employ multi-processing but indexes are not as strong
Pros and Cons
- "It is a scalable solution. It easily scales up and scales down."
- "The customer service and support are okay. But the response time is slow. Moreover, the material is not available freely."
What is our primary use case?
The solution is essentially an enterprise application. In our setup, there was a considerable amount of data being utilized. Later, the application shifted to the cloud, and for this cloud migration, we opted for a database switch from Oracle to MariaDB. That's why we migrated all the data and components to MariaDB.
What is most valuable?
The standout feature is the multitude of features available. There isn't a specific feature that's unavailable in other databases. The key differentiator is the speed.
When referring to it as a hard code, the core size is crucial. In MariaDB, we can employ multi-processing, allowing users to make use of the core and process data more efficiently and swiftly.
What needs improvement?
In MariaDB, three aspects can be enhanced, starting with the indexes. Currently, the indexes are not as strong. The second area is related to exclusion queries, subqueries, or joins. There's one join that isn't fully supported, the product I came across about MariaDB.
Customer support can also be improved.
For how long have I used the solution?
I have been using this solution for four years.
What do I think about the stability of the solution?
There have been some issues. If you need to provide 24/7 availability, you have to follow the active-subprivate mode, where one application is active and the second is down. So, other substitute techniques, like mirroring and scrubber techniques, are also available for such scenarios.
What do I think about the scalability of the solution?
It is a scalable solution. It easily scales up and scales down.
How are customer service and support?
The customer service and support are okay. But the response time is slow.
Moreover, the material is not available freely.
How would you rate customer service and support?
Neutral
Which solution did I use previously and why did I switch?
We have used several databases like MySQL, Oracle, and NoSQL MongoDB. We have tried a number of solutions, so we have that experience.
We switched due to its features. It is a lightweight application, making it the best choice for our lightweight applications.
How was the initial setup?
The initial setup is straightforward. It's not a big deal.
What about the implementation team?
I have deployed it on the cloud, using Linux and everything. It can be deployed within a day.
Which other solutions did I evaluate?
When we were doing the technical evaluation, we considered MariaDB, Finsecure, and AWS cloud databases. Based on that, we made the decision.
What other advice do I have?
Overall, I would rate the solution a five out of ten.
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: January 2025
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?