MySQL Reviews

We use MySQL and MariaDB for most part of our mission critical applications

This as it is so simple to integrate with web applications, and other well known applications.

Since it has many integrations to web applications, it is very easy to install and deploy open source web applications.

How it uses clustering.

The API's to PHP, ruby, perl, java, python, and many more high level programming languages makes it easy for us to deploy new features fast.

How to scale out with shard clusters.

The way how to handle replications needs to be improved, as we noticed that there are some performance drop of (using only one core for example)

More than five years.

No issues.

Yes, the binary log replication process in a cluster environment has issues processing data as fast as it arrives.

Customer Service:

A 10 out of 10.

Technical Support:

A 10 out of 10.

We have been using many different types of databases, and will most likely use this one for part of our systems, as it is has so much integration.

The initial setup was easy.

We implemented it in-house.

Free.

Be sure to take backups of the solution, as this will check that the blocks are okay.

We decided to use "DB Protection for MySQL" as it has options to perform block level incremental forever, and integrates well with Spectrum Protect.

Yes, we checked MongoDB, PostgreSQL and MariaDB.

• It is inexpensive as compared to other common databases like Microsoft SQL Server or Oracle. • MySQL is an extensible, open storage database engine that integrates seamlessly with a number of programming languages and other web-based technologies. • MYSQL is an open source system under the GNU General Public License. Developers can use it at no cost as long as the associated projects are also open-source. • Having excellent performance, MYSQL is used by many internet powerhouses like yahoo as their back-end database. MYSQL has great performance due to format of its default table, MyISAM. MyISAM databases use little disk space, memory and cpu. The system runs without flaw and perform better on all platforms including windows, Unix and Linux.

• MySQL has a limited storage capacity. It doesn’t support large databases. • Database transactions are not handled efficiently. • Unlike Oracle, MySQL doesn't have Tablespace, Role management, snapshots, synonym and packages. • For transferring data, MySQL doesn’t support other languages being executed from within the system, and neither does it supports XML. • Compared to Oracle, MySQL database does not support any feature like Audit Vault on its server • There is a limited scope and earning available for database administrator of MySQL.

MySQL is an open source database management system and is used by most of the most famous networking sites. It is more popular in websites and PHP integration. It can be executed under a number of operating systems like Linux, UNIX, Mac OS and Windows. MySQL supports ODBC interface which allows MySQL to be addressed by all the usual programming languages that run under Microsoft Windows.

It depends on the use and implementation, as I prefer to use Galera or XtraDB because of replication and failover functionality. However, the ability to scale horizontally is much better than other vendors. Also, the transactional functionality is good.

Configuration templates and reliability both need work.

I have been using MySQL for over five years.

I deploy multiples of these servers now, and it is all managed via a puppet so I/we have not had problems with deployment in a long time.

An overload of sessions, or long running queries. can cause the servers to be unusable.

Currently no, as we use our own load balancer to enable us to scale to any level.

We don't use it.

It was straightforward, and there are numerous blogs on-line that cover every possible configuration.

We did it in-house.

It takes about six months, but this does depend on its associated product and usage.

Chose your database based on traffic type and desired functionality, not on the initial cost.

If you have the in-house knowledge MySQL can be a great product. If you do not I would recommend using MSSQL instead.

Take a look at the environment you plan to implement including the application and traffic model.

MySQL is very flexible, has excellent performance, and it's simple to use.

Once we needed to use a database to distribute a product for my company and we chose MySQL, it was easy to use and it is very small, but powerful.

Maybe the way to build clusters needs to be improved. They could also improve the installation process.

I been using MySQL for nearly seven years.

There were no stability issues.

There were some scalability issues.

I would give the technical support an eight out of 10 rating.

We did upgrade the version with improvements to the product.

The setup was complex in the cluster installation.

MySQL is one of the best database options. The Community version is great.

We used Oracle and SQL Server, but their prices and licensing were so expensive.

Using MySQL could be an excellent option for you.

This product is valuable because it is used in production environments. Online backup can be implemented by activating a temporary storage similar to the Oracle's flash recovery area and introducing Percona innobackupex. This is possible from version 5.6.

It permits services such as data warehouse and retail.

The online backup needs to improve.

I have used this solution for 15 years.

We did encounter stability issues.

There were no scalability issues.

Not applicable because we don't purchase commercial support.

We switched due to cost saving reasons.

The setup was of medium-level complexity due to memory parameters.

Compared to PostgreSQL, it has an online backup feature only with the extension of Percona innobackupex.

1) It is freely available under the terms of GNU General Public License.2) MySQL works seamless on various platforms and environments.3) It is mainly used in Client/Server environment and it can be embedded in standalone applications. 4) Support SQL standards, and also provide Multi-thread environment.5) Offers high performance due to its unique storage engine architecture as well as it's core written in powerful languages such as C and C++.

1) Does not provide good development and debugging tools, so it’s cumbersome to write large SQL statements.2) MySQL uses temporary tables to execute queries, so it consumes more space.3) MySQL is missing some RDBMS features like stored procedures, foreign keys, transaction, rollback, and subselect. And it also does't support triggers.It is widely used in web applications, and several software stacks includes MySQL as a Data Base Management System like (WAMP, XAMPP) considering its flexibility and simplicity.

And if some one is looking for Database which performs simple processes like storing and displaying data only, then MySQL is the right choice.

We use this solution for billing, accounting, and data analysis.

The most valuable feature is the ease of use.

The manuals or documentation could be better.

I have been using MySQL for ten years.

We are using version 8.

We do not have any issues with the stability of MySQL.

For our needs, it's sufficient.

We have 10 users in our organization.

It has more than enough support available for our needs. There is plenty of support from the community.

We rely on the forums and other channels for help. It's pretty good at the moment.

The initial setup is straightforward.

The installation can take approximately an hour.

You need to be aware of databases to make use of it. You need a moderate level of competence.

We use the community edition.

There is no cost involved, no licensing fees.

We did not evaluate other products.

It's a good product for new startups.

I would rate MySQL a seven out of ten.

On-premises

It is the database for a web application. I am using it for personal and official purposes.

It is easy to use.

It is not as powerful as SQL Server. It can be more powerful.

It is not scalable and has certain limitations, which is not the case with SQL Server.

I have been using this solution for a couple of years.

It is stable.

It is not scalable. We have around 10 to 15 web developers who are currently using it.

I have not interacted with them.

Its installation is not very complex. It takes two hours.

I installed it on my own. We have four or five people for deployment and maintenance.

For the on-premise version, no license is required.

We plan to keep using this solution. I would rate MySQL a seven out of ten.

On-premises