Skip to content
Tagged articles

Database Migration

299 articles · Page 3 of 3
dbaplus Community
dbaplus Community
Sep 28, 2020 · Databases

How ClickHouse Outperformed Elasticsearch for Ctrip’s Log Analytics: Speed, Cost & Ops

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.

ClickHouseDatabase MigrationElasticsearch
0 likes · 14 min read
How ClickHouse Outperformed Elasticsearch for Ctrip’s Log Analytics: Speed, Cost & Ops
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 16, 2020 · Databases

Online DDL Tool pt-osc: Principles, Usage, and Comparison

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.

Database Migrationmysqlonline DDL
0 likes · 32 min read
Online DDL Tool pt-osc: Principles, Usage, and Comparison
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.

Database MigrationFinancial ServicesOracle migration
0 likes · 7 min read
How Lujinso Migrated 90% of Its Oracle Databases to MySQL at Scale
Qunar Tech Salon
Qunar Tech Salon
Aug 27, 2020 · Databases

Qunar Technology Carnival Interview Series: Insights on Hotel Flow Optimization, Database Architecture, and System Stability

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.

Database MigrationInfrastructureQunar
0 likes · 13 min read
Qunar Technology Carnival Interview Series: Insights on Hotel Flow Optimization, Database Architecture, and System Stability
dbaplus Community
dbaplus Community
Jul 31, 2020 · Databases

Optimizing TimesTen Cache Group Rebuilds During Oracle 19c Migration

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.

Cache GroupDatabase MigrationOracle 19c
0 likes · 10 min read
Optimizing TimesTen Cache Group Rebuilds During Oracle 19c Migration
dbaplus Community
dbaplus Community
Jul 23, 2020 · Databases

How to Export a 2TB Oracle LOB Table Using Rowid Partitioning

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.

Data PumpDatabase MigrationExport
0 likes · 8 min read
How to Export a 2TB Oracle LOB Table Using Rowid Partitioning
dbaplus Community
dbaplus Community
Jul 4, 2020 · Databases

Mastering Oracle 19c Hot Clone: A Complete Step‑by‑Step Guide

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.

Database MigrationHot CloneOracle
0 likes · 21 min read
Mastering Oracle 19c Hot Clone: A Complete Step‑by‑Step Guide
Tencent Cloud Developer
Tencent Cloud Developer
Jun 16, 2020 · Cloud Computing

Tencent Cloud Basic Network to VPC Migration Guide

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.

Basic NetworkCVMDatabase Migration
0 likes · 7 min read
Tencent Cloud Basic Network to VPC Migration Guide
ITPUB
ITPUB
May 10, 2020 · Databases

How We Migrated MySQL to Tencent Cloud CDB and Boosted Performance Up to 10×

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.

Database MigrationNUMAPerformance Tuning
0 likes · 20 min read
How We Migrated MySQL to Tencent Cloud CDB and Boosted Performance Up to 10×
macrozheng
macrozheng
May 9, 2020 · Databases

Why Insert‑Into‑Select Can Lock Your MySQL Tables and How to Fix It

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.

Database MigrationINSERT INTO SELECTIndex
0 likes · 7 min read
Why Insert‑Into‑Select Can Lock Your MySQL Tables and How to Fix It
Laravel Tech Community
Laravel Tech Community
May 4, 2020 · Databases

Laravel Schema Cheat Sheet: Quick Guide to Database Migrations

This Laravel Schema cheat sheet provides concise, English-translated code examples for creating, modifying, and managing database tables, columns, indexes, and foreign keys, covering table creation, column types, indexing options, and common schema operations with clear syntax.

Database MigrationLaravelPHP
0 likes · 5 min read
Laravel Schema Cheat Sheet: Quick Guide to Database Migrations
Programmer DD
Programmer DD
Apr 23, 2020 · Databases

How INSERT INTO SELECT Nearly Crashed a MySQL DB – Lessons & Fix

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.

Database MigrationINSERT INTO SELECTIndexing
0 likes · 7 min read
How INSERT INTO SELECT Nearly Crashed a MySQL DB – Lessons & Fix
NetEase Game Operations Platform
NetEase Game Operations Platform
Feb 15, 2020 · Databases

