Skip to content
Tagged articles

database management

102 articles · Page 1 of 2
macrozheng
macrozheng
Aug 6, 2026 · Databases

RedisInsight: A Stunning Official Redis Visualization Tool with Powerful Features

This article introduces RedisInsight, the official Redis visualization tool, walks through its Docker-based installation, showcases its graphical interface for data types, built-in workbench, slow‑log and memory analysis, JSON editing, theme switching, and provides a quick hands‑on experience for beginners.

DockerRedisInsightdatabase management
0 likes · 5 min read
RedisInsight: A Stunning Official Redis Visualization Tool with Powerful Features
Java Architect Essentials
Java Architect Essentials
Jul 8, 2026 · Databases

Can SQLark Replace Navicat and DBeaver? An AI‑Powered Domestic DB Tool That Boosts Developer Productivity

The article reviews SQLark, a Chinese one‑stop database development and management tool that supports Windows, macOS, and Linux, connects to major databases such as Oracle, MySQL and PostgreSQL, and integrates AI assistance, positioning it as a convenient, efficient alternative to Navicat and DBeaver.

AI assistantER diagramIntelligent SQL Editor
0 likes · 7 min read
Can SQLark Replace Navicat and DBeaver? An AI‑Powered Domestic DB Tool That Boosts Developer Productivity
Java Architect Essentials
Java Architect Essentials
May 11, 2026 · Databases

Why SQLark Beats Navicat: An AI‑Powered Database Tool Review

The author compares common database clients, highlights the risks of cracked Navicat and limited DBeaver, then details how SQLark’s cross‑platform support, AI‑driven features, smart SQL editor, data migration, ER diagram generation, and test‑data generator provide a more efficient and secure workflow for developers.

AI assistantER diagramSQLark
0 likes · 7 min read
Why SQLark Beats Navicat: An AI‑Powered Database Tool Review
Architect's Guide
Architect's Guide
Nov 27, 2025 · Databases

Master RedisInsight: Install, Configure, and Use the Redis GUI Tool

This guide introduces RedisInsight, a powerful Redis GUI, and provides step‑by‑step instructions for physical and Kubernetes installations, environment configuration, service startup, and basic usage including Redis setup and UI operations, all illustrated with code snippets and screenshots.

GUIKubernetesLinux
0 likes · 7 min read
Master RedisInsight: Install, Configure, and Use the Redis GUI Tool
Old Meng AI Explorer
Old Meng AI Explorer
Nov 24, 2025 · Databases

Why DBeaver Is the Ultimate All‑In‑One Database Management Tool

Developers, data analysts, and ops engineers can eliminate the hassle of juggling multiple database clients by adopting DBeaver, an open‑source, cross‑platform tool that supports over 100 databases, offers powerful SQL editing, visual design, data migration, and backup features—all for free.

DBeaverSQLcross-platform
0 likes · 11 min read
Why DBeaver Is the Ultimate All‑In‑One Database Management Tool
Architecture Digest
Architecture Digest
Sep 11, 2025 · Databases

Master RedisInsight: Install, Configure, and Deploy Redis GUI on Kubernetes

This guide explains how Redis, a high‑performance in‑memory database, works with the RedisInsight visual tool, covering its key features, step‑by‑step installation on Linux, environment‑variable configuration, service startup, Kubernetes deployment via YAML, and basic usage for monitoring, data manipulation, and memory analysis.

KubernetesRedisInsightdatabase management
0 likes · 8 min read
Master RedisInsight: Install, Configure, and Deploy Redis GUI on Kubernetes
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Aug 8, 2025 · Databases

GaussDB-Powered Database Textbook: Transforming Teaching & Practice

Facing gaps in database education, Beijing Information Technology University launched a GaussDB‑based textbook project to blend theory with hands‑on practice, producing a four‑part, thirteen‑chapter resource that covers fundamentals, SQL, design, and management, while supporting curriculum reform and industry collaboration.

Database EducationGaussDBSQL
0 likes · 10 min read
GaussDB-Powered Database Textbook: Transforming Teaching & Practice
Top Architecture Tech Stack
Top Architecture Tech Stack
Mar 10, 2025 · Databases

13 Popular MySQL Graphical Management Tools

This article presents a curated list of thirteen MySQL graphical management tools, describing their main features, platform support, and official download links, to help developers and administrators choose the most suitable GUI for database administration tasks.

