Michael - DEV Community

Michael

Jul 21

Fixing "Can't get distribution attribute of table" in GBase 8a

#gbase #database #数据库

2 min read

Michael

Jul 21

GBase 8a Load Performance Degradation: Root Causes and Diagnostic Steps

#gbase #database #数据库 #performance

3 min read

Michael

Jul 21

Using LAST_VALUE in GBase 8a for OLAP Analysis

#gbase #database #数据库 #olap

2 min read

Michael

Jul 21

Using FIRST_VALUE in GBase 8a for OLAP Analysis

#gbase #database #数据库 #olap

2 min read

Michael

Jul 17

GBase 8a OLAP: Data Bucketing with NTILE

#gbase #database #数据库

2 min read

Michael

Jul 17

GBase 8a OLAP: Using NTH_VALUE to Fetch the N‑th Row in a Window

#gbase #database #数据库

2 min read

Michael

Jul 17

GBase 8a Cluster Expansion Requires All Nodes Online

#gbase #database #数据库 #operations

1 min read

Michael

Jul 17

GBase 8a Parameter: _gcluster_optimizer_push_condition

#gbase #database #数据库 #performance

2 min read

Michael

Jul 14

Upgrading GBase 8a from V86 to V953: A Step‑by‑Step Migration Record

#gbase #database #数据库

2 min read

Michael

Jul 14

Running Multiple Commands with sudo (Including source) in Linux

#gbase #database #数据库 #linux

2 min read

Michael

Jul 14

Configuring Kerberos Authentication for Hadoop in the GCDW Stack

#gbase #database #数据库 #kerberos

3 min read

Michael

Jul 14

Configuring HDFS as Storage for GCDW Physical Deployment

#gbase #database #数据库 #hdfs

2 min read

Michael

Jul 13

Repairing a Harbor-db Container PostgreSQL After Power Failure in a GBase 8a Stack

#gbase #database #数据库 #docker

3 min read

Michael

Jul 13

How to Block User Access on a Specific GBase 8a Coordinator Node

#gbase #database #数据库 #security

3 min read

Michael

Jul 13

Using SELECT INTO with Dynamic SQL in GBase 8a: Why Local Variables Fail

#gbase #database #数据库

2 min read

Michael

Jul 13

Reducing GBase 8a gcware Log Volume to Save Disk I/O

#gbase #database #数据库 #performance

2 min read

Michael

Jul 12

Optimizing OR Conditions in GBase 8a: Filter and Join Rewrites

#gbase #database #数据库 #performance

3 min read

Michael

Jul 12

GBase 8a unnest Function: The Reverse of group_concat

#gbase #database #数据库

1 min read

Michael

Jul 12

Avoid Incomplete SFTP/FTP Exports in GBase 8a with a Python UDF Rename Trick

#gbase #database #数据库

2 min read

Michael

Jul 12

Loading Kerberos‑Authenticated HDFS Files in GBase 8a

#gbase #database #数据库 #hdfs

2 min read

Michael

Jul 11

GBase 8a Percentile Functions: percentile_cont and percentile_disc

#gbase #database #数据库

2 min read

Michael

Jul 11

Query GBase 8a Cluster Locks and Failover Info via Python UDFs

#gbase #database #数据库 #operations

1 min read

Michael

Jul 11

How to Identify the gcware Leader Node in GBase 8a

#gbase #database #数据库

2 min read

Michael

Jul 11

When a "Zombie" Process Killed GBase 8a Performance: A Story of Misguided Resource Utilization Rules

#gbase #database #数据库 #performance

2 min read

Michael

Jul 10

Field Types Supported for Hash Distribution Keys in GBase 8a

#gbase #database #数据库 #performance

2 min read

Michael

Jul 10

Does a Running Socket Automatically Listen on a Newly Added IP? It Depends.

#gbase #database #数据库 #network

2 min read

Michael

Jul 10

GBase 8a 9.5.3 New Feature: Event‑Based Data Node Replacement (eventMode)

#gbase #database #数据库 #operations

2 min read

Michael

Jul 10

Handling Newlines and Double Quotes When Exporting CSV from GBase 8a

#gbase #database #数据库 #csv

2 min read

Michael

Jul 9

Emergency Recovery: Reversing an Accidental "unavailable" Node in GBase 8a

#gbase #database #数据库 #operations

2

2 min read

Michael

Jul 9

Installing GBase 8a Cluster with a Non‑Default SSH Port

#gbase #database #数据库 #operations

2

2 min read

Michael

Jul 9

Why GBase 8a Installs and Upgrades Take So Long on a Laptop VM — and the Fix

#gbase #database #数据库 #performance

2

2 min read

Michael

Jul 9

