DEV Community

mmllllzcn profile picture

mmllllzcn

404 bio not found

Joined Joined on 
Rollback Plan Template: Make Database Cutover Safe

Rollback Plan Template: Make Database Cutover Safe

2
Comments 1
1 min read

Want to connect with mmllllzcn?

Create an account to connect with mmllllzcn. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
SQL Compatibility Scoring Card for Database Migration

SQL Compatibility Scoring Card for Database Migration

2
Comments 1
1 min read
MySQL to GBase Database: A Practical Dual-Write Migration Guide

MySQL to GBase Database: A Practical Dual-Write Migration Guide

2
Comments 1
1 min read
GBase Database Elastic Scale-Out: Why Adding a Node Isn't Simple

GBase Database Elastic Scale-Out: Why Adding a Node Isn't Simple

2
Comments 1
1 min read
Multi-Tenant Isolation: How GBase Database(GBase 8c) Controls Noisy Neighbors

Multi-Tenant Isolation: How GBase Database(GBase 8c) Controls Noisy Neighbors

2
Comments
2 min read
Vector Search Inside the Database: A Simpler RAG Architecture with GBase Database

Vector Search Inside the Database: A Simpler RAG Architecture with GBase Database

2
Comments
2 min read
1:30 Columnar Compression: How GBase Database(GBase 8a MPP Cluster) Reduces Storage

1:30 Columnar Compression: How GBase Database(GBase 8a MPP Cluster) Reduces Storage

2
Comments
2 min read
HTAP Explained: How GBase Database Brings Transactions and Analytics Together

HTAP Explained: How GBase Database Brings Transactions and Analytics Together

2
Comments
2 min read
Flash Sales Without Overselling: How GBase Database (GBase 8c) Protects Inventory

Flash Sales Without Overselling: How GBase Database (GBase 8c) Protects Inventory

2
Comments
2 min read
Distributed Transactions 101: How GBase Database (GBase 8c) Handles 2PC

Distributed Transactions 101: How GBase Database (GBase 8c) Handles 2PC

2
Comments
2 min read
PostgreSQL to GBase Database (GBase 8c): A Practical Adaptation Checklist

PostgreSQL to GBase Database (GBase 8c): A Practical Adaptation Checklist

2
Comments
2 min read
Triple-Mode Compatibility: How GBase Database (GBase 8c) Supports Oracle, PostgreSQL, and MySQL

Triple-Mode Compatibility: How GBase Database (GBase 8c) Supports Oracle, PostgreSQL, and MySQL

2
Comments
2 min read
Stored Procedure Migration: Turn a Black Box into a Measurable Checklist

Stored Procedure Migration: Turn a Black Box into a Measurable Checklist

2
Comments
2 min read
SM Crypto Performance: How to Benchmark the Cost of Transparent Encryption

SM Crypto Performance: How to Benchmark the Cost of Transparent Encryption

2
Comments
2 min read
Two Sites, Three Data Centers: A Practical DR Architecture with GBase Database

Two Sites, Three Data Centers: A Practical DR Architecture with GBase Database

2
Comments
2 min read
How RPO=0 Works: Shared-Storage High Availability in GBase Database

How RPO=0 Works: Shared-Storage High Availability in GBase Database

2
Comments
2 min read
10 SQL Smoke Tests to Run Before an Oracle Migration to GBase Database

10 SQL Smoke Tests to Run Before an Oracle Migration to GBase Database

2
Comments
3 min read
GBase Database MTK: A Practical SQL Compatibility Check for Oracle Migration

GBase Database MTK: A Practical SQL Compatibility Check for Oracle Migration

2
Comments
2 min read
Oracle Compatibility 95%: Where the Remaining 5% Matters

Oracle Compatibility 95%: Where the Remaining 5% Matters

2
Comments
2 min read
GCI vs. SQL Compatibility: Understanding GBase Database Oracle Migration

GCI vs. SQL Compatibility: Understanding GBase Database Oracle Migration

2
Comments
2 min read
Database High Availability FAQ: RPO, RTO, Failover, and Backup

Database High Availability FAQ: RPO, RTO, Failover, and Backup

2
Comments
3 min read
Database FAQ for Beginners: Transactions, Indexes, and Performance

Database FAQ for Beginners: Transactions, Indexes, and Performance

2
Comments
3 min read
OLTP vs. OLAP vs. HTAP: How to Choose the Right GBase Database Workload

OLTP vs. OLAP vs. HTAP: How to Choose the Right GBase Database Workload

2
Comments
3 min read
Centralized vs. Distributed: Which Fits High-Concurrency Transaction Workloads?

Centralized vs. Distributed: Which Fits High-Concurrency Transaction Workloads?

2
Comments
3 min read
A Backup That's Never Been Restored Is No Backup: A Practical Restore-Drill Checklist

A Backup That's Never Been Restored Is No Backup: A Practical Restore-Drill Checklist

2
Comments
3 min read
Query Mysteriously Slow? Refresh Statistics Before You Blame the SQL

Query Mysteriously Slow? Refresh Statistics Before You Blame the SQL

2
Comments
5 min read
Debugging a Stuck Bulk Update: Transactions, Locks, and Indexes

Debugging a Stuck Bulk Update: Transactions, Locks, and Indexes

2
Comments
2 min read
TIL: Online Index Creation — Keeping Production Running

TIL: Online Index Creation — Keeping Production Running

2
Comments
1 min read
TIL: Lock Waiting and Deadlocks Are Not the Same Problem

TIL: Lock Waiting and Deadlocks Are Not the Same Problem

2
Comments
1 min read
TIL: How MVCC Lets Reads and Writes Run Concurrently