Using Flyway for Database Version Management: Principles, Configuration, and Best Practices

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.

Database MigrationDevOpsFlyway
0 likes · 13 min read
Using Flyway for Database Version Management: Principles, Configuration, and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 10, 2020 · Databases

Handling Duplicate Data in MySQL: Techniques and Examples

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.

Database MigrationSQLdata cleaning
0 likes · 13 min read
Handling Duplicate Data in MySQL: Techniques and Examples
Ctrip Technology
Ctrip Technology
Jan 22, 2020 · Databases

Migrating Log Processing from Elasticsearch to ClickHouse: Architecture, Deployment, Optimization, and Benefits

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.

ClickHouseDatabase MigrationDistributed Systems
0 likes · 12 min read
Migrating Log Processing from Elasticsearch to ClickHouse: Architecture, Deployment, Optimization, and Benefits
Architects Research Society
Architects Research Society
Jan 20, 2020 · Databases

Goodbye MongoDB, Hello PostgreSQL: Olery’s Journey to a More Reliable Database Architecture

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.

Database MigrationMongoDBPostgreSQL
0 likes · 15 min read
Goodbye MongoDB, Hello PostgreSQL: Olery’s Journey to a More Reliable Database Architecture
Continuous Delivery 2.0
Continuous Delivery 2.0
Dec 31, 2019 · Backend Development

Database Migration Strategies with Feature Toggles: Code‑First, Data‑First, Big Bang, Expand‑Contract, and Double‑Writing

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.

BackendDatabase Migrationbig bang release
0 likes · 7 min read
Database Migration Strategies with Feature Toggles: Code‑First, Data‑First, Big Bang, Expand‑Contract, and Double‑Writing
Meitu Technology
Meitu Technology
Dec 12, 2019 · Databases

Migrating Meitu Push Service Storage to Titan: Architecture, Challenges, and Solutions

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.

Database MigrationPush ServiceTiKV
0 likes · 13 min read
Migrating Meitu Push Service Storage to Titan: Architecture, Challenges, and Solutions
Programmer DD
Programmer DD
Nov 29, 2019 · Databases

How to Resolve Flyway Permission Errors in Spring Boot Deployments

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.

Database MigrationFlywayPermission Error
0 likes · 5 min read
How to Resolve Flyway Permission Errors in Spring Boot Deployments
HomeTech
HomeTech
Nov 27, 2019 · Databases

Migrating AutoHome Community from SQL Server to TiDB: Architecture, Testing, and Lessons Learned

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.

Database MigrationETLSQL Server
0 likes · 15 min read
Migrating AutoHome Community from SQL Server to TiDB: Architecture, Testing, and Lessons Learned
ITPUB
ITPUB
Nov 18, 2019 · Databases

Master Oracle Data Pump: expdp & impdp Commands, Parameters, and Troubleshooting

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.

Data PumpDatabase MigrationOracle
0 likes · 17 min read
Master Oracle Data Pump: expdp & impdp Commands, Parameters, and Troubleshooting
AntTech
AntTech
Nov 10, 2019 · Backend Development

The Evolution of Alipay’s Double 11 Technical Architecture: From Capacity Crises to Cloud‑Native Success

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.

AlipayDatabase MigrationDouble 11
0 likes · 22 min read
The Evolution of Alipay’s Double 11 Technical Architecture: From Capacity Crises to Cloud‑Native Success
ITPUB
ITPUB
Nov 4, 2019 · Databases

Overcoming 50 Common PostgreSQL‑Oracle Migration Pitfalls in Financial Systems

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.

Database MigrationOraclePostgreSQL
0 likes · 16 min read
Overcoming 50 Common PostgreSQL‑Oracle Migration Pitfalls in Financial Systems
ITPUB
ITPUB
Oct 28, 2019 · Databases

How Xintai Life Insurance Replaced Oracle with PostgreSQL: A Three‑Step De‑Oracle Strategy

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.

Database MigrationDe‑OracleFinancial Services
0 likes · 8 min read
How Xintai Life Insurance Replaced Oracle with PostgreSQL: A Three‑Step De‑Oracle Strategy
21CTO
21CTO
Oct 26, 2019 · Databases

