Is it good time to switch from MySQL and choose some other database?

  •        0

Recently you might have seen many news that big organization like Redhat, Fedora, Wikipedia dumped MySQL and moved to MariaDB. Now Google also going to join them. Why everyone want to move out of MySQL? It is once a popular and stable software. What is the reason behind and what are the possible alternatives.

One possible reason is, MySQL acquired by Sun and later by Oracle. MySQL is free for open source or personnel use but commercial users have to pay. Those who have already bought, now its the time to renew the license and Oracle expecting a high price for that. Those who are in cloud and having 100s of instance of MySQL will burn their fingers. This is one of the reason for Google to move away from MySQL database.

Since, Most of them are planning to dump MySQL, Is it good time to switch?

I would say, don't follow the crowd. It is situation dependent. Many are leaving, but still many are using, Facebook uses MySQL. You need to think, of alternative only if you or your company is not able afford it. If you are running one or two instance, paying some extra dollars may not hurt you. If you are really concerned about the money spent on MySQL license then you need to really think of choosing other alternative. Other than cost, I don't see any issues with MySQL.

Below are some good alternative you could choose.
MariaDB: This is a MySQL fork and developed by MySQL original founder. It is a drop in place replacement of MySQL. You don't need to migrate your database.
PostgreSQL: It is a stable RDBMS and it is gaining popular. You need to migrate your existing database to PostgreSQL. There are some good open source tools available.

Redhat to ditch MySQL
Wikipedia to dump MySQL
Google switch from MySQL
Fedora to replace MySQL
Database Migration tools


Related Articles

Top 15 Open source alternative to Microsoft products

  • microsoft-alternative open-source-enterprise

Microsoft is monopoly in the commercial software. Here are 15 best alternatives to most popular and widely used Microsoft products.

Read More

How to solve CommunicationsException in Java while using Hibernate and MySQL

  • java hibernate mysql communicationsexception timeout

You might have faced CommunicationsException, basically timeout issue in Java while connecting to MySQL using Hibernate. The session would be timed out after certain period of time. You might be thinking that the your site or application is running without any issue but it would have stopped or crashed due to exception.

Read More

Is Unix time end by 2038

  • unix-time year-2038

In 32 bit operating system, Dates are calculated using number of seconds differece between 1 January 1970 and current date. This difference will reset to 00:00:00 on January 2038. This is called year-2038 Bug.

Read More

Open source is the backbone for Startups

  • opensource open-source startups

Many startups are entering in to the business due to open source. Open source acts as a back bone / pillar for their business. It reduces the cost of production, Generates revenue from consulting and support. This article describes about the startups which flourished because of open source. Sun acquired MySQL for $1Bn is the biggest achievement for open source startups.

Read More

Why require Searchengine? Why not use database for full text search in Enterprise application.

  • searchengine database

Most of the database has support of full text search, basically indexing and saarching. MySQL, Oracle and many more databases has in-built full text search. Then what is the need to go for external search engine like Lucene, Sphinx, Solr etc. Check out the advantage of using Searchengine.

Read More

Pros and Cons of GPL licenese

  • gpl license pros cons

GPL is widely used and known license in Open Source community. Richard Stallman father of GNU is the man behind GPL. GPL gives freedom and not free software.

Read More

An introduction to MongoDB

  • mongodb database document-oriented-databse no-sql c++ data-mining

MongoDB is the most exciting SQL-free database currently available in the market. The new kid on the block, called MongoDB is a scalable, high-performance, open source, schema free and document oriented database that focuses on the ideas of NoSQL Approach. Written in C++, it has taken rapid strides since its emergence into the public sphere as a popular way to build your database applications.

Read More

PrestaShop - A feature rich Open Source eCommerce solution

PrestaShop is an Open Source eCommerce Solution. It comes complete with over 310 features that have been carefully developed to assist business owners in increasing sales with virtually little effort. It is being used in more than 150,000 online stores.

Read More

LogicalDOC - Open Source DMS

  • dms document-management-system

LogicalDOC is both a document management and a collaboration system. The software is loaded with many functions and allows organizing, indexing, retrieving, controlling and distributing important business documents securely and safely for any organization and individual.

Read More