Wikipedia, RHEL ditches MySQL and moves to MariaDB

Prior to this Wikipedia has moved to MariaDB from MySQL recently.

According to news from the Red Hat summit which concludes in Boston on Friday, RHEL 7 will also include MongoDB.

The switch was expected to happen after Red Hat's community distribution Fedora announced earlier this year that it would be moving to MariaDB. But it will come as a major jolt to Oracle, the owner of MySQL. (openSUSE, the community distribution of SUSE, announced a switch to MariaDB at the same time as Fedora.)

Many changes in Fedora foreshadow changes in the enterprise distribution.

Once RHEL makes the switch, it will flow on to CentOS, a distribution that provides RHEL without the trademarks, hence making it free in terms of cost. CentOS is widely used by small businesses.

MySQL became Oracle's property after the company bought Sun Microsystems in 2010. There have been many complaints about its stewardship of what was once the last word in open-source database software.
MariaDB is a fork of MySQL that was begun by Ulf Michael Widenius under his new company, Monty Program. Widenius is one of the three co-founders of the original MySQL. The company was sold to Sun in 2008.

Earlier this year, Monty Program merged with SkySQL, a company set up in October 2010 by former employees of the original MySQL. Notable among SkySQL's ranks are former MySQL senior vice-president of global services, Ulf Sandberg, and adviser David Axmark, another of the three co-founders of MySQL.

Widenius and several others raised objections to Oracle's acquisition of MySQL but failed to stop the sale going through.

MySQL's first employee in Australia, Arjen Lentz, said Fedora and OpenSuSE were community driven, whereas RHEL's switch to MariaDB was a corporate decision with far-reaching implications.

"I presume there is not much love lost between Red Hat and Oracle (particularly since the "Oracle Linux" stuff started) but I'm pretty sure this move won't make Oracle any happier," said Lentz, who now runs his own consultancy, Open Query, from Queensland. "Thus it's a serious move in political terms."

He said that in practical terms, MariaDB should now get much more of a public footprint with people (people knowing about MariaDB and it being a/the replacement for MySQL), and direct acceptance both by individual users and corporates.

"Monty Program actually merged (aka was bought) by SkySQL a few months ago. SkySQL does not have significant activity in Australia and New Zealand, Open Query has. SkySQL is currently mainly active in Europe.

"So in terms of significance for AU/NZ, Open Query is definitely happy with this move, and is set to gain business for it. Which is nice in economic terms for Australia, it's not a foreign company with Australian clients."

java.sql.SQLException: Io exception: Broken pipe

It seems that connection is broken and we are trying to run a query on it. Try to add a PoolPing query and validate every connection before running it to as application. Now assuming that our ping query really worked and gave us a good connection, there is still a possibility that the connection is really good when you get it from the pool and goes bad while you’re running your app. Following could be the possibilities which could be causing it.
1. Physical connection was killed midstream – That is, some sort of network problem that is causing connections to be dropped after a period of time. If there are firewalls between the app server and database, those are frequently configured to kill connections after a period of time or simply a router problem.
Solution: Track down the problem.
2. The connections to the DB server are being reset and the client (the driver) is not notified. This can happen if the DB server times out and shuts down the connection w/o notifying the client. This can also be caused by firewalls dropping connections.
Solution: Set your connection timeout (in the pool) shorter than the network/DB server timeout.
Set your steady-connection size to 0.