MySQL master-slave build implementation

MySQL is a widely used relational database. When the data size expands and the importance increases, the reliability and performance of a single database are severely challenged, so there will be a master-slave database, read/write splitting and other requirements.

First, install mysql on two linux instances, preferably on an intranet machine. You can use an intranet Nic to perform synchronization, and ensure network quality and security.

1. Install common packages:

Yum-y install gcc-c ++ autoconf libjpeg-devel libpng-devel freetype-devel libxml2 libxml2-devel zlib-devel glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses- devel curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn-devel openssl-devel openldap-devel nss_ldap openldap-clients openldap-servers

Yum-y install perl-URI perl-DBI perl-String newt-perl

2. Download and install mysql

Wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.3-m3.tar.gz/from/http://mysql.he.net/

Tar-zxf mysql-5.5.3-m3.tar.gz

3. Compile and install mysql

Cd mysql-5.5.3-m3

. /Configure -- prefix =/usr/local/mysql -- enable-validator -- with-extra-charsets = complex -- enable-thread-safe-client -- with-big-tables --- readline -- with-ssl -- with-embedded-server -- enable-local-infile -- with-plugins = partition, innobase, myisammrg & make install

4. Create mysql users and data folders

/Usr/sbin/groupadd mysql

/Usr/sbin/useradd-g mysql

Chown-R mysql: mysql/usr/local/mysql
Mkdir-p/home/mysql/data

Mkdir-p/home/mysql/binlog
Mkdir-p/home/mysql/relaylog

Chown-R mysql: mysql/home/mysql /*

5. initialize the database

/Usr/local/mysql/bin/mysql_install_db -- basedir =/usr/local/mysql -- datadir =/home/mysql/data -- user = mysql

6. Create a mysql startup and shutdown script: vim/etc/init. d/mysql:

1. #! /Bin/sh
3. Mysql_port =3306
4. Mysql_username ="Root"// Modify it here
5. Mysql_password ="12345"// Modify it here
6. Function_start_mysql ()
7. {
8. Printf"Starting MySQL... \ n"
9. /Bin/sh/usr/local/mysql/bin/mysqld_safe -- defaults-file =/home/mysql/my. cnf2> &1>/Dev/null &
10. }
11. Function_stop_mysql ()
12. {
13. Printf"Stoping MySQL... \ n"
14. /Usr/local/mysql/bin/mysqladmin-u $ {mysql_username}-p $ {mysql_password}-S/tmp/mysql. sock shutdown
15. }
16. Function_restart_mysql ()
17. {
18. Printf"Restarting MySQL... \ n"
19. Function_stop_mysql
20. Sleep5
21. Function_start_mysql
22. }
23. Function_kill_mysql ()
24. {
25. Kill-9$ (Ps-ef | grep'Bin/mysqld_safe'| Grep $ {mysql_port} | awk'{Printf $2 }')
26. Kill-9$ (Ps-ef | grep'Libexec/mysqld'| Grep $ {mysql_port} | awk'{Printf $2 }')
27. }
28. If ["$1"="Start"]; Then
29. Function_start_mysql
30. Elif ["$1"="Stop"]; Then
31. Function_stop_mysql
32. Elif ["$1"="Restart"]; Then
33. Function_restart_mysql
34. Elif ["$1"="Kill"]; Then
35. Function_kill_mysql
36. Else
37. Printf"Usage:/home/mysql {start; stop; restart; kill} \ n"
38. Fi

1 2 3 Next Page