Mysql DBA Advanced Operations Learning Note-mysql5.5 Compilation method installation Combat

This article is the third section of the old boy MySQL DBA Advanced OPS course to learn the notes, thanks to the old boy teacher, I
is a rookie if there is an incorrect written place please the great God timely guidance.

4. Source code CMake way to compile and install MySQL5.5.32

4.1 Download MySQL installation package

MySQL uses the CMake installation method starting from 5.3.

The actual combat selection mysql5.5.32

MySQL Series
Http://dev.mysql.com/downloads/mysql/5.5.html#downloads

Download CMake
wget http://www.cmake.org/files/v2.8/cmake-2.8.8.tar.gz

4.2 Viewing the system environment

[[email protected] ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.7 (Santiago)[[email protected] ~]# uname -mx86_64[[email protected] ~]# uname -r2.6.32-573.el6.x86_64

4.3 Installing CMake
[Email protected] ~]# mkdir-p/HOME/ZBF

[[email protected] ~]# mkdir -p /home/zbf/tools[[email protected] ~]# cd /home/zbf/tools/[[email protected] tools]# tar -zxf cmake-2.8.8.tar.gz [[email protected] tools]# cd cmake-2.8.8[[email protected] cmake-2.8.8]# ./configure

Hint to install with gmake, with make also can

[[email protected] cmake-2.8.8]# gmake[[email protected] cmake-2.8.8]# gmake install

Install dependent packages

[[email protected] tools]# yum install ncurses-devel -y

4.5 Starting MySQL Installation

4.5.1 Creating users and Groups

[[email protected] tools]# groupadd mysql[[email protected] tools]# useradd -g mysql mysql

4.5.2 Decompression compiled MySQL

[[email protected] tools]# tar-zxf mysql-5.5.32.tar.gz[[email protected] tools]# CD Mysql-5.5.32[[email  protected] mysql-5.5.32] #cmake. -dcmake_install_prefix=/usr/local/mysql #指定安装目录-dmysql_datadir=/usr/local/mysql/data #指定数据存放目录重要-DMYSQL_UNIX_A Ddr=/usr/local/mysql/tmp/mysql.sock #指定sock路径-ddefault_charset=utf8 #指定默认字符集-ddefault_collation=utf8_general_ci # Specifies the calibration character set encoding-dextra_charsets=all #安装所需字符集-denabled_local_infile=on #启用加载本地数据-dwith_innobase_storage_engine=1 #支持i Nnode engine-dwith_federated_storage_engine=1 #支持federated引擎-dwith_blackhole_storage_engine=1 #支持黑洞存储引擎-dwithout_     Example_storage_engine=1-dwithout_partition_storage_engine=1 #支持安装数据库分区-dwith_fast_mutexes=1-dwith_zlib=bundled  #zlib压缩模式-denabled_local_infile=1-dwith_readline=1-dwith_embedded_server=1-dwith_debug=0 #禁用debug, turn on impact performance [[email protected] mysql-5.5.32]# make && make install[[email protected] mysql-5.5.32]# ln-s/home/ Zbf/tools/mysql-5.5.32/usr/local/mysql/ 

Special Note: The installation method of the general configure compiling method and the installation of the compiler-free way, and so on, are different in the above process, the same as below.

4.5.3 initializing the configuration of MySQL

4.5.3.1 Viewing the default template configuration file

[[email protected] mysql-5.5.32]# ll support-files/my*cnf-rw-r--r--. 1 root root  4723 1月  11 19:03 support-files/my-huge.cnf-rw-r--r--. 1 root root 19791 1月  11 19:03 support-files/my-innodb-heavy-4G.cnf-rw-r--r--. 1 root root  4697 1月  11 19:03 support-files/my-large.cnf-rw-r--r--. 1 root root  4708 1月  11 19:03 support-files/my-medium.cnf-rw-r--r--. 1 root root  2872 1月  

4.5.3.2 Selecting a configuration file

Configuration file Many of us choose a small one because it's a test environment

[[email protected] mysql-5.5.32]# cp support-files/my-small.cnf /etc/my.cnfcp：是否覆盖"/etc/my.cnf"？ y

4.5.3.3 Configuring environment variables

[[email protected] mysql-5.5.32]# echo ‘export PATH=/usr/local/mysql/bin:$PATH‘ >> /etc/profile[[email protected] mysql-5.5.32]# tail -1 /etc/profileexport PATH=/usr/local/mysql/bin:$PATH[[email protected] mysql-5.5.32]# source /etc/profile[[email protected] mysql-5.5.32]# echo $PATH/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

