Try our new research platform with insights from 80,000+ expert users
it_user130032 - PeerSpot reviewer
CEO at a tech services company with 51-200 employees
Consultant
SQL capability, functions and ease of optimization.

What is most valuable?

SQL capability, functions and ease of optimization.

What needs improvement?

Software and web development.

For how long have I used the solution?

15 years.

What was my experience with deployment of the solution?

No issues.

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

What do I think about the stability of the solution?

No issues.

What do I think about the scalability of the solution?

Manageable.

How are customer service and support?

Customer Service:

Used open source and never needed customer service.

The product is quite mature.

Technical Support:

NA

How was the initial setup?

Straightforward.

What about the implementation team?

In-house.

What was our ROI?

Good.

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

The open source product is good. If you want advanced features go for the enterprise edition.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Information Systems Computer System Controller at a insurance company with 11-50 employees
Real User
Top 20
Small application for easy deployment but has Java compatibility issues
Pros and Cons
  • "The solution is a small application and is very easy to deploy."
  • "There are some issues with compatibility with Java environments that need to be improved. When Oracle bought this solution there were some driver changes that caused some issues with operations."

What is our primary use case?

I have used the solution for a database tied to application development.

What needs improvement?

There are some issues with compatibility with Java environments that need to be improved. When Oracle bought this solution there were some driver changes that caused some issues with operations.

For how long have I used the solution?

I have been using the solution for approximately eight years.

What do I think about the scalability of the solution?

There are approximately 300 users using the solution in my organization. 

How was the initial setup?

The solution is a small application and is very easy to deploy.

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

There is a license for this solution. A lot of the time the solution gets bundled with other hardware or software purchases.

What other advice do I have?

I have plans to continue using the solution in the future.

I rate MySQL a seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
MySQL
August 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: August 2024.
801,634 professionals have used our research since 2012.
Full Stack Developer at a tech services company with 10,001+ employees
Real User
Open-source, easy to use, and simple to implement
Pros and Cons
  • "It is easy to use. It is simple to implement, which makes it suitable for our projects because we have deadlines. MySQL is also open-source, which is another plus point."
  • "Its performance should be better. When we use big data, it is slow in performance. We should be able to use mirroring for improved performance."

What is our primary use case?

I'm currently using MySQL for the contact center database, and it is in the cloud. I have also used it in other projects for database and CRM, and it was on-premises. I have used it in 20 projects.

What is most valuable?

It is easy to use. It is simple to implement, which makes it suitable for our projects because we have deadlines. MySQL is also open-source, which is another plus point.

What needs improvement?

Its performance should be better. When we use big data, it is slow in performance. We should be able to use mirroring for improved performance.

For how long have I used the solution?

I have been using MySQL for nine years.

What do I think about the scalability of the solution?

It is very flexible. It could be because I'm familiar with MySQL.

How are customer service and technical support?

I have never contacted the technical support of MySQL. If I have a problem, I find the solution from Stack Overflow.

How was the initial setup?

Its initial setup is easy. I only need a maximum of one hour for the installation of MySQL.

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

It is open-source.

What other advice do I have?

I would rate MySQL a nine out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
EUC Techical Operation at a tech services company with 10,001+ employees
Real User
Stable, easy to install, and comes with community support
Pros and Cons
  • "I like MySQL because of its community."
  • "MySQL doesn't have the auto-clustering and database clustering features that other competitors provide. They can include these features."

What is most valuable?

I like MySQL because of its community.

What needs improvement?

MySQL doesn't have the auto-clustering and database clustering features that other competitors provide. They can include these features.

For how long have I used the solution?

I have been using MySQL for about two years. 

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

It is really easy to scale. We have around 20 to 40 users who use it regularly.

How are customer service and technical support?

I never interacted with their technical support. If there is any problem in my project, I just look for it on Stack Overflow and fix it easily. It also comes with good documentation.

How was the initial setup?

It is easy to install. The deployment duration depends upon your internet connection. If you have a good internet connection, the deployment would be faster.

What other advice do I have?

I would recommend this product if someone is new to the IT world.

I would rate MySQL an eight out of ten.

Which deployment model are you using for this solution?