TIL: How MVCC Lets Reads and Writes Run Concurrently

2
Comments
3 min read
TIL: Stale Statistics Can Make the Optimizer Pick the Wrong Plan

TIL: Stale Statistics Can Make the Optimizer Pick the Wrong Plan

2
Comments
2 min read
Troubleshooting Slow Queries With Execution Plans: A Chain That Starts With EXPLAIN

Troubleshooting Slow Queries With Execution Plans: A Chain That Starts With EXPLAIN

2
Comments
4 min read
Index Design for Beginners: Read Your Query Patterns Before Creating Indexes

Index Design for Beginners: Read Your Query Patterns Before Creating Indexes

2
Comments
4 min read
SQL Transactions for Beginners: ACID Explained With a Bank Transfer

SQL Transactions for Beginners: ACID Explained With a Bank Transfer

2
Comments
3 min read
Database Fundamentals: 6 Things Every Developer Should Understand

Database Fundamentals: 6 Things Every Developer Should Understand

2
Comments
4 min read
Fixing Slow Query Performance in GBase Database: A Practical DBA Checklist

Fixing Slow Query Performance in GBase Database: A Practical DBA Checklist

2
Comments
4 min read
Troubleshooting Common GBase Database Connection Issues

Troubleshooting Common GBase Database Connection Issues

2
Comments
3 min read
Common GBase Database Migration Issues and How to Fix Them

Common GBase Database Migration Issues and How to Fix Them

2
Comments
4 min read
GBase Database(GBase 8c) vs Traditional Database Architecture: Distributed Multi-Model at Scale

GBase Database(GBase 8c) vs Traditional Database Architecture: Distributed Multi-Model at Scale

2
Comments
5 min read
Real-World Migration Performance: GBase Database Case Studies in Numbers

Real-World Migration Performance: GBase Database Case Studies in Numbers

2
Comments
5 min read
Shared Storage vs Shared-Nothing: How GBase Database Uses Two Architectures

Shared Storage vs Shared-Nothing: How GBase Database Uses Two Architectures

2
Comments
5 min read
OLTP vs OLAP vs HTAP: How to Choose the Right GBase Database Product

OLTP vs OLAP vs HTAP: How to Choose the Right GBase Database Product

2
Comments
5 min read
Performance Tuning GBase Database: A Practical Guide with Real SQL Queries

Performance Tuning GBase Database: A Practical Guide with Real SQL Queries

2
Comments
5 min read
TIL: Columnar Compression in GBase Database(GBase 8a) Can Reach a 1:20 to 1:30 Ratio

TIL: Columnar Compression in GBase Database(GBase 8a) Can Reach a 1:20 to 1:30 Ratio

2
Comments
4 min read
TIL: GBase Database Has Been Running Production Systems for More Than 20 Years

TIL: GBase Database Has Been Running Production Systems for More Than 20 Years

2
Comments
3 min read
TIL: How to Read a Database Compatibility Matrix Like a Pro

TIL: How to Read a Database Compatibility Matrix Like a Pro

2
Comments
4 min read
TIL: GBase Database(GBase 8a) Can Load 30TB of Data Per Hour

TIL: GBase Database(GBase 8a) Can Load 30TB of Data Per Hour

2
Comments
3 min read
TIL: HTAP Is Not a Replacement for OLTP or OLAP — It's the Middle Ground

TIL: HTAP Is Not a Replacement for OLTP or OLAP — It's the Middle Ground

2
Comments
3 min read
TIL: What Does 95% Oracle Syntax Compatibility Really Mean for GBase Database?

TIL: What Does 95% Oracle Syntax Compatibility Really Mean for GBase Database?

2
Comments
3 min read
TIL: How One SQL Query Can Help You Choose the Right GBase Database

TIL: How One SQL Query Can Help You Choose the Right GBase Database

2
Comments
2 min read
TIL: GBase Database Is Not One Product — It's Three

TIL: GBase Database Is Not One Product — It's Three

2
Comments
2 min read
Understanding SSC in GBase Database: Shared Storage Clustering Explained

Understanding SSC in GBase Database: Shared Storage Clustering Explained

2
Comments
2 min read
How to Classify Your Database Workload: A Practical Guide with GBase Database

How to Classify Your Database Workload: A Practical Guide with GBase Database

2
Comments
4 min read
How to Migrate from Oracle to GBase Database: A Practical Migration Methodology

How to Migrate from Oracle to GBase Database: A Practical Migration Methodology

2
Comments
4 min read
Getting Started with GBase Database: Install GBase Database(GBase 8s) and Run Your First SQL Query

Getting Started with GBase Database: Install GBase Database(GBase 8s) and Run Your First SQL Query

2
Comments
7 min read
8 Questions to Ask Yourself Before Choosing a Database

8 Questions to Ask Yourself Before Choosing a Database

2
Comments
5 min read
How to Pick a GBase Database? 9 Frequently Asked Questions

How to Pick a GBase Database? 9 Frequently Asked Questions

2
Comments
6 min read
OLTP vs OLAP vs HTAP: A Three-Quadrant Comparison + A Practical Workload Self-Test

OLTP vs OLAP vs HTAP: A Three-Quadrant Comparison + A Practical Workload Self-Test

2
Comments
6 min read
Centralized vs. Distributed Database Architecture: Why GBase Database Does Both

Centralized vs. Distributed Database Architecture: Why GBase Database Does Both

2
Comments
4 min read
Skipping Workload Classification Before GBase Database Migration: 3 Real Costs

Skipping Workload Classification Before GBase Database Migration: 3 Real Costs

2
Comments
4 min read
loading...