Facing growing log volumes and high Elasticsearch costs, Ctrip migrated its 200 TB daily logs to ClickHouse, achieving up to 38× faster queries, 60 % lower server resources, and simplified operations through columnar storage, sharding, and custom dashboards, while detailing deployment, tuning, and common pitfalls.
This article evaluates whether openGauss can serve as an Oracle replacement in OLTP scenarios by systematically testing compatibility of Oracle's character, numeric, date/time, large object, ROWID, and RAW data types, presenting command‑line results and practical substitution recommendations.
This article provides a comprehensive guide to the pt-online-schema-change (pt-osc) tool for MySQL online DDL, covering its underlying mechanism, limitations, installation steps, command‑line syntax, practical examples, and a comparative analysis with native Online DDL and gh‑ost to help users choose the appropriate solution.
This article analyzes a real‑world incident where using INSERT INTO SELECT to migrate large order data caused full‑table scans and locking in MySQL, explains the underlying lock behavior, and presents a solution that adds an index and forces its use to avoid the problem.
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.
The article presents a series of interviews from Qunar's Technology Carnival, featuring experts Liang Zhangping, Wang Zhufeng, and Zheng Jimin who discuss hotel booking flow improvements, database architecture comparisons and migration to PXC, and comprehensive system stability governance practices.
A telecom client migrated from IBM AIX/Oracle 11g to a domestic X86 appliance with Oracle 19c, encountering slow TimesTen Cache Group rebuilds, and the article details the root‑cause analysis and step‑by‑step optimization that cut rebuild time to one‑third.
This article details a real‑world migration from Oracle 11g on IBM AIX to Oracle 19c, focusing on exporting a 2 TB LOB‑heavy table by adjusting undo retention, then using ROWID‑based modulo queries with Data Pump to achieve balanced, error‑free parallel exports.
This article explains the background of Oracle 19c hot clone, lists the prerequisites, details the three‑phase cloning process, provides exhaustive local, remote, subset and refreshable PDB scenarios with exact SQL commands, highlights common errors and their solutions, and concludes with best‑practice recommendations.
This article explains how to upgrade the think-mongo module for ThinkJS to work with MongoDB 4.x, detailing API changes, new CRUD method mappings, transaction support, and provides code examples for adapting existing projects to the latest MongoDB features.
This guide explains why Tencent Cloud’s Basic Network must be replaced by VPC for security isolation and details migration methods—including interconnection, CVM conversion, IP changes, image rebuilding, database VPC conversion, DTS, and load‑balancer adjustments—illustrated by a case study moving 600+ CVMs across 80 projects.
This case study details the migration of Weimeng's MySQL databases to Tencent Cloud CDB, describing the testing methodology, performance bottlenecks discovered (NUMA, network parameters, low‑concurrency issues, and version bugs), the step‑by‑step optimizations applied, and the resulting QPS improvements across various workloads.
An engineer’s mishap with a massive ‘INSERT INTO … SELECT’ migration exposed how full‑table scans lock MySQL tables, causing payment failures, and shows that adding an index on the filter column prevents the lock and ensures safe, efficient data transfer.
This report details the background, testing methodology, encountered issues, optimization steps, migration process, and final performance outcomes of moving Weimeng's MySQL databases to Tencent Cloud CDB, providing a comprehensive case study for database engineers and cloud architects.
This article details the DRS team's step‑by‑step investigation and optimization of a massive MySQL migration involving 860,000 tables, addressing timeout, OOM, and performance bottlenecks to reduce total migration time from over 19 hours to under 10 hours.
An engineer’s attempt to migrate millions of orders using INSERT INTO SELECT caused massive table locking, payment failures, and system alerts, but by analyzing the locking behavior and adding an index on the timestamp column, the migration succeeded efficiently, illustrating the importance of proper indexing for large‑scale data moves.
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.
This article introduces Flyway as a database migration tool, explains its working principle, directory and naming conventions, supported databases, and provides detailed step‑by‑step instructions, best‑practice guidelines, and troubleshooting tips for safely managing MySQL schema changes in production environments.
This article explains how to identify and remove various kinds of duplicate data in MySQL—including fully duplicated rows, records with duplicate non‑key columns, and unwanted whitespace inside fields—by using SQL statements, table cloning, OS utilities, and regular‑expression updates, with performance measurements for each method.
This article details Ctrip's migration of large‑scale log processing from Elasticsearch to ClickHouse, explaining why ClickHouse was chosen, the high‑availability deployment architecture, data ingestion strategies, dashboard integration, performance gains, operational practices, and overall cost and reliability improvements.
The article recounts Olery’s five‑year evolution from a Ruby‑centric stack using MongoDB and MySQL to a PostgreSQL‑based architecture, detailing schema‑less pitfalls, database requirements, migration strategies, code adaptations, and the measurable performance gains achieved after the transition.
The article explains various database migration approaches—including code‑first, data‑first, big‑bang releases, expand‑contract migrations, and double‑writing with dark reads—highlighting how feature toggles influence compatibility and safety during production system changes.
Meitu migrated its high‑traffic push‑service storage from fragmented Redis nodes to the TiKV‑based Titan system, using a dual‑write rollout, batch‑operation tuning, and TiKV configuration tweaks, achieving required QPS, cutting costs by about 60%, and delivering stable, maintainable service after six months.
This article explains a Flyway permission error that occurs when deploying a Spring Boot application, analyzes its cause, and provides two practical solutions: granting the necessary MySQL privileges or downgrading to a compatible Flyway version.
This article details the AutoHome community's migration from a monolithic SQL Server database to the distributed TiDB platform, covering the performance bottlenecks that prompted the change, the evaluation of candidate databases, extensive OLTP/OLAP testing, the full‑ and incremental‑sync migration strategy, rollback mechanisms, and the resulting operational improvements.
This guide provides a comprehensive overview of Oracle Data Pump utilities, detailing how to create directories, use expdp and impdp commands for exporting and importing schemas, tables, and full databases, explaining key parameters, interactive mode, and common error resolutions.
This article chronicles how Alipay’s engineering teams tackled massive traffic spikes during Double 11 from 2009 to 2019, evolving their backend architecture, performance‑testing practices, database strategy, and cloud‑native infrastructure to achieve seamless, high‑throughput payment processing.
This article details more than fifty practical issues encountered when migrating financial applications from Oracle to PostgreSQL—including character sets, comment syntax, numeric precision, VARCHAR handling, sequence limits, type casting, operator overloading, and connectivity—while offering concrete solutions, code examples, and performance tips.
Facing rising costs and regulatory pressure, Xintai Life Insurance embarked on a multi‑year "de‑Oracle" journey, selecting PostgreSQL, executing extensive testing, adopting a phased rollout with fallback plans, and building new monitoring, offering practical insights for enterprises migrating away from legacy Oracle databases.
This article details the challenges and solutions encountered when migrating Fengchao's high‑throughput payment platform—handling over a hundred‑billion rows and millions of QPS—from a sharded MySQL architecture to TiDB, covering performance bottlenecks, TiDB advantages, migration steps, tooling, pitfalls, and optimization recommendations.
This weekly DBLE community roundup covers Amazon's migration away from Oracle databases, Percona's 2019 open‑source data management survey, the MySQL 8.0.18 GA release, and detailed DBLE and DTLE middleware updates including new features, bug fixes, and upcoming plans.
This article explains how Alibaba Cloud's BDS migration service enables continuous, high‑performance migration of HBase clusters—including schema, full data, and incremental sync—across version upgrades, hardware changes, network migrations, and cross‑region scenarios, while ensuring stability and minimal impact on live workloads.
This article demonstrates how to use MySQL's stacked diagnostics and a custom stored procedure to automatically capture and log errors from bulk INSERT statements during Oracle‑to‑MySQL migration, enabling quick identification and correction of problematic rows without manual inspection.
This article details Industrial and Commercial Bank of China's multi‑year journey from a monolithic mainframe‑based DB2 system to a high‑availability, container‑enabled MySQL distributed architecture, covering the challenges, strategic choices, technical stack, implementation phases, performance gains, cost reductions and future directions.
Tencent’s internal migration from isolated private data centers to a unified public‑cloud environment—driven by the need to eliminate siloed “chimney” architectures, boost development speed, engineer experience, and customer value—was executed in three staged phases using refactor‑or‑migrate strategies, comprehensive testing, security integration, database‑migration patterns, hybrid‑cloud management, and cloud‑native DevOps practices, yielding a scalable, cost‑effective platform.
This guide walks through preparing test data, migrating a SonarQube database from MySQL to PostgreSQL, running the MySQL‑Migrator tool, restarting services, verifying the migration, and finally upgrading SonarQube from 6.7.7 to the 7.9.1 LTS release with JDK 11.
The article reviews Alibaba's architectural evolution from early PHP and JavaBean systems through EJB, Spring, and service‑oriented transformations using EDAS, DRDS, and ONS, highlighting challenges such as maintenance, data silos, database limits, and the resulting enterprise‑grade cloud‑native solutions.
This article, based on a 2019 Ant Financial technology summit talk, details Net Business Bank’s adoption of the financial‑grade distributed database OceanBase, covering its logical and physical architectures, migration services, high‑availability designs, elastic data sources, and future outlook for distributed database innovation in banking.
This article details the Industrial and Commercial Bank of China's multi‑year migration from mainframe‑based DB2 to a high‑availability, distributed MySQL solution, covering the challenges, strategic decisions, technical stack, containerization, operational improvements, and measurable business outcomes.
This article details the Industrial and Commercial Bank of China's migration from traditional OLTP mainframe databases to a large‑scale, high‑availability MySQL distributed architecture, covering challenges, strategic goals, technology selection, implementation phases, performance improvements, and future directions.
Banking IT TransformationContainerizationDatabase Migration
This article provides a step‑by‑step tutorial for migrating MySQL databases—whether hosted on Amazon RDS or self‑managed servers—to Amazon Aurora, covering four scenarios from simple snapshot migration with downtime to complex minimal‑downtime approaches using read replicas, Percona XtraBackup, and AWS DMS.
Xianyu migrated its tens‑billion‑row product database from a shared MySQL cluster to an isolated instance by refactoring with dual‑write, employing TDDL for sharding and sequence management, and using Alibaba Cloud DTS for full‑load, incremental sync, consistency verification, and a no‑data‑loss rollback, achieving seamless, user‑transparent migration and improved stability.
The article examines whether Oracle will be completely supplanted by MySQL, comparing industry adoption, DBA role differences, performance versus scalability, cost considerations, and cultural factors that influence database choices in traditional and internet sectors.
The article outlines Ant Financial's three‑generation database architecture evolution, the challenges of upgrading legacy commercial databases, and introduces the OceanBase Migration Service (OMS) as a comprehensive, automated solution that enables seamless, low‑risk migration to a distributed cloud database with rapid validation, data verification, and one‑click cut‑over capabilities.
Facing MySQL limits, Meituan selected TiDB for its MySQL compatibility, strong consistency, and online scaling, deploying it on ten clusters and 200 nodes, building automated deployment, monitoring, and data‑sync tools, resolving performance issues, and planning broader adoption and joint development of future TiDB features.
Uber’s engineering team explains how Postgres’s immutable rows, write‑ahead logging, and replication design caused write amplification, upgrade pain, and data‑corruption risks, leading them to adopt a MySQL‑based Schemaless sharding layer that offers better buffering, connection handling, and replication semantics for massive scale.
This article explains how to build a complete application‑plus‑database DevOps pipeline using TFS, detailing script‑based database upgrades, CI/CD integration, backup and restore commands, and the open‑source SQLToolkit tool to automate versioned database deployments.
This article explains how Laravel's database migration system works, covering configuration, creating migration files, designing schemas with the Schema builder, and executing migrations and rollbacks via Artisan commands to efficiently manage and version‑control database structures.
This article recounts a step‑by‑step migration of a 2010‑era Nginx‑based multi‑site environment and two MySQL databases to a cloud server, highlighting security risks, performance bottlenecks, backup commands, failed restore attempts, and practical lessons learned.
This article introduces Yugong, an open‑source ETL framework for heterogeneous database migration, explains its core Extractor‑Translator‑Applier architecture, details key classes and interfaces, discusses limitations of the original version, and describes extensive refactoring and new features added to support SQL Server, MySQL, and Canal‑based incremental replication.
This article details the challenges of moving from SQL Server to MySQL, compares offline and online migration approaches, presents a complete toolbox—including ETL utilities, consistency checkers, CDC configuration, and rollback mechanisms—and shares practical lessons from a large‑scale production migration.
This article explains how to achieve near‑zero‑downtime online migration from SQL Server to MySQL by leveraging Change Data Capture (CDC) and the Alibaba Yugong tool, covering CDC principles, configuration, performance tuning, and practical migration steps.
This article recounts a blockchain finance company's rapid user growth, the decision to move MySQL from Docker Swarm to Alibaba Cloud RDS, the ensuing CPU overload caused by missing indexes, and the step‑by‑step troubleshooting and optimization that restored system stability.
This article recounts a real‑world MySQL migration from Docker Swarm containers to an Alibaba Cloud RDS instance, detailing the original architecture, migration steps, backup scripts, a critical index‑missing outage, and the practical indexing strategies used to restore performance.
This article explains the detailed steps of MySQL ALTER operations, compares single‑instance and master‑slave scenarios, introduces various online schema‑change tools such as pt‑OSC, outlines native MySQL OSC support, discusses limitations, and provides practical recommendations for safely performing large‑table DDL.
gh‑ost is a lightweight, trigger‑free, Go‑based online MySQL schema‑change tool that reads binary logs, applies alterations to temporary tables, and offers pauseable, auditable, and dynamically controllable migrations via socket commands, supporting master‑only, replica‑assisted, or replica‑testing modes and used extensively at GitHub.
This article details the background, design considerations, migration workflows, tooling choices, data consistency verification, rollback mechanisms, and practical experiences of moving a large‑scale production environment from Microsoft SQL Server to MySQL, covering both offline and online migration scenarios.
Learn how to build a repeatable, secure Spinnaker pipeline that automatically runs database migrations and deploys a Go‑based API service to Kubernetes, using Docker images, Run Job stages, and environment variables, without writing custom scripts.
This tutorial shows how to integrate Flyway into a Spring Boot application for database version control, covering dependency setup, creation of versioned SQL scripts, configuration, execution of migrations during tests, and handling of checksum validation errors.
This article walks through a practical, step‑by‑step migration from MongoDB to MySQL for a Rails project, covering data export, preprocessing embedded documents, handling UUIDs, adapting Mongoid plugins, rewriting models, writing migration scripts, rebuilding relationships, managing many‑to‑many links, and emphasizing thorough testing to ensure a smooth, low‑downtime transition.
This article compares FMDB and WCDB, detailing smooth migration steps, benchmark results showing WCDB's superior write and multithreaded performance, reduced code complexity, built‑in encryption, statistics and repair tools, and provides practical guidance for developers considering a database switch.
The article shares a DBA's real‑world experiences—from a risky MySQL restart that exposed hidden issues, through practical learning advice and MySQL technical nuances, to a detailed Oracle migration case—offering actionable insights for database professionals seeking robust data management and performance optimization.
When migrating applications from Oracle to MySQL, many teams encounter severe performance problems such as CPU saturation, high logical and physical reads, and slow queries, and this article outlines the root causes—including lack of parallelism, limited join algorithms, IN‑list limits, subquery inefficiencies, missing materialized views, and unsupported function indexes—and provides concrete remediation strategies for each issue.
This case study details Swat.io's two‑year journey from MySQL to PostgreSQL, covering the motivations, technical challenges, incremental experiments, migration strategy, performance tuning, and the lessons learned that helped the team successfully complete the transition.
This article details how Discord scaled from tens of millions to over a hundred million daily messages by replacing MongoDB with Cassandra, covering the motivations, data model design, handling of tombstones, performance results, unexpected issues, and future scalability plans.
This article shares practical experiences and step‑by‑step guidance for migrating databases from Oracle to MySQL, covering pre‑migration preparation, target selection, data‑object migration tools such as SQL LOAD, Python scripts, Oracle GoldenGate, MySQL Migration Toolkit and Kettle, handling of views, triggers, stored procedures, data validation techniques, and key MySQL performance parameters.
After migrating a core system from AIX to Linux and upgrading Oracle from 11.2.0.3 to 11.2.0.4, a critical SQL that previously ran in milliseconds began taking hundreds of seconds, prompting a detailed investigation of execution plans, CBO limitations, and three successive rewrite strategies that restored performance.
This article presents a comprehensive guide to XTTS, an Oracle table‑space transfer tool that extends TTS with cross‑platform support and incremental backup, comparing it with Data Pump and GoldenGate, detailing step‑by‑step procedures, performance optimizations, real‑world case studies, and a pre‑migration checklist.
This article compares how to create tables and perform upsert (insert‑or‑update) operations in MS SQL and Oracle, presenting five distinct Oracle techniques—including implicit cursor, exception handling, dual table, no_data_found, and MERGE—each with complete PL/SQL code samples.
This guide explains how to transform an ordinary Oracle table larger than 2 GB into a partitioned table using the online redefinition method (DBMS_REDEFINITION), detailing each step from feasibility checks to final cleanup with example PL/SQL code.
This article outlines common Oracle migration pitfalls—including architectural constraints, resource impacts, application coordination issues, and diverse database problems—drawn from real‑world projects, and offers practical guidance to help DBAs anticipate and mitigate these challenges during system cut‑overs, upgrades, and consolidations.
This article explains the root causes of unauthenticated public‑IP MongoDB breaches, outlines UCloud's built‑in security safeguards, and provides step‑by‑step guidance for hardening self‑hosted MongoDB and smoothly migrating it to a cloud‑managed service.
This article explains the reasons for breaking up tightly‑coupled monolithic systems, outlines preparation steps such as assessing business complexity and defining service boundaries, and provides detailed practical guidance on database sharding, migration, query refactoring, cut‑over plans, consistency, and post‑split stability.
This article walks through semi‑automated Oracle Data Guard deployment, when and how to use DG Broker, practical failover, switchover and archive‑recovery scenarios, Oracle 12c enhancements like Far Sync and VALIDATE, a real‑world standby query failure case, and using Data Guard for database migration.
This article provides a comprehensive overview of Oracle GoldenGate, detailing its supported databases, modular architecture, key components such as Extract, Data Pump, Replicat, Trails, Checkpoints, Manager and Collector, as well as processing types, group configuration, and commit sequence numbers for reliable data replication.
This article presents a systematic evaluation of four SQL Server‑to‑MySQL migration tools—SQLyog, Navicat Premium, Mss2sql, and DB2DB—covering usability, speed, memory usage, data integrity, trial limitations, and additional features to help developers choose the most reliable solution for large‑scale database migrations.
The discussion explores practical strategies for adding an index to a MySQL table containing tens of millions of rows without stopping service, covering intermediate tables, double‑write syncing, rename operations, traffic considerations, lock types, and tooling such as Percona.
This article walks through a real‑world upgrade from SQL Server 2008 R2 to 2014, detailing background analysis, data collection, solution design, detailed investigation, testing, performance baselines, side‑by‑side migration, cluster setup, application changes, and common pitfalls such as CDC issues, index‑rebuild logging, and query slowdowns.
An experienced Tencent Cloud engineer shares a detailed case study of moving over 130 MySQL instances (20 TB) from on‑premise IDC to CDB for MySQL, covering test cases, migration tool mechanics, multi‑instance concurrency, binlog handling, encountered issues, and practical solutions that ensured a smooth, high‑availability transition.
This article shares a real-world case study of migrating a SQL Server 2008 R2 environment to SQL Server 2014, detailing the pre‑migration research, architecture redesign with AlwaysOn high‑availability, testing procedures, implementation steps, performance tuning, and common pitfalls encountered during the three‑month project.
Learn a step-by-step method to safely alter large MySQL tables in production without locking, by creating a new table, syncing data via triggers, copying rows, swapping tables, and using Percona’s pt-online-schema-change tool with example commands and installation instructions.
This guide details how to move an Oracle 11.2.0.3.0 single‑instance database from Windows to a three‑node RAC on Linux using Data Guard, covering compatibility, required patches, configuration steps, parameter settings, and post‑migration tasks to ensure a fast, low‑downtime transition.
This guide explains how to use Alibaba Cloud Data Transmission and the dts-ads-writer plugin to continuously synchronize MySQL RDS tables to an analytical database, covering prerequisites, configuration files, step‑by‑step setup, and important considerations for reliable data replication.
This article chronicles Hotjar's evolution from a simple two‑server setup to a robust, eight‑server architecture handling billions of daily requests, sharing eight practical lessons on scaling, CDN usage, language choice, data storage, monitoring, and cost‑effective optimizations for fast‑growing web services.
This tutorial details the complete process of moving a single‑node DB2 v9.7 PHSDB database to K‑DB11G, covering schema‑to‑user mapping, object conversion, constraint handling, identity column emulation, manual adjustments for views/functions, and the export‑import scripts required for data migration.
This article explains why DB2 customers must upgrade to avoid EOS risks, compares replication options, and provides a detailed CDC‑based step‑by‑step process to achieve minute‑level downtime, zero performance impact, and fast rollback for large‑scale DB2 version migrations.
This guide details the complete process of moving a 2‑node Oracle 11gR2 RAC database to new servers and storage using Active Physical Standby Data Guard, covering architecture, pre‑implementation preparation, detailed implementation steps, switchover procedures, impact assessment, rollback measures, and lessons learned.
This article recounts Alibaba’s journey from Oracle‑based IOE architecture to a home‑grown MySQL/DRDS solution, detailing the motivations, challenges, technical choices, performance pitfalls, and operational practices that shaped the migration and the lessons learned for large‑scale database engineering.
This article provides a comprehensive walkthrough of Oracle's XTTS technology, covering its evolution, traditional and incremental‑backup workflows, version constraints, detailed configuration steps, real‑world migration timing, common pitfalls, remediation tactics, and a concise Q&A for practitioners.
This article explains why MySQL migrations are essential, outlines backup and restore strategies, and provides detailed, step‑by‑step procedures for multiple real‑world scenarios—including single‑master/slave moves, cross‑datacenter transfers, and multi‑instance setups—while highlighting key precautions and practical tips for successful execution.
This article explains why MySQL migration is essential, outlines various migration strategies—including full, partial, and cross‑datacenter moves—and provides detailed, step‑by‑step procedures, best‑practice tips, and precautionary measures to ensure a smooth, reliable transition.
This article compares MySQL client commands and features with their PostgreSQL psql equivalents, covering general command‑line options, SQL‑level operations such as showing tables, creating tables, listing databases, using databases, handling auto‑increment, process lists, global variables, and function‑level differences, plus practical code snippets.
This article records the Q&A from Zhejiang Mobile’s Operations Forum, revealing how the company is progressing through its PostgreSQL migration, the technical pitfalls encountered, and practical advice on database refactoring, ecosystem building, and the economic impact of moving away from legacy Oracle systems.
This article explains how to convert and restore SQL Server 2000 backup files to SQL Server 2005, detailing direct restore steps, required file extensions, path adjustments, and key differences such as database creation requirements and naming conventions between the two versions.
Olery’s journey from a mixed MySQL‑MongoDB setup to a PostgreSQL‑centric architecture reveals the pitfalls of schema‑less storage, the criteria for a robust database, a three‑stage migration process, and measurable performance gains across its services.
Learn a concise, five‑step process to safely replace MySQL with MariaDB on a CentOS system—including backup, removal of MySQL packages, downloading and installing MariaDB RPMs, restarting the service, and confirming compatibility with existing tools like phpMyAdmin.
In this technical Q&A, Microsoft SQL Server experts address common migration challenges, performance tuning tips, memory‑optimized table limitations, and best practices for SQL Server 2014, providing concrete guidance, reference links, and practical recommendations for database administrators.