Try our new research platform with insights from 80,000+ expert users
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.

Buyer's Guide
MariaDB
December 2024
Learn what your peers think about MariaDB. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.

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
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
Buyer's Guide
MariaDB
December 2024
Learn what your peers think about MariaDB. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
Mark Griffith - PeerSpot reviewer
Associate, Software Developer (Appian) at The European Bank for Reconstruction and Development
Real User
Top 10
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.
PeerSpot user
Ton Ancheta - PeerSpot reviewer
General Manager at Xurpas Software, Inc.
Real User
Top 20
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
    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
    Georges BOMBOH - PeerSpot reviewer
    Director at Pharos Consulting
    Reseller
    Easy to use with good performance and security
    Pros and Cons
    • "We like the easy way that we can collect data from other databases."
    • "We'd like more data intelligence."

    What is our primary use case?

    We're primarily using the solution for a data warehouse. It's just used to collect all this information from several databases, such as SQL Server, MySQL Server, DB2 Mainframe, and ZOS. We are collecting data from Excel spreadsheets. We're scanning and putting data right into MariaDB.

    How has it helped my organization?

    The best way to simplify our data governance process.

    What is most valuable?

    We like the easy way that we can collect data from other databases. 

    The performance and the security that we got on it are great.

    The way that they distribute the database is excellent.

    It is a product that is very easy to use.

    It's helped us a lot in our data governance procedure.

    Technical support is great.

    What needs improvement?

    We'd like more data intelligence. We are working with a client who needs a lot of information about Oracle groups that come in the country, on the passenger name records, and so on. We need more intelligence around that in order to work better.

    For how long have I used the solution?

    I've been using the solution for six months.

    What do I think about the stability of the solution?

    We didn't have any bugs yet. The solution is stable and reliable. We haven't had any issues yet.

    What do I think about the scalability of the solution?

    We're still testing the solution with 30 people. Once we go into production, we'll train the whole company. therefore, we do plan to increase usage. 

    How are customer service and support?

    We're quite happy with the technical support. We are satisfied as they are responding in time. They are giving us good answers. 

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

    We did not previously use a different solution. We started with this product from scratch. We're still organizing our approaches to be more competitive.

    How was the initial setup?

    We are implementing this solution with a variety of other solutions and setting everything up at once.

    The solution is not so complex in that we don't want to resell any solution that we are not trying on ourselves. Therefore, we have a good understanding of how everything works, having done it ourselves.

    We are still in production, and, after six months, we will begin deploying the solution.

    On our side, we have three people working with MariaDB and two people at MariaDB helping as well.

    What about the implementation team?

    We're working with our client's technical services to get everything deployed.

    What was our ROI?

    We don't have clarity on an ROI yet. We've just started using the solution. 

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

    I can't speak to the exact pricing.

    The cost of licensing is dependent on the projects. We have many types of licensing. We have a subscription and we also have some like lesson sheets that we buy. After, we just pay for the maintenance.

    Which other solutions did I evaluate?

    We evaluated many options. We went for simple software. We took Hadoop with Cloudera since the best version of Hadoop is Cloudera. Then, we have MariaDB on our HCI environment to secure all of this. There's a general sense of happiness with these products. It's really easy for us to use everything. Still, we are just at the beginning of the use phase.

    What other advice do I have?

    We've started from scratch and we are using this product to build up use cases. 

    We are a service company and we reselling the solution. We are working directly with MariaDB.

    The product is easy to use. When you're a database administrator and you're working with databases, such as MariaDB, it's very, very, very easy. You get the performance, you get the security, and you get monitoring and disaster recovery. You're working in a secure area with the performance you need and can mass scale it which is very useful.

    I'd rate the solution eight out of ten. We still are exploring all of the possibilities, however. 

    Which deployment model are you using for this solution?

    Private Cloud
    Disclosure: My company has a business relationship with this vendor other than being a customer:
    PeerSpot user