- Posted by redglue
- On April 23, 2018
- 0 Comments
- databases, mysql, opensource, postgresql, redopendb
The trend is bigger than ever, opensource DBs (mainly PostgreSQL and MariaDB/MySQL) are moving fast and hitting hard commercial databases like Oracle,DB2 or even SQLServer.
Recently PostgreSQL was nominated as DBMS of the year by db-engines ranking after suceeding to SQL Server in 2016. That is just a “popularity” number and it is difficult to evaluate if that is enterprise market reality, but there more facts coming to table to support this movement that are more relevant:
- Microsoft Azure Database for PostgreSQL is now a available managed service for PostgreSQL – One year ago (aorund May 2017), Microsoft deliver the first preview of its managed services for native PostgreSQL that includes what you are used on a managed service: High Availibity of 99.99%, automatic backups, encryption, scaling compute on the fly, monitoring, etc
- AWS RDS for PostgreSQL and MySQL – It is well-know that Amazon is pushing hard opensource DBs. Also some of their proprietary solutions like Amazon Aurora are backup and compatible with MySQL and PostgreSQL. Aurora and AWS are a huge player in this market, driving some innovation in PostgreSQL and MySQL areas like monitoring and benchmark.
- Microsoft Azure Database for MySQL: This one we know very well, as it is the backend of one of our products, redatasense . While PostgreSQL seems to be the choice for migrations from Oracle, DB2 or SQLServer, MySQL/MariaDB is the standard for new and startup projects, that usually grow large.
- Enterprise DB is a major player in PostgreSQL enterprise space, with EDB PostgreSQL Advance Server that improves a lot in some fields where the opensource DBs are not yet in pair with commercial databases, like Oracle.
Of course this movement happens for two particular reasons, mainly:
- Cost, one of the main drivers for database migrations to opensource RDBMS. Companies used to spend a lot of money in database software that they only use a few features from it. It is like Microsoft Excel, you know that it does a lot of things but you keep using the basics at it is enough for you. The same happens on most database workloads.
- Easier to find developers and enthuasiats, it is difficult to find a good PL/SQL or T-SQL developer nowdays as the new generations of developers was born using opensource databases for their applications, university projects or hobbies.
- Keep-It-Simple principle, yes, we need that! Commercial databases are now a huge everything, that do eveything from filesystem clustering to Linear Regressions in Python. The problem with this approach is that it is now very difficult to maintain a software that is so hard and costly and you know…bugs tend to happen more on large and complex software stacks
Opensource is taking world by storm. This is not a difficult argument to build up, as Linux took all datacenters and computing, Hadoop and Big Data ecosystem is all opensource, Programming languages,frameworks and tools are mostly opensource.
Back to title of this post, are databases the last bastion to fall to opensource? The answer will be probably yes, but..for some workloads only. Critical and legacy stuff will still running commercial databases for long time, but expect that new projects even in large enterprise space will kick-off with opensource databases.
Here at Redglue, we are also moving hard on this space, as we are in a near future release something called redopendb. You can now speculate what it can do 🙂