Tagged articles

8 articles

Page 1 of 1

Aug 7, 2025 · Databases

Unlock MySQL REST Service: Step‑by‑Step Installation and API Guide

This tutorial walks you through installing MySQL REST Service on Oracle Linux, configuring the metadata schema, using MySQL Shell in VS Code, loading the component, managing variables, handling X‑protocol settings, creating services, and authenticating via MRS, MySQL Internal, cookie or JWT, with full command‑line examples and code snippets.

AuthenticationJSONMySQL Shell

0 likes · 17 min read

Unlock MySQL REST Service: Step‑by‑Step Installation and API Guide

Aikesheng Open Source Community

Oct 12, 2023 · Databases

How to Import Large Volumes of Data into MySQL: Tools, Commands, and Performance Tips

This article compares various MySQL data import/export methods—including mysqldump, mydumper, SELECT OUTFILE, and MySQL Shell utilities—explaining their commands, configuration options, performance results, and best‑practice recommendations based on testing with a 10‑million‑row table.

ExportMySQL ShellSELECT OUTFILE

0 likes · 16 min read

How to Import Large Volumes of Data into MySQL: Tools, Commands, and Performance Tips

Aikesheng Open Source Community

Jan 11, 2023 · Databases

Collecting MySQL Diagnostic Reports with MySQL Shell 8.0.31 util.debug

The article explains how MySQL Shell 8.0.31's util.debug component provides built‑in functions to gather comprehensive diagnostic data—including error logs, replica status, InnoDB metrics, and OS metrics—and demonstrates practical command‑line examples for generating and analyzing zip‑packed diagnostic reports.

Database AdministrationMySQL Shellcollect_diagnostics

0 likes · 8 min read

Collecting MySQL Diagnostic Reports with MySQL Shell 8.0.31 util.debug

Aikesheng Open Source Community

Oct 26, 2022 · Databases

Using run_sql and sql Functions in MySQL Shell: Differences and Practical Examples

This article explains the functional differences between the run_sql and sql commands in MySQL Shell, demonstrates how to execute DDL/DML statements, bind variables, and retrieve results using both commands, and provides guidance on selecting the appropriate function for various use cases.

MySQL ShellSQLSQL Execution

0 likes · 7 min read

Using run_sql and sql Functions in MySQL Shell: Differences and Practical Examples

Aikesheng Open Source Community

Apr 27, 2021 · Databases

Efficient Data Import with MySQL Shell import_table and Its Performance Compared to LOAD DATA

This article introduces MySQL Shell’s import_table utility, demonstrates its core features and configuration options such as parallel import, speed throttling, and custom chunk sizes, provides side‑by‑side command examples with LOAD DATA, and shows that import_table can achieve more than double the import speed in practical tests.

MySQL Shelldata importimport_table

0 likes · 10 min read

Efficient Data Import with MySQL Shell import_table and Its Performance Compared to LOAD DATA

Aikesheng Open Source Community

Nov 10, 2020 · Databases

Custom Row Input with MySQL Shell util.import_table and decodeColumns in MySQL 8.0.22

The article explains how MySQL 8.0.22 enhances the util.import_table function with the decodeColumns option, allowing users to preprocess each row during import, replace load data statements, and customize column values directly within MySQL Shell.

MySQL Shelldata importdecodeColumns

0 likes · 4 min read

Custom Row Input with MySQL Shell util.import_table and decodeColumns in MySQL 8.0.22

Aikesheng Open Source Community

Feb 24, 2020 · Databases

How to Build and Manage MySQL InnoDB Replica Sets with MySQL Shell & Router

This guide walks through preparing the environment, configuring MySQL instances, creating an InnoDB ReplicaSet using MySQL Shell, adding replicas, setting up MySQL Router for read/write splitting, testing connections, and performing common management tasks such as promoting a primary and removing or re‑adding nodes.

Database AdministrationInnoDB ReplicaSetMySQL Router

0 likes · 12 min read

How to Build and Manage MySQL InnoDB Replica Sets with MySQL Shell & Router

Java High-Performance Architecture

Apr 25, 2017 · Databases

How to Build a Multi‑Node MySQL InnoDB Cluster from Scratch

This step‑by‑step guide explains how to set up a high‑availability MySQL InnoDB Cluster across four Linux servers, covering sandbox testing, installing MySQL, MySQL Shell, and MySQL Router, configuring each node, creating the cluster, adding instances, and connecting clients via the router.

InnoDB ClusterMySQL RouterMySQL Shell

0 likes · 10 min read

How to Build a Multi‑Node MySQL InnoDB Cluster from Scratch