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

-Mariadb 10.2.30 installation-

I. Source code compilation and installation

1. Installation dependency

# mkdir-pv / data_linux/mysql/3306/ {data,logs/ {binlog,relaylog} # yum-y install libaio libaio-devel\ bison bison-devel zlib-devel openssl\ openssl-devel ncurses ncurses-devel\ libcurl-devel libarchive-devel boost\ boost-devel lsof wget gcc gcc-c++ make\ cmake perl kernel-headers kernel-devel pcre-devel

2. Download the source package

# wget http://mirror.rackspace.com/mariadb//mariadb-10.2.30/source/mariadb-10.2.30.tar.gz

3. Compile and install

# cmake\-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\-DMYSQL_DATADIR=/data_linux/mysql/3306/data\-DSYSCONFDIR=/etc\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_ARCHIVE_STORAGE_ENGINE=1\-DWITH_READLINE=1\-DWITH_SSL=system\-DWITH_ZLIB=system\-DWITH_LIBWRAP=0\-DMYSQL_UNIX_ADDR=/tmp/mysql.sock\-DDEFAULT_CHARSET=utf8\-DDEFAULT_COLLATION=utf8_general_ci\-DMYSQL_UNIX_ADDR=/tmp/ Mysql.sock\-DENABLED_LOCAL_INFILE=1\-DWITH_PARTITION_STORAGE_ENGINE=1\-DWITH_DEBUG=0\-DWITHOUT_MROONGA_STORAGE_ENGINE=1 if the error is reported Follow the error prompt to install the corresponding dependency, then delete the CMakeCache.txt file in the current directory and recompile until there is no error error. # make#make install

4. Prepare the environment after installation

# chown-R mysql:mysql / usr/local/mysql/#cp support-files/my-large.cnf / etc/my.cnf# [root@deploy mariadb-10.2.30] # cat / etc/ my.cnf [client] port = 3306socket = / tmp/ mysql.sock [mysqld] port = 3306socket = / tmp/mysql.sockskip-external-lockingkey_buffer _ size = 256Mmax_allowed_packet = 1Mtable_open_cache = 256sort_buffer_size = 1Mread_buffer_size = 1Mread_rnd_buffer_size = 4Mmyisam_sort_buffer_size = 64Mthread_cache_size = 8query_cache_size = 16Mthread_concurrency = 8log-bin=mysql-binbinlog_format = mixedserver-id = 1datadir = / data_linux/mysql/3306/datainnodb_data_home_dir = / data_linux/mysql/3306/datainnodb_data_ file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = / data_linux/mysql/3306/datainnodb_ buffer_pool_ Size = 256m innodb_log_file_size = 64m innodb_log_buffer_size = 8m innodb_flush_log_at_trx_commit = 2innodb_lock_wait_timeout = 50innodb_file_per_table = ON skip_name_resolve = ON [mysqldump] quickmax_allowed_packet = 16m [MySQL] no-auto- rehash [myisamchk] key_buffer_size = 128Msort_buffer_size = 128Mread_buffer = 2Mwrite_buffer = 2m [mysqlhotcopy] interactive-timeout

5. Initialize the service

# cp support-files/mysql.server / etc/rc.d/init.d/mysqld#chmod + x / etc/rc.d/init.d/mysqld#/etc/init.d/mysqld start

Binary installation

Download address of binary package:

Wget https://downloads.mariadb.org/interstitial/mariadb-10.2.30/bintar-linux-systemd-x86_64/mariadb-10.2.30-linux-systemd-x86_64.tar.gz/from/http%3A//mirror.rackspace.com/mariadb/

1. Planning:

Data file storage location / data/mysql/data

Log file storage location / home/logs/mysql

Binlog file storage location / data/mysql

two。 Create directories and authorizations:

Mkdir-p / data/mysql/datamkdir-p / home/logs/mysqluseradd mysqlchown-R mysql:mysql / data/mysqlchown-R mysql:mysql / home/logs

3. Decompress the file

# tar-xzvf mariadb-10.2.30-linux-systemd-x86_64.tar.gz-C / usr/local#mv / usr/local/mariadb-10.2.30-linux-systemd-x86_64 / usr/local/mysql

4. Configuration file

# cat / etc/ my.cnf [client] socket = / tmp/ mysql.sock [mysqld] user = mysqldatadir = / data/mysql/dataport = 3306pid-file = / tmp/mysql.pidsocket = / tmp/mysql.sockserver-id = 2default-storage-engine = InnoDBcharacter- Set-client-handshake = FALSEcharacter-set-server = utf8mb4collation-server = utf8mb4_unicode_ciinit_connect = 'SET NAMES utf8mb4'performance-schema-instrument =' memory/%=COUNTED'interactive_timeout = 172800wait_timeout = 172800tmp-table-size = 8Mmax-heap-table-size = 4Mquery-cache-type = 0query-cache-size = 64Mmax-connections = 80thread-cache-size = 50open-files-limit = 65535table-definition-cache = 4096table-open-cache = 10innodb-flush-method = O_DIRECTinnodb-log-files-in-group = 2innodb-log-file-size = 256Minnodb-flush-log-at-trx-commit = 1innodb -file-per-table = 1innodb-buffer-pool-size = 3Glog-error = / home/logs/mysql/mysql_error.logslow-query-log = 1slow-query-log-file = / home/logs/mysql/mysql_slow.loglong_query_time = 0.2min_examined_row_limit = 100max-allowed-packet = 16Mmax- Connect-errors = 1000000#skip-name-resolvesql-mode = ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER NO_ENGINE_SUBSTITUTIONsysdate-is-now = 1innodb-strict-mode = 1sort_buffer_size = 2Mjoin_buffer_size = 2Mkey_buffer_size = 64Mread_buffer_size = 512Kread_rnd_buffer_size = 256Kbinlog_cache_size = 2Mthread_stack = 256Kbulk_insert_buffer_size = 64Mlower_case _ table_names = 1relay-log = / home/logs/mysql/mysql_relay.logrelay_log_recovery = 1slave-net-timeout = 60relay_log_purge = 0sync_binlog = 1log-bin = / data/mysql/mysql_bin.logbinlog_format = ROWexpire-logs-days = 2relay _ Log_recovery = 1slave_skip_errors = ddl_exist_errorsexplicit_defaults_for_timestamp = true

5. Data initialization

# / usr/local/mysql/scripts/mysql_install_db-basedir=/usr/local/mysql-datadir=/data/mysql/data-user=mysql

6. Set up the startup file

# cp / usr/local/mysql/support-files/mysql.server / etc/init.d/mysql

7. Start

# / etc/init.d/mysql start

8. Connect

Explicit_defaults_for_timestamp = true [root@deploy local] # mysqlWelcome to the MariaDB monitor. Commands end with; or\ g.Your MariaDB connection id is 12Server version: 10.2.30-MariaDB-log Source distributionCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.MariaDB [(none)] >

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.