Testing times: Microsoft gets PostgreSQL on Azure a day after GA

High end workloads with Hyperscale (Citus)

Microsoft has pushed PostgreSQL 14 into General Availability on Azure Hyperscale (Citus) regions and the company, famed for the occasional outage of its cloud and desktop platforms, has given an insight into what was involved.

PostgreSQL 14 turned up at the end of the last week packed with features (although perhaps lacking in any singularly outstanding new toy) and tweaks aimed at boosting performance on high-end systems.

Barely a day later, Microsoft was trumpeting the database's arrival in its cloud. Kind of – only Hyperscale (Citus) regions need apply for now. Other regions and Azure Database for PostgreSQL will follow over the next few months.

Still, as Microsoft Postgres engineer lead and CTO of Citus Data, Ozgun Erdogan, modestly said, "To our knowledge, this is the first time a major cloud provider has announced GA for a new Postgres major version on their platform one day after the official release."

Noting that Microsoft develops and maintains a number of open source extensions, including Citus, Erdogan explained the process by which extensions are updated as versions of PostgreSQL are released. Breaking changes must be addressed, new features added (if applicable) and, of course, any failing tests in the inevitable pipeline must be fixed.

The "best practice" employed in order to churn out the extension so quickly is interesting from a development standpoint. Unit tests come first, and Erdogan boasted of the 100 per cent coverage achieved for the control plane, as well as the two-minute run time for those tests.

However, while Unit Tests are all well and good, many of the calls have to be mocked – ie, software testers substitute a fake version of the service to stand in for the real one – which makes for quick feedback but, as Erdogan admitted, "doesn't provide a good end-to-end view." End-to-end testing therefore follows to check how the various components are interacting before deployment is considered.

Deployment to Azure is interesting in itself. A third round of tests is involved, with the payload first hitting a staging environment, then to the Azure Early Update Access Program regions, before finally hitting the rest of the production regions. More tests are then run during what Erdogan called the "bake off" period between deployments – including Citus provisioning, upgrades, restores and so on.

The seemingly cautious approach is highly automated: "all our team had to do was click a button - and the deployment was triggered," boasted Erdogan. And a new version of PostgreSQL became available.

Azure users reeling from repeated outages over the last year – and a change that left Azure Active Directory broken earlier this year as the company scrambled to roll back a change to its authentication system – would be forgiven for wondering why the wunder-tech that gets PostgreSQL updates up and running so quickly does not feature in all corners of Microsoft's cloud. ®

Other stories you might like

  • Lonestar plans to put datacenters in the Moon's lava tubes
    How? Founder tells The Register 'Robots… lots of robots'

    Imagine a future where racks of computer servers hum quietly in darkness below the surface of the Moon.

    Here is where some of the most important data is stored, to be left untouched for as long as can be. The idea sounds like something from science-fiction, but one startup that recently emerged from stealth is trying to turn it into a reality. Lonestar Data Holdings has a unique mission unlike any other cloud provider: to build datacenters on the Moon backing up the world's data.

    "It's inconceivable to me that we are keeping our most precious assets, our knowledge and our data, on Earth, where we're setting off bombs and burning things," Christopher Stott, founder and CEO of Lonestar, told The Register. "We need to put our assets in place off our planet, where we can keep it safe."

    Continue reading
  • Conti: Russian-backed rulers of Costa Rican hacktocracy?
    Also, Chinese IT admin jailed for deleting database, and the NSA promises no more backdoors

    In brief The notorious Russian-aligned Conti ransomware gang has upped the ante in its attack against Costa Rica, threatening to overthrow the government if it doesn't pay a $20 million ransom. 

    Costa Rican president Rodrigo Chaves said that the country is effectively at war with the gang, who in April infiltrated the government's computer systems, gaining a foothold in 27 agencies at various government levels. The US State Department has offered a $15 million reward leading to the capture of Conti's leaders, who it said have made more than $150 million from 1,000+ victims.

    Conti claimed this week that it has insiders in the Costa Rican government, the AP reported, warning that "We are determined to overthrow the government by means of a cyber attack, we have already shown you all the strength and power, you have introduced an emergency." 

    Continue reading
  • China-linked Twisted Panda caught spying on Russian defense R&D
    Because Beijing isn't above covert ops to accomplish its five-year goals

    Chinese cyberspies targeted two Russian defense institutes and possibly another research facility in Belarus, according to Check Point Research.

    The new campaign, dubbed Twisted Panda, is part of a larger, state-sponsored espionage operation that has been ongoing for several months, if not nearly a year, according to the security shop.

    In a technical analysis, the researchers detail the various malicious stages and payloads of the campaign that used sanctions-related phishing emails to attack Russian entities, which are part of the state-owned defense conglomerate Rostec Corporation.

    Continue reading

Biting the hand that feeds IT © 1998–2022