[MySQL] Automated installation deployment for MySQL

MySQL Ops people should be aware that the online MySQL is generally used to compile the source code, because this can be based on the needs of enterprises to choose to compile the function, although the source code compiled MySQL is very simple, but imagine, if you have hundreds of servers at the same time to install MySQL, Do you still have a set to manually compile and write configuration files? This is obviously too inefficient, this article discusses the automated installation deployment of MySQL.

1, production in line with their own needs RPM package we want to compile according to MySQL source code to meet the needs of the enterprise RPM package, the source code to obtain the command as follows:

wget HTTP://DOWNLOADS.MYSQL.COM/ARCHIVES/GET/FILE/MYSQL-5.6.16.TAR.GZTAR-ZXVF MYSQL-5.6.16.TAR.GZCD Mysql-5.6.16mkdir rpmcd rpm

In the above we get the source code, and in the main source directory to create the RPM directory, and then we create the Mysql.spec file in this directory:

name:mysqlversion:5.6.16release:guahaolicense:gplurl:http://downloads.mysql.com/archives/get/file/ Mysql-5.6.16.tar.gzgroup:applications/databasebuildroot:%{_tmppath}/%{name}-%{version}-%{release}-root Buildrequires:cmakepackager: [Email protected]autoreq:noprefix:/opt/mysqlsummary:mysql 5.6.16%description The MySQL (TM) software delivers a very fast, multi-threaded, Multi-user,and robust SQL (structured Query Language) databas E server. MySQL Serveris intended for mission-critical, heavy-load production systems as wellas in embedding into mass-deployed SOF Tware.%define mysql_user mysql%define mysql_group mysql%define __os_install_post%{nil}%buildcd $OLDPWD/... /cflags= "-o3-g-fno-exceptions-static-libgcc-fno-omit-frame-pointer-fno-strict-aliasing" CXX=g++CXXFLAGS= "-o3-g-                                                    Fno-exceptions-fno-rtti-static-libgcc-fno-omit-frame-pointer-fno-strict-aliasing "Export CFLAGS CXX CXXFLAGScmake.    -dsysconfdir:path=%{prefix}                          -dcmake_install_prefix:path=%{prefix}-dcmake_build_type:string=release                                    -denable_profiling:bool=on-dwith_debug:bool=off                             -dwith_valgrind:bool=off-denable_debug_sync:bool=off -dwith_extra_charsets:string=all-dwith_ssl:string=bundled-dwith _unit_tests:bool=off-dwith_zlib:string=bundled-dwith_partiti On_storage_engine:bool=on-dwith_innobase_storage_engine:bool=on-dwith_archive_storage _engine:bool=on-dwith_blackhole_storage_engine:bool=on-dwith_perfschema_storage_engi                      Ne:bool=on-ddefault_charset=utf8-ddefault_collation=utf8_general_ci -dwitH_extra_charsets=all-denabled_local_infile:bool=on-dwith_embedd Ed_server=0-dinstall_layout:string=standalone-dcommunity_build:boo l=on-dmysql_server_suffix= '-r5436 '; make-j ' Cat/proc/cpuinfo | grep processor| Wc-l '%INSTALLCD $OLDPWD/... /make destdir= $RPM _build_root install%cleanrm-rf $RPM _build_root%files%defattr (-,%{mysql_user},%{MYSQL_GROUP})% attr (755,%{mysql_user},%{mysql_group})%{prefix}/*%pre%postln-s%{prefix}/lib%{prefix}/lib64%preun%changelog

With this spec file, you can execute the following command to generate our own RPM package:

Rpmbuild-bb./mysql.spec

2, write my.cnf template my.cnf template as follows:

