BestHub
Sign in
Tagged articles
18 articles
Page 1 of 1
Raymond Ops
Raymond Ops
Sep 28, 2025 · Operations

How to Replace Your System with OpenEuler and OpenGauss: A Step‑by‑Step Guide

This article walks you through the complete process of switching to a domestically‑produced Linux stack by downloading and installing the openEuler operating system, configuring its package sources, installing required tools, then adding the openGauss database, adjusting its configuration files, and verifying successful deployment, all on a VM or physical server.

Linux Installationdatabase setupfirewall disable
0 likes · 6 min read
How to Replace Your System with OpenEuler and OpenGauss: A Step‑by‑Step Guide
dbaplus Community
dbaplus Community
Oct 27, 2024 · Databases

Master Multi‑DB Backup: Oracle, MySQL, PostgreSQL & openGauss Shell Scripts

This guide provides step‑by‑step shell scripts, directory setups, cron jobs, and cleanup commands for reliable backup and restore of Oracle (RMAN and logical), MySQL (full, incremental, Percona XtraBackup), PostgreSQL (logical and physical with pg_rman), and openGauss databases, including retention policies and automation tips.

BackupDatabase AdministrationOracle
0 likes · 19 min read
Master Multi‑DB Backup: Oracle, MySQL, PostgreSQL & openGauss Shell Scripts
Xiaolei Talks DB
Xiaolei Talks DB
Aug 28, 2024 · Databases

What 15 Years of China’s DTCC Conferences Reveal About Database Evolution

The author reflects on a decade‑plus journey through China’s DTCC database conferences, describing personal growth from novice to speaker and organizer, sharing insights on Redis Cluster, distributed database selection, openGauss, time‑series databases, and the evolving themes that chart the industry's progress.

Career DevelopmentDistributed SystemsTime Series Database
0 likes · 6 min read
What 15 Years of China’s DTCC Conferences Reveal About Database Evolution
ITPUB
ITPUB
Aug 7, 2024 · Databases

Ready-to-Use Shell Scripts for Backing Up Oracle, MySQL, PostgreSQL & openGauss

This guide provides a comprehensive collection of ready-to-use shell scripts and step-by-step instructions for backing up and restoring major databases—including Oracle RMAN, logical and physical backups, MySQL full and incremental backups with Xtrabackup, PostgreSQL logical and physical backups, and openGauss dump scripts—plus scheduling and cleanup procedures.

Database BackupOraclePostgreSQL
0 likes · 19 min read
Ready-to-Use Shell Scripts for Backing Up Oracle, MySQL, PostgreSQL & openGauss
ITPUB
ITPUB
Jan 18, 2023 · Cloud Native

How China Postal Savings Bank Built a High‑Performance Cloud‑Native Core Banking System

China Postal Savings Bank’s three‑year, 3‑thousand‑person effort delivered a cloud‑native, distributed core banking platform that migrated 650 million customers with a 67,000 TPS peak, 65 ms transaction latency and dramatically improved processing times, showcasing the power of open‑source databases and micro‑service architecture.

core bankingdistributed architectureopenGauss
0 likes · 14 min read
How China Postal Savings Bank Built a High‑Performance Cloud‑Native Core Banking System
dbaplus Community
dbaplus Community
Nov 18, 2022 · Databases

Why openGauss Misses Index‑Only Scan and How USTORE Fixes It

The article examines why openGauss 2.0/3.0 cannot use Index‑Only Scan for covering indexes, explores the role of the visibility map and VACUUM, compares behavior with PostgreSQL 11, and shows how the USTORE storage engine can finally enable true covering indexes.

Index Only ScanUSTOREVacuum
0 likes · 11 min read
Why openGauss Misses Index‑Only Scan and How USTORE Fixes It
Top Architect
Top Architect
Aug 3, 2022 · Databases

Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages and Experimental Evaluation

This article explains the fundamental differences between row‑based and column‑based storage in relational databases, compares their performance for writes, reads, compression and use cases, presents an openGauss experiment with sample tables and SQL commands, and offers practical guidance on when to choose each storage model.

Column StoreDatabase StorageRow Store
0 likes · 10 min read
Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages and Experimental Evaluation
IT Architects Alliance
IT Architects Alliance
Jul 28, 2022 · Databases

Row vs. Column Store: When to Use Each and Why?

This article compares row‑based and column‑based storage models, analyzes their write and read performance, presents a practical openGauss experiment showing size and insert‑time differences, and offers concrete guidance on selecting the appropriate storage type for various workloads.

Column StoreDatabase StorageRow Store
0 likes · 10 min read
Row vs. Column Store: When to Use Each and Why?
Top Architect
Top Architect
Jul 26, 2022 · Databases

Row Store vs Column Store: Comparison, Advantages, and Experimental Evaluation in openGauss

This article explains the differences between row-based and column-based storage in databases, compares their advantages and disadvantages, presents experimental results using openGauss including space usage and insert performance, and offers practical guidance on selecting the appropriate storage model for various workloads.

Column StoreDatabase StorageRow Store
0 likes · 10 min read
Row Store vs Column Store: Comparison, Advantages, and Experimental Evaluation in openGauss
Architecture Digest
Architecture Digest
Jul 19, 2022 · Databases

Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages, and Experimental Evaluation

This article explains the fundamental differences between row‑based and column‑based storage in databases, compares their read/write performance, presents experimental results on openGauss showing space and speed trade‑offs, and offers practical guidance on when to choose each storage model.

Column StoreDatabase StorageRow Store
0 likes · 11 min read
Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages, and Experimental Evaluation
ITPUB
ITPUB
Oct 8, 2021 · Cloud Native

How China’s Postal Savings Bank Built a Distributed Core System with OpenGauss and Kunpeng

The article examines how Postal Savings Bank of China tackled legacy core banking limitations by designing a distributed, cloud‑native core system using openGauss, Kunpeng hardware, microservices, and DevOps, detailing the architecture, deployment process, performance gains, and industry implications.

Distributed SystemsKunpengcore banking
0 likes · 10 min read
How China’s Postal Savings Bank Built a Distributed Core System with OpenGauss and Kunpeng
dbaplus Community
dbaplus Community
Nov 25, 2020 · Databases

How OpenGauss Handles Oracle SQL Compatibility: Features, Limits, and Workarounds

This article examines how openGauss implements Oracle SQL compatibility, covering query syntax like ROWNUM and DUAL, unsupported CONNECT BY, HINT handling, execution‑plan commands, Oracle functions such as DECODE, SYSDATE, NVL/NVL2, PL/SQL UDFs, stored procedures, triggers, cursors, VARRAYs, and provides a detailed compatibility summary.

Oracle compatibilityPL/SQLSQL dialect
0 likes · 13 min read
How OpenGauss Handles Oracle SQL Compatibility: Features, Limits, and Workarounds
dbaplus Community
dbaplus Community
Nov 7, 2020 · Databases

How OpenGauss Handles Oracle Objects: Indexes, Constraints, Views, and More

This article evaluates the compatibility of Oracle logical objects—indexes, constraints, views, sequences, and synonyms—in openGauss, detailing each object type, providing concrete SQL examples, highlighting differences such as bitmap index support, and summarizing the overall compatibility in a concise table.

ConstraintsOracle compatibilitySequences
0 likes · 11 min read
How OpenGauss Handles Oracle Objects: Indexes, Constraints, Views, and More