DBeaverDataGripMySQL
0 likes · 8 min read
13 Popular MySQL Graphical Management Tools
Su San Talks Tech
Su San Talks Tech
Mar 4, 2025 · Databases

Master DBeaver: Free Open-Source Database Management Tool Tutorial

This guide introduces the free, open‑source DBeaver tool, explains how to download and install it, demonstrates configuring themes, creating data sources, managing tables, executing SQL, and highlights its support for many databases while noting limitations of the community edition.

DBeaverSQLTutorial
0 likes · 7 min read
Master DBeaver: Free Open-Source Database Management Tool Tutorial
macrozheng
macrozheng
Feb 26, 2025 · Databases

Boost Your SQL Workflow with Chat2DB’s AI‑Powered Database Management

This article introduces Chat2DB, an AI‑enhanced SQL client and reporting tool, walks through its key features, Docker‑based installation, practical usage with a SpringBoot‑Vue e‑commerce project, and demonstrates how its built‑in AI can generate SQL queries automatically.

AIChat2DBDocker
0 likes · 4 min read
Boost Your SQL Workflow with Chat2DB’s AI‑Powered Database Management
macrozheng
macrozheng
Dec 26, 2024 · Databases

Master DBeaver: Free Open‑Source Tool for Managing 100+ Databases

This guide introduces the open‑source DBeaver database manager, walks through downloading, installing, and configuring it, demonstrates its use with a SpringBoot3 + Vue e‑commerce project, and covers theme settings, data source creation, table operations, SQL editing, and its support for various database types.

DBeaverSQLTutorial
0 likes · 7 min read
Master DBeaver: Free Open‑Source Tool for Managing 100+ Databases
IT Services Circle
IT Services Circle
Oct 25, 2024 · Databases

Database Management Challenges in the Cloud Era and How Apache ShardingSphere Addresses Them

The article outlines the growing difficulties of managing diverse databases in cloud-native environments, introduces Apache ShardingSphere as a comprehensive open‑source solution with three core capabilities—connectivity, enhancement, and pluggability—and guides readers through a three‑step learning path from fundamentals to deployment and testing.

Database MiddlewareSQLShardingSphere
0 likes · 9 min read
Database Management Challenges in the Cloud Era and How Apache ShardingSphere Addresses Them
dbaplus Community
dbaplus Community
Sep 1, 2024 · Databases

How Do Oracle’s SQL Management Features Stack Up Against Domestic Databases?

The article examines Oracle’s comprehensive SQL management capabilities—such as parsing, plan caching, process tracing, execution plan handling, optimization, and runtime monitoring—and compares them with the features offered by major Chinese and open‑source databases, highlighting gaps, strengths, and practical recommendations for adopting domestic solutions.

OracleSQLdatabase management
0 likes · 12 min read
How Do Oracle’s SQL Management Features Stack Up Against Domestic Databases?
MaGe Linux Operations
MaGe Linux Operations
Aug 30, 2024 · Databases

Master MongoDB: From Basics to Advanced Operations

This comprehensive guide walks you through MongoDB fundamentals, installation checks, service management, user authentication, database and collection creation, and essential CRUD commands, providing clear examples and code snippets to help you efficiently manage and query your NoSQL data.

CRUDMongoDBNoSQL
0 likes · 13 min read
Master MongoDB: From Basics to Advanced Operations
Programmer DD
Programmer DD
Jul 24, 2024 · Databases

How We Cut Redis Costs by $460k Monthly: 10 Proven Optimization Strategies

In 2023, a TapTap infra team reduced Redis operating costs by 460,000 CNY per month through low‑cost ESSD instances, traffic compression, unused‑instance cleanup, TTL management, data migration, online compression, and targeted cleaning, detailing ten concrete measures and the open‑source tools that enabled zero‑downtime optimization.

Cost OptimizationData CompressionInfrastructure
0 likes · 17 min read
How We Cut Redis Costs by $460k Monthly: 10 Proven Optimization Strategies
Efficient Ops
Efficient Ops
Jun 25, 2024 · Databases

How ICBC Built a Unified Multi‑Database Test Data Management Platform

This case study details how Industrial and Commercial Bank of China's software development center tackled growing complexity, multi‑database client fragmentation, password‑storage risks, and data tampering by creating a centralized online platform that streamlines test data maintenance across thousands of databases while ensuring security and traceability.

