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.

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

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
PeerSpot user
Senior Production Support Engineer at a tech company with 501-1,000 employees
Consultant
Simple to use with excellent performance

What is most valuable?

MySQL is very flexible, has excellent performance, and it's simple to use.

How has it helped my organization?

Once we needed to use a database to distribute a product for my company and we chose MySQL, it was easy to use and it is very small, but powerful.

What needs improvement?

Maybe the way to build clusters needs to be improved. They could also improve the installation process.

For how long have I used the solution?

I been using MySQL for nearly seven years.

What do I think about the stability of the solution?

There were no stability issues.

What do I think about the scalability of the solution?

There were some scalability issues.

How are customer service and technical support?

I would give the technical support an eight out of 10 rating.

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

We did upgrade the version with improvements to the product.

How was the initial setup?

The setup was complex in the cluster installation.

What's my experience with pricing, setup cost, and licensing?

MySQL is one of the best database options. The Community version is great.

Which other solutions did I evaluate?

We used Oracle and SQL Server, but their prices and licensing were so expensive.

What other advice do I have?

Using MySQL could be an excellent option for you.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
MySQL
April 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,857 professionals have used our research since 2012.
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.

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 technical 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_user1077 - PeerSpot reviewer
Developer at a tech company with 51-200 employees
Vendor
MySQL is the most popular Open Source Data Base Management System, developed and supported by Oracle Corporation.

Valuable Features:

1) It is freely available under the terms of GNU General Public License.2) MySQL works seamless on various platforms and environments.3) It is mainly used in Client/Server environment and it can be embedded in standalone applications. 4) Support SQL standards, and also provide Multi-thread environment.5) Offers high performance due to its unique storage engine architecture as well as it's core written in powerful languages such as C and C++.

Room for Improvement:

1) Does not provide good development and debugging tools, so it’s cumbersome to write large SQL statements.2) MySQL uses temporary tables to execute queries, so it consumes more space.3) MySQL is missing some RDBMS features like stored procedures, foreign keys, transaction, rollback, and subselect. And it also does't support triggers.It is widely used in web applications, and several software stacks includes MySQL as a Data Base Management System like (WAMP, XAMPP) considering its flexibility and simplicity.

Other Advice:

And if some one is looking for Database which performs simple processes like storing and displaying data only, then MySQL is the right choice.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user517392 - PeerSpot reviewer
it_user517392DBA Manager at a media company with 1,001-5,000 employees
Vendor

MySQL is great to provide a testing ground for new developers.

See all 2 comments
PeerSpot user
Intern at a tech vendor with 1,001-5,000 employees
Real User
It is used for many projects and easy to access. Needs to get more solid for my company to rely on it.

What is most valuable?

It is Open Source and easy to access.

How has it helped my organization?

My company does not use MySQL. However, it is often used at universities and is suitable for beginners. It is used for many projects.

What needs improvement?

From the perspective of the company, you can count on reliable Microsoft SQL or Oracle. If MySQL gets solid, it will be a good solution.

For how long have I used the solution?

I have used this solution for around two to three years.

What do I think about the stability of the solution?

There were no stability issues.

What do I think about the scalability of the solution?

There were no scalability issues.

How are customer service and technical support?

There does not seem to be any technical support for MySQL.

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

I have used MS SQL and Oracle. However, now I have no money and am using MySQL.

How was the initial setup?

Encoding problems were always complicated, but nothing else.

What's my experience with pricing, setup cost, and licensing?

If you have money, it would be better to use Oracle.

Which other solutions did I evaluate?

I thought about other Open Sources, but I chose MySQL, which I have already used.

What other advice do I have?

MySQL is a good choice for startups and beginners.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user1044 - PeerSpot reviewer
Developer at a tech company with 51-200 employees
Vendor
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
PopularVendor

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: April 2024
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.