Try our new research platform with insights from 80,000+ expert users
PeerSpot user
IT Manager at a retailer with 1,001-5,000 employees
Real User
Online backup can be implemented by activating a temporary storage and introducing Percona innobackupex

What is most valuable?

This product is valuable because it is used in production environments. Online backup can be implemented by activating a temporary storage similar to the Oracle's flash recovery area and introducing Percona innobackupex. This is possible from version 5.6.

How has it helped my organization?

It permits services such as data warehouse and retail.

What needs improvement?

The online backup needs to improve.

For how long have I used the solution?

I have used this solution for 15 years.

Buyer's Guide
MySQL
March 2025
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.

What do I think about the stability of the solution?

We did encounter stability issues.

What do I think about the scalability of the solution?

There were no scalability issues.

How are customer service and support?

Not applicable because we don't purchase commercial support.

Which solution did I use previously and why did I switch?

We switched due to cost saving reasons.

How was the initial setup?

The setup was of medium-level complexity due to memory parameters.

What other advice do I have?

Compared to PostgreSQL, it has an online backup feature only with the extension of Percona innobackupex.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user285990 - PeerSpot reviewer
Service Operations Manager at a tech vendor with 51-200 employees
Real User
Its ability to scale horizontally and transactional functionality features have been valuable to us, but the configuration templates could be improved.

Valuable Features:

It depends on the use and implementation, as I prefer to use Galera or XtraDB because of replication and failover functionality. However, the ability to scale horizontally is much better than other vendors. Also, the transactional functionality is good.

Room for Improvement:

Configuration templates and reliability both need work.

Use of Solution:

I have been using MySQL for over five years.

Deployment Issues:

I deploy multiples of these servers now, and it is all managed via a puppet so I/we have not had problems with deployment in a long time.

Stability Issues:

An overload of sessions, or long running queries. can cause the servers to be unusable.

Scalability Issues:

Currently no, as we use our own load balancer to enable us to scale to any level.

Customer Service:

We don't use it.

Initial Setup:

It was straightforward, and there are numerous blogs on-line that cover every possible configuration.

Implementation Team:

We did it in-house.

ROI:

It takes about six months, but this does depend on its associated product and usage.

Cost and Licensing Advice:

Chose your database based on traffic type and desired functionality, not on the initial cost.

Other Advice:

If you have the in-house knowledge MySQL can be a great product. If you do not I would recommend using MSSQL instead.

Take a look at the environment you plan to implement including the application and traffic model.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
MySQL
March 2025
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
844,944 professionals have used our research since 2012.
reviewer1514799 - PeerSpot reviewer
Project Business Analyst RPA at a consultancy with 11-50 employees
Real User
An open-source relational database management system with a useful search feature
Pros and Cons
  • "What I really like about MySQL is the opportunity to search for information and organize it any way I like."
  • "It should provide better customer experiences."

What is our primary use case?

We use MySQL to organize data, analyze information, and make decisions for the company. We also use it to process information from different areas in the company.

What is most valuable?

What I really like about MySQL is the opportunity to search for information and organize it any way I like. If you know the queries and you add the code, you can organize information any way you like.

What needs improvement?

MySQL needs to be more accessible and user-friendly. The person working with it needs to be trained in MySQL to have the necessary skills to control the database and analyze data. It should provide better customer experiences.

For how long have I used the solution?

I have been using MySQL for one year.

How was the initial setup?

The initial setup depends on your knowledge. If you know the principles, except when it comes to queries, it's easy. But if you don't know anything about MySQL or SQL, you can't do it. It took us about six months to set up and deploy MySQL.

What other advice do I have?

I would tell potential users that people in production have to be trained to use MySQL. They should take some courses, and get certificated. This will show them how to use the principal tools and provide some context about how MySQL works. 

On a scale from one to ten, I would give MySQL an eight.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
it_user1044 - PeerSpot reviewer
Developer at a tech company with 51-200 employees
Real User
Most Powerful Open Source Database

Valuable Features:

• Free to download and use • Loads of new features over 4.1 version. • Excellent support for a range of platforms. • Performs well in small and medium applications. • Most popular Open Source database engine. • Supports advanced concepts such as replication. • Performs extremely well in the average case.

Room for Improvement:

• It doesn't support stored procedures. • You probably wouldn't use it for heavy-duty installation. • There is no active directory for integration with Microsoft SQL Server or other data bases.

Other Advice:

As a developer I have used many database engines but MySQL is by far the best known and most popular Open Source database engine.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user2652 - PeerSpot reviewer
it_user2652Project Manager at a non-tech company with 10,001+ employees
Top 20Vendor

As of MySQL 5.5.16, commercial distributions of MySQL include an authentication plugin that enables MySQL Server to use PAM (Pluggable Authentication Modules) to authenticate MySQL users. PAM enables a system to use a standard interface to access various kinds of authentication methods, such as Unix passwords or an LDAP directory.

See all 2 comments
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2025
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.