Tagged articles
database deployment
25 articles · Page 1 of 1
This guide shows how to install, configure, and manage MySQL/MariaDB, Redis, and PostgreSQL inside Windows Subsystem for Linux, including remote access setup, common command‑line operations, GUI client recommendations, and scripts for one‑click start/stop and backup.
GUI clientMySQLPostgreSQL
0 likes · 14 min read


ITPUBSep 12, 2025 · Cloud Native
Deploying MySQL in production containers introduces volatile storage, unstable networking, performance variability, and replication challenges that clash with the database's need for persistent, high‑availability, and consistent operation, making native VM or bare‑metal deployments far more reliable.
KubernetesMySQLcloud-native
0 likes · 7 min read

This tutorial provides a step-by-step guide to deploying openGauss database using Docker Compose, covering environment setup, directory creation, docker-compose.yml configuration with persistent storage and environment variables, container startup, service verification, and troubleshooting common issues like password policy and permission errors.
ContainerizationDocker Composedatabase deployment
0 likes · 9 min read

This guide walks you through installing Docker and Docker Compose on AlmaLinux, creating a concise docker‑compose.yml to run PostgreSQL in an isolated container, connecting with DataGrip, and managing the lifecycle of the database service with simple commands.
AlmaLinuxContainerizationDataGrip
0 likes · 11 min read

The article examines three modern, cloud‑native and open‑source methods for deploying PostgreSQL—using the CloudNativePG operator on Kubernetes, leveraging Korifi’s self‑service platform, and adopting Neon’s compute‑storage separation—highlighting trends toward cloud‑native infrastructure, self‑service, and open‑source SaaS alternatives.
CloudNativePGKorifiKubernetes
0 likes · 6 min read

This guide walks you through the complete process of setting up a production‑grade TiDB 8.4.0 cluster on a self‑managed Kubernetes environment using the latest TiDB Operator, covering environment prerequisites, PV pool initialization, operator installation, CRD creation, and full cluster deployment with detailed commands and configurations.
KubernetesOperatorTiDB
0 likes · 15 min read

This tutorial walks you through downloading MySQL binaries, creating a dedicated mysql user, extracting files to /usr/local, setting up separate data directories, initializing each instance, configuring my.cnf, managing the services with systemd, setting root passwords, and troubleshooting common errors, enabling you to run three isolated MySQL servers on a single host.
LinuxMySQLdatabase deployment
0 likes · 23 min read

This guide walks through deploying a PostgreSQL instance with the PostGIS extension on a CentOS server using Docker Compose, covering image retrieval, docker‑compose configuration, environment variables, logging settings, container startup, and verification of PostGIS integration.
CentOSDockerDocker Compose
0 likes · 5 min read

Facing data security and cost challenges in SaaS, the author evaluates ClickHouse versus Elasticsearch, highlighting ClickHouse’s superior write throughput, query speed, lower storage and CPU usage, and provides detailed deployment guides for Zookeeper, Kafka, FileBeat, and ClickHouse to build a cost‑effective private analytics platform.
ClickHouseElasticsearchKafka
0 likes · 8 min read


政采云技术Nov 28, 2023 · Databases
This guide explains how to deploy the high‑performance MPP database StarRocks 3 on ARM servers by using Docker images, configuring FE and BE nodes, adjusting Java versions, integrating with Hadoop/Hive, and setting up monitoring and log‑cleanup scripts.
ARMDockerStarRocks
0 likes · 12 min read

This article outlines nine typical problems that arise when executing SQL scripts in production—such as missing scripts, syntax errors, wrong order, timing issues, wrong database selection, long‑running updates, lack of rollback, missing indexes, and field renaming—and provides practical solutions to prevent each pitfall.
Best PracticesDBADevOps
0 likes · 11 min read


ITPUBMar 9, 2023 · Databases
Deploying SQL scripts to production often leads to missed scripts, syntax errors, wrong execution order, mistimed runs, wrong databases, long runtimes, lack of rollback, missing indexes, and illegal column renames, but following structured version‑controlled practices can prevent these costly issues.
DevOpsSQLScript Management
0 likes · 11 min read

