Percona packages PostgreSQL alongside existing MySQL and MongoDB products

Free should mean free, says open-source DB biz


Interview PostgreSQL is among the most popular database management systems, but market share is a slippery thing to measure, depending on whether you mean revenue, developer activity, or actual deployed databases.

The developer-focused StackOverflow puts PostgreSQL second after MySQL, with Microsoft SQL Server third and Oracle way down at 8th. DB-Engines on the other hand, which measures general discussion, puts Oracle top, followed by MySQL, Microsoft SQL Server and PostgreSQL 4th.

Open-source company Percona's distribution, announced at its Percona Live event in Amsterdam, is based on PostgreSQL 11.5, supplemented by several extensions. The pg_repack extension reorganises tables with minimal locks. The PostgreSQL Audit Extension (pgaudit) provides tools for audit logs to meet compliance requirements. And backup and restore is provided by the pgBackRest extension.

Perhaps the most interesting addition is Patroni, developed by online fashion platform Zolando 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 – though this is not yet part of the Percona package.

The rationale behind the product, according to Chief Experience Officer Matt Yonkovit, is that with PostgreSQL "there's all these extensions to fill in gaps, but they're not supported". Therefore a pre-built and supported package of the core product together with important extensions is useful.

Is it a fork? "It isn't a fork. We do not believe in forking any code," Yonkovit told The Reg.

The distinction can be a fine one. In the case of MySQL, Percona's build is based on the official community version, but with fixes and patches to fix bugs or performance issues. "We contribute those back to Oracle to fix upstream, and a lot of times it takes six months, a year, sometimes longer to get these bugs fixed in the community version," Yonkovit said. "A lot of enhancements end up in MySQL Enterprise version. They don't have an incentive to include those in Community. So they put them in their Enterprise edition which is locked away from most of the community."

PostgreSQL is different since "it is owned by the community". Yonkovit believes that any fixes will therefore appear upstream much earlier. "There isn't a disincentive to include things."

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

The Percona business model is based on support and consultancy and the company promises [PDF] that "there is no fee or commercial license requirement for downloading and using any Percona software".

The company has released statistics from its own State of Open Source Databases survey, based on data from around 800 respondents at small, medium-sized and large business – but skewed somewhat towards Percona users. According to this survey, 46 per cent use PostgreSQL in some measure, tilted towards the smaller companies, making it the second most popular after MySQL, which has around 92 per cent share.

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

Another factor is the increasing demand for Kubernetes support. Around 25 per cent of those surveyed have Kubernetes (K8s) database deployments in development, but only 13 per cent are in production. Yonkovit said that Percona doesn't have "an operator yet for PostreSQL for K8s" but is working towards one, though this may use Citus, another solution for distributed PostgreSQL, rather than Patroni.

"We're getting a large demand from our enterprise space for additional K8s support," said Yonkovit. "Companies are looking at the cloud as the new vendor lock-in, so ways to deploy cross-cloud or hybrid with a consistent environment. K8s plays to the manageability and the portability."

Use of open-source database technology is increasing, according to a report to be presented at Percona Live, with 79.4 per cent of respondents motivated by cost savings, and 62 per cent fleeing vendor lock-in.

Finally, Yonkovit was keen to comment on the efforts of open-source businesses to use new licences that better protect their interests – such as MongoDB's Server Side Public License. MongoDB argues that "it is too easy for large cloud vendors to capture all the value but contribute nothing back to the community". Similar issues have been raised by Redis and others.

"Based on 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 the open source makes it less open. How will the user base respond?"

How then do they prevent large cloud vendors from in effect exploiting the open-source community? "Our philosophy is that having a larger ecosystem is best for everyone," said Yonkovit. "Other companies are looking at it as a threat to their subscription. People jump into the open-source space as a business model that will make money. But open source really isn't a business model. It's a method to build your applications." ®

Similar topics