How We Migrated a Billion‑Transaction Payment Platform from MySQL to TiDB

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.

Database MigrationTiDBdistributed database
0 likes · 20 min read
How We Migrated a Billion‑Transaction Payment Platform from MySQL to TiDB
Big Data Technology & Architecture
Big Data Technology & Architecture
Sep 22, 2019 · Databases

Alibaba Cloud BDS Service for Non‑Stop HBase Cluster Migration

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.

Alibaba CloudBDSDatabase Migration
0 likes · 10 min read
Alibaba Cloud BDS Service for Non‑Stop HBase Cluster Migration
Programmer DD
Programmer DD
Aug 17, 2019 · Databases

How ICBC Transformed Its Legacy Systems with a MySQL Distributed Architecture

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.

ContainerizationDatabase Migrationbanking IT
0 likes · 20 min read
How ICBC Transformed Its Legacy Systems with a MySQL Distributed Architecture
Tencent Cloud Developer
Tencent Cloud Developer
Aug 13, 2019 · Cloud Computing

Tencent's Internal Business Migration to Public Cloud: Strategies, Practices, and Lessons

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.

Cloud MigrationDatabase MigrationDevOps
0 likes · 21 min read
Tencent's Internal Business Migration to Public Cloud: Strategies, Practices, and Lessons
Architecture Digest
Architecture Digest
Jun 28, 2019 · Cloud Computing

Evolution of Alibaba's Technical Architecture and Lessons for Enterprise Systems

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.

AlibabaDatabase MigrationDistributed Systems
0 likes · 10 min read
Evolution of Alibaba's Technical Architecture and Lessons for Enterprise Systems
AntTech
AntTech
Jun 11, 2019 · Databases

Applying OceanBase Financial‑Grade Distributed Database at Net Business Bank: Architecture, Migration, and High‑Availability Practices

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.

Cloud ArchitectureDatabase MigrationOceanBase
0 likes · 9 min read
Applying OceanBase Financial‑Grade Distributed Database at Net Business Bank: Architecture, Migration, and High‑Availability Practices
21CTO
21CTO
May 16, 2019 · Databases

How ICBC Transformed Its Legacy OLTP Systems with a Distributed MySQL Architecture

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.

Cloud NativeDatabase MigrationHigh Availability
0 likes · 19 min read
How ICBC Transformed Its Legacy OLTP Systems with a Distributed MySQL Architecture
Aikesheng Open Source Community
Aikesheng Open Source Community
May 14, 2019 · Databases

Industrial and Commercial Bank of China's IT Architecture Transformation: A MySQL Distributed Enterprise Solution

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
0 likes · 19 min read
Industrial and Commercial Bank of China's IT Architecture Transformation: A MySQL Distributed Enterprise Solution
Xianyu Technology
Xianyu Technology
Mar 6, 2019 · Databases

Seamless Migration of Xianyu Product Database Using TDDL and DTS

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.

DTSData ConsistencyDatabase Migration
0 likes · 9 min read
Seamless Migration of Xianyu Product Database Using TDDL and DTS
ITPUB
ITPUB
Feb 26, 2019 · Databases

Will Oracle Be Replaced by MySQL? DBA Demand and Database Trends Explained

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.

DBADatabase MigrationOracle
0 likes · 6 min read
Will Oracle Be Replaced by MySQL? DBA Demand and Database Trends Explained
AntTech
AntTech
Jan 9, 2019 · Databases

Evolution of Ant Financial Database Architecture and the OceanBase Migration Service

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.

Ant FinancialDatabase MigrationOceanBase
0 likes · 11 min read
Evolution of Ant Financial Database Architecture and the OceanBase Migration Service
Meituan Technology Team
Meituan Technology Team
Nov 22, 2018 · Databases

Meituan's TiDB Adoption: Architecture, Deployment, and Operational Practices

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.

Database MigrationMeituanPerformance Optimization
0 likes · 20 min read
Meituan's TiDB Adoption: Architecture, Deployment, and Operational Practices
ITPUB
ITPUB
Sep 8, 2018 · Databases

Why Uber Switched from Postgres to MySQL: Scaling Lessons from a Real‑World Migration

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.