Private Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
IT Manager
Real User
Performance, stability, and free version are key for us
Pros and Cons
    • "Some problems with big table operations, and a struggle to keep the servers responding in peak situations."

    How has it helped my organization?

    Web portal database.

    What is most valuable?

    • Free usage
    • Performance
    • Community

    What needs improvement?

    Scaling.

    For how long have I used the solution?

    More than five years.

    What do I think about the stability of the solution?

    There have been some problems with big table operations.

    What do I think about the scalability of the solution?

    Some problems with big table operations, and a struggle to keep the servers responding in peak situations.

    How is customer service and technical support?

    I don't have enough information about it, as I normally look for community support.

    How was the initial setup?

    Straightforward, and and easy to run.

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

    Can range from free to quite expensive, depending on the environments and requirements, so better to really set goals ahead of setting it up.

    Which other solutions did I evaluate?

    SQL Server, Oracle XE, MariaDB.

    What other advice do I have?

    It is a stable, reliable, and powerful solution that is quite suited for small to medium organizations and/or projects.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    IT Specialist at a government with 1,001-5,000 employees
    Real User
    Reliable, responsive technical support, and straightforward installation
    Pros and Cons
    • "One of the best features is this solution is easy to use."
    • "The solution could improve by having better performance and security."

    What is our primary use case?

    We are using this solution for database management.

    What is most valuable?

    One of the best features is this solution is easy to use.

    What needs improvement?

    The solution could improve by having better performance and security.

    For how long have I used the solution?

    I have been using this solution for approximately five years.

    What do I think about the stability of the solution?

    The solution is relatively stable.

    What do I think about the scalability of the solution?

    For what we have been using the solution for it is scalable. However, it could be more scalable.

    We have a lot of customers using this solution with more projects coming up. We have overall approximately 500 users using this solution.

    How are customer service and technical support?

    The technical support is very good and responsive.

    How was the initial setup?

    The installation is straightforward. It can easily be installed onto a laptop or any computer.

    What about the implementation team?

    I did the implementation myself.

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

    There is not a license required for this solution.

    What other advice do I have?

    I would recommend this solution to others.

    I rate MySQL an eight out of ten.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    Systems Administrator at Nubity Inc. at a tech services company
    Consultant
    Think about the size of the database

    What is most valuable?

    Easy:

    • Installation
    • Customization
    • Use

    How has it helped my organization?

    Data is:

    • More ordered
    • Reliable
    • Available in time and form

    What needs improvement?

    Scalability: In large databases, they become slow.

    For how long have I used the solution?

    12 years.

    What do I think about the stability of the solution?

    No.

    What do I think about the scalability of the solution?

    Yes. In large databases, response times are high.

    How are customer service and technical support?

    10 out of 10.

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

    We used this solution, but changed for another because the database was very large.

    How was the initial setup?

    Configuration was easy and with much support material.

    Which other solutions did I evaluate?

    No.

    What other advice do I have?

    Let them think about the size of the database.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    Infrastructure Expert at a tech services company with 51-200 employees
    Consultant
    MySQL is a database system that is most used, fast, more reliable, cheaper, and better than any other database system.

    Valuable Features:

    It has a relational database system. Client/Server Architecture SQL compatibility (Structured Query Language) .MySQL has the features of the current SQL standard (at the moment SQL: 2003). SubSELECTs: From version 4.1, MySQL is capable of processing a query in the form of SELECT * FROM tablename1 WHERE x IN (SELECT y FROM tablename2). MySQL supports views from MYSQL version 5.0. Stored procedures: Is capable of storing codes: MySQL has supported SPs since version 5.0. Triggers: MySQL has supported triggers in a limited form from version 5.0 Unicode: MySQL has supported all conceivable character sets since version 4.1, including Latin-1, Latin-2, and Unicode (either in the variant UTF8 or UCS2). User interface: There are a number of convenient user interfaces for administering a MySQL server. Full-text search: Full-text search simplifies and accelerates the search for words that are located within a text field. If you employ MySQL for storing text (such as in an Internet discussion group), you can use full-text search to simply implement an efficient search function. Has got statement-based replication. It's one of the simplest ways to create databases.

    Room for Improvement:

    DELETE and UPDATE statements that use a LIMIT clause without an ORDER BY are non deterministic. Statements using any of the following functions cannot be replicated properly using statement-based replication: LOADFILE (), USER ().
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user116742 - PeerSpot reviewer
    it_user116742Oracle Web Administrator at a tech services company with 1,001-5,000 employees
    Consultant

    It is the easiest to use and simplest to learn. The coding is just simple.

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