MySQL
JetwareExternal reviews
External reviews are not included in the AWS star rating for the product.
Easy to use and open source with almost endless community support
Analysis of customer purchasing patterns and user actions has been effectively facilitated
What is our primary use case?
What is most valuable?
What needs improvement?
For how long have I used the solution?
What do I think about the stability of the solution?
What do I think about the scalability of the solution?
How are customer service and support?
How would you rate customer service and support?
Positive
What's my experience with pricing, setup cost, and licensing?
What other advice do I have?
Most Popular Relational Database Solution Businesses
Easy to use & convenient
Making database entries is very simple and seamless.
Native encryption ensures secure data management with a simple deployment
What is our primary use case?
We are using two or three types of databases in our organization, such as Oracle and MySQL. We usually use the MySQL database for the business applications that we develop in-house.
What is most valuable?
The most valuable feature is the on-premises data encryption facilities. By default, we can provide encryption, and this feature in MySQL is why we prefer it over other databases. The native encryption in MySQL encourages us to use this database model more frequently compared to Oracle and other databases.
With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment. It perfectly supports our ROI, and we have no issues with its functionality.
What needs improvement?
The data masking functionality should be improved as well as the native encryption functionality in the MySQL database. It could be more beneficial if MySQL can enhance its data masking functionality in the same way it has improved data encryption.
For how long have I used the solution?
I have been using it for around ten years.
What do I think about the stability of the solution?
We face certain integration issues, especially when we integrate the database with security solutions like IBM QRadar, which affects database performance.
How are customer service and support?
We have a local vendor available here in Pakistan, who provides service. As far as the principal is concerned, we do not directly communicate with them. We have a vendor here, so we have no issues and usually receive timely responses. I would rate customer service nine out of ten.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
We are working with Oracle, and we also use a file database called GT.M.
How was the initial setup?
It is a pretty simple deployment process that can take around two to three hours.
What about the implementation team?
We have a dedicated database administration team responsible for implementation. We have around five to ten people in the team.
What was our ROI?
We estimate the ROI to be around 40%.
What other advice do I have?
With respect to BAM, database activity monitoring, when we integrate BAM solutions, we face certain integration challenges. These are mainly compatibility issues, like when IBM Guardian is integrated with MySQL for database monitoring. Despite these challenges, the availability of support from IBM helps us to overcome them.
The product is highly recommended for its compatibility with other platforms like dot net framework. It easily integrates with in-house development functionalities and provides excellent relational database functionality.
Overall, I give it an eight out of ten.
Which deployment model are you using for this solution?
MySQL database review
Powerfull DB engine easy to integrate with many tools
MySql Database
Best open source relational database management system.
Structure is well-defined and easy for end users and business stakeholders to read
What is our primary use case?
I use MySQL as a metadata database to store information about our product and transactions from other platforms. We extract and store these transactions daily.
What is most valuable?
I find MySQL's relational data storage format very useful for data management. Our structure is well-defined and easy for end users and business stakeholders to read. I appreciate the tool's simplicity and ability to integrate with our backend tools.
Performance optimization techniques in MySQL are foundational and very useful. Many big database tools are based on their techniques. We use basic optimization methods like indexes and constraints, which should be set up early when designing the database schema. These optimizations are important for us and work well with MySQL.
What needs improvement?
As for areas that could be improved, the tool is often used as a local database on laptops. But now, we're moving to cloud-based solutions that are more scalable and highly available. I think the tool should offer a cloud database option. This would let users keep a local copy of data if needed, but also have their data available across different regions through a cloud account.
What do I think about the stability of the solution?
The product's stability is high.
What do I think about the scalability of the solution?
I rate the tool's scalability as about six out of ten. It's moderate since it's a relational database, so scalability depends on the data volume we can store. We use MySQL mainly for structured data in its final state. About 1800 people use MySQL in our organization. Around 1200 use it daily, and about 600 developers use it for local databases or small project tasks.
How are customer service and support?
MySQL has been in the market for a long time, and its community keeps growing. As developers, we've gotten full support from them since we started using it. This includes help from their support team and software team and assistance with any technical issues we encounter.
How would you rate customer service and support?
Positive
How was the initial setup?
I'd rate the initial setup as nine out of ten for ease, with ten being the easiest. It's very simple for beginners to set up because the documentation is thorough, and each step is well explained. The deployment usually takes minutes to hours, depending on the data volume we're putting into the database. It typically doesn't take longer than a day.
What was our ROI?
MySQL has had a moderate impact on our cost efficiency so far. We mainly use it for local development in our internal environments. For production, we use other cloud solutions. However, MySQL's impact on our operational productivity is significant. It's very reliable for all the solutions we're building.
What's my experience with pricing, setup cost, and licensing?
I rate the solution's pricing as four out of ten, where one is cheap, and ten is expensive. For our basic needs, it's quite affordable. However, the cost increases when we need to scale up or require high availability. Our developer team of about 600 people uses MySQL without much issue. The pricing becomes more of a concern on the business side, as we have more end users and need constant database availability and scaling. In those cases, the solution gets a bit more expensive, even though it provides good value for the business.
What other advice do I have?
I rate the overall solution a nine out of ten.
Enhanced data handling and seamless integration for efficient project management
What is our primary use case?
I have worked on migration projects between Power BI on Microsoft and SAP modules, which involve exchanging databases from Power BI on Microsoft to SAP modules.
Additionally, I have been involved in integration projects as a MySQL developer using Oracle SQL databases.
How has it helped my organization?
MySQL has facilitated the migration projects to SAP modules from Microsoft Power BI, easing database exchange. The integration is smoother and more efficient, which has been beneficial for handling various projects.
What is most valuable?
The ML modules in MySQL are advantageous since they make data handling easy and quick at MNQM. I have a lot of experience with QA test sections on MySQL, and it aids in connecting with third-party programs effortlessly due to its adaptation capabilities.
What needs improvement?
MySQL has some unique exchange problems when it comes to migration projects. The product could improve in terms of security, though not necessarily when compared to Azure. It can be improved in areas related to database exchange during migration projects.
For how long have I used the solution?
I have five years of experience with MySQL.
What do I think about the stability of the solution?
MySQL is stable and continuously improves concerning databases. It is advantageous for projects in this area.
What do I think about the scalability of the solution?
Scalability in MySQL involves unique troubleshooting for every project that differs according to database exchanges. You can solve scalability issues easily if you possess strong SQL skills.
How are customer service and support?
Technical support from Oracle for MySQL is very good. They are really good at providing support.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
I have experience with Oracle SQL and have not used Microsoft SQL. MySQL and PostgreSQL are the tools I currently work with.
How was the initial setup?
The initial setup for MySQL took about one and a half hours, and only one person was required for the installation.
What was our ROI?
Cost-saving is not a significant concern, but focusing on project details is crucial. The project details provide exchangeable areas that can lead to cost savings.
What's my experience with pricing, setup cost, and licensing?
The pricing for MySQL is slightly expensive, especially in unique projects for sectors like automotive and pharmaceuticals. Despite this, it is preferable for special projects due to its unique offerings.
Which other solutions did I evaluate?
I have experience with Oracle SQL and PostgreSQL.
What other advice do I have?
I'd rate the solution eight out of ten.