Try our new research platform with insights from 80,000+ expert users
Walter Diurno - PeerSpot reviewer
Director - Software Development at PRI
Real User
Top 10
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. 

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.

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.
PeerSpot user
Nalin Kumar - PeerSpot reviewer
Quality Assurance Group Lead at Samsung
Real User
Top 5Leaderboard
Allows for fetching data from multiple correlated or related databases in a single query, user-friendly and easy to handle
Pros and Cons
  • "One of the great features of MariaDB is its scalability. It's easy to handle even with large databases."
  • "In future releases, mainly the addition of security features would be beneficial for MariaDB."

What is our primary use case?

For various applications, we use MariaDB as a database to test the incoming and outgoing data for any application. 

We check the relational database, how it's working, how the data is organized, how the queries have been written, and how we can streamline or improve the performance of these stored procedures. 

These are the things we look for to maintain a good relationship between the front end and the back end of the system.

What is most valuable?

One of the great features of MariaDB is its scalability. It's easy to handle even with large databases. 

It's also user-friendly and allows you to create complex relationships with the data. It means you can fetch data from multiple correlated or related databases in a single query. So it allows complex relationships with specific databases.

MariaDB supports SQL, and it has an advantage over regular SQL in that it is a lighter version. Even with huge amounts of data, it performs well.

What needs improvement?

MariaDB is everything that SQL DB has, but it's much lighter and more flexible. It's also more expandable. So I don't think MariaDB has any disadvantages compared to SQL DB.

So the only issue is that it's not as lightweight as SQL DB. That's probably the only drawback.

In future releases, mainly the addition of security features would be beneficial for MariaDB. It would be great to have built-in capabilities that can be managed through plug-ins and system administration. This would require incorporating security measures into the code, which is a one-time activity but needs to be maintained. Wrappers can also be written for reusability and improved security. That's something MariaDB could benefit from.

For how long have I used the solution?

Since I've been in my current company, we have used Microsoft SQL Server (MSSQL) as the database since the beginning. And then there's MariaDB.

Additionally, we also use Oracle in some specific projects.

What do I think about the stability of the solution?

Sometimes any system may have occasional issues, but overall, we are not facing significant problems. We used to face more issues in the early stages.

Overall, I would rate the stability a nine out of ten. 

What do I think about the scalability of the solution?

MariaDB is quite easy to maintain. It's scalable and maintainable. Since it's Knox, directly or indirectly, around 40,000 people would be using it.

How are customer service and support?

We have an in-house team to maintain MariaDB, so we don't require much external support.

Which solution did I use previously and why did I switch?

I've worked with Oracle for one and a half years. Currently, I'm working with MariaDB and SQL DB.

I worked with Oracle DB before. Currently, I am not working with Oracle DB. Oracle is much more secure, but it is also costlier. 

With MariaDB, you have to be proactive. The security team and the design team need to be vigilant to ensure sufficient security measures. On the other hand, Oracle comes with security features included in the package, which is a major advantage. 

How was the initial setup?

MariaDB is quite easy to install.

What about the implementation team?

Deployment time depends on the level of application and the size of the database. For example, installing MariaDB from scratch may take some time due to design and architectural issues. 

However, if the DB is already available and you need to install it on your system, it doesn't take much time. It usually takes only one or two days, depending on the support you receive from the server side.

So, the number of people required for the deployment depends on the systems and the project. The magnitude of the database also plays a role. 

Since it's not a centralized database and specific to various systems, I would say for Knox, where we also use MariaDB in a large-scale system, there are more than 50 people involved in the design and database aspects out of a team of a thousand people.

And as for architects, there would be fewer. There are six to seven architects because there are different systems for nodes, meetings, Knox Mail, and Knox Client teams. So each specific system may have a dedicated architect.

What's my experience with pricing, setup cost, and licensing?

MariaDB is relatively cheap. It is very cost-effective.

What other advice do I have?

My advice would be, if you can handle the security aspect, MariaDB is a lightweight, scalable, and maintainable database that can be used for both small and large applications.

On a scale of one to ten, I would rate it nine. Due to its cost-effectiveness, scalability, and flexibility, I find it highly commendable.

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.
PeerSpot user
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.
Salomon Metre - PeerSpot reviewer
Laboratory Assistant at Strathmore University
Real User
Top 5
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?

I use MariaDB in my company to build simple web applications.

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.

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.
PeerSpot user
Product Manager at Hyundai Autoever Company
Real User
Top 10
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.
PeerSpot user
Martin Simons - PeerSpot reviewer
Senior Consultant at Matrix technology AG
Consultant
Top 10
A reliable relational database that offers good stability to its users
Pros and Cons
  • "The most valuable feature of the solution is a relational database, which is fairly reliable...It is a stable solution."
  • "MariaDB should provide HA and archive logging... I haven't had the opportunity to use the features provided by the solution since I don't know how to see them."

What is our primary use case?

I use MariaDB since my organization has different customers who use different databases. My company caters to the customers' needs depending on the database they want to use.

What is most valuable?

The most valuable feature of the solution is a relational database, which is fairly reliable. My company is satisfied with most of the features of the solution. My company just provides services to customers depending on what they want, so we don't necessarily dig too deeply into why they want it. If a customer asks for a referral or suggestions for a free database, then my company normally tries to push PostgreSQL, a tool we get directly from the vendor.

What needs improvement?

My company hasn't seen any problems with the solution where it has been running. The solution works fine for the purpose it is meant for, so there are no issues.

MariaDB should provide HA and archive logging. If HA and archive logging are present in the solution, it is hard to find them. The aforementioned details related to HA and archive logging need to be considered for improvement. I haven't had the opportunity to use the features provided by the solution since I don't know how to see them.

For how long have I used the solution?

I have been using MariaDB for a couple of years. My company operates as a consultant offering support for the solution.

What do I think about the stability of the solution?

It is a stable solution. I haven't seen any stability issues for the purpose MariaDB is meant to function.

What do I think about the scalability of the solution?

In my company, the instance related to MariaDB is fairly small, so I can't comment much on its scalability.

For MariaDB, my company has only one customer who uses it for a single instance, which is about 20 GB of data at the moment.

How are customer service and support?

I haven't had the need to contact the solution's technical support.

How was the initial setup?

The solution is deployed on an on-premises model.

MariaDB can be deployed in a day.

What's my experience with pricing, setup cost, and licensing?

My company uses the free version of the solution.

Which other solutions did I evaluate?

With PostgreSQL, it's simply the archive logging functionality and remote hard clustering capabilities.

My company is not familiar with how the functionalities of PostgreSQL would work for MariaDB or MySQL.

What other advice do I have?

I would tell those planning to use the solution that it is pretty much the same as MySQL, but since my company has dealt with only one instance in MariaDB, I can't say much about it.

I rate the overall solution an eight 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.
PeerSpot user
Ton Ancheta - PeerSpot reviewer
General Manager at Xurpas Software, Inc.
Real User
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.
Flag as inappropriate
PeerSpot user
reviewer1378032 - PeerSpot reviewer
Site Reliability Engineer at a computer software company with 10,001+ employees
MSP
Top 20
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.
    Flag as inappropriate
    PeerSpot user
    reviewer2046459 - PeerSpot reviewer
    Works at a tech services company with 10,001+ employees
    MSP
    Top 20
    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
    Flag as inappropriate
    PeerSpot user