Platformdatabase managementmulti-database
0 likes · 6 min read
How ICBC Built a Unified Multi‑Database Test Data Management Platform
JavaEdge
JavaEdge
Jan 18, 2024 · Databases

Master RedisInsight: Visualize, Manage, and Optimize Redis Seamlessly

This guide introduces RedisInsight, a powerful GUI for Redis, outlines its key features such as cluster support, visual data browsing, built‑in CLI, stream and log analysis, and provides step‑by‑step installation instructions for Linux, Kubernetes, and macOS, plus basic usage tips.

GUIKubernetesRedisInsight
0 likes · 10 min read
Master RedisInsight: Visualize, Manage, and Optimize Redis Seamlessly
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 11, 2024 · Databases

Step-by-Step Guide to Managing SQL Releases with SQLE

This article provides a detailed walkthrough of using the SQLE platform to create users, configure data sources, submit SQL tickets, perform reviews, and execute releases, illustrating each step with screenshots and practical tips for effective database change management.

MySQLSQLSQL Release
0 likes · 7 min read
Step-by-Step Guide to Managing SQL Releases with SQLE
MaGe Linux Operations
MaGe Linux Operations
Aug 12, 2023 · Databases

Master DBeaver: Install, Connect, and Generate ER Diagrams Easily

This guide introduces DBeaver, a free Java‑based database management tool, covering its cross‑platform installation, JDBC connectivity to numerous relational and NoSQL databases, step‑by‑step connection setup, driver management, and how to generate ER diagrams from existing schemas.

DBeaverER diagramJDBC
0 likes · 6 min read
Master DBeaver: Install, Connect, and Generate ER Diagrams Easily
macrozheng
macrozheng
Jun 17, 2023 · Databases

Why DBeaver Is the Free, Open-Source Database Tool Every Backend Developer Needs

This article introduces DBeaver, an open‑source, cross‑platform database management tool, outlines its key features, provides step‑by‑step usage instructions, and shares the project’s GitHub link, helping developers efficiently handle MySQL, PostgreSQL, Oracle and many other databases.

DBeaverSQLdatabase management
0 likes · 5 min read
Why DBeaver Is the Free, Open-Source Database Tool Every Backend Developer Needs
MaGe Linux Operations
MaGe Linux Operations
May 30, 2023 · Databases

Explore a Lightweight Redis GUI: Features, Setup, and Future Plans

This article introduces a lightweight Redis graphical management tool, outlines its backend (Spring Boot) and frontend (Vue) architecture, provides step‑by‑step installation instructions including Docker usage, describes current features like multi‑user management and permission control, and shares future development plans with screenshots and the project repository link.

Admin ToolGUIVue
0 likes · 4 min read
Explore a Lightweight Redis GUI: Features, Setup, and Future Plans
Laravel Tech Community
Laravel Tech Community
May 25, 2023 · Databases

Using Sequel Pro on macOS to Manage MySQL and MariaDB Databases

This article introduces Sequel Pro, a macOS GUI client for MySQL and MariaDB, explains how to configure standard connections with required fields, describes the main interface features such as database selection, table structure and content viewing, and highlights additional tools like Query and Table Info.

GUIMariaDBMySQL
0 likes · 3 min read
Using Sequel Pro on macOS to Manage MySQL and MariaDB Databases
MaGe Linux Operations
MaGe Linux Operations
Apr 10, 2023 · Databases

Master DBeaver: Install, Connect, and Generate ER Diagrams Quickly

This guide introduces DBeaver, a free Java‑based database management tool, covering its cross‑platform installation, how to create connections for databases like PostgreSQL via JDBC, and how to generate ER diagrams from existing schemas, all illustrated with step‑by‑step screenshots.

DBeaverER diagramJDBC
0 likes · 7 min read
Master DBeaver: Install, Connect, and Generate ER Diagrams Quickly
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 10, 2023 · Databases

Understanding OceanBase Recycle Bin: Retrieval, Multiple Same‑Name Tables, Visibility, and Flashback Behavior

This article explains how OceanBase's recycle bin works, covering error causes when flashing back tables, methods to obtain a table's database, handling of multiple same‑name tables, visibility across tenants, and the ability to flash back tables or tenants even after the recycle bin is disabled.

