Percona-Server装配记录
Percona-Server安装记录
本文档记录安装Percona-Server开发环境，非生产环境使用
1.下载Percona-Server-5.5.38-rel35.2-674.Linux.x86_64.tar.gz
下载地址
http://www.percona.com/downloads/Percona-Server-5.5/Percona-Server-5.5.38-35.2/binary/tarball/
2. 执行安装脚本
cd script
./mysql_install_db --user=admin --basedir=/home/admin/jyp/mysql --datadir=/home/admin/jyp/mysql/data
可能会出现如下错误提示，忽略：
写道
[admin@v125048147 scripts]$ ./mysql_install_db --user=admin --basedir=/home/admin/jyp/mysql --datadir=/home/admin/jyp/mysql/data
Installing MySQL system tables...
Error in my_thread_global_end(): 1 threads didn't exit
OK
Filling help tables...
Error in my_thread_global_end(): 1 threads didn't exit
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/home/admin/jyp/mysql/bin/mysqladmin -u root password 'new-password'
/home/admin/jyp/mysql/bin/mysqladmin -u root -h v125048147.bja password 'new-password'
Installing MySQL system tables...
Error in my_thread_global_end(): 1 threads didn't exit
OK
Filling help tables...
Error in my_thread_global_end(): 1 threads didn't exit
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/home/admin/jyp/mysql/bin/mysqladmin -u root password 'new-password'
/home/admin/jyp/mysql/bin/mysqladmin -u root -h v125048147.bja password 'new-password'
3. 启动mysql
下面是最简单的启动方法：
[admin@v125048147 mysql]$ ./bin/mysqld_safe --user=yunpeng --basedir=/home/admin/jyp/mysql --datadir=/home/admin/jyp/mysql/data 140728 23:05:06 mysqld_safe Logging to '/home/admin/jyp/mysql/data/v125048147.bja.err'. 140728 23:05:06 mysqld_safe Starting mysqld daemon with databases from /home/admin/jyp/mysql/data
在日志可以看到如下信息，启动成功：
写道
140728 23:03:29 mysqld_safe mysqld from pid file /home/admin/jyp/mysql/data/v125048147.bja.pid ended
140728 23:05:06 mysqld_safe Starting mysqld daemon with databases from /home/admin/jyp/mysql/data
140728 23:05:06 [Note] Plugin 'FEDERATED' is disabled.
140728 23:05:06 InnoDB: The InnoDB memory heap is disabled
140728 23:05:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140728 23:05:06 InnoDB: Compressed tables use zlib 1.2.3
140728 23:05:06 InnoDB: Using Linux native AIO
140728 23:05:06 InnoDB: Initializing buffer pool, size = 128.0M
140728 23:05:06 InnoDB: Completed initialization of buffer pool
140728 23:05:06 InnoDB: highest supported file format is Barracuda.
140728 23:05:06 InnoDB: Waiting for the background threads to start
140728 23:05:07 Percona XtraDB (http://www.percona.com) 5.5.38-35.2 started; log sequence number 1597945
140728 23:05:07 [Note] Event Scheduler: Loaded 0 events
140728 23:05:07 [Note] /home/admin/jyp/mysql/bin/mysqld: ready for connections.
Version: '5.5.38-35.2' socket: '/tmp/mysql.sock' port: 3306 Percona Server (GPL), Release 35.2, Revision 674
140728 23:05:06 mysqld_safe Starting mysqld daemon with databases from /home/admin/jyp/mysql/data
140728 23:05:06 [Note] Plugin 'FEDERATED' is disabled.
140728 23:05:06 InnoDB: The InnoDB memory heap is disabled
140728 23:05:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140728 23:05:06 InnoDB: Compressed tables use zlib 1.2.3
140728 23:05:06 InnoDB: Using Linux native AIO
140728 23:05:06 InnoDB: Initializing buffer pool, size = 128.0M
140728 23:05:06 InnoDB: Completed initialization of buffer pool
140728 23:05:06 InnoDB: highest supported file format is Barracuda.
140728 23:05:06 InnoDB: Waiting for the background threads to start
140728 23:05:07 Percona XtraDB (http://www.percona.com) 5.5.38-35.2 started; log sequence number 1597945
140728 23:05:07 [Note] Event Scheduler: Loaded 0 events
140728 23:05:07 [Note] /home/admin/jyp/mysql/bin/mysqld: ready for connections.
Version: '5.5.38-35.2' socket: '/tmp/mysql.sock' port: 3306 Percona Server (GPL), Release 35.2, Revision 674