Database MigrationPostgreSQLUber
0 likes · 23 min read
Why Uber Switched from Postgres to MySQL: Scaling Lessons from a Real‑World Migration
DevOps
DevOps
Aug 27, 2018 · Databases

Implementing a Database CI/CD Pipeline with Team Foundation Server and SQLToolkit

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.

Database CI/CDDatabase MigrationDevOps
0 likes · 7 min read
Implementing a Database CI/CD Pipeline with Team Foundation Server and SQLToolkit
Python Programming Learning Circle
Python Programming Learning Circle
Jul 13, 2018 · Backend Development

Master Laravel Database Migrations: Step-by-Step Guide

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.

ArtisanDatabase MigrationLaravel
0 likes · 5 min read
Master Laravel Database Migrations: Step-by-Step Guide
Hujiang Technology
Hujiang Technology
Jun 20, 2018 · Databases

Deep Dive into Yugong: Architecture, Core Modules, and Custom Enhancements for Database Migration

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.

Database MigrationETLJava
0 likes · 9 min read
Deep Dive into Yugong: Architecture, Core Modules, and Custom Enhancements for Database Migration
Beike Product & Technology
Beike Product & Technology
Apr 13, 2018 · Databases

Understanding MySQL ALTER Operations and Online Schema Change (OSC) Tools

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.

ALTERDatabase MigrationOnline Schema Change
0 likes · 13 min read
Understanding MySQL ALTER Operations and Online Schema Change (OSC) Tools
Tencent Cloud Developer
Tencent Cloud Developer
Mar 23, 2018 · Databases

Using gh-ost for Online MySQL Schema Changes: Features, Modes, and Practical Tips

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.

Binary LogDBA toolsDatabase Migration
0 likes · 17 min read
Using gh-ost for Online MySQL Schema Changes: Features, Modes, and Practical Tips
Hujiang Technology
Hujiang Technology
Mar 13, 2018 · Databases

Migrating from SQL Server to MySQL: Strategies, Tools, and Lessons Learned

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.

Data ConsistencyDatabase MigrationETL
0 likes · 13 min read
Migrating from SQL Server to MySQL: Strategies, Tools, and Lessons Learned
Programmer DD
Programmer DD
Jan 15, 2018 · Cloud Native

Automate Safe Database Migrations on Kubernetes with Spinnaker

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.

CI/CDCloud NativeDatabase Migration
0 likes · 7 min read
Automate Safe Database Migrations on Kubernetes with Spinnaker
dbaplus Community
dbaplus Community
Oct 17, 2017 · Databases

How to Migrate a MongoDB Database to MySQL with Minimal Downtime

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.

ActiveRecordDatabase MigrationMongoDB
0 likes · 23 min read
How to Migrate a MongoDB Database to MySQL with Minimal Downtime
WeChat Client Technology Team
WeChat Client Technology Team
Aug 16, 2017 · Backend Development

Why Switch from FMDB to WCDB? Performance, Migration & Feature Guide

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.

Database MigrationFMDBSQLite
0 likes · 10 min read
Why Switch from FMDB to WCDB? Performance, Migration & Feature Guide
dbaplus Community
dbaplus Community
Jul 17, 2017 · Databases

DBA Lessons: From MySQL Restart Pitfalls to Smart Data Migration Strategies

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.

DBAData ManagementDatabase Migration
0 likes · 15 min read
DBA Lessons: From MySQL Restart Pitfalls to Smart Data Migration Strategies
ITPUB
ITPUB
May 19, 2017 · Databases

Why Oracle‑to‑MySQL Migrations Stall: Common Pitfalls and Fixes

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.

Database MigrationOraclePerformance Tuning
0 likes · 10 min read
Why Oracle‑to‑MySQL Migrations Stall: Common Pitfalls and Fixes
MaGe Linux Operations
MaGe Linux Operations
May 8, 2017 · Databases

How Swat.io Migrated from MySQL to PostgreSQL in Two Years

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.

Database MigrationPerformance OptimizationPostgreSQL
0 likes · 18 min read
How Swat.io Migrated from MySQL to PostgreSQL in Two Years
dbaplus Community
dbaplus Community
Apr 17, 2017 · Databases