[Mysqld_safe]pid-file=/opt/mysql/run/mysqld.pid[mysql]prompt=\\[email protected]\\d \\r:\\m:\\s> DEFAULT-CHARACTER-SET=GBKNO-AUTO-REHASH[CLIENT]SOCKET=/OPT/MYSQL/RUN/MYSQL.SOCK[MYSQLD] #dirbasedir =/opt/ mysqldatadir=/data/mysql/datatmpdir=/data/mysql/tmplog-error=/data/mysql/log/alert.logslow_query_log_file=/ data/mysql/log/slow.loggeneral_log_file=/data/mysql/log/general.logsocket=/opt/mysql/run/mysql.sock# Innodbinnodb_data_home_dir=/data/mysql/datainnodb_log_group_home_dir=/data/mysql/datainnodb_data_file_path= Ibdata1:2g;ibdata2:16m:autoextendinnodb_buffer_pool_size=10ginnodb_buffer_pool_instances=4innodb_log_files_in_ Group=4innodb_log_file_size=1ginnodb_log_buffer_size=200minnodb_flush_log_at_trx_commit=1innodb_additional_mem _pool_size=20minnodb_max_dirty_pages_pct=60innodb_io_capacity=200innodb_thread_concurrency=32innodb_read_io_ threads=8innodb_write_io_threads=8innodb_open_files=60000innodb_file_format=barracudainnodb_file_per_table= 1innodb_flush_method=o_directinnodb_change_Buffering=allinnodb_adaptive_flushing=1innodb_old_blocks_time=1000innodb_stats_on_metadata=0innodb_read_ahead= 0innodb_use_native_aio=0innodb_lock_wait_timeout=50innodb_rollback_on_timeout=0innodb_purge_threads=1innodb_ Strict_mode=1transaction-isolation=read-committed#myisamkey_buffer_size=100mmyisam_sort_buffer_size= 64mconcurrent_insert=2delayed_insert_timeout=300#replicationmaster-info-file=/data/mysql/log/ master.inforelay-log=/data/mysql/log/mysql-relayrelay_log_info_file=/data/mysql/log/ Mysql-relay.inforelay-log-index=/data/mysql/log/mysql-relay.indexslave_load_tmpdir=/data/mysql/tmpslave_type_ conversions= "All_non_lossy" slave_net_timeout=4skip-slave-startsync_master_info=1000sync_relay_log_info=1000# Binloglog-bin=/data/mysql/log/mysql-binserver_id=2552763370binlog_cache_size=32kmax_binlog_cache_size=2gmax_ binlog_size=500mbinlog_format=rowsync_binlog=1000log-slave-updates=1expire_logs_days=0# Serverdefault-storage-engine=innodbcharacter-set-server=gbklower_case_table_names=1skip-external-lockingopen_files_limit=65536safe-user-createlocal-infile=1performance_schema=0log_slow_admin_statements= 1log_warnings=1long_query_time=1slow_query_log=1general_log=0query_cache_type=0query_cache_limit=1mquery_cache _min_res_unit=1ktable_definition_cache=65536thread_stack=512kthread_cache_size=256read_rnd_buffer_size= 128ksort_buffer_size=256kjoin_buffer_size=128kread_buffer_size=128kport=3306skip-name-resolveskip-sslmax_ Connections=4500max_user_connections=4000max_connect_errors=65536max_allowed_packet=128mconnect_timeout=8net_ Read_timeout=30net_write_timeout=60back_log=1024#server ID

Attentive readers should note that at the end of the my.cnf there is a blank space on the server ID, and the shell script in the back is dynamically added, because all MySQL server IDs within an enterprise must maintain global consistency so that no confusion occurs when the primary and standby replicates. In fact, if you want to write this script more general, it is possible to leave more parameters white, such as Port, DataDir, memory-related parameters, and here I just take the server ID as an example, to offer. 3. Prepare MySQL Data Catalog template you have to prepare a MySQL, according to your own needs, the commonality of things on top (such as accounts, etc.), the following is the simplest installed MySQL Data directory structure:

[[email protected] mysql]# ls-ltotal 12drwxr-xr-x 5 mysql mysql 4096 Jul  2 09:26 datadrwxr-xr-x 2 mysql mysql 4096 Ju L  1 18:21 logdrwxr-xr-x 2 mysql mysql 4096 Jul  2 09:26 tmp[[email protected] mysql]# CD data[[email protected] Dat a]# ls-ltotal 6314044drwx------2 mysql mysql       4096 Jul  1 17:17 mysqldrwx------2 mysql mysql       4096 Jul  1 1 7:17 performance_schemadrwx------2 mysql mysql       4096 Jul  1 17:17 test

Package the directory in tar (named Data.tar), then extract the template to the newly installed MySQL instance data directory. 4. Writing an automated installation deployment script before running this script, we have to put the previous RPM packages, my.cnf templates and Data Catalog templates in a fixed place, in this case FTP on the inside of the enterprise. The MySQL Automation installation deployment script (named: mysql_install.sh) is as follows:

#!/bin/sh#step 1:prepareyum Install cmake gcc g++ bison ncurses-devel zlib groupadd mysqluseradd-g mysql mysql#step 2:g ET sourceftp-n<<eofopen 10.10.100.254user zhuxianjie zxj321binarycd mysqlpromptmget *eof#step 3:installunique_ Id= ' Date ' +%y%m%d%m%s "' echo ' server_id= ' $unique _id >> my.cnfrpm-ivh MYSQL-5.6.16-GUAHAO.X86_64.RPMCP my.cnf/ Opt/mysqlchown-r Mysql:mysql/opt/mysqltar xvf data.tar-c/datachown-r mysql:mysql/data/mysql#step 4:start mysqlcp/o Pt/mysql/support-files/mysql.server/etc/rc.d/init.d/mysqldchmod 755/etc/init.d/mysqldchkconfig mysqld on/etc/ Init.d/mysqld start