This article outlines practical guidance for DBAs transitioning to Chinese domestic databases, highlighting why standard Oracle benchmark tweaks often fail, the limited relevance of buffer‑hit ratios, the importance of SQL execution efficiency, and specific strategies for handling high‑concurrency workloads.
This article compiles the most frequently asked MySQL‑related questions from developers and operations teams in banks, covering why MySQL is chosen over Oracle, compatibility gaps, migration methods, sharding strategies, performance tuning, consistency guarantees, and resource planning.
Facing high licensing costs and poor scalability, Lujinso embarked on an 18‑month, self‑driven project to replace 90% of its Oracle databases—spanning billions of rows across financial services—with MySQL, supplemented by Elasticsearch, Redis, TiDB and HBase, using an automated migration platform.
This article compiles a series of questions and answers from a recent PostgreSQL live session, covering recommended scenarios, differences with Oracle, backup and recovery, clustering, PostGIS, stored procedures, migration tips, version recommendations, performance tuning, high‑availability, and real‑world adoption across industries.
This article walks through the entire Oracle‑to‑GaussDB migration process with Huawei DataSync, covering environment setup, tool constraints, NFS mounting, JDBC driver preparation, configuration file editing, password encryption, export and import execution, and post‑migration validation.
