We developed a network monitoring software and used MySQL as a backend database.
We utilized the two most common and popular MySQL database engines, MyISAM and InnoDB.
We store collected monitoring data and configuration data on MySQL. Also, our network monitoring solution reporting module is based on the MySQL MyISAM database engine.
We use both Windows and Linux versions of MySQL, and we utilize the backup and recovery features.
To summarize, our primary use case is the embedded DB component for our network management software.
MySQL is a popular database platform for businesses because it is extremely easy to use. It is commonly used in combination with PHP and Java. For instance, someone with little to no knowledge of MySQL can easily establish a database connection and start programming immediately.
So MySQL improved our developing process speed. MySQL is a very popular and well-known database solution, so it is easy to find a MySQL developer.
MySQL performance also improved our NMS solution performance.
MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses.
MySQL advantages and valuable points include:
- MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
- MySQL uses a standard form of the well-known SQL data language.
- MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, Java, etc.
- MySQL works very quickly and works well, even with large datasets.
- MySQL is very friendly to PHP and Java at the same time. Both PHP and Java are our development languages.
The two most common and popular MySQL database engines are MyISAM and InnoDB. Database engines provide the underlying functionality for MySQL to work with and process data. MyISAM is the default engine for MySQL for versions earlier than 5.5.5 and functions well in most scenarios.
However, depending on your needs, there are situations where another database engine, such as InnoDB, may be the better choice. For example, InnoDB supports transactions, whereas MyISAM does not. InnoDB also provides support for foreign keys, whereas MyISAM does not.
When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL. An example of this is the Vertica DB engine (https://en.wikipedia.org/wiki/...), and offering support for it would be valuable.
We have been using MySQL for more than ten years.
Previously, we used MSSQL and switched to MySQL because of performance issues.
After installation, the maintanence is easy for an end-user.
MySQL is released under an open-source license, so you have nothing to pay to use it.