FlashbackOceanBaseRecycle Bin
0 likes · 11 min read
Understanding OceanBase Recycle Bin: Retrieval, Multiple Same‑Name Tables, Visibility, and Flashback Behavior
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 3, 2023 · Databases

SQL Quality Management with Open-Source SQLE: Insights from the 2023 DAMS China Data Intelligence Management Summit

The 2023 DAMS China Data Intelligence Management Summit in Shanghai featured a technical presentation by Zhang Shenbo on an open‑source SQLE solution for SQL quality control, covering multi‑database auditing, automated review workflows, and practical tips to reduce DBA workload and cross‑department communication.

SQLSQLEdata governance
0 likes · 3 min read
SQL Quality Management with Open-Source SQLE: Insights from the 2023 DAMS China Data Intelligence Management Summit
ITPUB
ITPUB
Mar 10, 2023 · Databases

How ICBC Secures MySQL at Scale: Insights from a Senior Database Architect

In this interview, ICBC senior manager Wei Yadong shares the bank's challenges with massive data, the five‑point criteria for database selection, the DevOps‑driven MySQL governance framework, evolving security demands, future database trends for finance, and practical advice for database professionals.

DevOpsFinancial IndustryMySQL
0 likes · 16 min read
How ICBC Secures MySQL at Scale: Insights from a Senior Database Architect
Zhuanzhuan Tech
Zhuanzhuan Tech
Feb 15, 2023 · Operations

Automating TiDB Operations at ZuanZuan: From Manual Management to Platform‑Based Automation

This article details ZuanZuan's journey of automating TiDB operations, covering the initial operational pain points, the implementation of metadata and resource management, comprehensive upgrades, alarm redesign, and the development of a work‑order‑driven platform that streamlines node, scaling, decommission, and monitoring tasks while significantly reducing manual effort and costs.

OperationsTiDBautomation
0 likes · 18 min read
Automating TiDB Operations at ZuanZuan: From Manual Management to Platform‑Based Automation
Open Source Linux
Open Source Linux
Sep 15, 2022 · Databases

Master RedisInsight: Install, Deploy on Kubernetes, and Unlock Redis Monitoring

RedisInsight is a powerful GUI for Redis that offers cluster support, SSL/TLS connections, and memory analysis; this guide walks you through its features, step‑by‑step physical and Kubernetes installations, environment configuration, service startup, and basic usage for monitoring and managing Redis instances.

KubernetesRedisInsightdatabase management
0 likes · 7 min read
Master RedisInsight: Install, Deploy on Kubernetes, and Unlock Redis Monitoring
Senior Brother's Insights
Senior Brother's Insights
Aug 8, 2022 · Databases

How to Install and Use RedisInsight for Redis Cluster Management

RedisInsight is a powerful GUI for Redis that supports cluster management, SSL connections, and memory analysis; this guide walks through downloading, installing on Linux, configuring environment variables, running as a service, deploying via Kubernetes, and using the web UI to monitor and operate Redis instances.

GUIKubernetesRedisInsight
0 likes · 7 min read
How to Install and Use RedisInsight for Redis Cluster Management
Programmer DD
Programmer DD
Jul 19, 2022 · Databases

Master RedisInsight: Install, Configure, and Use the Ultimate Redis GUI

This guide walks you through installing RedisInsight on Linux and Kubernetes, configuring environment variables, launching the service, and using its GUI to monitor Redis metrics, edit data, and analyze memory, providing step‑by‑step commands and screenshots for each stage.

GUIKubernetesRedisInsight
0 likes · 7 min read
Master RedisInsight: Install, Configure, and Use the Ultimate Redis GUI
Bilibili Tech
Bilibili Tech
Jun 17, 2022 · Operations

Profile of Chen Yang, Senior DevOps Engineer

Chen Yang, a senior DevOps engineer at Bilibili, brings over a decade of database expertise from multinational IT firms and major internet companies, having designed trillion‑scale architectures for billion‑user services, specialized in MySQL, automated and cloud‑native database operations, and holds several patented innovations.

DevOpsPatent Holdercloud native
0 likes · 1 min read
Profile of Chen Yang, Senior DevOps Engineer
Programmer DD
Programmer DD
Jun 13, 2022 · Databases

Master DataGrip: Essential Tips for Efficient Database Management

