Data Analyst in Quality Assurance at Gfactors (11-50 employees employees)

Use Cases and Deployment Scope

We use MySQL mostly for relational data base system for our core data base related work. It work as a tool for storing structured data and many web services dependency on MySQL for retrieval and storage.Business problems we solve using MySQL includes data management and reporting ,Data warehousing and analytics.

Pros

MySQL usability is easier compare to other database.
MySQL supports many SQL features to handle light analytical workloads.
MySQL with the InnoDB storage provides full ACID compliance which is suitable for transactional systems where data integrity is critical.

Cons

For complex reporting or analytical queries it has limited advanced SQL features.
Weak JSON and NoSQL capabilities for applications that require flexible document storage.
partitioning challenges for horizontally scaling a massive database

Return on Investment

cost is low compare to other data base software.
Medium to High Negative ROI (for growing systems) for scaling limitations
Negative ROI due to hidden operational costs to backups, replication lag, failover setups.

Usability

Alternatives Considered

SQLite, MariaDB Platform and MongoDB

Other Software Used

SQLite, MariaDB Platform, MongoDB

Sharang Dwivedi View profile

Database Engineer in Information Technology at Infosys Ltd. (10,001+ employees employees)

Use Cases and Deployment Scope

For a customer onboarding web application, we have used MySQL database. For web application MySQL database had been preferred choice in the past which provides both open source and licensed feature. Among other reason MySQL DB is easy to setup , simpler feature set, fewer advanced features, but lightweight, stable, and fast for read-heavy workloads.

Pros

Performance of SQL read operations
Easy of setup
Open source
Very low license cost

Cons

Scalability options
Backup and Recovery options
Limited extensibility, fewer user-defined functions and plugins
Enterprise grade High Availability feature

Return on Investment

Cost saving due open source feature and low cost license
Need for enterprise edition for advanced features
Easy to setup in on prem or in cloud

Usability

Other Software Used

PostgreSQL, Oracle Database, Azure SQL Database, MongoDB

Verified User

Engineer in Research & Development (501-1000 employees employees)

Use Cases and Deployment Scope

MySQL is important to critical aspect of my organizations software product experience. It helps us with transaction management, account data management , know your customer verification documentations and auditing trails etc
Overall, MySQLas our RDBMS of choice for key applications goes beyond merely being a backend infrastructure tool, it helps shape a trustworthy and reliable experience for users of our products.

Pros

Strong Query performance as a result of its B-tree indexing capabilities.
MySQL functions with minimal maintenance
Large and active user community.
Proven ACID ( atomicity, consistency , isolation , durability ) compliance.

Cons

Limited JSON capabilities.
Basic text search capability.
Slow with complex joins and full table scans.

Return on Investment

For an organization like mine, it is always our goal to prevent financial data corruption situations whereby someone makes a transfer and the money doesn't get to the destination, meanwhile their cards have been debited. MySQL being ACID compliant eliminates this prospect.
Building with MySQL ensures that we are able to iterate features faster because it is a well known ecosystem, where we have easy access to an abundance of documentation , developers , libraries etc
MySQL is cost efficient because it is open source.

Usability

Other Software Used

Slack, GitLab, Atlassian Jira

Verified User

Consultant in Information Technology (10,001+ employees employees)

Use Cases and Deployment Scope

I use MySQL as a core relational database management system to support a variety of business-critical applications. We leverage MySQL for both internal and customer-facing systems, including web applications, reporting dashboards, content management systems, and data pipelines. Its reliability, performance, and open-source nature make it a strong fit for many of our workloads.

Pros

Scalability
Data consistency
Reporting
Rapid development

Cons

Intégration with AI

Return on Investment

Cost
Easy to deploy
Easy to admin

Usability

Alternatives Considered

EDB Postgres Advanced Server

Other Software Used

3Cloud, AWS Backup, AWS CloudTrail

Verified User

Professional in Information Technology (1001-5000 employees employees)

Use Cases and Deployment Scope

We use the MySQL database for applications like Confluence, Jira, and a few other Java-based applications. As it is Open source, we have also been using it for application development and testing purposes.
MySQL is a very lightweight database, which makes it faster and easier to manage and our applications run smoothly on the MySQL database.

Pros

As its open source, we can modify the code as per our need.
For developing and testing purposes, we can extensively use it without thinking about cost as its free to download
As it's lightweight, we don't have to worry much about resources like CPU, memory, etc.

Cons

As it's open source, there is a lack of support when it's required.
Its good for small scale applications, but for large scale operation, there still needs some improvements in feature and performance.
MySQL is not very suitable for OLTP and analytics-based applications.

Return on Investment

MySQL database is open source and freeware, so it saves a lot in IT revenue.
It's compatible with most Operating systems and applications, so we haven't encountered any compatibility issues so far.
With limited resources, MySQL has given high performance to our applications saving a lot on resource cost.

MySQL

What is MySQL?

Categories & Use Cases

Reviews

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Usability

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Usability

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Usability

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Usability

Alternatives Considered

Other Software Used

Use Cases and Deployment Scope

Pros

Cons

Return on Investment

Usability

Alternatives Considered

Other Software Used

Related Products