Mysql多主一从配置(外国英语资料).docVIP

Mysql多主一从配置 Take two masters one for one as an example, The two master MySQL Server is configured as normal, and the only thing to note is that the ports need to be aligned with the ports that correspond to the database configuration from the server Modify the /etc/my.cnf document Change port=3306 to port=3307 or port accordingly The MySQL compilation and installation standards process is as follows Install MySQL This article uses the binary installation method, the basic order and the MySQL official order is similar, only some places do some explanation. Shell groupadd MySQL Shell, useradd, -g, mysql, MySQL Shell CD /usr/local Shell tar -xvzf /path/to/mysql-VERSION-OS.tar.gz Shell MKDIR /usr/local/mysql Shell, CP, -rf, /path/to/mysql-VERSION-OS, /usr/local/mysql Shell CD /usr/local/mysql Shell, chown, -R, MySQL Shell, chgrp, -R, MySQL Shell scripts/mysql_install_db --user=mysql Shell, chown, -R, root Shell, chown, -R, mysql, data Shell, bin/mysqld_safe, --user=mysql The first few steps are generally not a problem, but the last step is to execute bin/mysqld_safe --user=mysql the system went wrong: Starting, mysqld, daemon, with, databases, from, /var/lib/mysql STOPPING, server, from, PID, file, /var/run/mysqld/mysqld.pid 090930 12:19:32 mysqld ended And then its over, the reason for this problem, we can see in the log file /var/log/mysqld.log 090930 12:19:31 mysqld started 090930, 12:19:31, [Warning], option,thread_stack: unsigned, value, 126976, adjusted, to, 131072 090930 12:19:32 InnoDB: Started; log sequence number 043655 090930, 12:19:32, [ERROR], /usr/local/mysql/bin/mysqld:, Cant, create/write, to, file,/var/run/mysqld/mysqld.pid(Errcode:, 2) The 12:19:32 [ERROR] Cant start server: cant create PID file: No such or file directory 090930 12:19:32 mysqld ended It is not right, there are two solutions, one is to build a MySQL have permission to read and write the /var/run/mysqld/ folder; another way, we can use /usr/local/mysql/support-files/mysql.server to sta