2.\u5b89\u88c5\u57fa\u7840\u5305 <\/p>
yum -y install ntpdate gcc gcc-c++ ncurses ncurses-devel cmake readline-devel zlib.x86_64 zlib-devel.x86_64 bison libcurl-* net-tool* tree nmap sysstat lrzsz dos2unix telnet.x86_64 nethogs iftop iotop unzip ftp.x86_<\/p>
64 xfs* expect vim wget psmisc openssh-client* libaio libaio1 libnuma openssl-devel bzip2<\/p>
3.\u57fa\u7840\u73af\u5883\u914d\u7f6e<\/p>
systemctl stop firewalld<\/p>
systemctl disabled firewalld<\/p>
systemctl stop postfix<\/p>
systemctl disable postfix<\/p>
sed -i 's\/^SELINUX=.*\/SELINUX=disabled\/g' \/etc\/selinux\/config && cat \/etc\/selinux\/config >> ${tmplog_dir}\/base.log 2>&1<\/p>
setenforce 0<\/p>
getenforce<\/p>
4.\u5185\u6838\u53c2\u6570\u4fee\u6539<\/p>
echo "vm.swappiness=10">>\/etc\/sysctl.conf<\/p>
echo "net.ipv4.tcp_tw_recycle=1">>\/etc\/sysctl.conf<\/p>
echo "net.ipv4.tcp_tw_reuse=1">>\/etc\/sysctl.conf<\/p>
echo "vm.dirty_background_ratio=8">>\/etc\/sysctl.conf<\/p>
echo "* soft nofile 1024000" >>\/etc\/security\/limits.conf<\/p>
echo "* hard nofile 1024000" >>\/etc\/security\/limits.conf<\/p>
\u6570\u636e\u76d8\u6302\u6302\u8f7d\u53c2\u6570
rw,noatime,nodiratime,nobarrier<\/p>
5.\u5347\u7ea7gcc<\/p>
mkdir \/usr\/local\/tools && cd \/usr\/local\/tools<\/p>
wget http:\/\/ftp.tsukuba.wide.ad.jp\/software\/gcc\/releases\/gcc-5.5.0\/gcc-5.5.0.tar.xz<\/p>
tar xf gcc-5.5.0.tar.xz<\/p>
cd gcc-5.5.0<\/p>
.\/contrib\/download_prerequisites<\/p>
mkdir build && cd build<\/p>
..\/configure --enable-checking=release --enable-languages=c,c++ --disable-multilib<\/p>
make && make install<\/p>
6.\u5347\u7ea7cmake<\/p>
\u5efa\u8bae\u53e6\u5916\u5f00\u4e00\u4e2asession\u9632\u6b62\u73af\u5883\u53d8\u91cf\u672a\u751f\u6548<\/p>
cd \/usr\/local\/tools<\/p>
wget https:\/\/github.com\/Kitware\/CMake\/releases\/download\/v3.14.5\/cmake-3.14.5.tar.Z<\/p>
.\/bootstrap<\/p>
make && make install<\/p>
\u5982\u679c\u51fa\u73b0\u4ee5\u4e0b\u9519\u8bef
ibstdc++.so.6: version `CXXABI_1.3.9' not found (required by .\/destructor)
\u5904\u7406\u5982\u4e0b\uff1a<\/p>
find \/ -name "libstdc++.so*"<\/p>
mv \/usr\/lib64\/libstdc++.so.6.0.21 \/tmp\/<\/p>
cp \/usr\/local\/tools\/gcc-5.5.0\/build\/x86_64-unknown-linux-gnu\/libstdc++-v3\/src\/.libs\/libstdc++.so.6.0.21 \/usr\/lib64\/<\/p>
mv \/usr\/lib64\/libstdc++.so.6 \/tmp\/<\/p>
ln -s libstdc++.so.6.0.21 libstdc++.so.6<\/p>
7.\u7f16\u8bd1\u5b89\u88c5Mysql<\/p>
cd \/usr\/local\/tools<\/p>
tar xf mysql-boost-8.0.16.tar.gz<\/p>
cd mysql-8.0.16<\/p>
cmake . \\<\/p>
-DWITH_BOOST=\/usr\/local\/tools\/mysql-8.0.16\/boost\/boost_1_69_0 \\<\/p>
-DCMAKE_INSTALL_PREFIX=\/usr\/local\/mysql \\<\/p>
-DMYSQL_DATADIR=\/data\/mysql3306\/data \\<\/p>
-DWITHOUT_CSV_STORAGE_ENGINE=1 \\<\/p>
-DWITHOUT_FEDERATED_STORAGE_ENGINE=1 \\<\/p>
-DWITHOUT_ARCHIVE_STORAGE_ENGINE=1 \\<\/p>
-DFORCE_INSOURCE_BUILD=1 \\<\/p>
-DWITH_SSL=system \\<\/p>
-DCMAKE_CXX_COMPILER=\/usr\/local\/bin\/g++ \\<\/p>
-DCMAKE_C_COMPILER=\/usr\/local\/bin\/gcc<\/p>
make -j 8<\/p>
make install<\/p>
8.\u751f\u6210\u914d\u7f6e\u6587\u4ef6<\/p>
cat \/data\/conf\/my3306.cnf<\/p>
[client]<\/p>
port = 3306<\/p>
socket = \/data\/mysql3306\/data\/mysql.sock<\/p>
[mysql]<\/p>
prompt="\\u@netdatdb01-137-32 \\R:\\m:\\s [\\d]> "<\/p>
no-auto-rehash<\/p>
[mysqld]<\/p>
user = mysql<\/p>
port = 3306<\/p>
basedir = \/usr\/local\/mysql<\/p>
datadir = \/data\/mysql3306\/data<\/p>
tmpdir = \/data\/mysql3306\/tmp<\/p>
socket = \/data\/mysql3306\/data\/mysql.sock<\/p>
pid-file = netdatdb01-137-32.pid<\/p>
character-set-server = utf8mb4<\/p>
skip_name_resolve = 1<\/p>
#\u82e5\u4f60\u7684MySQL\u6570\u636e\u5e93\u4e3b\u8981\u8fd0\u884c\u5728\u5883\u5916\uff0c\u8bf7\u52a1\u5fc5\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u8c03\u6574\u672c\u53c2\u6570<\/p>
default_time_zone = "+8:00"<\/p>
open_files_limit = 65535<\/p>
back_log = 1024<\/p>
max_connections = 512<\/p>
max_connect_errors = 1000000<\/p>
table_open_cache = 1024<\/p>
table_definition_cache = 1024<\/p>
table_open_cache_instances = 64<\/p>
thread_stack = 512K<\/p>
external-locking = FALSE<\/p>
max_allowed_packet = 32M<\/p>
sort_b","orderid":"0","title":"CentOS 7.6 \u4e0bMySQL 8.0.16\u7f16\u8bd1\u5b89\u88c5(\u4e00)","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"201","pages":"3","comments":"0","posttime":"2019-07-10 20:11:34","list":"1562760694","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"CentOS<\/A> 7.6<\/A> MySQL<\/A> 8.0.16<\/A> \u7f16\u8bd1<\/A> \u5b89\u88c5<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"47.106.78.186","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"CentOS 7.6 \u4e0bMySQL 8.0.16\u7f16\u8bd1\u5b89\u88c5","lastview":"1714082763","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}