Database
Mysql Tutorial
Detailed explanation of the steps for deploying MySQL multi-instance in Linux environment
Detailed explanation of the steps for deploying MySQL multi-instance in Linux environment
Apr 08, 2025 am 10:12 AM
The key to deploying MySQL multi-instances under Linux is to configure independent data directories and configuration files for each instance. Specific steps: 1. Create an independent instance directory; 2. Copy and modify the configuration file to ensure that the datadir and port parameters of each instance are unique; 3. Use mysql_install_db to initialize the database of each instance; 4. Register each instance as a system service for management; 5. Reasonably allocate system resources and perform performance tuning, and back up data regularly. Only by understanding the principles behind these steps can we effectively avoid errors and ensure the stable operation of multiple instances.
Play with MySQL multiple instances under Linux: A sharing of experience of an old bird
Many friends asked me how to deploy multiple MySQL instances on Linux systems, which cannot be done simply by copying and pasting. In this article, I will take you into the deep understanding of this process. It is not just a simple step, but more importantly, understanding the principles behind it and how to avoid those crazy pitfalls. After reading, you will be able to independently deploy and manage multiple MySQL instances and have a deeper understanding of the underlying mechanism of MySQL.
Basic knowledge lays the foundation: The limitations of single instances
Before we start, we need to understand why multiple instances are needed. A MySQL instance has only one listening port and can only serve one application. If you have multiple applications that require using MySQL databases, or need to isolate different database environments (such as development, testing, production), then a single instance seems to be overwhelming. Multi-instance deployment can perfectly solve this problem, making your MySQL service more flexible and robust.
Core: The magic of data directories and configuration files
The key to deploying multiple instances is to cleverly utilize data directories and configuration files. Each MySQL instance needs to have its own independent data directory (storage database files) and configuration files (my.cnf). In the configuration file, the most important parameters are datadir (data directory) and port (listening port). Remember, these two parameters must be unique in different instances.
Let's look at a practical example. Suppose we want to deploy two instances, named mysql57 and mysql80:
<code class="bash"># 創(chuàng)建兩個(gè)實(shí)例目錄<br>sudo mkdir -p /data/mysql57 /data/mysql80</code><h1> Copy the configuration files in the MySQL installation directory and modify the port and data directory</h1><p> sudo cp /etc/my.cnf /etc/my.cnf.mysql57<br> sudo cp /etc/my.cnf /etc/my.cnf.mysql80</p><h1> Modify /etc/my.cnf.mysql57</h1><p> sudo sed -i 's/port=3306/port=3307/g' /etc/my.cnf.mysql57<br> sudo sed -i 's#datadir=.*/var/lib/mysql#datadir=/data/mysql57#g' /etc/my.cnf.mysql57</p><h1> Modify /etc/my.cnf.mysql80</h1><p> sudo sed -i 's/port=3306/port=3308/g' /etc/my.cnf.mysql80<br> sudo sed -i 's#datadir=.*/var/lib/mysql#datadir=/data/mysql80#g' /etc/my.cnf.mysql80</p><h1> Initialize the database</h1><p> sudo mysql_install_db --user=mysql --datadir=/data/mysql57<br> sudo mysql_install_db --user=mysql --datadir=/data/mysql80</p><h1> Start the instance (the commands need to be adjusted according to your MySQL version and installation method)</h1><p> sudo systemctl start mysqld.mysql57<br> sudo systemctl start mysqld.mysql80</p><h1> verify</h1><p> sudo mysql -P 3307 -u root -p<br> sudo mysql -P 3308 -u root -p </p>
Code interpretation and trap evasion
In this code, we use the sed command to modify the configuration file, which is an efficient batch modification method. However, be sure to double-check the modified configuration file to ensure there are no unexpected errors. A small error may cause the instance to fail to start or even the data is corrupted.
In addition, the mysql_install_db command is used to initialize the database, which is a key step in creating a new instance. This command requires root permissions and requires the correct data directory to be specified.
Advanced Tips: System Service Management
To facilitate management, it is recommended to register each MySQL instance as a system service. This way, you can use the systemctl command to start, stop and restart the instance. The specific registration method depends on your Linux distribution and MySQL installation method, please refer to the relevant documentation.
Performance Tuning and Best Practices
Multi-instance deployment consumes a lot of system resources, so resource allocation needs to be planned reasonably. The configuration file of each instance needs to be tuned according to actual conditions, such as adjusting the cache size, limiting the number of connections, etc. At the same time, data must be backed up regularly to prevent data loss. Code specifications and comments are also important, which facilitate future maintenance and upgrades.
Summary: It's not just steps, but also understanding
Remember that deploying multiple instances of MySQL is not just about copying the steps, but more importantly, understanding the principles behind it. Only by understanding the importance of data catalogs, configuration files and system service management can we truly master this technology and be able to deal with various emergencies. I hope this article can help you successfully complete the deployment of MySQL multi-instances and provide some help for your database management path. I wish you all the best!
The above is the detailed content of Detailed explanation of the steps for deploying MySQL multi-instance in Linux environment. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
What is Bitcoin Taproot Upgrade? What are the benefits of Taproot?
Jul 30, 2025 pm 08:27 PM
Directory What is Bitcoin? How does Bitcoin work? Why is Bitcoin not scalable? What is BIP (Bitcoin Improvement Proposal)? What is Bitcoin Taproot Update? Pay to Taproot (P2TR): Benefits of Taproot: Space-saving privacy advantages Security upgrade conclusion: ?Bitcoin is the first digital currency that can send and receive funds without using a third party. Since Bitcoin is software, like any other software, it needs updates and bug fixes. Bitcoin Taproot is such an update that introduces new features to Bitcoin. Cryptocurrency is a hot topic now. People have been talking about it for years, but now with prices rising rapidly, suddenly everyone decides to join and invest in them. Message
Why does Binance account registration fail? Causes and solutions
Jul 31, 2025 pm 07:09 PM
The failure to register a Binance account is mainly caused by regional IP blockade, network abnormalities, KYC authentication failure, account duplication, device compatibility issues and system maintenance. 1. Use unrestricted regional nodes to ensure network stability; 2. Submit clear and complete certificate information and match nationality; 3. Register with unbound email address; 4. Clean the browser cache or replace the device; 5. Avoid maintenance periods and pay attention to the official announcement; 6. After registration, you can immediately enable 2FA, address whitelist and anti-phishing code, which can complete registration within 10 minutes and improve security by more than 90%, and finally build a compliance and security closed loop.
How to Schedule Tasks on Linux with Cron and anacron
Aug 01, 2025 am 06:11 AM
cronisusedforpreciseschedulingonalways-onsystems,whileanacronensuresperiodictasksrunonsystemsthataren'tcontinuouslypowered,suchaslaptops;1.Usecronforexacttiming(e.g.,3AMdaily)viacrontab-ewithsyntaxMINHOURDOMMONDOWCOMMAND;2.Useanacronfordaily,weekly,o
Why is Bitcoin with a ceiling? Why is the maximum number of Bitcoins 21 million
Jul 30, 2025 pm 10:30 PM
The total amount of Bitcoin is 21 million, which is an unchangeable rule determined by algorithm design. 1. Through the proof of work mechanism and the issuance rule of half of every 210,000 blocks, the issuance of new coins decreased exponentially, and the additional issuance was finally stopped around 2140. 2. The total amount of 21 million is derived from summing the equal-scale sequence. The initial reward is 50 bitcoins. After each halving, the sum of the sum converges to 21 million. It is solidified by the code and cannot be tampered with. 3. Since its birth in 2009, all four halving events have significantly driven prices, verified the effectiveness of the scarcity mechanism and formed a global consensus. 4. Fixed total gives Bitcoin anti-inflation and digital yellow metallicity, with its market value exceeding US$2.1 trillion in 2025, becoming the fifth largest capital in the world
Why are everyone buying stablecoins? Analysis of market trends in 2025
Aug 01, 2025 pm 06:45 PM
Stablecoins are highly favored for their stable value, safe-haven attributes and a wide range of application scenarios. 1. When the market fluctuates violently, stablecoins can serve as a safe haven to help investors lock in profits or avoid losses; 2. As an efficient trading medium, stablecoins connect fiat currency and the crypto world, with fast transaction speeds and low handling fees, and support rich trading pairs; 3. It is the cornerstone of decentralized finance (DeFi).
What are the main pros and cons of Linux vs. Windows?
Aug 03, 2025 am 02:56 AM
Linux is suitable for old hardware, has high security and is customizable, but has weak software compatibility; Windows software is rich and easy to use, but has high resource utilization. 1. In terms of performance, Linux is lightweight and efficient, suitable for old devices; Windows has high hardware requirements. 2. In terms of software, Windows has wider compatibility, especially professional tools and games; Linux needs to use tools to run some software. 3. In terms of security, Linux permission management is stricter and updates are convenient; although Windows is protected, it is still vulnerable to attacks. 4. In terms of difficulty of use, the Linux learning curve is steep; Windows operation is intuitive. Choose according to requirements: choose Linux with performance and security, and choose Windows with compatibility and ease of use.
Ethereum price trend suggests market momentum transfer: Bitcoin is sleeping, Ethereum is active
Aug 01, 2025 pm 08:00 PM
Ethereum is becoming the focus of the market, while Bitcoin is relatively quiet. 1. The rise in Ethereum prices is due to its technological upgrades (such as The Merge), deflation mechanism (EIP-1559) and active on-chain data (such as DApp usage and active address growth). 2. The deep reason for the transfer of market momentum is that Ethereum is a diversified narrative as a decentralized application platform, covering fields such as DeFi, NFT, GameFi, etc., attracting a large number of developers and users, and forming a strong ecological effect. 3. Bitcoin still plays the role of "digital gold" and emphasizes store of value, while Ethereum is more like the "digital world operating system", providing innovative application infrastructure, and the two complement each other rather than replace them. 4. In terms of technical analysis, investors can use the moving average
Why do you say you choose altcoins in a bull market and buy BTC in a bear market
Jul 30, 2025 pm 10:27 PM
The strategy of choosing altcoins in a bull market, and buying BTC in a bear market is established because it is based on the cyclical laws of market sentiment and asset attributes: 1. In the bull market, altcoins are prone to high returns due to their small market value, narrative-driven and liquidity premium; 2. In the bear market, Bitcoin has become the first choice for risk aversion due to scarcity, liquidity and institutional consensus; 3. Historical data shows that the increase in the bull market altcoins in 2017 far exceeded that of Bitcoin, and the decline in the bear market in 2018 was also greater. In 2024, funds in the volatile market will be further concentrated in BTC; 4. Risk control needs to be vigilant about manipulating traps, buying at the bottom and position management. It is recommended that the position of altcoins in a bull market shall not exceed 30%, and the position holdings of BTC in a bear market can be increased to 70%; 5. In the future, due to institutionalization, technological innovation and macroeconomic environment, the strategy needs to be dynamically adjusted to adapt to market evolution.
