Blog posts tagged "RDBMS"

Nov 6th, 2024:  Today Canonical announced the release of Charmed MySQL, an enterprise solution that helps you secure and automate the deployment, maintenance and upgrades of your MySQL databases across private and public clouds. MySQL is one of the world’s most popular databases. MySQL’s simple deployment model and ease of use make it the

Cybersecurity threats are increasing in volume, complexity and impact. Yet, organisations struggle to counter these growing threats. Cyber attacks often intend to steal, damage, hijack or alter value-generating data. In this article around database security, we use the NIST framework to lay out the common controls that you can implement t

In a previous blog, we talked about patterns to run a database in a highly available manner.  In this blog, we present our recipe for MySQL high availability. We will also explain how our solution interacts with K8s objects to provide some of its features. Why use MySQL MySQL is the most popular open-source database

In a previous blog, we talked about patterns to run a database in a highly available manner. In this blog, we present our open source recipe for PostgreSQL high availability. Benefits of a highly available PostgreSQL  A good recipe should always start by exposing the benefits of the concerned meal. Therefore, we will start this

Migrating your workloads to the cloud can bring some undeniable benefits to your organisation. For example, you can leverage cloud automation to significantly improve your time to market. You can also benefit from the ever increasing number of cloud regions to place your workloads close to your clients. This improves the response time of

There’s been a lot of talk in recent years about companies leaving the cloud. With the looming macroeconomic uncertainties that are affecting growth, companies are trying to control their costs by downsizing their staff and reducing their infrastructure costs.  One way to reduce infrastructure costs is repatriating workloads from public c

Since November 2021, Canonical and Microsoft have been offering a jointly supported Microsoft SQL Server on Ubuntu Pro solution. With this offering, you can set up an optimised configuration of SQL Server on Ubuntu in a few steps. As database professionals, we should ensure the highest possible standards for database security and availabi

You are not the only one asking this seemingly popular question! Several companies are torn between the rise in appeal of open-source databases and the undeniable challenges inherent to their adoption. Let’s explore the trends, the drivers and the challenges related to open-source database adoption. The popularity of open-source databases

The cost of database downtime A study from ManageForce estimated the cost of a database outage to be an average of $474,000 per hour. Long database outages are the result of poor design concerning high availability. With the exponential growth of data that is generated over the internet (which is expected to reach 180 zeta-bytes

IT leaders, engineers, and developers must consider multiple factors when using a database. There are scores of open source and proprietary databases available, and each offers distinct value to organisations. They can be divided into two primary categories: SQL (relational database) and NoSQL (non-relational database). This article will

Not going to lie, the Microsoft SQL Server is my all-time favourite Microsoft product. For a long time, SQL Server was only available for Windows, but not much is really sacred. So now Microsoft, in collaboration with Canonical, are distributing and supporting several flavours of SQL Server on Ubuntu Pro for Azure. I’m going to

1st November 2021: Today, Canonical announced support with Microsoft for Microsoft SQL Server with Ubuntu Pro on Microsoft Azure. Canonical has worked with Microsoft to bring a highly performant and fully supported solution for SQL Server to market, based around the Ubuntu Pro 20.04 LTS operating system. Customers on Microsoft Azure can l

For many people, fast broadband connection and unlimited data are a reality. For others, they are not. If you have several Linux hosts in your (home) environment, and you’re using snaps, each of these systems will separately communicate with the Snap Store and periodically download necessary updates. This can be costly in terms of inbound

The Ubuntu in the wild blog post ropes in the latest highlights about Ubuntu and Canonical around the world on a bi-weekly basis.

Everyone knows that if you’ve got big data, you need Apache Hadoop, right? It’s an affordable, horizontally scalable, clustered data processing platform ideal for data warehousing use cases. And it knocks the socks off classic relational database management systems like PostgreSQL that can barely keep up when playing with a terabyte of da

Assuring the security of PostgreSQL and all open source database systems is critical as many learned with the PgMiner botnet attacks in December 2020. Having an understanding of, and visibility into, how these attacks happen and following standard best practices is the best way to make sure that your data is not at risk. This