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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
