# Apache Derby, MariaDB vs MySQL Comparison | | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Star Rating** | 3.8 out of 5 | 4.4 out of 5 | 4.4 out of 5 | | **Total Reviews** | 23 | 226 | 1,675 | | **Largest Market Segment** | Small-Business (39.1% of reviews) | Small-Business (41.3% of reviews) | Small-Business (36.7% of reviews) | | **Entry Level Price** | No pricing available | No pricing available | $5,000 | --- ## Top Pros & Cons ### Apache Derby **Not enough data** ### MariaDB Pros: - Ease of Use (2 reviews) - Easy Integrations (2 reviews) Cons: - Beginner Unfriendliness (1 reviews) - Connectivity Issues (1 reviews) ### MySQL Pros: - Ease of Use (17 reviews) - Easy Integrations (9 reviews) Cons: - Feature Limitations (12 reviews) - Limited Database Support (9 reviews) --- ## Ratings Comparison | Rating | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Meets Requirements** | 8.2 (22 reviews) | 8.9 (183 reviews) | 8.9 (1404 reviews) | | **Ease of Use** | 8.6 (23 reviews) | 8.9 (185 reviews) | 8.7 (1408 reviews) | | **Ease of Setup** | 9.0 (10 reviews) | 8.7 (115 reviews) | 8.6 (671 reviews) | | **Ease of Admin** | 8.2 (10 reviews) | 8.4 (110 reviews) | 8.4 (633 reviews) | | **Quality of Support** | 8.1 (19 reviews) | 7.9 (142 reviews) | 8.0 (1184 reviews) | | **Has the product been a good partner in doing business?** | 8.0 (9 reviews) | 8.1 (88 reviews) | 8.5 (519 reviews) | | **Product Direction (% positive)** | 6.4 (23 reviews) | 8.9 (176 reviews) | 8.0 (1371 reviews) | --- ## Pricing ### Apache Derby #### Entry-Level Pricing No pricing available #### Free Trial No information available ### MariaDB #### Entry-Level Pricing No pricing available #### Free Trial Yes ### MySQL #### Entry-Level Pricing Plan: MySQL Enterprise Edition Price: $5,000 [Browse all 3 editions](https://www.g2.com/products/mysql/pricing) #### Free Trial No --- ## Features Comparison By Category ### Relational Databases | Product | Score | Reviews | |---|---|---| | **Apache Derby** | 7.4/10 | 20 | | **MariaDB** | 8.7/10 | 175 | | **MySQL** | 8.7/10 | 1290 | #### Management | Feature | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Data Schema** | Not enough data | 9.2 (28 reviews) | 9.0 (148 reviews) | | **Query Language** | Not enough data | 9.2 (29 reviews) | 9.2 (150 reviews) | | **ACID - Complaint** | Not enough data | 8.5 (25 reviews) | 8.9 (132 reviews) | | **Data Replication** | Not enough data | 8.5 (23 reviews) | 8.8 (130 reviews) | #### Support | Feature | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Text Search** | Not enough data | 8.6 (26 reviews) | 8.4 (139 reviews) | | **Data Types** | Not enough data | 8.9 (28 reviews) | 8.7 (147 reviews) | | **Languages** | Not enough data | 8.5 (23 reviews) | 8.8 (138 reviews) | | **Operating Systems** | Not enough data | 8.9 (22 reviews) | 9.1 (136 reviews) | #### Security | Feature | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Database Locking** | Not enough data | 8.7 (27 reviews) | 8.8 (137 reviews) | | **Access Control** | Not enough data | 8.8 (28 reviews) | 9.0 (137 reviews) | | **Encryption** | Not enough data | 8.8 (22 reviews) | 8.6 (130 reviews) | | **Authentication** | Not enough data | 8.7 (23 reviews) | 8.6 (135 reviews) | #### Performance | Feature | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Disaster Recovery** | Not enough data | 8.3 (21 reviews) | 8.4 (127 reviews) | | **Data Concurrency** | Not enough data | 8.6 (22 reviews) | 8.6 (130 reviews) | | **Workload Management** | Not enough data | 8.4 (24 reviews) | 8.5 (131 reviews) | | **Advanced Indexing** | Not enough data | 8.4 (20 reviews) | 8.6 (134 reviews) | | **Query Optimizer** | Not enough data | 8.5 (27 reviews) | 8.7 (132 reviews) | #### Database Features | Feature | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Storage** | 7.3 (20 reviews) | 9.0 (153 reviews) | 8.8 (1152 reviews) | | **Availability** | 8.0 (20 reviews) | 9.1 (156 reviews) | 8.9 (1156 reviews) | | **Stability** | 7.9 (20 reviews) | 9.2 (156 reviews) | 8.7 (1160 reviews) | | **Scalability** | 6.7 (20 reviews) | 8.6 (148 reviews) | 8.1 (1128 reviews) | | **Security** | 7.0 (19 reviews) | 8.6 (150 reviews) | 8.4 (1116 reviews) | | **Data Manipulation** | 7.3 (20 reviews) | 8.7 (150 reviews) | 8.7 (1130 reviews) | | **Query Language** | 7.3 (20 reviews) | 9.0 (154 reviews) | 8.9 (1152 reviews) | ### Columnar Databases | Product | Score | Reviews | |---|---|---| | **Apache Derby** | N/A | N/A | | **MariaDB** | 9.0/10 | 10 | | **MySQL** | N/A | N/A | #### Storage | Feature | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Data Model** | Not enough data | 8.8 (8 reviews) | Not enough data | | **Data Types** | Not enough data | 8.9 (9 reviews) | Not enough data | #### Availability | Feature | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Auto Sharding** | Not enough data | 9.0 (5 reviews) | Not enough data | | **Auto Recovery** | Not enough data | 8.8 (7 reviews) | Not enough data | | **Data Replication** | Not enough data | 8.6 (6 reviews) | Not enough data | #### Performance | Feature | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Integrated Cache** | Not enough data | 9.0 (8 reviews) | Not enough data | #### Security | Feature | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Role-Based Authorization** | Not enough data | 9.4 (8 reviews) | Not enough data | | **Authentication** | Not enough data | 9.5 (7 reviews) | Not enough data | | **Audit Logs** | Not enough data | 8.6 (7 reviews) | Not enough data | | **Encryption** | Not enough data | 9.2 (6 reviews) | Not enough data | #### Support | Feature | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Multi-Model** | Not enough data | 9.7 (5 reviews) | Not enough data | | **Operating Systems** | Not enough data | 8.8 (7 reviews) | Not enough data | ### AWS Marketplace | Product | Score | Reviews | |---|---|---| | **Apache Derby** | N/A | N/A | | **MariaDB** | N/A | N/A | | **MySQL** | N/A | N/A | #### Agentic AI - AWS Marketplace | Feature | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Autonomous Task Execution** | Not enough data | Not enough data | Not enough data | | **Multi-step Planning** | Not enough data | Not enough data | Not enough data | | **Cross-system Integration** | Not enough data | Not enough data | Not enough data | --- ## Categories **Shared Categories (1):** [Relational Databases](https://www.g2.com/categories/relational-databases) **Unique to MariaDB (2):** [Columnar Databases](https://www.g2.com/categories/columnar-databases), [AWS Marketplace Software](https://www.g2.com/categories/aws-marketplace) --- ## Reviewer Demographics ### By Company Size | Segment | Apache Derby | MariaDB | MySQL | |---|---|---|---| | **Small-Business** | 39.1% | 41.3% | 36.7% | | **Mid-Market** | 30.4% | 31.7% | 30.8% | | **Enterprise** | 30.4% | 27.1% | 32.5% | ### By Industry #### Apache Derby - **Computer Software:** 39.1% - **Information Technology and Services:** 13.0% - **Government Administration:** 13.0% - **Education Management:** 8.7% - **Medical Practice:** 4.3% - **Hospital & Health Care:** 4.3% - **Higher Education:** 4.3% - **E-Learning:** 4.3% - **Banking:** 4.3% - **Airlines/Aviation:** 4.3% #### MariaDB - **Information Technology and Services:** 26.1% - **Computer Software:** 20.2% - **Internet:** 5.0% - **Telecommunications:** 5.0% - **Computer & Network Security:** 3.7% - **Education Management:** 3.7% - **Marketing and Advertising:** 2.8% - **Computer Networking:** 2.3% - **Higher Education:** 2.3% - **Retail:** 1.8% - **Other:** 27.1% #### MySQL - **Information Technology and Services:** 25.1% - **Computer Software:** 20.4% - **Internet:** 4.5% - **Higher Education:** 4.1% - **Education Management:** 3.3% - **Financial Services:** 3.0% - **Telecommunications:** 3.0% - **Hospital & Health Care:** 2.3% - **Banking:** 2.0% - **Computer & Network Security:** 1.8% - **Other:** 30.4% --- ## Alternatives ### Alternatives to Apache Derby - [SQLite](https://www.g2.com/products/sqlite/reviews) — 4.3/5 stars (260 reviews) - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) — 4.4/5 stars (677 reviews) - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) — 4.4/5 stars (2274 reviews) - [Google Cloud SQL](https://www.g2.com/products/google-cloud-sql/reviews) — 4.5/5 stars (366 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) — 4.3/5 stars (1010 reviews) - [Amazon Aurora](https://www.g2.com/products/amazon-aurora/reviews) — 4.5/5 stars (457 reviews) - [IBM Db2](https://www.g2.com/products/ibm-db2/reviews) — 4.1/5 stars (682 reviews) - [Amazon Relational Database Service (RDS)](https://www.g2.com/products/amazon-relational-database-service-rds/reviews) — 4.5/5 stars (906 reviews) - [SAP HANA Cloud](https://www.g2.com/products/sap-hana-cloud-2025-10-01/reviews) — 4.3/5 stars (621 reviews) - [Teradata Vantage](https://www.g2.com/products/teradata-teradata-vantage/reviews) — 4.3/5 stars (373 reviews) ### Alternatives to MariaDB - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) — 4.4/5 stars (2274 reviews) - [Oracle Database](https://www.g2.com/products/oracle-database/reviews) — 4.3/5 stars (1010 reviews) - [Amazon Relational Database Service (RDS)](https://www.g2.com/products/amazon-relational-database-service-rds/reviews) — 4.5/5 stars (906 reviews) - [IBM Db2](https://www.g2.com/products/ibm-db2/reviews) — 4.1/5 stars (682 reviews) - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) — 4.4/5 stars (677 reviews) - [Amazon Aurora](https://www.g2.com/products/amazon-aurora/reviews) — 4.5/5 stars (457 reviews) - [SQLite](https://www.g2.com/products/sqlite/reviews) — 4.3/5 stars (260 reviews) - [Google Cloud SQL](https://www.g2.com/products/google-cloud-sql/reviews) — 4.5/5 stars (366 reviews) - [SAP HANA Cloud](https://www.g2.com/products/sap-hana-cloud-2025-10-01/reviews) — 4.3/5 stars (621 reviews) - [OpenText Vertica](https://www.g2.com/products/opentext-vertica/reviews) — 4.3/5 stars (216 reviews) ### Alternatives to MySQL - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) — 4.4/5 stars (2274 reviews) - [Amazon Relational Database Service (RDS)](https://www.g2.com/products/amazon-relational-database-service-rds/reviews) — 4.5/5 stars (906 reviews) - [IBM Db2](https://www.g2.com/products/ibm-db2/reviews) — 4.1/5 stars (682 reviews) - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) — 4.4/5 stars (677 reviews) - [SAP HANA Cloud](https://www.g2.com/products/sap-hana-cloud-2025-10-01/reviews) — 4.3/5 stars (621 reviews) - [Teradata Vantage](https://www.g2.com/products/teradata-teradata-vantage/reviews) — 4.3/5 stars (373 reviews) - [SQLite](https://www.g2.com/products/sqlite/reviews) — 4.3/5 stars (260 reviews) - [Azure SQL Database](https://www.g2.com/products/azure-sql-database/reviews) — 4.5/5 stars (241 reviews) - [IBM Informix](https://www.g2.com/products/ibm-informix/reviews) — 4.5/5 stars (111 reviews) - [Google Cloud SQL](https://www.g2.com/products/google-cloud-sql/reviews) — 4.5/5 stars (366 reviews) --- ## Top Discussions ### Apache Derby No discussions available for this product. ### MariaDB - Title: [What is MariaDB used for?](https://www.g2.com/discussions/mariadb-what-is-mariadb-used-for) — 1 comment > **Top comment:** "It is a fork of MySQL used for data warehouse, e-com services and usage for similar kind of data manipulation tasks. " - Title: [Is MariaDB compatible with MySQL?](https://www.g2.com/discussions/is-mariadb-compatible-with-mysql) — 1 comment > **Top comment:** "Yes" - Title: [What is MariaDB server?](https://www.g2.com/discussions/what-is-mariadb-server) — 1 comment > **Top comment:** "MariaDB server is an open-source relational database management system (RDBMS) that is compatible with MySQL. I'm pretty sure it was a fork of MySQLs..." - Title: [What is MariaDB used for?](https://www.g2.com/discussions/what-is-mariadb-used-for) — 1 comment > **Top comment:** "It is a relational database that stores data in form of row and column coming as input from a source like application softwares" - Title: [Improvements in the mechanism of replication](https://www.g2.com/discussions/12584-improvements-in-the-mechanism-of-replication) — 1 comment, 1 upvote > **Top comment:** "MarieDB Galera cluster is the way to go https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/" ### MySQL - Title: [Does MySQL new version has strong security?](https://www.g2.com/discussions/10422-question-about-mysql) — 10 comments, 2 upvotes > **Top comment:** "Hasini, What do you mean? Have you experienced any security issue? How are you using MySQL (any back-end language) If so, like any other language it depends..." - Title: [What is MySQL used for?](https://www.g2.com/discussions/what-is-mysql-used-for) — 3 comments > **Top comment:** "MySQL is a widely used relational database management system (RDBMS) that serves various purposes across different industries and applications. Here are some..." - Title: [Can I use MySQL for free?](https://www.g2.com/discussions/can-i-use-mysql-for-free) — 3 comments, 2 upvotes > **Top comment:** "Yes, If you are using it for your own purpose (not business purpose), you can download MySQL Community version for free. Link for downloading the community..." - Title: [Could you explain how to optimize MySQL database performance for a new user handling large-scale data?](https://www.g2.com/discussions/could-you-explain-how-to-optimize-mysql-database-performance-for-a-new-user-handling-large-scale-data) — 2 comments > **Top comment:** "Try these steps: 1) try normalization 2) use indexes 3) try to separate workloads using different techinques" - Title: [Is there any possibilities than mysql database can be online?](https://www.g2.com/discussions/is-there-any-possibilities-than-mysql-database-can-be-online) — 2 comments, 1 upvote > **Top comment:** "Yes, you can make MySQL databases accessible online and many websites/application do this. It all depends on server configuration." --- **Source:** [G2.com](https://www.g2.com) | [Comparison Page](https://www.g2.com/compare/apache-derby-vs-mariadb-vs-mysql)