Tagged articles
5 articles
Page 1 of 1
dbaplus Community
dbaplus Community
Jun 21, 2022 · Databases

Essential Tips for Optimizing Chinese Domestic Databases: What Oracle DBAs Should Know

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.

DBADatabase OptimizationDomestic Databases
0 likes · 7 min read
Essential Tips for Optimizing Chinese Domestic Databases: What Oracle DBAs Should Know
dbaplus Community
dbaplus Community
Oct 20, 2020 · Databases

15 Critical MySQL vs Oracle Migration Questions Every Bank Should Know

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.

Database ArchitectureOracle migrationdatabase sharding
0 likes · 17 min read
15 Critical MySQL vs Oracle Migration Questions Every Bank Should Know
Efficient Ops
Efficient Ops
Aug 29, 2020 · Databases

How Lujinso Migrated 90% of Its Oracle Databases to MySQL at Scale

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.

Financial ServicesOracle migrationautomation
0 likes · 7 min read
How Lujinso Migrated 90% of Its Oracle Databases to MySQL at Scale
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 3, 2020 · Databases

PostgreSQL Q&A: Use Cases, Oracle Comparison, Features, Migration and Best Practices

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.

DatabaseOracle migrationPerformance tuning
0 likes · 10 min read
PostgreSQL Q&A: Use Cases, Oracle Comparison, Features, Migration and Best Practices