This article mainly introduces the use of basic commands in the MySQL Cluster configuration process. The example of two node connections is provided in the real-time recording. For more information, see the following.
1. check whether you should use
1. Full backup and incremental backup 1.1 full-scale backupFull-volume data is all the data in the database, and a full backup is the backup of all the data in the database.Back Up all libraries:mysqldump -uroot -p123456 -S /data/3306/mysql.sock -F -
The basic commands used for MySQL cluster configuration and the real-time operation process,
1. Check whether you should use a MySQL cluster.
Reduce the pressure on the data center nodes and process large data volumes. MySQL is distributed and one
**************************************** ******************
The first part is to build a multi-mysql service on a server.
**************************************** ******************
I. xuyan
There is a mysqld_multi command in Mysql that can be used
Onsql and MySQL Start and Stop scripts and onsqlmysql scripts
Start and stop onesql. A total of four parameters are {start | stop | restart | status}. You only need to slightly change the three file paths in the header to start and stop a single
I. Principles of MySQL master-slave Replication
1. mysql replication process: each time a write operation is executed, it will save a copy to its own database. At the same time, this write operation will also be stored in a binary log file, and save
1. Run the MySQL server as a non-privileged user
Before discussing how to start the MySQL server, let's take a look at the user identity to run the MySQL server. The server can be started manually or automatically. If you manually start it, the
1. run the MySQL server as a non-privileged user. before discussing how to start the MySQL server, let's consider the user identity to run the MySQL server. The server can be started manually or automatically. If you manually start it, the server is
I am used to installing MySQL in binary format. today I am eager to install an RPM Package for MySQL. I did not expect that I have encountered some problems. I will share with you the problems I encountered. first, I will download the installation
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.