Percona packages PostgreSQL alongside existing MySQL and MongoDB products

Free should mean free, says open source DB biz

  PostgreSQL is the easiest route away from Oracle according to Percona

PostgreSQL is the easiest route away from Oracle, according to Percona

Interview PostgreSQL It is among the most popular database management systems, but the market share is somewhat slippery to measure, depending on whether it is revenue, developer activity or actual implemented databases.

The developer-centered StackOverflow places PostgreSQL in second place after MySQL, with Microsoft SQL Server third and Oracle very low in eighth. DB-Engines on the other hand, which measures the general discussion, puts Oracle first, followed by MySQL, Microsoft SQL Server and PostgreSQL 4.

The distribution of the open source company Percona, announced at its Percona Live event in Amsterdam, it is based on PostgreSQL 11.5, complemented by several extensions. The pg_repack extension reorganizes the tables with minimal blocks. The PostgreSQL audit extension (pgaudit) provides tools for auditing records to meet compliance requirements. And the pgBackRest extension provides backup and restore.

Perhaps the most interesting addition is Patroni, developed by the Zolando online fashion platform to implement high availability, using Consul, Zookeeper or Etcd, which are existing tools for managing distributed services. You can also run Patroni natively on Kubernetes, although this is not yet part of the Percona package.

The reason behind the product, according to Experience Director Matt Yonkovit, is that with PostgreSQL "there are all these extensions to fill in the gaps." , but they are not compatible. "Therefore, a preconstructed and compatible package of the core product along with important extensions is useful.

Is it a fork?" It is not a fork. We don't believe in forking any code, "said Yonkovit The Reg .

The distinction may be good. In the case of MySQL, the Percona compilation is based on the official version of the community, but with corrections and patches to correct errors or performance problems. "We contribute to return them to Oracle to solve the problem, and many times it takes six months, one year, sometimes more time to correct these errors in the version of the community, "said Yonkovit." Many improvements end in the MySQL Enterprise version. They do not have an incentive to include them in the community. Therefore, they put them in their Enterprise edition, which is blocked for the majority of the community. "

PostgreSQL is different since" it is owned by the community. "Yonkovit believes that any solution will appear, therefore, much before. "There is no disincentive to include things."

Percona is also launching version two of its monitoring and administration tool. PMM2 adds support for adjusting PostgreSQL queries and is more secure, with all traffic between client and server now encrypted with TLS A new API opens PMM for scripting and interaction with third-party tools.

Percona's business model is based on support and consulting, and the company promises [PDF] that "there is no commercial license fee or requirement to download and use any Percona software."

The company has published statistics of its own survey on the status of Open source databases, based on data from around 800 respondents in small, medium and large companies, but somewhat biased towards Percona users. According to this survey, 46 percent use PostgreSQL to some extent, leaning towards smaller companies, which makes it the second most popular after MySQL, which has about 92 percent participation.

"PostgreSQL is the fastest growing database," Yonkovit said. "What really captured people lately is this proprietary database movement, especially Oracle. PostregSQL has a very similar experience to Oracle. It is not a 1-1 match, but it is far superior to what you get from MySQL. "

Another factor is the growing demand for support from Kubernetes. About 25 percent of respondents have Kubernetes (K8) database implementations in development, but only 13 percent are in production. Yonkovit said Percona does not yet have "an operator for PostreSQL for K8", but is working to get one, although this can use Citus, another solution for distributed PostgreSQL, instead of Patroni.

"We are receiving a great demand from our business space for additional K8 support," said Yonkovit. "Companies are considering the cloud as the new blocking provider, so the ways to implement cross-cloud or hybrid with a consistent environment. K8s play with management capacity and portability."

The use of open source database technology is increasing, according to a report to be presented at Percona Live, with 79.4 percent of respondents motivated by cost savings, and 62 percent fleeing from the confinement of suppliers.

Finally, Yonkovit was eager to comment on the opening efforts. Home businesses to use new licenses that better protect their interests, such as the MongoDB server-side Public License. MongoDB argues that "it is too easy for large cloud providers to capture all the value, but not contribute anything to the community." Redis and others have raised similar issues.

"According to our survey, people are two and a half times more likely to choose a more open license than one of these new licenses," said Yonkovit. "Restricting open source makes it less open. How will the user base respond?"

How do they prevent large cloud providers from exploiting the open source community? "Our philosophy is that having a bigger ecosystem is the best for everyone," said Yonkovit. "Other companies see it as a threat to their subscription. People launch into the open source space as a business model that will generate money. But open source is not really a business model. It is a method to build their applications." . "®

Your guide to being truly data driven with unmatched data analysis performance

For More Updates Check out Blog, Windows Softwares Drivers, Antivirus, Ms Office, Graphic Design Don’t Forget to Look Our Facebook Page Get Into Pc like us & follow on Twitter- @getinpc

Please Note: This content is provided and hosted by a 3rd party server. Sometimes these servers may include advertisements. does not host or upload this material and is not responsible for the content.