56,682
社区成员
发帖
与我相关
我的任务
分享
[root@vm10-136-50-8 home]# sudo yum install mysql-community-server
Loaded plugins: fastestmirror
Setting up Install Process
Repository base is listed more than once in the configuration
Repository extras is listed more than once in the configuration
Repository centosplus is listed more than once in the configuration
Repository contrib is listed more than once in the configuration
Loading mirror speeds from cached hostfile
* base: mirror.bit.edu.cn
* extras: mirror.bit.edu.cn
* updates: mirror.bit.edu.cn
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.6.27-2.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.27-2.el7 for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) = 5.6.27-2.el7 for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: systemd for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: systemd for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: libnuma.so.1(libnuma_1.2)(64bit) for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: libnuma.so.1(libnuma_1.1)(64bit) for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: libnuma.so.1()(64bit) for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: libaio.so.1()(64bit) for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Running transaction check
---> Package libaio.x86_64 0:0.3.107-10.el6 will be installed
---> Package mysql-community-client.x86_64 0:5.6.27-2.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) = 5.6.27-2.el7 for package: mysql-community-client-5.6.27-2.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.6.27-2.el7 will be installed
---> Package mysql-community-server.x86_64 0:5.6.27-2.el7 will be installed
--> Processing Dependency: systemd for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: systemd for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) for package: mysql-community-server-5.6.27-2.el7.x86_64
---> Package numactl.x86_64 0:2.0.9-2.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.6.27-2.el7 will be installed
---> Package mysql-community-server.x86_64 0:5.6.27-2.el7 will be installed
--> Processing Dependency: systemd for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: systemd for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Processing Dependency: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Finished Dependency Resolution
Error: Package: mysql-community-server-5.6.27-2.el7.x86_64 (mysql56-community)
Requires: systemd
Error: Package: mysql-community-server-5.6.27-2.el7.x86_64 (mysql56-community)
Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit)
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
[root@vm10-136-50-8 home]# yum install libstdc*
Loaded plugins: fastestmirror
Setting up Install Process
Repository base is listed more than once in the configuration
Repository extras is listed more than once in the configuration
Repository centosplus is listed more than once in the configuration
Repository contrib is listed more than once in the configuration
Loading mirror speeds from cached hostfile
* base: mirror.bit.edu.cn
* extras: mirror.bit.edu.cn
* updates: mirror.bit.edu.cn
Package libstdc++-4.4.7-16.el6.x86_64 already installed and latest version
No package libstdc++6_4.7.2-5_amd64.deb available.
No package libstdc++6_4.7.2-5_i386.deb available.
No package libstdc++.so.6.0.17.tar.gz available.
Nothing to do
[root@localhost /]# yum -y install gcc gcc-c++ ncurses ncurses-devel cmake bison cmake
[root@localhost /]# cd /usr/local/
[root@localhost local]# groupadd -r mysql && useradd -r -g mysql -s /sbin/nologin -m mysql
[root@localhost local]# mkdir -p /data/mysql
[root@localhost local]# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.20.tar.gz
[root@localhost local]# tar -axvf mysql-boost-5.7.20.tar.gz
[root@localhost local]# cd mysql-5.7.20/
[root@localhost mysql-5.7.20]# cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/data/mysql \
-DWITH_BOOST=./boost \
-DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLE_DTRACE=0 \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_EMBEDDED_SERVER=1
[root@localhost mysql-5.7.20]# make -j `grep processor /proc/cpuinfo | wc -l`
[root@localhost mysql-5.7.20]# make install
[root@localhost mysql-5.7.20]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@localhost mysql-5.7.20]# chmod +x /etc/init.d/mysqld
[root@localhost mysql-5.7.20]# systemctl enable mysqld
[root@localhost mysql-5.7.20]# cat > /etc/my.cnf << EOF
[client]
port = 3306
socket = /dev/shm/mysql.sock
[mysqld]
port = 3306
socket = /dev/shm/mysql.sock
basedir = /usr/local/mysql
datadir = /data/mysql
pid-file = /data/mysql/mysql.pid
user = mysql
bind-address = 0.0.0.0
server-id = 1
init-connect = 'SET NAMES utf8mb4'
character-set-server = utf8mb4
#skip-name-resolve
#skip-networking
back_log = 300
max_connections = 1000
max_connect_errors = 6000
open_files_limit = 65535
table_open_cache = 128
max_allowed_packet = 4M
binlog_cache_size = 1M
max_heap_table_size = 8M
tmp_table_size = 16M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 8M
key_buffer_size = 4M
thread_cache_size = 8
query_cache_type = 1
query_cache_size = 8M
query_cache_limit = 2M
ft_min_word_len = 4
log_bin = mysql-bin
binlog_format = mixed
expire_logs_days = 30
log_error = /data/mysql/mysql-error.log
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /data/mysql/mysql-slow.log
performance_schema = 0
explicit_defaults_for_timestamp
#lower_case_table_names = 1
skip-external-locking
default_storage_engine = InnoDB
#default-storage-engine = MyISAM
innodb_file_per_table = 1
innodb_open_files = 500
innodb_buffer_pool_size = 64M
innodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb_thread_concurrency = 0
innodb_purge_threads = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
innodb_log_file_size = 32M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
bulk_insert_buffer_size = 8M
myisam_sort_buffer_size = 8M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
interactive_timeout = 28800
wait_timeout = 28800
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
read_buffer = 4M
write_buffer = 4M
EOF
[root@localhost mysql-5.7.20]# echo -e '\n\nexport PATH=/usr/local/mysql/bin:$PATH\n' >> /etc/profile && source /etc/profile
[root@localhost mysql-5.7.20]# mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
[root@localhost mysql-5.7.20]# systemctl start mysqld
[root@localhost mysql-5.7.20]# mysql_secure_installation
[root@localhost mysql-5.7.20]# ldconfig |grep mysql
[root@localhost mysql-5.7.20]# echo "/usr/local/mysql/lib" > /etc/ld.so.conf.d/mysql.conf
[root@localhost mysql-5.7.20]# ldconfig
[root@localhost mysql-5.7.20]# ldconfig -v |grep mysql
[root@localhost mysql-5.7.20]# firewall-cmd --permanent --add-port=3306/tcp
[root@localhost mysql-5.7.20]# firewall-cmd --reload