Loading Data with Different Date Formats in GBase 8a — Per‑Column Control

#gbase #database #数据库 #performance

2

2 min read

Michael

Jul 8

How a Misconfigured NIC RX/TX Buffer Caused Intermittent Slowdowns in a GBase 8a Cluster

#gbase #database #数据库 #performance

2

2 min read

Michael

Jul 8

Managing GBase 8a Sync Recovery with gcadmin recover: VC Prioritization and Pause/Resume

#gbase #database #数据库

2

2 min read

Michael

Jul 8

Replacing ntpdate with chronyc on Anolis OS for GBase 8a Cluster Time Sync

#gbase #database #数据库 #operations

2

3 min read

Michael

Jul 8

GBase Visio Rsynctool (GVR) Quick Deployment and Configuration

#gbase #database #数据库 #operations

2

2 min read

Michael

Jul 7

How to Update GDOM Database Credentials: Changing Users, Passwords, and IPs

#gbase #database #数据库 #security

2

2 min read

Michael

Jul 7

Installing GDOM with PostgreSQL as the Backend Database

#gbase #database #数据库 #postgres

2

3 min read

Michael

Jul 7

Pure Shell Script to Compress IPv6 Addresses

#gbase #database #operations #数据库

2

4 min read

Michael

Jul 7

Pure Shell Script to Expand IPv6 Addresses

#gbase #database #operations #数据库

2

3 min read

Michael

Jul 6

Who Decides the SSH Cipher? Why the Client's Preference Matters

#gbase #database #数据库 #performance

2

2 min read

Michael

Jul 5

Quick Diagnostic Commands for GBase 8a Cluster Glitches

#gbase #database #数据库 #performance

2

2 min read

Michael

Jul 5

Demystifying SSH with -vvv: How GBase 8a's Underlying Connection Negotiates Encryption

#gbase #database #数据库 #security

2

3 min read

Michael

Jul 5

Database Industry Trends and Technical Observations

#ai #gbase #database #数据库

2

1 min read

Michael

Jul 5

GBase 8s Kernel Evolution: Expressing User Understanding Through Product

#gbase #database #数据库

2

1 min read

Michael

Jul 5

GBase 8a: A Decade of Iteration, Empowering Digital Business

#gbase #database #数据库

2

2 min read

Michael

Jul 5

How GBase 8a Handles Masked Columns in WHERE, GROUP BY, and Projections

#gbase #database #数据库 #sql

2

2 min read

Michael

Jul 5

GBase 8a Performance Anomaly Case Study: How a Single Parameter Change Sparked a Chain Reaction

#gbase #database #数据库

2

4 min read

Michael

Jun 30

High-Performance SFTP Loading in GBase 8a: New Parameter Configuration

#gbase #database #数据库 #security

2

2 min read

Michael

Jun 30

Scaling the GBase 8a gcware Management Cluster: Adding and Removing Nodes

#gbase #database #数据库 #operations

2

2 min read

Michael

Jun 23

GBase 8a Cluster Installation in Practice: From Environment Setup to Health Checks

#gbase #database #数据库 #operations

2

3 min read

Michael

Jun 23

GBase 8a Performance Troubleshooting and Stability Governance: From Slow Queries to Primary-Replica Consistency

#gbase #database #数据库 #operations

2

3 min read

Michael

Jun 23

Making GBase 8a Backup and Recovery Reliable: Full Backups, Incrementals, and Recovery Drills

#gbase #database #数据库 #operations

2

3 min read

Michael

Jun 23

GBase 8a Operations Inspection and Alerting: Don't Wait for a Failure to Check the Logs

#gbase #database #数据库 #monitoring

2

3 min read

Michael

Jun 21

GBase 8a Table Design and Modeling: Choosing Data Types, Partitions, Distribution Keys, and Replicated Tables

#gbase #database #数据库 #performance

2

3 min read

Michael

Jun 21

Deep Dive into GBase 8a MPP Distributed Query Execution

#gbase #database #数据库 #performance

2

3 min read

Michael

Jun 21

GBase 8a Table Design in Practice: Choosing Distribution Keys, Partitions, and Replicated Tables

#gbase #database #数据库 #performance

2

4 min read

Michael

Jun 21

Permission Governance in GBase 8c: Separate Role Boundaries First, Then Assign Privileges

#gbase #database #数据库 #security

2

3 min read

Michael

Jun 20

Data Lifecycle Management in GBase 8c: Partitioning, Archiving, and Cleanup

#gbase #database #数据库 #operations

2

4 min read

Michael

Jun 20

Making GBase 8c Auditing Work: Traceable, Retainable, and Queryable

#gbase #database #数据库 #security

2

3 min read

Writing Debut