Azure admins free to sync their teeth into database-spreader tool

Harmonise with on-premises SQL for when, you know, the cloud falls out of the sky


Microsoft announced general availability of its Azure Data Sync tool this week, which allows data to be synchronised between cloudy Azure SQL databases and on-premises servers.

Just in time for Azure to go for a good long lie down, in Northern Europe at least.

Microsoft Azure on show at Ignite in Orlando

Microsoft Azure Europe embraced the other GDPR: Generally Down, Possibly Recovering

READ MORE

The technology, which has been in preview for a while, allows administrators to configure bidirectional or unidirectional synchronisation for their databases, theoretically allowing a copy of the data in each Azure region or locally.

By pointing applications at their local copy of the database, Microsoft reckons that access time and responsiveness will be improved significantly and latency and connection failures reduced.

Something users of the Northern Europe Azure data centres would doubtless have appreciated last night.

So far so good. However, having dispensed with industry buzzwords such as "hybridisation", the methodology used is not new. It looks to be more suited to databases that, frankly, don't get changed an awful lot.

The basis of the technology is a central hub database, which must be in Azure, and a bunch of member SQL databases, which could also be hosted in Azure or lurk on premises.

An administrator configures those databases as a Sync Group, specifying the direction of data between member and hub (either uni or bidirectional). The databases are then sprayed with Insert, Update and Delete triggers, which dump data changes into a table that eventually finds its way to the Hub to be downloaded to the other members.

SQL Server greybeards will be stroking their facial hair thoughtfully at the familiarity of the process.

Conflicts are handled by either a Hub-Wins method (the Hub will overwrite data in the member) or vice versa with Member-Wins. In the latter scenario, with multiple members, the final value depends on which member syncs first.

The limitations are also wide and varying. Data types such as TimeStamp are not supported and encrypted columns could present a challenge. And you can forget all about maintaining transactional consistency (although Microsoft "guarantees that all changes are made eventually and that Data Sync does not cause data loss"). FileStream is also an absolute no-no.

Administrators also need to consider the impact on database performance of all those extra triggers as well as the potential cost of data flying in and out of Azure.

To be fair, Microsoft is clear that users should not use this technology for disaster recovery or scaling up Azure workloads, nor is it intended to replace the Azure Database Migration Service, to shift on-premises SQL to Redmond's cloud. The software maker sees it filling a niche for customers who want an up-to-date copy of the their data for reporting and analytics purposes.

Administrators reeling from this morning's outage will be taking a good hard look at how their solutions have been architected, and while the process may be a little archaic and limited, more support for distributed data will be very welcome indeed. ®


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
  • FTC signals crackdown on ed-tech harvesting kid's data
    Trade watchdog, and President, reminds that COPPA can ban ya

    The US Federal Trade Commission on Thursday said it intends to take action against educational technology companies that unlawfully collect data from children using online educational services.

    In a policy statement, the agency said, "Children should not have to needlessly hand over their data and forfeit their privacy in order to do their schoolwork or participate in remote learning, especially given the wide and increasing adoption of ed tech tools."

    The agency says it will scrutinize educational service providers to ensure that they are meeting their legal obligations under COPPA, the Children's Online Privacy Protection Act.

    Continue reading
  • Mysterious firm seeks to buy majority stake in Arm China
    Chinese joint venture's ousted CEO tries to hang on - who will get control?

    The saga surrounding Arm's joint venture in China just took another intriguing turn: a mysterious firm named Lotcap Group claims it has signed a letter of intent to buy a 51 percent stake in Arm China from existing investors in the country.

    In a Chinese-language press release posted Wednesday, Lotcap said it has formed a subsidiary, Lotcap Fund, to buy a majority stake in the joint venture. However, reporting by one newspaper suggested that the investment firm still needs the approval of one significant investor to gain 51 percent control of Arm China.

    The development comes a couple of weeks after Arm China said that its former CEO, Allen Wu, was refusing once again to step down from his position, despite the company's board voting in late April to replace Wu with two co-chief executives. SoftBank Group, which owns 49 percent of the Chinese venture, has been trying to unentangle Arm China from Wu as the Japanese tech investment giant plans for an initial public offering of the British parent company.

    Continue reading
  • SmartNICs power the cloud, are enterprise datacenters next?
    High pricing, lack of software make smartNICs a tough sell, despite offload potential

    SmartNICs have the potential to accelerate enterprise workloads, but don't expect to see them bring hyperscale-class efficiency to most datacenters anytime soon, ZK Research's Zeus Kerravala told The Register.

    SmartNICs are widely deployed in cloud and hyperscale datacenters as a means to offload input/output (I/O) intensive network, security, and storage operations from the CPU, freeing it up to run revenue generating tenant workloads. Some more advanced chips even offload the hypervisor to further separate the infrastructure management layer from the rest of the server.

    Despite relative success in the cloud and a flurry of innovation from the still-limited vendor SmartNIC ecosystem, including Mellanox (Nvidia), Intel, Marvell, and Xilinx (AMD), Kerravala argues that the use cases for enterprise datacenters are unlikely to resemble those of the major hyperscalers, at least in the near term.

    Continue reading

Biting the hand that feeds IT © 1998–2022