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).
767,319 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
"It is a scalable solution. It easily scales up and scales down.""MariaDB has a straightforward initial setup with easy-to-understand documentation.""We use MariaDB for identity provider services. Most of the things that we are doing are deployed in the container mode. All such solutions require a database, and MariaDB is easier to use for these kinds of deployments.""The product has good documentation and you can find many examples online.""MariaDB is stable and the initial setup is straightforward.""The product has been stable and reliable.""The solution is very stable. It was originally built under MySQL. It has a similar level of stability.""The most valuable feature of the solution is a relational database, which is fairly reliable...It is a stable solution."

More MariaDB Pros →

"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms.""The product can automatically reinstall and reconfigure in case of a shutdown.""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 most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines.""MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short.""The product's initial setup phase was pretty straightforward, with no complex processes.""The paramount advantage is the exceptional speed."

More SingleStore Pros →

Cons
"In future releases, mainly the addition of security features would be beneficial for MariaDB.""One feedback I can quickly provide is the need for a robust IDE for MongoDB. The existing PHP admin console doesn't meet the client's requirements effectively.""Master-master replication is something that needs to be simplified.""The dashboard and pricing need improvement.""I’m not sure if it can scale.""In the next release, I would like to see improvements in the scalability and redundancy features.""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.""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."

More MariaDB Cons →

"We don't get good discounts in Pakistan.""Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally.""It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks.""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.""The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings.""There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great.""Having the ability to migrate servers using a single command would be extremely beneficial."

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.
    767,319 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.
    SQL Server logo
    Compared 10% of the time.
    MySQL logo
    Compared 9% of the time.
    Teradata logo
    Compared 7% of the time.
    Oracle Database logo
    Compared 7% of the time.
    Amazon RDS logo
    Compared 4% 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 SingleStoreDB, 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 Akamai Technologies Arcules Armis Security Canadian Tire CARFAX Cigna Cisco Systems Comcast dailyVest Dell Technologies Digital Asset Research (DAR) Directed Technologies DirectlyApply Factors.AI Fathom Analytics FirstEnergy GAMEFAM/Silicon Digital GE Goldman Sachs Heap Hulu IMAX impact.com Kakao Kellogg Kroger LiveRamp Lumana Millennium bcp MonitorBase NBC Universal Nyris Octane Outreach Palo Alto Networks PAN HOME Questrade Saudi Telecom Company Siemens AG SiriusXM Siteimprove SK Telecom SKAI Sony Interactive Entertainment Tata Communications Limited Western Digital Corporation 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 Enterprise58%
    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.
    767,319 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 Amazon RDS.

    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.