H2 Database vs Percona Server for MySQL

Likelihood to Recommend

For running application tests it's well suited. H2 [Database Engine] can replace the real-world database solution for them easily and removes the requirement to set up a a separate database instance just for running unit tests. For using in actual production application one needs to consider scale. H2 is suitable if application runs in single instance and database is located in same machine as a file where that application runs. This means the application shouldn't have a large user base. However it's easy to switch to an actual MySQL instance if the need arises, it's most likely only a configuration change and doesn't require new code.

Read full review

Verified User

Employee in Information Technology

Computer Software Company, 1001-5000 employees

View all 2 answers on this topic

Percona Server for MySQL covers 100% of our requirements in terms of our OLTP traffic and provides the High Availability levels required through a typical primary and 2 replica's using semi-synchronous replication. We're able to scale our writes using sharding, but a true distributed database would be a great option on top of this. In terms of OLAP traffic, we leverage columns stores available, but Percona Server fairs well

Read full review

Douglas Doo

Principle Database Architect

ImpactMarketing & Advertising, 201-500 employees

View all 5 answers on this topic

Pros

Can run as an in-memory database.
Simple and quick to get started with, and is light weight (only 2MB).
SQL compliant so it compatible with most relational databases.

Read full review

Verified User

Employee in Information Technology

Computer Software Company, 1-10 employees

View all 2 answers on this topic

Faster than other server solutions
Installation and configuration process is easy from the user's standpoint
Easy to learn and good support

Read full review

Jose Manuel Ortega

Software Engineer && Security researcher

UA - Universidad de Alicante / Universitat d'AlacantComputer Software, 51-200 employees

View all 5 answers on this topic

Cons

There's a warning in official FAQ "Is it Reliable?"-section which makes it seem like H2 is not yet a mature product.
If raw SQL queries are used there maybe be differences between MySQL & H2. ORM library should be used.
Support seems to be community-based only.

Read full review

Verified User

Employee in Information Technology

Computer Software Company, 1001-5000 employees

View all 2 answers on this topic

Better documentation
A better UI

Read full review

Dushyant Pathak

Software Engineer

AndroLedaEducation Management, 1-10 employees

View all 5 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Starting Price

—

General

Free Trial

Yes

Free/Freemium Version

Yes

Premium Consulting/Integration Services

Yes

Entry-level set up fee?

Optional

Starting Price

—

Usability

No score

No answers yet

No answers on this topic

Percona Server for MySQL 8.7

Based on 4 answers

It is easy to install and use. Using it along with Percona Monitoring and Management makes it even easier to use.

Read full review

Verified User

Team Lead in Engineering

Construction Company, 51-200 employees

View all 4 answers on this topic

Support Rating

No score

No answers yet

No answers on this topic

Percona Server for MySQL 6.9

Based on 3 answers

We are using opensource so we have not used customer support.

Read full review

Anil Yadav

Senior Engineering Manager (Site Reliability Engineering)

Ola (ANI Technologies Pvt. Ltd)Information Technology & Services, 1001-5000 employees

View all 3 answers on this topic

Alternatives Considered

While both can run as an in-memory database, H2 Database Engine was just so much easier for us to use since we primarily use the Java stack and H2 Database Engine is also built with Java.

Read full review

Verified User

Employee in Information Technology

Computer Software Company, 1-10 employees

View all 2 answers on this topic

Performance and stability sets Percona Server for MySQL apart from the rest. Percona embraces the upstream version and contributes towards the upstream version making MySQL stronger on two fronts and thus having a much larger community. Many quality contributions have been made by Percona into the base code. Percona provides great tools to support Percona Server for MySQL and this makes the monitoring and management easier

Read full review

Douglas Doo

Principle Database Architect

ImpactMarketing & Advertising, 201-500 employees

View all 5 answers on this topic

Return on Investment

Doesn't take time from developers, once it's configs are set up for testing it works in everyone's development environments
Easy to integrate in application, no need to setup separate database software, no maintenance
No need to deal with infrastructure related issues/costs - database runs in same machine as the application that uses it.

Read full review

Verified User

Employee in Information Technology

Computer Software Company, 1001-5000 employees

View all 2 answers on this topic

At the performance level, it maintains and even improves other open-source databases such as MariaDB or some commercial ones such as Oracle.
If we compare it with MySQL, we could have up to 50% improvement in performance.
For some small companies or startups, the price of the complete solution and the support can be a bit high.

Read full review

Jose Manuel Ortega

Software Engineer && Security researcher

UA - Universidad de Alicante / Universitat d'AlacantComputer Software, 51-200 employees

View all 5 answers on this topic

H2 Database vs Percona Server for MySQL

H2 Database

Percona Server for MySQL

Attribute Ratings

Likelihood to Recommend

H2 Database

Percona Server for MySQL

Likelihood to Renew

H2 Database

Percona Server for MySQL

Usability

H2 Database

Percona Server for MySQL

Support Rating

H2 Database

Percona Server for MySQL

Pros

Cons

Pricing Details

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Starting Price

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Starting Price

Usability

Support Rating

Alternatives Considered

Return on Investment

Screenshots

Add comparison