Be sure to put the/usr/local/mysql/bin in front of you, because there is likely to be a yum installed client in the system installed later. If you don't put/usr/local/

Mysql/bin is placed in front of the MySQL command that calls system RPM when we enter MySQL. Here is an example of a configuration environment variable, the following example from the old boy teacher's blog. You can take a look at http://blog.51cto.com/oldboy/1122867.

4.5.3.4 Initializing data files

#已经有了, no words create a MySQL data file directory

[[email protected] mysql-5.5.32]# ll /usr/local/mysql/data/总用量 4drwxr-xr-x. 2 root root 4096 1月  11 19:17 test

#授权mysql用户访问mysql的安装目录

[[email protected] mysql-5.5.32]# chown -R mysql.mysql /usr/local/mysql/data/

#调整/tmp permission, otherwise the initialization will be wrong

[[email protected] mysql-5.5.32]# chmod -R 1777 /tmp/

#初始化注意这个初始化和5.1 not the same, under scripts.

[[email protected] mysql-5.5.32]# cd /usr/local/mysql/scripts/[[email protected] scripts]# ./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysql

Now that the MySQL installation is complete, we must look at the initialized information after the installation, because it

Give us a hint of a lot of information.

Installing MySQL system tables...##### #初始化成功的关键是有两个OK, there are generally two OK to indicate the success of the initialization, there is a warning without tube okfilling help tables ... ok## #这个是启动脚本, prompted for the copy startup script to start Mysqlto start mysqld at boot time, which has to Copysupport-files/mysql.server For your systemplease REMEMBER to SET A PASSWORD for the MySQL root USER! To does, start the server, then issue the following commands:#### #mysql没有密码可以改密码/usr/local/mysql//bin/mysqladmin-u root Password ' new-password '/usr/local/mysql//bin/mysqladmin-u root-h mysql password ' new-password ' alternatively you can Run:/usr/local/mysql//bin/mysql_secure_installationwhich would also give you the option of removing the testdatabases and a  Nonymous user created by default. This isstrongly recommended for production servers. See the Manual for more instructions.### #如果想启动mysql, can start with the following method of the MySQL daemon with:cd/usr/local/mysql/; /usr/local/mysql//bin/mysqld_safe &## #如果想测试可以用这个方法测试You can test the MySQL daemon with mysql-test-run.plcd/usr/ Local/mysql//mysqL-test; Perl mysql-test-run.pl## #如果想汇报bug可以用这个方法汇报bugPlease Report no problems with The/usr/local/mysql//scripts/mysqlbug script!

4.5.3.5 copy MySQL startup script, start MySQL

[[email protected] mysql-5.5.32]# cp support-files/mysql.server /etc/init.d/mysqld[[email protected] mysql-5.5.32]# chmod +x /etc/init.d/mysqld [[email protected] mysql-5.5.32]# /etc/init.d/mysqld startStarting MySQL.. SUCCESS![[email protected] ~]# chkconfig mysqld on[[email protected] ~]# chkconfig --list mysqldmysqld  0:关闭    1:关闭    2:启用    3:启用    4:启用    5:启用    6:关闭

4.6 Simple optimization

4.6.1 Clear and modify Admin user

ysql> select user,host from mysql.user;+------+-----------+| user | host  |+------+-----------+| root | 127.0.0.1 || root | ::1   ||  | localhost || root | localhost ||  | mysql || root | mysql |+------+-----------+6 rows in set (0.01 sec)mysql> delete from mysql.user where user="";Query OK, 2 rows affected (0.07 sec) mysql> delete from mysql.user where host="mysql";Query OK, 1 row affected (0.00 sec)mysql> delete from mysql.user where host="::1";Query OK, 1 row affected (0.00 sec)

4.6.2 Deleting the test library

mysql> show databases;+--------------------+| Database   |+--------------------+| information_schema || mysql  || performance_schema || test   |+--------------------+4 rows in set (0.01 sec)mysql> drop database test;Query OK, 0 rows affected (0.11 sec)

4.6.3 quit MySQL and change the password for MySQL

It's easy to change the password. The preceding initialization information has been explained

[[email protected] ~]# /usr/local/mysql//bin/mysqladmin -u root password ‘123456‘[[email protected] ~]# mysql -uroot -p123456

Mysql DBA Advanced Operations Learning Note-mysql5.5 Compilation method installation Combat