Mastering Oracle‑to‑MySQL Migration: Tools, Pitfalls, and Performance Tweaks

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.

Database MigrationETLOracle
0 likes · 26 min read
Mastering Oracle‑to‑MySQL Migration: Tools, Pitfalls, and Performance Tweaks
dbaplus Community
dbaplus Community
Mar 28, 2017 · Databases

Why an Oracle SQL Slowed After Upgrade—and How to Fix It

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.

CBODatabase MigrationOracle
0 likes · 9 min read
Why an Oracle SQL Slowed After Upgrade—and How to Fix It
dbaplus Community
dbaplus Community
Mar 20, 2017 · Databases

Mastering XTTS: Fast, Low‑Downtime Oracle Table‑Space Migration

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.

Data PumpDatabase MigrationGoldenGate
0 likes · 20 min read
Mastering XTTS: Fast, Low‑Downtime Oracle Table‑Space Migration
ITPUB
ITPUB
Mar 8, 2017 · Databases

5 Ways to Upsert in Oracle vs MS SQL – Practical Code Examples

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.

Database MigrationOraclePL/SQL
0 likes · 8 min read
5 Ways to Upsert in Oracle vs MS SQL – Practical Code Examples
ITPUB
ITPUB
Feb 27, 2017 · Databases

Convert a Large Oracle Table to a Partitioned Table with DBMS_REDEFINITION

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.

DBMS_REDEFINITIONDatabase MigrationOracle
0 likes · 5 min read
Convert a Large Oracle Table to a Partitioned Table with DBMS_REDEFINITION
ITPUB
ITPUB
Feb 3, 2017 · Databases

Top Oracle Migration Pitfalls Every DBA Must Avoid

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.

DBADataGuardDatabase Migration
0 likes · 6 min read
Top Oracle Migration Pitfalls Every DBA Must Avoid
Efficient Ops
Efficient Ops
Jan 8, 2017 · Databases

Why MongoDB Instances Get Hacked and How to Secure Them on the Cloud

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.

AuthenticationDatabase MigrationMongoDB
0 likes · 8 min read
Why MongoDB Instances Get Hacked and How to Secure Them on the Cloud
Architecture Digest
Architecture Digest
Jan 3, 2017 · Backend Development

Why and How to Split Monolithic Applications: Practical Guidance and Database Migration Strategies

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.

Backend ArchitectureDatabase Migrationapplication splitting
0 likes · 17 min read
Why and How to Split Monolithic Applications: Practical Guidance and Database Migration Strategies
ITPUB
ITPUB
Nov 2, 2016 · Databases

Mastering Oracle GoldenGate: Architecture, Components, and Configuration Guide

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.

Database MigrationETLOracle GoldenGate
0 likes · 20 min read
Mastering Oracle GoldenGate: Architecture, Components, and Configuration Guide
dbaplus Community
dbaplus Community
Sep 27, 2016 · Databases

Which Tool Best Migrates SQL Server to MySQL? A Detailed Performance Comparison

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.

Database MigrationPerformance TestSQL Server
0 likes · 12 min read
Which Tool Best Migrates SQL Server to MySQL? A Detailed Performance Comparison
dbaplus Community
dbaplus Community
Sep 20, 2016 · Databases

Upgrading SQL Server 2008 R2 to 2014 with AlwaysOn: A Hands‑On High‑Availability Guide

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.

AlwaysOnDatabase MigrationHigh Availability
0 likes · 13 min read
Upgrading SQL Server 2008 R2 to 2014 with AlwaysOn: A Hands‑On High‑Availability Guide
dbaplus Community
dbaplus Community
Sep 6, 2016 · Databases

Migrating 130 MySQL Instances to Tencent Cloud CDB: Key Lessons and Tips

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.

CDBDatabase MigrationMaster‑Slave
0 likes · 10 min read
Migrating 130 MySQL Instances to Tencent Cloud CDB: Key Lessons and Tips
Architecture Digest
Architecture Digest
Sep 1, 2016 · Databases

Upgrading SQL Server 2008 R2 to 2014 and Implementing AlwaysOn High Availability: Process, Research, Testing, and Lessons Learned

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.

