Companies globally prefer to have multiple databases placed in multiple locations across multiple platforms, confirmed Percona in its report on Live Open Sourced Database, that surveyed respondents across 85 countries, many of which offer SaaS and cloud solutions to startups, as well as established enterprises.
Over 50% of the respondents run up to about 25 databases instances in production, while some larger organizations even have more than 10,000 instances. The report suggests that as the enterprises scale up operations, they will need databases to interact with more, diverse, and varied applications. Each application might or might not play well with an existing database, leading to database specialization. The prevalence of different database options is pushing more enterprises to pick open-source database technology based on the application use case.
Also, the survey doesn’t put a particular figure on the use of open source solutions versus the proprietary ones. Still, it does confirm that over 80% of respondents use more than one single open-source database. The open-source MySQL databases dominate in the open-source database adoption, as the survey points out that they are compatible databases that have shown an upsurge in adoption in the past few years. Surprisingly about 43% run both PostgreSQL and MySQL, which are both mature relational databases that are often seen pitted against each other.
One surprising trend which has emerged is that despite the number of options offered, relational DBMS continue to dominate the market, with over 90% of the respondents preferring them. Interestingly, 73% of respondents choose to use both a relational database and a NoSQL purpose-built database.
Cloud, however, is an entirely different story
Another trend that has been highlighted is that while most survey respondents are informed about leveraging the open-source technology in the cloud, they often discover themselves tied to cloud vendors having a single solution and higher monthly costs. More than 50% of the respondents avoid public clouds, which is actually dominated by AWS.
The report continues to point out that regardless of the container’s popularity and the advent of orchestration options such as Kubernetes, there aren’t too many that are using containers to run databases.
Also, the survey informed that only a third actually put Kubernetes into the production and an even smaller percentage use it for databases. Another interesting highlight in the report is how changing software licenses influence the adoption criteria or behavior. So, it is obvious that digital transformation is here as most companies are moving to multi-cloud and multi-database deployments.