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
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
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
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
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
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
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
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
[*] 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
My data is organized by PVC value. Most of them have 1, 2, or 3 rows assigned per PVC value. But, sometimes the volume values aren’t all included. For instance, a PVC value might have 3 rows, but only 1 of them actually has a volume whereas the other two are NA. If a certain … Read more