Overview
What is MariaDB Platform?
MariaDB is an open-source relational database made by the original developers of MySQL, supported by the MariaDB Foundation and a community of developers. The community states recent additional capabilities as including clustering with Galera Cluster 4, compatibility with Oracle Database,…
MariaDB fast and reliable
Simplicity at your service
Using MariaDB with SaaS.
Great stability with no DDL operations
MariaDB: the little DB that could.
Positive Review for MariaDB
A Tiny Review of MariaDB
MariaDB Review
MariaDB economical high availability solution with great support
MariaDB Enterprise - Washing the taste of NoSQL out of my mouth!
Gets the job done without punishing you
Fast, reliable, economical database solution
MariaDB - great relational database solution
MariaDB is your go-to RDBMS solution if you need simplicity above all else
MariaDB is one of our go-to choices for …
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Pricing
What is MariaDB Platform?
MariaDB is an open-source relational database made by the original developers of MySQL, supported by the MariaDB Foundation and a community of developers. The community states recent additional capabilities as including clustering with Galera Cluster 4, compatibility with Oracle Database, and…
Entry-level set up fee?
- Setup fee optional
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
38 people also want pricing
Alternatives Pricing
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database.
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is MariaDB Platform?
Other resources:
5 Key Steps for Selecting Your Ideal DBaaS
Guide to Open Source Database Selection: MariaDB vs. MySQL
Enterprise Database Comparison Guide – MariaDB vs. MS, IBM and Oracle
MariaDB Platform Features
- Supported: Cloud DBaaS: SkySQL
- Supported: Workloads: transactions, analytics and smart transactions (HTAP)
- Supported: Transactional scalability: distributed SQL
- Supported: Analytical scalability: columnar data with massively parallel processing
- Supported: Development: temporal tables, JSON documents and geospatial support
- Supported: High availability: automatic failover and transaction replay
- Supported: Disaster recovery: online backups and point-in-time restore
- Supported: Security: transparent data encryption and dynamic data masking
- Supported: Oracle Database compatiblity: data types, sequences and PL/SQL
MariaDB Platform Video
MariaDB Platform Competitors
MariaDB Platform Technical Details
Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Windows, Linux, Centos, Debian, RHEL, SLES, Ubuntu |
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(76)Community Insights
- Business Problems Solved
- Pros
- Cons
MariaDB TX Cluster has been widely used in various industries and organizations, serving as a reliable and efficient solution for a wide range of applications. Users have migrated their operations from Oracle to MariaDB, finding it to be an efficient and reliable database for finance-related services. Additionally, MariaDB is being utilized in academic computing and research projects, providing a quick setup without the need for complex database administration. This has enabled institutions like Pomona College to focus more on their core objectives instead of spending valuable time and resources on managing databases.
Many applications and services heavily rely on MariaDB as their database server. For example, the Eduroam Authentication Service and Stoa, a social collaborative net and learning platform, use MariaDB to ensure smooth and reliable data storage. Furthermore, MariaDB is highly regarded as a drop-in replacement for MySQL, offering performance and stability upgrades without requiring changes to legacy applications. Its simplicity and practical maintenance-free nature make it suitable for low-maintenance systems.
Moreover, MariaDB is utilized in production environments where high availability is essential. The Enterprise 3-node cluster setup leverages improvements in InnoDB performance and SQL-mode features to provide robust database solutions. Whether it's content apps, configuration management, or contest apps, MariaDB serves as the main relational database solution for multiple applications requiring reliable storage.
In addition to these key use cases, organizations have successfully employed MariaDB for storing flattened data from various sources, addressing the need for working with disparate data. Users have also found value in using front-end UI tools like Heidi SQL to overcome command line limitations when leveraging the power of MariaDB. Moreover, MariaDB finds its application in monitoring solutions, open-source projects, and even as a backup option for replication scenarios.
The Aviation division of one company relies on MariaDB as its primary database server, supporting internal business tools that require reliable data storage. Customers have also reported great satisfaction with the product's ability to replicate data across multiple sites without the high costs associated with other database solutions. Moreover, reviewers have praised MariaDB for its performance and value, thanks to its flexible engines that allow for tuning based on the needs of different applications and data.
Overall, MariaDB has become a go-to choice for organizations of all sizes and industries. Its simplicity, reliability, and versatility have fueled its adoption for various use cases, making it a preferred database solution both internally and externally. From simple web applications to mission-critical systems, MariaDB has proven to be a valuable asset in managing and storing data. Another significant use case for MariaDB is its application in clustered setups with manual sharding. By utilizing multiple engines like Spider, Connect, Federated, MyISAM, Memory, InnoDB, and potentially ColumnStore, organizations can optimize data access and ensure efficient storage. This approach enables companies to handle large amounts of data while maintaining optimal performance and scalability.
Furthermore, MariaDB's licensing advantages and free software nature make it a popular choice for mission-critical applications. It serves as a reliable and cost-effective option for hosting various applications, including widely used platforms like WordPress and Magento. Many organizations have chosen MariaDB as their go-to relational database solution for both internal and third-party applications.
Beyond traditional database usage, MariaDB plays a crucial role in collecting and sending data to centralized servers while maintaining top performance. This decentralization capability allows organizations to distribute their data efficiently without sacrificing reliability or speed.
In terms of user experiences, customers have reported great satisfaction with MariaDB's performance and value. They appreciate the product's ability to provide replicated data across multiple sites without incurring high costs typically associated with other database solutions. Additionally, users have praised the fast and thorough support provided by the MariaDB team, ensuring smooth operations and quick issue resolution.
Overall, the versatility of MariaDB has positioned it as a dependable choice across various industries and applications. From serving as the primary relational database for critical systems to powering simple web applications quickly, MariaDB's simplicity, ease of use, reliability, and ability to handle diverse use cases make it an invaluable tool for businesses seeking robust database storage solutions.
High Availability: Many users have praised MariaDB TX Cluster for providing high availability, which is crucial for their business needs. This feature ensures that their databases are always accessible and minimizes downtime.
Performance Improvement: Several reviewers have mentioned the great advantage of using the proxy for MariaDB, MaxScale, as it significantly improves performance. Users appreciate the faster response times and enhanced efficiency they experience when using this feature.
Quick and Helpful Support: The prompt and helpful support provided by the MariaDB team has been highly appreciated by many users. They have stated that their questions were answered quickly and efficiently, making it easier for them to resolve any issues they encountered.
UI Lacking: Users have expressed dissatisfaction with the user interface of MariaDB, describing it as confusing and inefficient. They recommend incorporating UI tools similar to those offered by its competitors to enhance usability and streamline tasks. Some users feel that the current interface makes it difficult to perform tasks efficiently.
Replication Issues: Some users have encountered problems with replication in MariaDB, specifically related to table locks. They suggest that better troubleshooting tools be provided out of the box to address these issues effectively. This would help users resolve replication-related problems more easily.
Performance Impact: The addition of indexes to large tables and performing operations like altering the table has resulted in replication and storage issues, significantly impacting the overall performance of MariaDB. Users have reported experiencing slowdowns and delays due to these performance issues caused by certain database operations on large tables.
Attribute Ratings
Reviews
(1-25 of 29)MariaDB fast and reliable
- Easy to install
- No big hardware required
- Clear configuration files
- Performances not comparable to e.g. Oracle
- Indexes not always updated
- Recovery procedures in case of dataloss are not linear
Simplicity at your service
- Simplicity
- Open source
- SQL standard
- High cost horizontal scale
- Kafka compatibility
- JSON management
Using MariaDB with SaaS.
- SQL - Is well known and supports most types of usage cases for a database.
- Open source - means there's lots of support and resources to develop on.
- Multi-platform - runs on any operating system and doesn't tie it down.
- Full text searches - slows startup to the extreme, leaks memory, can be buggy.
- Startup process needs to be streamlined and with more output. You shouldn't need to debug the system to find out what the startup process is doing.
- More consideration to using multiple databases. Most solutions seem to concentrate on single database products.
- MariaBackup is buggy and might not work on larger databases. Taking backups or restoring them takes manual work. Could really need some easy to use tools and less hand scripting shell scripts.
Great stability with no DDL operations
- Great stabiltity
- Good performance on retrieving data
- Easy configuration
- Easy management
- DDL operations do not work well on running MariaDB Cluster
- Cluster management from CLI could be improved
MariaDB: the little DB that could.
- Read/write split
- Connection handling
- Transaction replay
- Service independence
- Stats
- Load Management
- Galera Cluster for write heavy applications
- Expanded Standard config templates
Positive Review for MariaDB
- Easy deployment.
- Ample amount of tools to be used.
- Documentation.
- Initial setup needs to be improved (determining correct configuration values).
- If replication fails, needs to be easier to recover.
- More functionality in the Community Server.
RDBMS at its best
- High performance and availability.
- Has an active open-source developer community.
- Robust transactional support.
- Availability of many storage engines.
- MariaDB is no longer completely compatible with MySQL, which makes migration a tedious process.
- Needs improvement in caching.
- It doesn't support full outer joins.
- Implementation of JSON datatype in MariaDB isn't ideal.
A Tiny Review of MariaDB
- Aria engine support, the improved MyISAM, it deliver faster performance with less required buffer than InnoDB, also almost a maintenance free table that less fragmented, no need to optimize so often.
- Based on out experience, having smaller memory requirement.
- With proper setup, it is fast.
- It will nice to have Aria engine be able to perform concurrent SELECT and INSERT/UPDATE like in InnoDB.
MariaDB Review
- Strict type checking with default mode on for STRICT_TRANS_TABLES
- Instant drop column operation (instant add column is already available), a big part of schema changes can be performed ad hoc
- MariaDB 10.4 will benefit from faster extension of VARCHAR columns, additionally, character set and collation changes on non-indexed columns will be instant.
- MariaDB 10.4 comes with an option for expiring user password
- Galera 26.4 - MariaDB 10.4 will benefit from a new Galera version with features like streaming replication or improved SST thanks to backup locks.
- MariaDB 10.4 you can set SQL-mode = MSSQL
- Explain and analyze works as a separate command as compared to other MySQL products
MariaDB economical high availability solution with great support
- High availability through the MariaDB TX Cluster.
- Performance improvement with proxy for MariaDB, MaxScale.
- Great support, respond quickly to questions.
- Constant evolution of the product.
- Improving the migration of databases from MySQL to Maria DB, by default they are done easily but as there is an error it is costly to solve it.
- Some minor bugs in MariaDB version updates.
MariaDB Enterprise - Washing the taste of NoSQL out of my mouth!
- Replication - Works extremely well and has very reasonable latency.
- Monitoring - There is no shortage of tools for monitoring clusters.
- Reliability - Rock-solid product that appears to be quite resilient.
- I honestly can't think of anything I'd change.
Gets the job done without punishing you
- Simpler learning curve. MariaDB is a cleaner, simpler system that is (IMO) easier to learn and easier to manage effectively than many other database systems.
- Lower hardware requirements. After migrating to MariaDB from another database software system, we find that our hardware needs have substantially decreased.
- MariaDB support is very responsive. It's like they actually care. On the few occasions we've run into technical issues, support has always come through with what we needed. Once it was showing me a relatively new feature the server supported that I wasn't aware of, that, once I was able to properly make use of it helped me resolve a serious production performance issue.
- Architectural flexibility. As an example, the ready availability of synchronous (Galera) versus asynchronous replication schemes without being locked into one of the other by enormous technical complexity or punitive licensing, allows the customer to find what really works best for their needs.
- Complications from the single, global shared ibdata1 (which may be considered more an InnoDB limitation).
- Backups and restores, especially if you do partial (per db) backups. Actually the backups work very well but the restores are not pleasant.
- Certain weaknesses in Galera. Because of the way it works it doesn't handle very large single transactions very well (I understand that has improved in recent releases, but that was after we moved away from Galera), and there are altogether too many ways to stall an entire Galera cluster - you will find them.
Fast, reliable, economical database solution
- Query optimization
- Table partitioning
- Relational and non-relational data
- Adding servers to replication series (playing catchup)
MariaDB - great relational database solution
- It's easy to use for software development team members with knowledge of SQL.
- It's better than standard MySQL solutions, it's a little bit faster.
- It's also often required for some applications that we use for example CMS.
- While using with large data it's slowing.
- Simple, easy to install and upgrade.
- Mature.
- Massive user base which makes it easier to find support when needed.
- Lack of advanced features.
- Caching performance is lackluster compared to PostgreSQL or SQL Server.
- Arguably prone to error since it doesn't distinguish data as accurate as PostgreSQL for example.
MariaDB: good OLTP db
- Fast writes. Writes are fast, where it depends on the hardware.
- Reads are fast. Putting into memory is easy.
- Functions and procedures are easy to implement.
- Paritioning is nicely implemented.
- Bloating. Can't reduce the size of idx log file, especially when data is truncated from tables. Space is not reclaimed. Need to find way to "shrink" file.
- Writes are dependent on hardware. If hardware isn't great, writes will be effected. If that can still be solved through software.
- Flushing of cache data is not as fast as it should be. There can be cases of malformed data.
- Reliability - MariaDB handles heavy usage loads well for high-traffic applications.
- Easy Administration - For those who are familiar with MySQL, MariaDB is easy to administer and configure.
- Cost - MariaDB is free to use.
- Driver Support - Some third party applications use database drivers that cause unexplained slowness with MariaDB. This can be worked around by using the MySQL drivers, but it's not clear what causes the problem in the first place.
- Support - While online communities are helpful in diagnosing problems, there isn't as much professional documentation/support available for MariaDB as some of the other major database options.
- Data Visualization - It would be helpful if there were more built in options for analyzing statistics and generating reports.
- MariaDB does well with PHP or Python (django) in a web environment. Developers are able to work quickly.
- MariaDB is extremely well documented and has a gigantic support community. If you need ask a question on how to do things you can go to many placces online and find answers quickly.
- MariaDB is fast! Queries with tens of thousands of rows are quick.
- MariaDB is highly compatible with Oracle's MySQL. Basically the same thing but more open and with a brighter future.
- With MariaDB it is so easy to import and export data, and backups are a cinch. This saves me so much time as compared to other RDBMS.
- I can honestly sat that there is no area where MariaDB needs improvement. Nothing is hard to use, the learning curve is just the nature of the product. I see no missing functionality, add ting things would only be unwanted bloat.
MariaDB Review
MariaDB vs. MySQL
- We are seeing more security releases than we did when we were running MySQL
- Very large queries complete more quickly on MariaDB than they do on MySQL
- Setting up Master-Master replication is more straightforward in MariaDB than it is in MySQL
- MariaDB doesn't yet have a Memcached interface
- CHECKSUM TABLE can give different results in MariaDB than in MySQL
Easy to store data with minimum CPU resources
- It gives better performance with a large amount of data.
- Easy to switch from SQL database.
- Help to take backups for integration and testers.
- Hard to implement relational queries.
- The graphical user interface should be more attractive.
- It does not show or allow to add a filter to the execution plan.
SQL database you can count on
- Easy to switch to it from MySQL. No client side re-configuration or re-programming is needed.
- Developed by open community.
- Widely supported in all environments and software.
- It's not guaranteed to be 100% compatible with MySQL (especially newer versions). However I've never encountered problems with this.
- Could have some UI tools incorporated into it like its competitors.
MariaDB Review
- SQL
- Applications
- Replication
- Fixing replication issues still needs some work
Great Database server with free license and many features
- Synchronous multi-master cluster that permits to develop high availability applications
- Compatible with applications developed to MySQLDB.
- Not much modification required
- Quicker security releases. You don't need to wait about 2 or 3 months to security patches.
- MariaDB is developed fully in the open: all development decisions can be reviewed and debated on a public mailing list of in the public bug tracker
- We still do not have confidence in using MariaDB in our administrative systems because we do not have experience to use it in critical systems
- We can consider that It is developed mainly by a small company and the future of MariaDB maybe is uncertain (!) (?).
- On the other hands, we didn't find other cons of this software
MariaDB > MySQL
- It has many speed improvements over MySQL.
- It offers better time precision over MySQL.
- It adheres to open source methodologies and testing, which MySQL has moved away from since Oracle took it over.
- It could use a memcached interface.
- Although it is traditionally thought of as a binary drop-in replacement for MySQL, some incompatibilities have come up since version 5.1