Blog posts tagged
"RDBMS"

Mohamed Wadie Nsiri
18 August 2023

How to secure your database

Data Platform Article

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 ...

Mohamed Wadie Nsiri
18 July 2023

MySQL high availability made charmingly easy

Charms Article

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 ...

Mohamed Wadie Nsiri
18 April 2023

PostgreSQL high availability made charmingly easy

Data Platform Article

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 ...

Mohamed Wadie Nsiri
16 February 2023

Common misconceptions behind cloud migration failures

Cloud and server Article

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 ...

Mohamed Wadie Nsiri
10 February 2023

Why are companies leaving the cloud? Exploring the main reasons for cloud repatriation

Cloud and server Article

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 ...

Mohamed Wadie Nsiri
28 September 2022

The benefits of running Microsoft SQL Server on Ubuntu Pro

Data Platform Article

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 ...

Mohamed Wadie Nsiri
14 September 2022

Should you use open-source databases?

Charms Article

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 ...

Mohamed Wadie Nsiri
2 August 2022

Patterns to achieve database High Availability

Cloud and server Article

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 ...

Michelle Anne Tabirao
10 June 2022

SQL vs NoSQL: Choosing your database

Data Platform Article

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 ...

robgibbon
10 November 2021

SQL Server on Ubuntu Pro: bringing it all back home

Cloud and server Article

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 ...

Canonical
1 November 2021

Ubuntu Pro-based Microsoft SQL Server Instances available for Azure

Ubuntu Article

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 ...

Igor Ljubuncic
14 July 2021

How to cache snap downloads and save bandwidth

Cloud and server Article

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 ...

Blog posts tagged "RDBMS"

Blog posts tagged
"RDBMS"