• ADADADADAD

    Percona MySQL 5.5 Linux通用二进制包安装(CentOS 6.9)[ mysql数据库 ]

    mysql数据库 时间:2024-12-03 12:12:43

    作者:文/会员上传

    简介:

    创建软件安装目录
    mkdir /mysql_software_55

    下载软件
    Percona官网的下载页面有两个二进制Tar包,分别对应不同的发行版本
    ssl100 - Debian/Ubuntu
    ssl101 - for CentOS 6 an

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。

    创建软件安装目录
    mkdir /mysql_software_55

    下载软件
    Percona官网的下载页面有两个二进制Tar包,分别对应不同的发行版本
    ssl100 - Debian/Ubuntu
    ssl101 - for CentOS 6 and CentOS 7

    解压安装包
    tar xvfz Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101.tar.gz -C /mysql_software_55/

    创建mysql用户
    useradd mysql

    创建数据目录、日志目录和临时目录
    mkdir -p /mysql_55_3306/data
    mkdir -p /mysql_55_3306/log
    mkdir -p /mysql_55_3306/tmp

    创建错误日志
    touch /mysql_55_3306/log/error.log

    chown -R mysql.mysql /mysql_55_3306

    编辑配置文件
    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

    初始化MySQL数据库的数据文件路径,并且创建系统表
    删除Percona-Server-5.5.58-rel38.10-Linux.x86_64.ssl101目录,将软件文件移动到上一级目录,否则初始化的时候会报错
    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/

    执行初始化
    [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.

    启动 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
    root10302 10278 0 10:11 pts/100:00:00 su - mysql
    mysql10303 10302 0 10:11 pts/100:00:00 -bash
    mysql21952 10303 0 10:45 pts/100:00:00 tailf error.log
    root21953 1960 0 10:45 pts/000:00:00 /bin/sh bin/mysqld_safe --defaults-file=/etc/my_55_3306.cn
    mysql23005 21953 0 10:45 pts/000: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
    root23051 1960 0 10:46 pts/000:00:00 grep mysql
    Percona MySQL 5.5 Linux通用二进制包安装(CentOS 6.9).docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: centos安装linux