Click the blue text to follow us The core goal of learning on the second day is to enable the code to have judgment and repetition capabilities. Building on the foundation from the first day (previous notes), we will expand the practicality of the code while reinforcing the knowledge already learned. Below is the modular … Read more
1. Import the required software packages: docker-27.1.2.tgz, docker-compose-linux-aarch64, xxl-job-2.4.2.zip, xxl-job-admin-arrch64_2.3.1.tar2. Install Docker: “Installing Docker & Docker-Compose on ARM64 Server” 3. Import the image file $ docker load -i xxl-job-admin-arrch64_2.3.1.tar 4. Install MySQL: “Installing MySQL on ARM Server”5. Create a database user > CREATE USER 'xxl'@'%' IDENTIFIED BY 'Apple2009@';> GRANT ALL PRIVILEGES ON *.* TO 'xxl'@'%';> … Read more
Download and Extract 1## Download the compressed package 2wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.39-1.el8.x86_64.rpm-bundle.tar 3## Upload to the server 4scp mysql-8.0.39-1.el8.x86_64.rpm-bundle.tar root@your-server:/root 5## Move to the specified directory 6mv mysql-8.0.39-1.el8.x86_64.rpm-bundle.tar /opt 7## Extract 8cd /opt 9tar -xvf mysql-8.0.39-1.el8.x86_64.rpm-bundle.tar After extraction, the following files will be available 1mysql-community-client-8.0.39-1.el8.x86_64.rpm 2mysql-community-server-8.0.39-1.el8.x86_64.rpm 3mysql-community-libs-8.0.39-1.el8.x86_64.rpm 4mysql-community-common-8.0.39-1.el8.x86_64.rpm 5mysql-community-client-plugins-8.0.39-1.el8.x86_64.rpm 6mysql-community-icu-data-files-8.0.39-1.el8.x86_64.rpm Uninstall the system-installed MariaDB (if present) 1rpm … Read more
✅ 1. <span>EXPLAIN FORMAT=JSON</span> —— In-depth Analysis of Execution Plans 🔍 Purpose Provides more detailed execution information than the standard <span>EXPLAIN</span>, including: Cost of accessing each table (<span>cost_info</span>) Details on index usage Whether temporary tables or sorting are used JOIN order and driving strategy 📌 Usage EXPLAIN FORMAT=JSON SELECT u.username, v.n_time FROM abc v JOIN … Read more
Introduction MySQL, as one of the most popular open-source relational database management systems, plays a crucial role in enterprise applications. With the continuous growth of data volume and the increasing demand for data security, high availability and data redundancy backup of databases have become particularly important. The Master-Slave Replication technology is an effective solution to … Read more
Check the SystemConfirm the version of CentOS. Generally, CentOS 7 and above are well compatible with MySQL. Use the command<span><span>cat /etc/centos-release</span></span>to check the system version.Update the SystemRun the command<span><span>yum -y update</span></span>to update the system packages, ensuring the system is up to date and reducing compatibility issues.Add MySQL Yum Repository wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm Then run<span><span>rpm -ivh mysql80-community-release-el7-3.noarch.rpm</span></span>to … Read more
👨🎓Author Introduction 🏅 High-quality creator in the cloud computing field 🏅 Expert blogger in Huawei Cloud Developer Community 🏅 Expert blogger in Alibaba Cloud Developer Community💊Community for Communication: Welcome to join the Operations and Maintenance Communication Community!🐋 Hope everyone supports us, and we can progress together! 😄🎉 If this article helps you, feel free to like 👍🏻, … Read more
1. MySQL/MariaDB Connection 1. Command Line Connection mysql -u username -p -h host_address -P port Example: mysql -u root -p -h 127.0.0.1 -P 3306 Parameter Description: <span><span>-u</span></span>: Username <span><span>-p</span></span>: Interactive password input (no space after password) <span><span>-h</span></span>: Database server IP (default is localhost) <span><span>-P</span></span>: Port (default is 3306) 2. Operations After Connection SHOW DATABASES; — … Read more
1. Background Introduction As a DBA, it is inevitable to encounter performance issues. How should we troubleshoot when we face performance problems? For instance, under high concurrency, if we experience slow business response and long processing times, how do we start the investigation? This article will analyze how to diagnose and locate issues when IO … Read more
Author: Zhang Zhengjun Working at Central European Fund, a fan of Zhishutang, a database enthusiast, familiar with various databases such as RDBMS, NoSQL, NewSQL, etc. After finishing O’Reilly’s “High Performance MySQL” and Teacher Jiang’s “MySQL Technical Insider”, along with 2-3 years of practical experience, one can essentially become a DBA capable of handling problems independently.However, … Read more