Other stories you might like

  • Your snoozing iOS 15 iPhone may actually be sleeping with one antenna open
    No, you're not really gonna be hacked. But you may be surprised

    Some research into the potentially exploitable low-power state of iPhones has sparked headlines this week.

    While pretty much no one is going to utilize the study's findings to attack Apple users in any meaningful way, and only the most high-profile targets may find themselves troubled by all this, it at least provides some insight into what exactly your iOS handheld is up to when it's seemingly off or asleep. Or none of this is news to you. We'll see.

    According to the research, an Apple iPhone that goes asleep into low-power mode or is turned off isn't necessarily protected against surveillance. That's because some parts of it are still operating at low power.

    Continue reading
  • China will produce one in five of the chips it uses in 2026, says analyst
    Well short of planned 70 percent domestic capacity

    China’s integrated circuit (IC) production has failed to keep pace with its appetite for silicon, with market research firm IC Insights predcicting the nation will produce only one in five ICs it uses in 2026.

    That figure is a increase from 2021's one in six, and reflects eight percent compound annual growth rate from 2021 to 2026. But it means China will miss its own targets for locally-made-and-consumed silicon.

    “Although China has been the largest consuming country for ICs since 2005, it does not necessarily mean that large increases in IC production within China would immediately follow, or ever follow” said the firm in a bulletin on Wednesday.

    Continue reading
  • Tencent happily parting ways with loss-making cloud customers
    Cutting costs across sprawling business as COVID makes life hard in China

    Chinese tech giant Tencent has recorded its first ever quarter-to-quarter revenue fall, warned that COVID-19 lockdowns will hurt messing with its business, and cautioned against assumptions that Beijing is ready to enthusiastically support tech companies.

    On its Q1 2022 earnings call yesterday, the company offered more explanation of its shifting cloud strategy.

    Chief strategy officer James Mitchell told investors the company is pleased to have shown loss-making cloud customers the door, and “proactively scaled back … deeply discounted infrastructure-only contracts for basic services such as cloud compute and content delivery network.” Projects that had high costs and/or relied on sub-contractors have also been scaled back.

    Continue reading
  • Will this be one of the world's first RISC-V laptops?
    A sneak peek at a notebook that could be revealed this year

    Pic As Apple and Qualcomm push for more Arm adoption in the notebook space, we have come across a photo of what could become one of the world's first laptops to use the open-source RISC-V instruction set architecture.

    In an interview with The Register, Calista Redmond, CEO of RISC-V International, signaled we will see a RISC-V laptop revealed sometime this year as the ISA's governing body works to garner more financial and development support from large companies.

    It turns out Philipp Tomsich, chair of RISC-V International's software committee, dangled a photo of what could likely be the laptop in question earlier this month in front of RISC-V Week attendees in Paris.

    Continue reading
  • Did ID.me hoodwink Americans with IRS facial-recognition tech, senators ask
    Biz tells us: Won't someone please think of the ... fraud we've stopped

    Democrat senators want the FTC to investigate "evidence of deceptive statements" made by ID.me regarding the facial-recognition technology it controversially built for Uncle Sam.

    ID.me made headlines this year when the IRS said US taxpayers would have to enroll in the startup's facial-recognition system to access their tax records in the future. After a public backlash, the IRS reconsidered its plans, and said taxpayers could choose non-biometric methods to verify their identity with the agency online.

    Just before the IRS controversy, ID.me said it uses one-to-one face comparisons. "Our one-to-one face match is comparable to taking a selfie to unlock a smartphone. ID.me does not use one-to-many facial recognition, which is more complex and problematic. Further, privacy is core to our mission and we do not sell the personal information of our users," it said in January.

    Continue reading
  • Meet Wizard Spider, the multimillion-dollar gang behind Conti, Ryuk malware
    Russia-linked crime-as-a-service crew is rich, professional – and investing in R&D

    Analysis Wizard Spider, the Russia-linked crew behind high-profile malware Conti, Ryuk and Trickbot, has grown over the past five years into a multimillion-dollar organization that has built a corporate-like operating model, a year-long study has found.

    In a technical report this week, the folks at Prodaft, which has been tracking the cybercrime gang since 2021, outlined its own findings on Wizard Spider, supplemented by info that leaked about the Conti operation in February after the crooks publicly sided with Russia during the illegal invasion of Ukraine.

    What Prodaft found was a gang sitting on assets worth hundreds of millions of dollars funneled from multiple sophisticated malware variants. Wizard Spider, we're told, runs as a business with a complex network of subgroups and teams that target specific types of software, and has associations with other well-known miscreants, including those behind REvil and Qbot (also known as Qakbot or Pinkslipbot).

    Continue reading
  • Supreme Court urged to halt 'unconstitutional' Texas content-no-moderation law
    Everyone's entitled to a viewpoint but what's your viewpoint on what exactly is and isn't a viewpoint?

    A coalition of advocacy groups on Tuesday asked the US Supreme Court to block Texas' social media law HB 20 after the US Fifth Circuit Court of Appeals last week lifted a preliminary injunction that had kept it from taking effect.

    The Lone Star State law, which forbids large social media platforms from moderating content that's "lawful-but-awful," as advocacy group the Center for Democracy and Technology puts it, was approved last September by Governor Greg Abbott (R). It was immediately challenged in court and the judge hearing the case imposed a preliminary injunction, preventing the legislation from being enforced, on the basis that the trade groups opposing it – NetChoice and CCIA – were likely to prevail.

    But that injunction was lifted on appeal. That case continues to be litigated, but thanks to the Fifth Circuit, HB 20 can be enforced even as its constitutionality remains in dispute, hence the coalition's application [PDF] this month to the Supreme Court.

    Continue reading
  • How these crooks backdoor online shops and siphon victims' credit card info
    FBI and co blow lid off latest PHP tampering scam

    The FBI and its friends have warned businesses of crooks scraping people's credit-card details from tampered payment pages on compromised websites.

    It's an age-old problem: someone breaks into your online store and alters the code so that as your customers enter their info, copies of their data is siphoned to fraudsters to exploit. The Feds this week have detailed one such effort that reared its head lately.

    As early as September 2020, we're told, miscreants compromised at least one American company's vulnerable website from three IP addresses: 80[.]249.207.19, 80[.]82.64.211 and 80[.]249.206.197. The intruders modified the web script TempOrders.php in an attempt to inject malicious code into the checkout.php page.

    Continue reading

Biting the hand that feeds IT © 1998–2022