software engineer
October 24, 2018

software engineer

Tuan Anh Nguyen | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with MySQL

My group is the performance engineering group for Data Domain. In particular, we provide the infrastructure for other teams to do the performance analysis. We have thousands of machines in our infrastructure on different cloud vendors. When they run the performance, we collect the logs, and write the performance data to MySQL. Then the analysts will query and look at the performance data.

SQL queries are formulated to perform a wide range of tasks, including maintaining and analyzing structured data. Though the use of MySQL could vary from one person to other, as well as business requirements, some of the common applications include:
  • Defines database user privileges
  • Add, edit or delete data records
  • Connecting or joining data records that comes from multiple tables
  • Editing or creating the data dictionary of definitions
  • Locking or manipulating data tables

This standard tool helps users to manage a variety of functionalities, such as record management, quality control and data analysis. With MySQL, you can easily complete all communications with or within the databases.
  • MySQL has the structured data that is organized into a table that is easy to manage
  • Everyone is familiar with the syntax
  • Performance is very good
  • Need to support unstructured data
  • Need ability to scale
  • Positive: Everyone knows about SQL
  • Easy to develop
  • Good performance
Comparing MongoDB vs MySQL performance is difficult, since both management systems are extremely useful and the core differences underly their basic operations and initial approach. However, MongoDB vs MySQL is a hot argument that has been going on for a while now: mature relational database against a young non-relational system. Both are open-source and easily available, as well as both systems offer commercial versions with tons of additional features.
For MySQL
Pros:
  • Gives you the ability to host several databases on one server.
  • Uses tables to store data.
  • It has primary and foreign key constraints.
  • Uses indexes to sort data and speed up performance, and supports both desktop and web applications.
Cons: If there is unstructured data, it's very hard to create a table.