Maintenance of a Multi-Database Citus Cluster

This guide is designated for database administrators (DBA) who manages an on-premise cluster of PostgreSQL nodes with Citus, an extension for PostgreSQL for horizontal scalability and columnar storage. Every DBA at some point reaches a threshold when manual maintenance of a cluster becomes an arduous chore, and the necessity of some automated solution becomes more … Read more

Is NaaS the Evolution of CaaS?

Choosing a Namespace-as-a-Service strategy will incur cost and development time upfront; cluster-as-a-service defers operational complexity and cost until cluster count grows. However, as cluster counts grow in large organizations, perhaps Namespace-as-a-Service is an evolution of Cluster-as-a-Service. Kubernetes Cluster-As-A-Service (k8sCaaS) Each user or team is provided with a cluster that they manage and control. They don’t … Read more

How to Upgrade TiDB Safely

As a fast-growing open source NewSQL database, TiDB frequently releases new features and improvements. If you are a TiDB user, you may have found it hard to decide whether or not to upgrade your version. You may have also wondered how to make your upgrade journey safer, smoother, and even unnoticed by business. On the … Read more

CockroachDB, Deno: Combining Technologies – DZone Web Dev

This tutorial will walk through building a simple application using Deno, backed by CockroachDB (CRDB) Serverless. Deno (pronounced dee-no) is a “modern runtime environment for JavaScript and TypeScript”, while CockroachDB Serverless offers a free startup that scales with your app. Both technologies claim quick startup times for developers, so I’d like to test them out … Read more

Upgrading Kubernetes Clusters With Cluster API

In this post, I’ll cover an awesome feature of Cluster API: the ability to do a rolling upgrade of your Kubernetes cluster. Cluster API makes it simple, and repeatable. I’ll be totally honest, I’ve manually upgraded a Kubernetes cluster, it wasn’t the end of the world, but I’m a lazy hacker so why do it … Read more

sql server – Optimizing MySQL query with INNER JOINS, LEFT JOINS, GROUP BY and HAVING

I’m having trouble optimizing this really big query and I can’t change the table structure except creating additional indexes and small adjustments. SELECT ‘Fattura Prodotti Postali’ AS `type`, SUM(dpd.qta) AS `products_count_quantity`, COUNT(dpd.IDlavorazione_dett) AS `products_count`, dpd.IDlavorazione_dett AS `IDlavorazione_dett`, dp.prod_totali- CAST(dp.opzione1 AS UNSIGNED) AS `process_products_count`, dp.IDdistinta AS `product_code`, dp.data_distinta AS `process_date`, dp.IDesito AS `process_status_id`, dp.note AS `process_note`, … Read more

How to Bring Shadow Kubernetes IT Into the Light

Shadow IT continues to be a challenge for IT leaders, but perhaps not in the sense that companies have seen in the past. Traditionally, shadow IT occurs within the application stack, which creates problems because the use of IT systems occurs without the approval, or even knowledge, of the corporate IT department. DevOps practices have … Read more

From Relational to Really Relational: The RDB2RDF Working Group

While a lot of databases have been created listing information in a table format, the web isn’t set up in a tabular style. Neither is plenty of data in a variety of formats that the web uses. However, many databases are still using tables, because many web developers feel that tables handle plenty of data … Read more

The Open Source Way to Rightsize Kubernetes

[*] Rightsizing resource requests is an increasing challenge for teams using Kubernetes—and especially critical as they scale their environments. Overprovisioning CPU and memory lead to costly overspending, but underprovisioning risks CPU throttling and out-of-memory errors if requested resources aren’t sufficient. Dev and engineering teams that don’t thoroughly understand the live performance profile of their containers … Read more