Shulou(Shulou.com)06/01 Report--

Create a software installation directory

Mkdir / mysql_software_55

Download software

The download page of the Percona official website has two binary Tar packages, corresponding to different distributions.

Ssl100-Debian/Ubuntu

Ssl101-for CentOS 6 and CentOS 7

Extract the installation package

Tar xvfz Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101.tar.gz-C / mysql_software_55/

Create a mysql user

Useradd mysql

Create data directories, log directories, and temporary directories

Mkdir-p / mysql_55_3306/data

Mkdir-p / mysql_55_3306/log

Mkdir-p / mysql_55_3306/tmp

Create an error log

Touch / mysql_55_3306/log/error.log

Chown-R mysql.mysql / mysql_55_3306

Edit configuration file

Vim / etc/my_55_3306.cn

[client]

Port = 3306

Socket = / mysql_55_3306/tmp/mysql.sock

# The MySQL server

# Basic#

[mysqld]

Server-id = 101

Port = 3306

User = mysql

Basedir = / mysql_software_55/

Datadir = / mysql_55_3306/data

Tmpdir = / mysql_55_3306/tmp

Socket = / mysql_55_3306/tmp/mysql.sock

Skip-external-locking

Skip-name-resolve

Default-storage-engine = INNODB

Character-set-server = utf8

Wait_timeout = 100

Connect_timeout = 20

Interactive_timeout = 100

Back_log = 500,

Myisam_recover

Event_scheduler = ON

# binlog#

Log-bin = / mysql_55_3306/log/mysql-bin

Binlog_format = row

Max_binlog_size = 128m

Binlog_cache_size = 2m

Expire-logs-days = 5

# replication#

Slave-net-timeout = 10

# rpl_semi_sync_master_enabled = 1

# rpl_semi_sync_master_wait_no_slave = 1

# rpl_semi_sync_master_timeout = 1000

# rpl_semi_sync_slave_enabled = 1

Skip-slave-start

Log_slave_update = 1

Relay_log_recovery = 1

# slow log#

Slow_query_log = 0

Slow_query_log_file = / mysql_55_3306/log/mysql_slow.log

Long_query_time = 2

# error log#

Log-error = / mysql_55_3306/log/error.log

General_log = 0

General_log_file = / mysql_55_3306/log/general_query.log

# per_thread_buffers#

Max_connections = 1024

Max_user_connections = 1000

Max_connect_errors = 10000

Key_buffer_size = 10m

Max_allowed_packet = 128m

Table_cache = 3096

Table_open_cache = 6144

Table_definition_cache = 4096

Sort_buffer_size = 512K

Read_buffer_size = 512K

Read_rnd_buffer_size = 512K

Join_buffer_size = 512K

Tmp_table_size = 64m

Max_heap_table_size = 64m

Query_cache_type = 0

Query_cache_size = 0

Bulk_insert_buffer_size = 32m

Thread_cache_size = 64

Thread_concurrency = 32

Thread_stack = 256K

# InnoDB#

Innodb_data_home_dir = / mysql_55_3306/data

Innodb_log_group_home_dir = / mysql_55_3306/log

Innodb_data_file_path = ibdata1:2G:autoextend

Innodb_buffer_pool_size = 128m

Innodb_buffer_pool_instances = 1

Innodb_additional_mem_pool_size = 2m

Innodb_log_file_size = 512m

Innodb_log_buffer_size = 10m

Innodb_log_files_in_group = 3

Innodb_flush_log_at_trx_commit = 2

Innodb_lock_wait_timeout = 10

Innodb_sync_spin_loops = 40

Innodb_max_dirty_pages_pct = 90

Innodb_support_xa = 1

Innodb_thread_concurrency = 0

Innodb_thread_sleep_delay = 500,

Innodb_file_io_threads = 4

Innodb_concurrency_tickets = 1000

Log_bin_trust_function_creators = 1

Innodb_flush_method = O_DIRECT

Innodb_file_per_table

Innodb_read_io_threads = 16

Innodb_write_io_threads = 16

Innodb_io_capacity = 2000

Innodb_file_format = Barracuda

Innodb_purge_threads = 1

Innodb_purge_batch_size = 32

Innodb_old_blocks_pct = 75

Innodb_change_buffering = all

Transaction_isolation = READ-COMMITTED

Initialize the data file path of the MySQL database and create the system table

Delete the Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101 directory and move the software files to a higher level directory, otherwise an error will be reported during initialization

Cd / mysql_software_55/Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101

[root@MySQL01 Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101] # mv *..

[root@MySQL01 Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101] # cd..

[root@MySQL01 mysql_software_55] # rmdir Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101/

Perform initialization

[root@MySQL01 mysql_software_55] # / scripts/mysql_install_db-- user=mysql-- basedir=/mysql_software_55/-- datadir=/mysql_55_3306/data/

WARNING: The host 'MySQL01' could not be looked up with resolveip.

This probably means that your libc libraries are not 100% compatible

With this binary MySQL version. The MySQL daemon, mysqld, should work

Normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames

When specifying MySQL privileges!

Installing MySQL system tables...

171214 9:56:46 [Note] Ignoring-- secure-file-priv value as server is running with-- bootstrap.

171214 9:56:46 [Note] / mysql_software_55//bin/mysqld (mysqld 5.5.58-38.10) starting as process 9175.

OK

Filling help tables...

171214 9:56:47 [Note] Ignoring-- secure-file-priv value as server is running with-- bootstrap.

171214 9:56:47 [Note] / mysql_software_55//bin/mysqld (mysqld 5.5.58-38.10) starting as process 9182.

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:

/ mysql_software_55//bin/mysqladmin-u root password' new-password'

/ mysql_software_55//bin/mysqladmin-u root-h MySQL01 password' new-password'

Alternatively you can run:

/ mysql_software_55//bin/mysql_secure_installation

Which will also give you the option of removing the test

Databases and anonymous user created by default. This is

Strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

Cd / mysql_software_55/; / mysql_software_55//bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

Cd / mysql_software_55//mysql-test; perl mysql-test-run.pl

Please report any problems at

Https://bugs.launchpad.net/percona-server/+filebug

Percona recommends that all production deployments be protected with a support

Contract (http://www.percona.com/mysql-suppport/) to ensure the highest uptime

Be eligible for hot fixes, and boost your team's productivity.

Start MySQL

[root@MySQL01 mysql_software_55] # bin/mysqld_safe-- defaults-file=/etc/my_55_3306.cn &

[1] 21953

[root@MySQL01 mysql_software_55] # ps-ef | grep mysql

Root 10302 10278 0 10:11 pts/1 00:00:00 su-mysql

Mysql 10303 10302 0 10:11 pts/1 00:00:00-bash

Mysql 21952 10303 0 10:45 pts/1 00:00:00 tailf error.log

Root 21953 1960 0 10:45 pts/0 00:00:00 / bin/sh bin/mysqld_safe-defaults-file=/etc/my_55_3306.cn

Mysql 23005 21953 0 10:45 pts/0 00:00:00 / mysql_software_55/bin/mysqld-defaults-file=/etc/my_55_3306.cn-basedir=/mysql_software_55/-datadir=/mysql_55_3306/data-plugin-dir=/mysql_software_55//lib/mysql/plugin-user=mysql-log-error=/mysql_55_3306/log/error.log-pid-file=/mysql_55_3306/data/MySQL01.pid-socket= / mysql_55_3306/tmp/mysql.sock-- port=3306

Root 23051 1960 0 10:46 pts/0 00:00:00 grep mysql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.