MariaDB vs SingleStore comparison

Cancel
You must select at least 2 products to compare!
MariaDB Logo
7,700 views|6,757 comparisons
96% willing to recommend
SingleStore Logo
308 views|238 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between MariaDB and SingleStore based on real PeerSpot user reviews.

Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases.
To learn more, read our detailed Open Source Databases Report (Updated: March 2024).
768,415 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"There is the need for a robust IDE for MongoDB. The existing PHP admin console doesn't meet the client's requirements effectively.""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 can solve things better than MySQL. Maria DB has better performance than MySQL.""It is very simple to install, and the commands are exactly the same as MySQL.""I haven't faced any technical issues with the product, and it works fine.""The most valuable feature is that it uses multiple cores, which is better than some of the other databases.""Easy to use and available in most environments.""MariaDB has a straightforward initial setup with easy-to-understand documentation."

More MariaDB Pros →

"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms.""MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short.""The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines.""The product's initial setup phase was pretty straightforward, with no complex processes.""The paramount advantage is the exceptional speed.""It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data.""The product can automatically reinstall and reconfigure in case of a shutdown."

More SingleStore Pros →

Cons
"MariaDB could improve by adding support for non-relational structures and new data types.""The performance could be a bit better.""I’m not sure if it can scale.""I would like to see more compatibility going forward. This would help if there is a need to change databases.""The configuration could be improved. It should be easier.""The PL/SQL performance is slow if you have big batch jobs running overnight.""The stability could always continue to be improved upon.""It does not have tools for debugging procedures and functions."

More MariaDB Cons →

"We don't get good discounts in Pakistan.""There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great.""It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks.""Having the ability to migrate servers using a single command would be extremely beneficial.""The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings.""Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally.""For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."

More SingleStore Cons →

