MySQL Reviews

At this time, pricing and footprint.

This database enabled us to web present our content in a cost efficient way.

I am not up to date on this issue.

At the time pricing and footprint.

This was the IT consultant's task to solve.

No issues encountered.

Not really, as our DB was small. With time, we got version issues, as our DB engine was so old and not updated.

Customer Service:

I've never used it.

Technical Support:

I've never used it.

No previous solution was used.

I don't know as we had consultants.

Consultant team.

We installed it under another now-obsolete license form (free on Linux).

No, as it was required for a CMS we implemented.

• Excellent performance, mainly due to the format of its default table, MyISAM - low disk space, CPU, and memory
• Flexibility offering multiple variations such as Berkely DB , InnoDB, Heap and MyISAM
• Reliability. Although the system runs on Windows without flaws, it tends to perform better on Linux and other UNIX-like Systems.
• Availability
• Open-Source System, open storage database engine
• Used by many websites (e.g. LinkedIn, Facebook, Verizon, and PayPal)
• It's inexpensive when compared to other common databases like Microsoft SQL Server.
• As a developer myself, I enjoy using it at no cost as long as the associated projects are also open-source.

• Limited storage capacity
• Support for foreign keys
• Stored procedures
• The biggest disadvantage of MySQL is MyISAM system, which doesn't support well transactions (lack of efficiency)

Personally, I've been using it for over 10 years, and professionally for three to four years.

I had no problems deploying it.

With each release of MySQL Server was useful for any little problems that users detected, so I would say it's quite stable.

It was straightforward, thanks to the workbench that pulls together nearly every MySQL task, and puts them into one easy and friendly GUI.

Because MySQL is an open-source , the system is under GNU Licence. The system isn't always free, but it's more affordable. If you intend to sell your software as a proprietary product, you would need to purchase a commercial license, which is quite inexpensive when compared with a Microsoft SQL license.

From my perspective, MySQL is a product that allows you to be efficient, but the decision goes down to the situation and what you're looking to accomplish.

• Reliability
• Security
• Flexibility
• Functionality
• Availability - controllability anywhere and with different methods

MyISAM tables could be more reliable.

I've been using the Workbench Server for six years.

I have had no problems deploying it.

I have no stability problems.

I currently do not need to scale on my network.

Customer Service:

I only have the free version, which does not have customer service.

Technical Support:

I only have the free version, which does not have technical support.

We use Cisco ASA and Nagios devices alongside the MySQL server as our network infrastructure needs expanding and required more serious hardware solutions.

I believe it is hard to calculate for hardware.

I only use the free version.

We also looked at PostgreSQL.

As a rule, any device upon delivery is obsolete. Pick up the solution for your business, based on your specific needs.

MySQL 5.6 has a great many new features, including, but certainly not limited to, a number of performance improvements.

However, besides the widely talked-about features such as InnoDB, there's also support for full text search, optimizer, performance schema improvements and GTID.

In order to change the size of InnoDB transaction log files, you have to follow this procedure. Beware that if you don’t follow these instructions step-by-step, your server may not restart or rather it will start with InnoDB storage engine disabled and an error in the logs. So, here’s what you want to do:

1. change (or add) the following variable in my.cnf: innodb_log_file_size = ..
2. stop MySQL server
3. make sure you see a successful shutdown of InnoDB in the MySQL error log
4. move away old log files (at this point I have to double check where they are) by running the following command:
mv /var/lib/mysql/ib_logfile* /tmp/
5. start MySQL server – it should take a bit longer to start because it is going to be creating new transaction log files
6. When you’re positive that MySQL server has started successfully, you can remove the old log files:
rm /tmp/ib_logfile*

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.

• Speed
• Cost

MySQL provides a low cost and effective SQL Database solution for smaller companies that don’t require the overhead and cost associated with RDBMS tools like Oracle

Replication and HA features, but that is to be expected at this entry point

10 years.

No, the deployment of MySQL is very easy as it is usually a part of Linux distributions and most hosting services provide a MySQL database as a part of their hosting service.

No, MySQL has always been a stable database. If there are sufficient resources on the server to run the database it will do fine.

None that I have run into. For really big databases I have always used Oracle.

Customer Service:

There is plenty of support available on the internet. I have never really needed to use or activate a support contract for MySQL

Technical Support:

There is plenty of support available on the internet. I have never really needed to use or activate a support contract for MySQL.

Before using MySQL I used Oracle and Informix for RDBMS.

The initial setup was easy as there is usually a version distributed as a part of the Linux distribution.

I have always implemented MySQL through and in house team.

The initial setup cost and maintenance costs are built into the OS costs for all of my implementations and are insignificant.

I usually look at MySQL, PostgreSQL and Oracle.

MySQL is a great RDBMS, but make sure it will integrate with all of the clients you will be using and the rest of your infrastructure. The problems usually have more to do with other products supporting MySQL than MySQL itself.

• 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.

MySQL has established itself not only as the most popular open-source database, but the most reliable one as well. In my more than six years as system administrator managing various websites and web servers, MySQL has been our server of choice for web applications. It wouldn't be acquired by Oracle if it did not see it that way too.What I like most about MySQL is that it's relatively easy to install, fast, lightweight and reliable. It's available for both Windows and Linux, making it a very good alternative to other open source databases back then, which only runs on Linux. PostgreSQL for example did not have a Windows installer before. This made it very difficult to adopt it for mixed-OS environments and that is why we use MySQL.

Back in the days, our only gripe about MySQL was that it was a purely command-line based system. We don't really see it as disadvantage though, as it allowed it to be fast and very reliable. This has been addressed through the years with graphical management systems for MySQL. MySQL is a highly recommended product. I give it five stars as it really gets the job done without much of a hassle. Being available for the many platforms also makes it a very compelling choice for mixed-OS environments, as data migration can just be as easy as backing-up and restoring on another server even on different operating systems.

Just be ready though to work at the command line should you wish to use MySQL in its free form. It may not be the most intuitive user interfaces available, but it also makes MySQL a simple yet very reliable database for most people's needs.