mysql数据库测试助手：从业务文档与存量 DDL 生成规范建表语句
mysql数据库测试助手（@user_1a9d72e6/mysql-design）是 SkillHub 社区 Skill，v1.0.0，分类 dev-programming。根据业务规则 .md 与存量 .sql DDL，在对话触发词下生成符合阿里巴巴规范、面向 MySQL 5.7/8.0 与阿里云 RDS 的 CREATE TABLE 设计。无需 API Key。安装需 SkillHub CLI，使用 skillhub install 并 --dir 指向 Cursor 等客户端 skills 目录。适合文档与旧库对齐新表结构，产出须人工与测试库验证。
Read Moredsh-credentials-mysql: MySQL Credential Store for DeepSeek Harness
`dsh-credentials-mysql` is a plugin-based credentials component for DeepSeek Harness, designed to address the inability of traditional local file storage to be shared across multiple instances. The plugin implements persistent credential storage using MySQL, supports AES-256-GCM field-level encryption, and enables multi-process concurrent access. Its core features include using InnoDB transactions and row locks to ensure data consistency, built-in connection pooling, and the ability to be deployed alongside other MySQL plugins in the ecosystem. Users configure database connection, encryption keys, table prefix, and other parameters via environment variables. After installation, the plugin takes over `ctx.credentials` and provides read/write capabilities consistent with local storage, making it suitable for building distributed DSH deployment environments.
Read MoreImplementing MySQL Database Master-Slave Replication
This document provides a detailed introduction to how to configure Master-Slave Replication in MySQL database, accompanied by configuration steps and simple test cases. The key points summarized are as follows: ### Configuration Steps #### 1. Select servers as master and slave - Choose one MySQL server as the master and another as the slave. #### 2. Setup on the master server - First, add the following configurations to the master's `/etc/my.cnf` or `my.ini` configuration file:
Read MoreInstalling and Using Mycat for Distributed Database on CentOS
This article provides a detailed introduction to how to install and configure Mycat in a CentOS environment to achieve basic operations of distributed databases. Below is a summary of the content in the article, along with some possible missing information or steps supplemented. ### I. Environment Preparation 1. **System Requirements**: Ensure that a Java environment (e.g., JDK8) is installed. 2. **Network Configuration**: - Open the firewall and configure rules to allow the service ports of MySQL and Mycat to pass through. - Ensure that the network connections between all nodes are smooth.
Read More