MariaDB vs SingleStore comparison

Cancel
You must select at least 2 products to compare!
MariaDB Logo
8,428 views|7,360 comparisons
SingleStore Logo
283 views|227 comparisons
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).
765,234 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
"Easy to use and available in most environments.""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 solution has PL/SQL compatibility.""It's easy to set up.""MariaDB is scalable.""This solution is user-friendly.""MariaDB can solve things better than MySQL. Maria DB has better performance than MySQL.""Installation is straightforward."

More MariaDB Pros →

"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.""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 paramount advantage is the exceptional speed.""The product can automatically reinstall and reconfigure in case of a shutdown.""The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."

More SingleStore Pros →

Cons
"With respect to clustering and the master-slave configuration, sometimes the slave goes out of synch.""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.""Could have more integration with user platforms.""The solution can improve by having support for more integration. However, at this time it is working well for us.""The PL/SQL performance is slow if you have big batch jobs running overnight.""The price could be less expensive.""The solution is not scalable.""An improvement would be scaling it up to the levels of Oracle, especially when it comes to resilience, so that we can do higher transactions for two databases or power our operation."

More MariaDB Cons →

"We don't get good discounts in Pakistan.""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.""There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great.""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.""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.
    765,234 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
    8,428
    Comparisons
    7,360
    Reviews
    29
    Average Words per Review
    429
    Rating
    8.1
    6th
    Views
    283
    Comparisons
    227
    Reviews
    6
    Average Words per Review
    607
    Rating
    8.7
    Comparisons
    SQL Server logo
    Compared 36% of the time.
    PostgreSQL logo
    Compared 12% of the time.
    Oracle Database logo
    Compared 12% of the time.
    MySQL logo
    Compared 12% of the time.
    IBM Informix logo
    Compared 0% of the time.
    SQL Server logo
    Compared 10% of the time.
    MySQL logo
    Compared 9% of the time.
    Oracle Database logo
    Compared 8% of the time.
    Teradata logo
    Compared 7% of the time.
    Amazon RDS logo
    Compared 3% 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 Provider11%
    Financial Services Firm8%
    Educational Organization8%
    VISITORS READING REVIEWS
    Financial Services Firm25%
    Computer Software Company14%
    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.
    765,234 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.0, 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, PostgreSQL, Oracle Database, MySQL and IBM Informix, whereas SingleStore is most compared with SQL Server, MySQL, Oracle Database, Teradata 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.