This guide walks you through installing DataGrip, configuring database connections, customizing the IDE, and leveraging its powerful SQL editing, navigation, and data import/export features, providing a comprehensive overview for developers seeking a streamlined database client experience.

DataGripIDEJetBrains
0 likes · 12 min read
Master DataGrip: Essential Tips for Efficient Database Management
Open Source Linux
Open Source Linux
Apr 2, 2022 · Databases

Mastering MySQL with Sequel Pro: A Complete Beginner's Guide

Sequel Pro is a user‑friendly MySQL client that lets you connect via standard, socket or SSH methods, configure connection details, test and save them, and then explore databases through panels for selecting schemas, viewing table structures, contents, relationships, triggers, table info, and running queries.

GUIMySQLSQL
0 likes · 3 min read
Mastering MySQL with Sequel Pro: A Complete Beginner's Guide
Java Captain
Java Captain
Mar 31, 2022 · Databases

Installing and Using RedisInsight for Redis Management

This guide explains what RedisInsight is, outlines its key features, and provides step‑by‑step instructions for installing it on a physical server or via Kubernetes, configuring environment variables, launching the service, and using the GUI to monitor and manage Redis instances.

GUIKubernetesRedisInsight
0 likes · 6 min read
Installing and Using RedisInsight for Redis Management
Java Backend Technology
Java Backend Technology
Mar 27, 2022 · Databases

How to Install and Use RedisInsight on Linux and Kubernetes

RedisInsight is a powerful GUI for Redis that offers cluster support, SSL/TLS connections, and memory analysis; this guide walks you through downloading, installing on Linux, configuring environment variables, running the service, deploying via Kubernetes, and basic usage for monitoring and managing Redis instances.

GUIKubernetesRedisInsight
0 likes · 7 min read
How to Install and Use RedisInsight on Linux and Kubernetes
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 9, 2022 · Databases

Introducing SQLE: An Open‑Source SQL Quality Control Platform with Java Application Auditing

The article presents SQLE, an open‑source SQL quality‑control tool that supports end‑to‑end development, testing, and deployment, highlights new features in version 1.2202.0—including user‑group permissions, MySQL rules, and Java application auditing—and demonstrates a step‑by‑step integration workflow with code examples and screenshots.

Java integrationSQL AuditingSQLE
0 likes · 7 min read
Introducing SQLE: An Open‑Source SQL Quality Control Platform with Java Application Auditing
Top Architect
Top Architect
Feb 24, 2022 · Databases

Using Sequel Pro on macOS to Manage MySQL and MariaDB Databases

This article introduces Sequel Pro, a lightweight macOS client for MySQL and MariaDB, explains how to configure standard connections, describes its main interface modules such as database selection, table structure, query editor, and provides visual guidance for common operations.

GUI ToolMariaDBMySQL
0 likes · 4 min read
Using Sequel Pro on macOS to Manage MySQL and MariaDB Databases
HomeTech
HomeTech
Jan 19, 2022 · Databases

Introduction to Zhijia Cloud Multi-Database Management Platform (RDS)

This article introduces the background, supported database types, key features such as unified management, query, monitoring, and health diagnostics of the Zhijia Cloud multi-database management platform (RDS), and outlines its future development plans for expanding database integration and migration capabilities.

Future PlanningHealth DiagnosisRDS
0 likes · 6 min read
Introduction to Zhijia Cloud Multi-Database Management Platform (RDS)
Architecture & Thinking
Architecture & Thinking
Nov 4, 2021 · Databases

Master MySQL: From DDL Basics to Advanced Table Constraints

This guide walks through SQL’s language categories—DDL, DML, DQL, DCL, and TCL—then demonstrates practical database and table management commands such as creating and dropping databases, defining tables with various constraints (not‑null, default, primary/foreign keys, unique, auto‑increment), and modifying or copying fields and tables.

DDLMySQLSQL
0 likes · 13 min read
Master MySQL: From DDL Basics to Advanced Table Constraints
Efficient Ops
Efficient Ops
Jul 20, 2021 · Databases

Master Redis: 13 Proven Practices to Boost Memory, Performance & Reliability

Discover a comprehensive Redis best‑practice guide covering memory optimization, performance tuning, high reliability, daily operations, resource planning, monitoring, and security, with actionable tips such as key length control, maxmemory settings, lazy‑free, connection pooling, replication strategies, and safe deployment practices.

