Ubuntu Pro supports a new version of Microsoft’s database system SQL Server. Canonical, developer of the Linux distribution, and Microsoft have announced this. Customers of the cloud-based Ubuntu Pro on Azure can now use customized versions of the database management systems SQL Server 2017 and SQL Server 2019. The new SQL version is the result of the deeper cooperation between the two companies.
Ubuntu Pro 18.04 LTS and Ubuntu Pro 20.04 LTS users can a blog post from Canonical Leverage versions of both the Web, Standard, and Enterprise editions of SQL Server. Unsurprisingly, the new version is called SQL Server on Ubuntu Pro. It uses the XFS file system including the direct writing methods Direct I / O and Forced Unit Access (FUA). If available, the Ubuntu Pro version also benefits from the advantages of persistent memory (PMEM). Under Ubuntu Pro 20.04 LTS, SQL Server also relies on Corosync and Pacemaker with a special fencing agent for Azure if high availability is required.
Long-term cooperation sought
Ubuntu Pro is the professional version of the Ubuntu Linux distribution. Canonical aims to operate in the cloud systems AWS, Microsoft Azure and, more recently, the Google Cloud. The publisher promises its customers updates for up to ten years; according to the press release, SQL Server on Ubuntu Pro comes from both Canonical and Microsoft. Both companies had announced that they wanted to cooperate more intensively. Canonical’s Alex Gallagher called the new version a “logical extension [von Canonicals] continued collaboration with Microsoft “.