AlwaysOnDatabase MigrationPerformance Tuning
0 likes · 12 min read
Upgrading SQL Server 2008 R2 to 2014 and Implementing AlwaysOn High Availability: Process, Research, Testing, and Lessons Learned
ITPUB
ITPUB
Jul 26, 2016 · Cloud Computing

How to Real-Time Sync MySQL RDS to Analytic DB with Alibaba Cloud Data Transmission

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.

Alibaba CloudData TransmissionDatabase Migration
0 likes · 7 min read
How to Real-Time Sync MySQL RDS to Analytic DB with Alibaba Cloud Data Transmission
Java High-Performance Architecture
Java High-Performance Architecture
Jun 14, 2016 · Backend Development

How Hotjar Scaled to 500M Daily Requests: 8 Lessons for Rapid Backend Growth

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.

CDNDatabase MigrationPerformance Optimization
0 likes · 7 min read
How Hotjar Scaled to 500M Daily Requests: 8 Lessons for Rapid Backend Growth
ITPUB
ITPUB
May 20, 2016 · Databases

Step-by-Step Guide: Migrating DB2 v9.7 PHSDB to K-DB11G

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.

DB2Database MigrationK-DB
0 likes · 10 min read
Step-by-Step Guide: Migrating DB2 v9.7 PHSDB to K-DB11G
dbaplus Community
dbaplus Community
Apr 6, 2016 · Databases

Seamless DB2 Major Version Upgrade Using CDC Replication

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.

CDCDB2Database Migration
0 likes · 10 min read
Seamless DB2 Major Version Upgrade Using CDC Replication
dbaplus Community
dbaplus Community
Mar 24, 2016 · Databases

Step‑by‑Step Migration of a 2‑Node Oracle 11gR2 RAC to New Hardware with Active Data Guard

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.

Data GuardDatabase MigrationHigh Availability
0 likes · 10 min read
Step‑by‑Step Migration of a 2‑Node Oracle 11gR2 RAC to New Hardware with Active Data Guard
dbaplus Community
dbaplus Community
Feb 25, 2016 · Databases

How Alibaba Migrated from Oracle to MySQL: Lessons from the IOE Transition

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.

AlibabaDRDSDatabase Migration
0 likes · 16 min read
How Alibaba Migrated from Oracle to MySQL: Lessons from the IOE Transition
dbaplus Community
dbaplus Community
Dec 18, 2015 · Databases

Mastering Oracle XTTS: Fast, Low‑Downtime Database Migration

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.

Best PracticesDatabase MigrationOracle
0 likes · 18 min read
Mastering Oracle XTTS: Fast, Low‑Downtime Database Migration
21CTO
21CTO
Oct 9, 2015 · Databases

Mastering MySQL Migration: Practical Scenarios and Step-by-Step Guides

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.

Backup and RestoreDatabase Migrationmysql
0 likes · 25 min read
Mastering MySQL Migration: Practical Scenarios and Step-by-Step Guides
21CTO
21CTO
Oct 4, 2015 · Databases

Mastering MySQL Migration: Practical Scenarios and Step‑by‑Step Guide

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.

Cross-DataCenterDatabase Migrationbackup
0 likes · 21 min read
Mastering MySQL Migration: Practical Scenarios and Step‑by‑Step Guide
Qunar Tech Salon
Qunar Tech Salon
Jul 13, 2015 · Databases

Mapping MySQL Commands and Features to PostgreSQL psql Equivalents

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.

Database MigrationPostgreSQLSQL
0 likes · 6 min read
Mapping MySQL Commands and Features to PostgreSQL psql Equivalents
MaGe Linux Operations
MaGe Linux Operations
Jul 18, 2014 · Databases

How to Migrate MySQL to MariaDB on CentOS: Step‑by‑Step Guide

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.

CentOSDatabase MigrationLinux
0 likes · 3 min read
How to Migrate MySQL to MariaDB on CentOS: Step‑by‑Step Guide
ITPUB
ITPUB
May 23, 2014 · Databases

Expert Answers to Top SQL Server 2014 Memory‑Optimized Table Questions

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.

Database MigrationSQL ServerSQL Server 2014
0 likes · 16 min read
Expert Answers to Top SQL Server 2014 Memory‑Optimized Table Questions