This guide walks through preparing the environment, building and launching the OceanBase Config Server, registering it with an OB server cluster, installing and configuring OBproxy, and includes troubleshooting tips for common connection issues.
Config ServerDevOpsOceanBase
0 likes · 11 min read

This article provides a detailed, step‑by‑step tutorial on installing and configuring an OceanBase 4.0 cluster on Ubuntu 22.04 using the OBD (ob‑deploy) tool, covering prerequisite hardware, required commands, configuration file creation, deployment, startup, and basic verification.
Distributed DatabaseOBDOceanBase
0 likes · 9 min read

This article explains how TiDB, a cloud‑native distributed database, can be deployed on private or public clouds using the TiDB Operator, covering Kubernetes basics, operator concepts, TiDB Operator features, architecture, and upcoming deployment guides.
KubernetesOperatorTiDB
0 likes · 10 min read

This guide provides step‑by‑step instructions for downloading Apache Doris, configuring and deploying FE, BE, and Broker nodes, performing scaling operations, managing users and tables, importing and exporting data, and integrating Doris with Spark and Flink using code examples.
Apache DorisCluster ScalingFlink Integration
0 likes · 17 min read

This tutorial walks through installing and configuring PostgreSQL 12 with TimescaleDB on a CentOS 7.5 server, covering kernel tweaks, required packages, compilation, initialization, start/stop commands, remote access setup, and user‑role management for a production‑ready time‑series database.
CentOSLinuxPostgreSQL
0 likes · 9 min read

The article examines the challenges of running MySQL in Docker containers, highlighting data‑security risks, performance bottlenecks, state‑management problems, and resource‑isolation limits, while also outlining scenarios where containerizing MySQL can still be appropriate.
MySQLcontainersdata security
0 likes · 8 min read

This article provides a detailed shell-script tutorial for installing MySQL 5.7 on a Linux node, initializing the database, setting the root password, and automatically creating multiple user accounts with random passwords, suitable for operations and database administrators. The guide includes full script listings, explains repository configuration, service management, and error handling, making it a practical reference for DevOps engineers.
LinuxMySQLautomation
0 likes · 4 min read

Suning’s 2020 PostgreSQL case study, presented at PostgresConf.CN & PGConf.Asia, details how the company deployed over 4,000 instances, leveraged Citus, JSON, PostGIS and roaringbitmap, and achieved cost savings and smart‑retail capabilities across billing, analytics, location search and user profiling.
CitusPostgreSQLSmart Retail
0 likes · 3 min read

This article walks through the entire process of installing and configuring a TiDB cluster using Ansible, covering component overview, environment preparation, detailed deployment commands, common pitfalls, and verification steps to help readers avoid common mistakes.
Cluster SetupTiDBdatabase deployment
0 likes · 9 min read


DevOpsMay 6, 2019 · Operations
Facing a legacy .NET and Oracle‑based vendor system serving ten countries, a global bank doubled release frequency and halved failures by separating small data‑patch deployments from monthly releases, automating testing and deployment with Jenkins, GitHub, and custom scripts, and aligning release windows to regional business hours.
Continuous DeliveryDevOpsJenkins
0 likes · 9 min read


ITPUBJul 20, 2016 · Databases
This article details the challenges of deploying traditional MongoDB clusters on physical servers and explains how the authors containerized MongoDB using a custom Docker orchestration system, covering architecture, initialization, resource isolation, automated deployment, monitoring, logging, storage, networking, scheduling, and practical pitfalls such as image caching and graceful shutdown.
ContainerizationMongoDBdatabase deployment
0 likes · 23 min read

This guide explains how to build Docker images, configure Redis, and orchestrate containers to create a fully automated, one‑click Redis sharding cluster, covering preparation, scripting, configuration, and verification steps.
ClusterDevOpsDocker
0 likes · 11 min read

This article details how to use PXE to automatically provision three‑node Oracle 11gR2 RAC clusters on bare‑metal servers, covering network planning, PXE server setup with a one‑click installer, required software download, MAC address collection, shared‑disk and node configuration, virtual tape library setup, time synchronization, and user creation.
LinuxOraclePXE
0 likes · 13 min read