Operationsdatabase managementperformance optimization
0 likes · 23 min read
Master Redis: 13 Proven Practices to Boost Memory, Performance & Reliability
ITPUB
ITPUB
Jun 22, 2021 · Databases

Master DataGrip: Essential Tips for Efficient Database Management

This guide walks you through installing DataGrip, configuring drivers, connecting to various databases, using its powerful SQL editor with shortcuts, customizing appearance, performing data export/import, and leveraging advanced navigation and editing features to boost productivity.

DataGripIDEJetBrains
0 likes · 12 min read
Master DataGrip: Essential Tips for Efficient Database Management
Python Programming Learning Circle
Python Programming Learning Circle
Jun 21, 2021 · Databases

Comprehensive Guide to Using DataGrip for Database Management

This article provides a detailed, step‑by‑step tutorial on installing, configuring, and using JetBrains DataGrip—including connection setup, SQL editing, result navigation, data import/export, and advanced editor shortcuts—demonstrating why the tool is considered a powerful and user‑friendly database client.

DataGripIDEJetBrains
0 likes · 12 min read
Comprehensive Guide to Using DataGrip for Database Management
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Jun 12, 2021 · Databases

Which Redis GUI Reigns Supreme? A Deep Dive into 8 Popular Tools

This article compares eight Redis visualization tools—desktop clients, a web app, and an IDE plugin—detailing their features, pricing, platform support, and usability, while also showing how command‑line tricks can enhance JSON handling, helping developers choose the most efficient solution for their workflow.

GUIdatabase managementperformance
0 likes · 10 min read
Which Redis GUI Reigns Supreme? A Deep Dive into 8 Popular Tools
Programmer DD
Programmer DD
Dec 23, 2020 · Databases

13 Must-Have MongoDB GUI Tools for Efficient Database Management

This guide reviews thirteen popular MongoDB graphical tools—covering open‑source and commercial options, their key features, platform support, and download links—to help developers and DBAs choose the most suitable visual interface for managing MongoDB databases.

CompassMongoDBNoSQLBooster
0 likes · 12 min read
13 Must-Have MongoDB GUI Tools for Efficient Database Management
macrozheng
macrozheng
Nov 25, 2020 · Databases

Can MySQL Workbench Replace Navicat? Installation, Features, and Comparison

This article walks through installing MySQL Workbench, demonstrates its core database management features such as creating connections, adjusting appearance, handling tables and data, executing SQL, and managing instances, then compares it with Navicat, highlighting differences in design, backup, multi-database support, and unique capabilities.

MySQL WorkbenchNavicatdatabase management
0 likes · 6 min read
Can MySQL Workbench Replace Navicat? Installation, Features, and Comparison
Programmer DD
Programmer DD
Sep 26, 2020 · Databases

Master DBeaver: Install, Connect, and Generate ER Diagrams for Any Database

This guide walks you through downloading and installing DBeaver, setting up connections to various databases—including PostgreSQL, Oracle, and NoSQL platforms—using JDBC drivers, and creating ER diagrams, providing step‑by‑step instructions and screenshots to help you manage and visualize your data efficiently.

DBeaverER diagramJDBC
0 likes · 7 min read
Master DBeaver: Install, Connect, and Generate ER Diagrams for Any Database
Programmer DD
Programmer DD
Sep 12, 2020 · Databases

Mastering SQL Server: Essential Commands, Tips, and Advanced Techniques

This comprehensive guide covers SQL Server fundamentals and advanced operations, including database creation, table manipulation, indexing, view management, backup and restore procedures, performance tuning, replication setup, linked servers, and a collection of practical code snippets for everyday database tasks.

Performance TuningReplicationSQL Server
0 likes · 25 min read
Mastering SQL Server: Essential Commands, Tips, and Advanced Techniques
HomeTech
HomeTech
Sep 9, 2020 · Databases

Using TiDB for High-Concurrency Event Management

The article details how TiDB was deployed for the high-concurrency '818 Global Car Night' event, providing robust database solutions for real-time transactions and analytics.

Event TechnologyTiDBdatabase management
0 likes · 10 min read
Using TiDB for High-Concurrency Event Management
ITPUB
ITPUB
Mar 30, 2020 · Databases

How to Streamline MySQL Audits with the Open‑Source Yearning Platform