Pricing and Cost Advice
  • "The price of this solution represents a very good compromise between the cost and what it offers."
  • "It's an open-source solution."
  • "The licensing cost is approximately $4000.00 per year and the licensing is based on the software and the number of posts that you make."
  • "I used the open-source version, which is available free of charge."
  • "This is an open-source product, which can be used free of charge."
  • "This is an open source solution with no licensing fees."
  • "MariaDB is open-source and self-hosted."
  • "When it comes to MariaDB, it should have a more cost-effective license."
  • More MariaDB Pricing and Cost Advice →

  • "I would advise users to try the free 128GB version."
  • "SingleStore is a bit expensive."
  • "The product's licensing is not expensive. It is comparable."
  • "Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."
  • "The price of the product is okay compared to the other available solutions in the market. SingleStore is a reasonably priced product, considering the functions it offers."
  • "They have two main options: cloud installation and bare-metal installation, each with different pricing models."
  • More SingleStore Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
    768,415 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:There is the need for a robust IDE for MongoDB. The existing PHP admin console doesn't meet the client's requirements effectively.
    Top Answer:Price-wise, the product is affordable. The product is not expensive.
    Top Answer:There is the need for a robust IDE for MongoDB. The existing PHP admin console doesn't meet the client's requirements effectively.
    Top Answer:The paramount advantage is the exceptional speed.
    Top Answer:Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure. While building an on-premise cluster incurs an initial cost for servers with ample RAM… more »
    Top Answer:There's a noteworthy consideration when it comes to collecting massive amounts of data. It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation… more »
    Ranking
    3rd
    Views
    7,700
    Comparisons
    6,757
    Reviews
    28
    Average Words per Review
    438
    Rating
    8.0
    6th
    Views
    308
    Comparisons
    238
    Reviews
    6
    Average Words per Review
    607
    Rating
    8.7
    Comparisons
    SQL Server logo
    Compared 37% of the time.
    Oracle Database logo
    Compared 13% of the time.
    PostgreSQL logo
    Compared 12% of the time.
    Firebird SQL logo
    Compared 11% of the time.
    Vertica logo
    Compared 0% of the time.
    Learn More
    MariaDB
    Video Not Available
    SingleStore
    Video Not Available
    Overview

    MariaDB is an open source relational database created by the original founders of MySQL. It is considered one of the most popular and trusted database servers throughout the world. MariaDB is a valued component found in most cloud offerings and is the default in many Linux tools. It is also widely used by Wikipedia, WordPress, and Google, among other well-known sites. Maria DB easily melds data into concise information from a vast array of applications, such as banking, online shopping, websites, and more.

    MariaDB was originally created to improve MySQL performance. It is the most widely chosen database server due to the solution being super fast, robust, user-friendly, and easily scalable. MariaDB also offers a substantial ecosystem of plugins, storage engines, and numerous other valuable tools that make it very attractive for a significant offering of use cases.

    The solution’s newest functionalities include compatibility with Oracle Database and Temporal Data Tables, and advanced clustering with Galera Cluster 4, which make it easier for users to research data history from any point in the past. Additionally, the most recent versions include JSON and GIS features. MariaDB is committed to staying an open source solution.

    MariaDB Features

    • More storage: MariaDB works with more storage engines than MySQL and most other database servers available. Some storage options include, but are not limited to ARCHIVE, MERGE, CSV, MEMORY, BLACKHOLE, MyISAM, ColumnStore, MyRocks, and Cassandra.

    • Super fast: MariaDB offers faster authentication checks. The FlushSSL permits SSL certificates to be reloaded without a server restart, resulting in huge time savings.

    • Improved testing: MariaDB offers an extending testing suite that runs faster and can test more than ever before. Bugs can be easily fixed and invalid tests removed.

    • Genuinely open source: Every code in MariaDB is GPL, LGPL, or BSD. Client libraries [for Windows (ODBC), Java (JDBC), or C] allow linking to closed source software. All fixed bug cases and development plans are completely public. MariaDB is a community-developed solution representing the true spirit of open source products.

    Reviews from Real Users

    Faustine C., Engineering Supervisor- Corporate Data Solutions and Services at TZ Telecoms Corporation, shares, “The software provides a lot of information on what is happening inside the database. For most performance parameters it is easy to know if something is not right in the configuration or optimization which helps engineers take remedial fine-tuning measures. For example, if the database is underperforming it is easy to know which performance parameter can be adjusted to handle the workload. It is difficult to troubleshoot database issues if many performance parameters can not be monitored or debugged which is the case with some database management systems. It provides great monitoring of data storage, processing, and performance stability which is really important for real-time data storage and processing. It's a user-friendly product.”

    A PeerSpot user who is a Senior Engineer at a tech services company relates, “ The solution's high availability is its most valuable aspect. We have found the product to be stable and the initial setup is pretty simple. 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.”

    SingleStore is headquartered in San Francisco, California, and offers the SingleStore platform,which combines transactional, analytical, & vector data workloads in a real-time, unified, distributed SQL database that is MySQL and MongoDB wire protocol-compatible. SingleStoreDB Cloud is offered as a managed service on AWS, Google, and Azure and in private clouds including IBM Cloud Pak for Data and Red Hat OpenShift. Other partners (50+ in all) include HPE, Twingo, Data-Sleek, Datadog, and Arcion. SingleStoreDB Self-Managed runs on premise/containers/Kubernetes. SingleStore has offices in Sunnyvale, Seattle, Portland, Raleigh, Boston, London, Dublin, Lisbon, Kyiv, Hyderabad, and Singapore, with remote workers worldwide. It has hundreds of customers including 100+ Fortune 500, Forbes Global 2000, and Inc. 5000 brands across 37 verticals, with the top four being financial services and fintech; media, streaming, and telecommunications; adtech/martech/salestech; and retail/eCommerce. SingleStore platform features include Code Engine with WASM, Data API, dbt Connector, Limitless Point-in-Time Recovery, MongoDB API, Pipelines, Unlimited (Bottomless) Storage, and Workspaces.

    Sample Customers
    Google, Wikipedia, Tencent, Verizon, DBS Bank, Deutsche Bank, Telefónica, Huatai Securities
    SingleStore has hundreds of customers including 100+ Fortune 500, Forbes Global 2000, and Inc. 5000 brands across 37 verticals, with the top four being financial services and fintech; media, streaming, and telecommunications; adtech/martech/salestech; and retail/eCommerce. Sample customers include: 6Sense Adobe Akamai CARFAX Cigna Cisco Comcast DBS Bank Dell GE Goldman Sachs Heap Hulu IMAX Kakao Kroger LiveRamp Lumana NBC Outreach Palo Alto Networks Siemens SiriusXM SK Telecom SKAI Sony STC TATA ZoomInfo
    Top Industries
    REVIEWERS
    Computer Software Company19%
    Manufacturing Company16%
    Financial Services Firm13%
    Comms Service Provider13%
    VISITORS READING REVIEWS
    Computer Software Company15%
    Comms Service Provider12%
    Financial Services Firm8%
    Educational Organization8%
    VISITORS READING REVIEWS
    Financial Services Firm25%
    Computer Software Company15%
    Comms Service Provider6%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business39%
    Midsize Enterprise22%
    Large Enterprise39%
    VISITORS READING REVIEWS
    Small Business26%
    Midsize Enterprise16%
    Large Enterprise57%
    REVIEWERS
    Small Business57%
    Large Enterprise43%
    VISITORS READING REVIEWS
    Small Business22%
    Midsize Enterprise14%
    Large Enterprise64%
    Buyer's Guide
    Open Source Databases
    March 2024
    Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases. Updated: March 2024.
    768,415 professionals have used our research since 2012.

    MariaDB is ranked 3rd in Open Source Databases with 51 reviews while SingleStore is ranked 6th in Database as a Service with 7 reviews. MariaDB is rated 8.2, while SingleStore is rated 8.8. The top reviewer of MariaDB writes "Simultaneously use active server capabilities but lacks the maturity ". On the other hand, the top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". MariaDB is most compared with SQL Server, Oracle Database, PostgreSQL, Firebird SQL and Vertica, whereas SingleStore is most compared with SQL Server, MySQL, Teradata, Oracle Database and Cloudera Distribution for Hadoop.

    We monitor all Open Source Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.