MariaDB vs SingleStore comparison

Cancel
You must select at least 2 products to compare!
MariaDB Logo
7,195 views|6,415 comparisons
96% willing to recommend
SingleStore Logo
323 views|236 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, Firebird and others in Open Source Databases.
To learn more, read our detailed Open Source Databases Report (Updated: June 2024).
772,679 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 stable solution.""The performance is very good.""The solution is very easy to implement.""From the user's perspective, the performance of the columnar queries is very good in terms of the database when comparing it to the Oracle, and MySQL.""It's easy to set up.""It's open source.""The most valuable feature of MariaDB is the power it provides. It is a powerful solution.""Great monitoring and performance stability."

More MariaDB Pros →

"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines.""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.""MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short.""The paramount advantage is the exceptional speed.""The product's initial setup phase was pretty straightforward, with no complex processes."

More SingleStore Pros →

Cons
"Data continuity could be improved.""The GUI could be improved a bit. The user interface needs to be improved.""The price could be less expensive.""The customer service and support are okay. But the response time is slow. Moreover, the material is not available freely.""Maria DB has to improve from a management perspective.""The configuration could be improved. It should be easier.""There is room for improvement in terms of security.""It would be good if they can maybe improve the mass import in the database. Currently, for importing a large number of data, we create a CSV file and upload all the things in the system. The system does not activate them by default. We have to do this manually. This may be due to the version we are using, but this is something we would like to see improved."

More MariaDB Cons →

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

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.
    772,679 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The integration with other products is seamless.
    Top Answer:We are facing some deadlock issues when the nodes get rebooted. There is not much support available. The support must be improved. The downtime is more. It takes us time to restore production. There… more »
    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
    4th
    Views
    7,195
    Comparisons
    6,415
    Reviews
    26
    Average Words per Review
    451
    Rating
    8.0
    7th
    Views
    323
    Comparisons
    236
    Reviews
    6
    Average Words per Review
    607
    Rating
    8.7
    Comparisons
    SQL Server logo
    Compared 36% of the time.
    Oracle Database logo
    Compared 14% of the time.
    Firebird SQL logo
    Compared 12% of the time.
    PostgreSQL logo
    Compared 11% of the time.
    IBM Informix logo
    Compared 1% of the time.
    SQL Server logo
    Compared 10% of the time.
    Teradata logo
    Compared 8% of the time.
    MySQL logo
    Compared 8% of the time.
    CockroachDB logo
    Compared 8% of the time.
    Neo4j Graph Database 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.”

    The SingleStore platform combines transactional, analytical, and vector data workloads in a real-time, unified, distributed SQL database that is MySQL and MongoDB wire protocol-compatible. SingleStore also combines the capabilities of traditional databases with the scalability of the cloud, making it suitable for a range of data-driven applications.

    SingleStore provides a unified platform that supports both transactional and analytical workloads, enabling real-time data processing and analysis. It is optimized for speed, offering low-latency data access and high throughput. The platform's distributed architecture allows it to scale horizontally, handling large volumes of data across multiple nodes. Additionally, it supports SQL, making it accessible for users familiar with standard query languages.

    Key features of SingleStore include real-time data ingestion, which allows for the immediate processing of incoming data, and a fully distributed SQL execution engine that enhances performance. The platform also offers in-memory rowstore and disk-based columnstore, providing flexibility in data storage and retrieval methods. Furthermore, SingleStore ensures high availability and disaster recovery with its multi-cloud, multi-region deployment options.

    When evaluating SingleStore, you should consider its ability to reduce query response times significantly, improve operational efficiencies with real-time analytics, and lower infrastructure costs through efficient resource utilization. Additionally, the platform's support for mixed workloads enables businesses to streamline their data operations, reducing the need for multiple specialized databases.

    SingleStore is implemented across various industries, including finance, healthcare, and retail. In finance, it helps with real-time risk analysis and fraud detection. In healthcare, it supports advanced analytics for patient data management. Retailers use SingleStore to optimize supply chain operations and personalize customer experiences through real-time data insights.

    Pricing for SingleStore is based on a subscription model, with costs determined by the resources allocated and the level of support required. It offers flexible licensing options to accommodate different business needs. SingleStore's customer support is known for its responsiveness and expertise, providing users with the necessary assistance to maximize the platform's potential.

    In summary, SingleStore offers a versatile and efficient cloud database solution suitable for handling diverse data workloads with high performance and scalability.

    Sample Customers
    Google, Wikipedia, Tencent, Verizon, DBS Bank, Deutsche Bank, Telefónica, Huatai Securities
    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, and ZoomInfo.
    Top Industries
    REVIEWERS
    Computer Software Company21%
    Manufacturing Company15%
    Financial Services Firm12%
    Comms Service Provider12%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Comms Service Provider11%
    Financial Services Firm9%
    Educational Organization8%
    VISITORS READING REVIEWS
    Financial Services Firm25%
    Computer Software Company14%
    Manufacturing Company6%
    Comms Service Provider6%
    Company Size
    REVIEWERS
    Small Business39%
    Midsize Enterprise21%
    Large Enterprise40%
    VISITORS READING REVIEWS
    Small Business27%
    Midsize Enterprise17%
    Large Enterprise57%
    REVIEWERS
    Small Business57%
    Large Enterprise43%
    VISITORS READING REVIEWS
    Small Business23%
    Midsize Enterprise13%
    Large Enterprise63%
    Buyer's Guide
    Open Source Databases
    June 2024
    Find out what your peers are saying about Oracle, PostgreSQL, Firebird and others in Open Source Databases. Updated: June 2024.
    772,679 professionals have used our research since 2012.

    MariaDB is ranked 4th in Open Source Databases with 52 reviews while SingleStore is ranked 7th 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 "Easy to deploy, cost-effective, and integrates seamlessly with other products". 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, Firebird SQL, PostgreSQL and IBM Informix, whereas SingleStore is most compared with SQL Server, Teradata, MySQL, CockroachDB and Neo4j Graph Database.

    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.