Yearning is an open‑source MySQL audit platform that offers query auditing, SQL review, and workflow automation, providing a web‑based interface for managing tickets, permissions, and notifications, with detailed installation and configuration instructions for quick deployment.

MySQLSQL AuditingYearning
0 likes · 7 min read
How to Streamline MySQL Audits with the Open‑Source Yearning Platform
dbaplus Community
dbaplus Community
Sep 25, 2019 · Databases

Master MySQL Backup & Disaster Recovery: Strategies, Tools, and Automation

Effective MySQL backup and disaster recovery are essential for protecting critical business data; this guide explains backup types, tools like Percona XtraBackup, scheduling, local and remote strategies, incremental processes, preparation and restoration steps, and introduces a platform for automated backup management.

MySQLXtraBackupautomation
0 likes · 26 min read
Master MySQL Backup & Disaster Recovery: Strategies, Tools, and Automation
Tencent Cloud Developer
Tencent Cloud Developer
Feb 19, 2019 · Databases

What Makes a Great Database Management Tool? Key Features and Tencent Cloud DMC Review

This article analyzes the evolving demands of modern databases, outlines essential features for remote management tools, compares open‑source and cloud‑based solutions, and evaluates Tencent Cloud’s console, DMC, and integrated phpMyAdmin, highlighting strengths, shortcomings, and future development directions.

Tencent Cloudcross-platformdatabase management
0 likes · 11 min read
What Makes a Great Database Management Tool? Key Features and Tencent Cloud DMC Review
Tencent Database Technology
Tencent Database Technology
May 9, 2018 · Databases

Optimizing Xtrabackup Recovery Process for InnoDB Databases

Xtrabackup is an open-source hot backup tool for InnoDB and XtraDB databases, offering non-blocking backups with features like fast backup speeds, reliable physical backups, and efficient disk space usage. The recovery process involves complex log parsing and page flushing mechanisms, which can be optimized to improve performance, especially for large datasets.

InnoDBPage FlushingXtraBackup
0 likes · 16 min read
Optimizing Xtrabackup Recovery Process for InnoDB Databases
ITPUB
ITPUB
Apr 8, 2018 · Databases

How to Check and Manage Oracle RAC Instances and Services with SRVCTL

This guide shows how to use SRVCTL commands and SQL queries to view the status of Oracle RAC databases, instances, services, node applications, ASM instances, and disk groups, as well as how to start and stop the entire RAC cluster safely.

ClusterOracleRAC
0 likes · 10 min read
How to Check and Manage Oracle RAC Instances and Services with SRVCTL
ITPUB
ITPUB
Oct 18, 2017 · Databases

How ZanDB Automates MySQL Backup, Task Scheduling, and Instance Management

This article outlines ZanDB's approach to standardizing MySQL environments, implementing a real‑time backup monitoring system, and building a comprehensive automation platform that includes task scheduling, host and instance management, log handling, metadata tracking, and daily maintenance to streamline DBA operations.

MySQLTask SchedulingZanDB
0 likes · 11 min read
How ZanDB Automates MySQL Backup, Task Scheduling, and Instance Management
StarRing Big Data Open Lab
StarRing Big Data Open Lab
Aug 11, 2017 · Databases

Unlock Efficient SQL Management with Waterdrop: A Complete Guide

Waterdrop is a cross‑platform SQL IDE and database management suite that offers a navigator, editor, executor, and data viewer, plus import/export and stored‑procedure testing tools, enabling developers and DBAs to efficiently browse metadata, write and format SQL, execute queries, edit data, and manage licenses.

Data ViewerETL ToolsInceptor
0 likes · 9 min read
Unlock Efficient SQL Management with Waterdrop: A Complete Guide
Java High-Performance Architecture
Java High-Performance Architecture
Nov 3, 2016 · Databases

How Uber Scaled 4,000 MySQL Instances with Docker: The Schemadock Architecture

Uber tackled the challenge of managing over 1,000 MySQL clusters by designing Schemadock, a Docker‑based solution that runs stateless MySQL containers, uses configuration‑driven topologies, and employs agents for automated deployment, monitoring, and centralized control, enabling multi‑database hosts, full automation, and unified management.

ContainerizationDockerMySQL
0 likes · 9 min read
How Uber Scaled 4,000 MySQL Instances with Docker: The Schemadock Architecture