MySQL 5.6.26 源码安装包 与 cmake安装包链接：
操作系统版本：Centos release 6.3 (Final)
安装过程：（记得挂载镜像，并且配置yum，方便yum安装各种依赖的包
CentOS配置yum： 1、cd /etc/yum.repos.d2、创建个任意目录，将所有文件移动到创建的目录中，除了CentOS-Media.repo3、编辑CentOS-Media.repovi CentOS-Media.repo[c6-media]name=CentOS-$releasever – Mediabaseurl=file:///media/CentOS/# file:///media/cdrom/# file:///media/cdrecorder/gpgcheck=1enabled=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
4、创建/media/CentOS/目录5、挂载mount /dev/cdrom /media/CentOS/
[root@hank-yoon ~]# mkdir -p /export/servers
[root@hank-yoon servers]# 上传安装脚本、MySQL源码安装包，Cmake安装包
[root@hank-yoon servers]#lscmake-2.8.3.tar.gz mysql-5.6.26.tar.gz install.sh
[root@hank-yoon servers]#shinstall.sh
[root@hank-yoon servers]#cat install.sh 脚本内容 #!/bin/bash
# checkecho -e “\033[;37;34mCheck Memory Size…\033[0m”if [ `free -g|grep ^Mem|awk ‘{print $2}’` != 125 ]thenread -p “Memory size is `free -g|grep ^Mem|awk ‘{print $2}’`G , enter innodb_buffer_pool_size(default 20G) : ” poolelseecho -e “\033[;37;32mMemory Size is 125G , innodb_buffer_pool_size set 100G\033[0m”fiecho -e “\033[;37;34mCheck Network…\033[0m”#if ! ping -c 1 -w 1 www.baidu.com > /dev/null;then echo -e “\033[;37;31mPlease Check Network Before Setup\033[0m”;exit 1;else echo -e “\033[;37;32mOK\033[0m”;fiecho -e “\033[;37;34mCheck Packet…\033[0m”if ! ls mysql-5.6.26.tar.gz cmake-2.8.3.tar.gz > /dev/null;then echo -e “\033[;37;31mNo Packets\033[0m”;exit 1;else echo -e “\033[;37;32mOK\033[0m”;fi# replace yum.repos.d#rm -f /etc/yum.repos.d/*#wget -P /etc/yum.repos.d/-i ‘s/6.3/6.5/’ /etc/yum.repos.d/CentOS-Media.repo#echo -e “\033[;37;34mreplace yum.repos.d…\033[0m”
#wget mysql cmake
#change IO schedulerecho deadline > /sys/block/sda/queue/schedulerecho -e “\033[;37;34mchange IO scheduler to deadline…\033[0m”
# init enviromentecho -e “\033[;37;34mStarting Yum Install…\033[0m”yum install -y ncurses-devel glibc gcc gcc-c++ libstdc++* libtool cmake lrzsz libaio-develecho -e “\033[;37;32mYum Install Done\033[0m”echo -e “\033[;37;34mAdd MySQL OS User…\033[0m”useradd mysqlecho -e “\033[;37;32mAdd User Done\033[0m”
setuplog=/home/mysql/logs/install-logsetupdir=$(pwd)mysqldir=(/export/data/mysql/tmp /export/data/mysql/undo /export/data/mysql/data /export/servers/mysql/etc /export/data/mysql/dumps /export/data/mysql/log /home/mysql/scripts /home/mysql/logs)mkdir -p ${mysqldir[*]}chown mysql:mysql -R /export/data/mysql /home/mysql/
echo -e “\033[;37;34mExtracting package to /usr/local/src/\033[0m”tar xzf cmake-2.8.3.tar.gz -C /usr/local/srctar xzf mysql-5.6.26.tar.gz -C /usr/local/srcmv *.tar.gz /usr/local/srcecho -e “\033[;37;32mExtracting Done\033[0m”
# installecho -e “\033[;37;34mInstall Cmake…\033[0m”cd /usr/local/src/cmake-2.8.3 ; ./bootstrap && gmake && make installif [ $? = 0 ];then echo -e “\033[;37;32mCmake Install Done\033[0m”;else echo -e “\033[;37;31mCmake Install Faild\033[0m”;fi
echo -e “\033[;37;34mInstall MySQL…\033[0m”echo “Configure Error” > $setuplogcd /usr/local/src/mysql-5.6.26 ; cmake . -DCMAKE_INSTALL_PREFIX=/export/servers/mysql/ -DMYSQL_DATADIR=/export/data/mysql/data -DSYSCONFDIR=/export/servers/mysql/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_UNIX_ADDR=/export/data/mysql/tmp/mysql.sock -DENABLED_LOCAL_INFILE=ON -DENABLED_PROFILING=ON -DWITH_DEBUG=0 -DENABLE_DTRACE=OFF -DMYSQL_TCP_PORT=3358 2>> $setuplogmake && make installif [ $? = 0 ];then echo -e “\033[;37;32mMySQL Install Done\033[0m”;else echo -e “\033[;37;31mMySQL Install Faild\033[0m”;exit 1;fi/sbin/ldconfig /export/servers/mysql/lib/
echo -e “\033[;37;34mModify /home/mysql/.bash_profile…\033[0m”echo “export LANG=en_US.UTF-8” >> /home/mysql/.bash_profilesed -i ‘s!PATH=$PATH:$HOME/bin!PATH=$PATH:$HOME/bin:/export/servers/mysql/bin!’ /home/mysql/.bash_profilesource /home/mysql/.bash_profileecho -e “\033[;37;32mDONE\033[0m”
# my.cnfecho -e “\033[;37;34mCreate /export/servers/mysql/etc/my.cnf…\033[0m”cat >> /export/servers/mysql/etc/my.cnf << EOF[client]port = 3358socket = /export/data/mysql/tmp/mysql.sock
[mysqld]port = 3358socket = /export/data/mysql/tmp/mysql.sockdatadir = /export/data/mysql/data/
#— GLOBAL —#character-set-server = utf8lower_case_table_names = 1log-output = FILElog-error = /export/data/mysql/log/error.log
general_log = 0
general_log_file = /export/data/mysql/log/mysql.logpid-file = /export/data/mysql/mysql.pidslow-query-logslow_query_log_file = /export/data/mysql/log/slow.logtmpdir = /export/data/mysql/tmplong_query_time = 1
#thread_concurrency = 16thread_cache_size = 512table_open_cache = 16384table_definition_cache = 16384sort_buffer_size = 2Mjoin_buffer_size = 2Mread_buffer_size = 4Mread_rnd_buffer_size = 4Mkey_buffer_size = 8Mmyisam_sort_buffer_size = 8Mtmp_table_size = 64Mmax_heap_table_size = 64Mopen_files_limit = 65535query_cache_size = 0
#add z #################innodb_undo_directory = /export/data/mysql/undoinnodb_undo_tablespaces = 4explicit_defaults_for_timestamp = 1
#— NETWORK —#back_log = 1024max_allowed_packet = 16Minteractive_timeout = 28800wait_timeout = 28800skip-external-lockingmax-connections = 1000skip-name-resolve#read_only = 1#— REPL —#server-id = 360360log-bin = mysql-binbinlog_format = mixedexpire_logs_days = 7relay-log = relay-log
replicate-ignore-db = mysql.slave_Master_inforeplicate-ignore-db = mysql.slave_relay_log_inforeplicate-ignore-db = mysql.slave_worker_inforeplicate-ignore-db = testreplicate-ignore-db = information_schemareplicate-ignore-db = performance_schema
log_slave_updatesskip-slave-startslave-parallel-workers= 4sync_master_info = 1sync_relay_log = 1sync_relay_log_info = 1relay_log_info_repository = TABLEmaster_info_repository = TABLE#rpl_semi_sync_master_enabled = 1#rpl_semi_sync_slave_enabled = 1#rpl_semi_sync_master_timeout = 1000
#— INNODB —#default-storage-engine = INNODBinnodb_data_home_dir = /export/data/mysql/datainnodb_file_per_tableinnodb_log_group_home_dir = /export/data/mysql/datainnodb_log_files_in_group = 3innodb_log_file_size = 512Minnodb_log_buffer_size = 16Minnodb_flush_log_at_trx_commit = 1innodb_lock_wait_timeout = 120innodb_flush_method = O_DIRECTinnodb_max_dirty_pages_pct = 75
#change z #####sync_binlog = 1innodb_buffer_pool_size = 100Ginnodb_data_file_path = ibdata1:2G;ibdata2:2G:autoextendinnodb_autoextend_increment = 500innodb_thread_concurrency = 32innodb_open_files = 65535innodb_write_io_threads = 20innodb_read_io_threads = 20innodb_spin_wait_delay = 10innodb_flush_neighbors = 1innodb_use_native_aio = 1innodb_io_capacity = 2000innodb_io_capacity_max = 6000relay_log_recovery = 1#innodb_additional_mem_pool_size = 128M
#change h #####
#innodb_numa_interleave=ONinnodb_lru_sCan_depth=512innodb_checksum_algorithm=crc32innodb_purge_threads=4
[mysqldump]quickmax_allowed_packet = 16M
[mysql]# auto-rehash# Remove the next comment character if you are not familiar with SQL# safe-updatesdefault-character-set=utf8
[myisamchk]key_buffer_size = 128Msort_buffer_size = 128Mread_buffer = 2Mwrite_buffer = 2M
[mysqlhotcopy]interactive-timeout
EOFserverid=$(ifconfig |grep Bcast|grep ‘inet addr:’ | awk ‘{print $2}’ |awk -F. ‘{print $3$4}’)#serverid=$(ifconfig eth0|grep Bcast|grep ‘inet addr:’ | awk ‘{print $2}’ |awk -F. ‘{print $3$4}’)sed -i ‘s/360360/’$serverid’/’ /export/servers/mysql/etc/my.cnfif [ ! -z $pool ];then sed -i ‘s/innodb_buffer_pool_size = 100G/innodb_buffer_pool_size = ‘$pool’/’ /export/servers/mysql/etc/my.cnf;echo -e “\033[;37;34m`cat /export/servers/mysql/etc/my.cnf|grep innodb_buffer_pool_size`\033[0m”;fiecho -e “\033[;37;32mDONE\033[0m”
# start/export/servers/mysql/scripts/mysql_install_db –user=mysql –basedir=/export/servers/mysql/ –datadir=/export/data/mysql/data//export/servers/mysql/bin/mysqld_safe –defaults-file=/export/servers/mysql/etc/my.cnf &echo -e “\033[;37;34mStart MySQL\033[0m”for i in {1..500};do [ -S /export/data/mysql/tmp/mysql.sock ] && echo -e “\033[;37;32m[OK]\033[0m” && break || echo -n “. “;sleep 2;doneif [ ! -S /export/data/mysql/tmp/mysql.sock ];then echo -e “\033[;37;31m[Start Faild,See /export/data/mysql/log/error.log]\033[0m”;exit 1;fi
# cuttingecho -e “\033[;37;34mCreate Cutting.sh to Crontab\033[0m”cat >> /home/mysql/scripts/cutting.sh << EOF#!/bin/bashmysql=/export/servers/mysql/bin/mysqluser=backuppassword=’7FH3iwIX90VdUInu’
generallog=/export/data/mysql/log/mysql.logif [ -f \$generallog ]thenmv \$generallog \${generallog}.\`date “+%Y%m%d%H”\`\$mysql -u\$user -p\$password -e “flush no_write_to_binlog general logs;”fi
slowlog=/export/data/mysql/log/slow.logif [ \`date “+%w”\` = 6 -a -f \$slowlog ]thenmv \$slowlog \${slowlog}.\`date “+%Y%m%d%H”\`\$mysql -u\$user -p\$password -e “flush no_write_to_binlog slow logs;”fi
find /export/data/mysql/log/ -type f -name “*.log.*” -mtime +7 |xargs rm -fEOFchown mysql.mysql /home/mysql/scripts/cutting.shchmod +x /home/mysql/scripts/cutting.shecho “1 0 * * * /home/mysql/scripts/cutting.sh” >> /var/spool/cron/mysqlecho “1 0 * * * /usr/sbin/ntpdate 172.17.1.134 | hwclock -w” >> /var/spool/cron/rootchown mysql.root /var/spool/cron/mysqlchmod 600 /var/spool/cron/mysql/etc/init.d/crond restartecho -e “\033[;37;32mDONE\033[0m”mkdir /var/lib/mysqlln -s /export/data/mysql/tmp/mysql.sock /var/lib/mysql/mysql.sockchown -R mysql.mysql /var/lib/mysql
echo -e “\033[;37;34mClean…\033[0m”> /export/data/mysql/log/mysql.logrm -f ${setupdir}/`basename $0`echo -e “\033[;37;32mDONE\033[0m”
# add servicecp /export/servers/mysql/support-files/mysql.server /etc/init.d/mysql
# rpl semi sync ON/export/servers/mysql/bin/mysql -uroot -e “install plugin rpl_semi_sync_master soname ‘semisync_master.so'”/export/servers/mysql/bin/mysql -uroot -e “install plugin rpl_semi_sync_slave soname ‘semisync_slave.so'”;sed -i ‘s/#rpl_semi_sync_master_enabled/rpl_semi_sync_master_enabled/’ /export/servers/mysql/etc/my.cnfsed -i ‘s/#rpl_semi_sync_slave_enabled/rpl_semi_sync_slave_enabled/’ /export/servers/mysql/etc/my.cnfsed -i ‘s/#rpl_semi_sync_master_timeout/rpl_semi_sync_master_timeout/’ /export/servers/mysql/etc/my.cnf
# mysql restartservice mysql restart
Linux上以二进制包形式安装Mysql 总是不成功，不知道是什么原因？
答案一你遵循brew install mysql的说明了吗？用用户账户来执行以下命令：1unset TMPDIRmysql_install_db --verbose --user=`whoami` --basedir=$(brew --prefix mysql) --datadir=/usr/local/var/mysql --tmpdir=/tmp若想在另一个文件夹中建立基础表，或者使用了不同的用户运行了mysqld，请查看mysql_install_db的帮助文档：1mysql_install_db --help或者查看MySQL官方文档：比如说你想使用’mysql’作为用户，你需要运行sudo命令：1sudo mysql_install_db ...然后手动启动 start注意：如果该操作失败的话，你可能是忘记运行前两步操作答案二尝试找到后缀名为””的log文件，这里记录了更详细的信息。 它可能位于：1/usr/local/var/mysql/your_computer_或许是由于权限问题：检查是否有mysql实例正在运行：1ps -ef | grep mysql如果是的话，你应该关掉它，或者直接杀掉进程：1kill -9 PID其中PID是第一个命令输出的靠近用户名的那个数字（进程ID）检查 /usr/local/var/mysql/的所有者：1ls -laF /usr/local/var/mysql/如果它的所有者是root的话，你应该把它改成mysql或者你的用户名：1sudo chown -R mysql /usr/local/var/mysql/答案三译者注：我是使用该方法解决的。 我在我的Mac上存在同样的问题(我是严格按照brew install的说明来安装的)删掉下面这个错误文件解决了我的问题：1sudo rm -rf /usr/local/var/mysql/ ( is my hostname)这个对我起作用是由于是属于_mysql:wheel的，而不是我自己的用户名.更改“错误文件”的所有者可能也会起作用。 答案四检查所有正在运行的MySQL进程：1$ ps aux | grep mysqlUSER PID%CPU%MEM _mysql 5970 0.0 0.4 ...使用下面的命令杀死所有的进程：1$ sudo kill -9 [PID]使用第一条命令获得的PID来代替[PID]，比如说：5970然后重启MySQL服务器：1$ start
linux如何安装mysql的rpm包在什么位置
首先下载rpm安装包，要下载两个安装包一个client，一个server，有个镜像做的不错，下载/mysql，进入后找到你想要的版本，我下的是mysql5.5版的1我的linux是32位的，我下的如下图所示2下载完后加压，得到几个压缩文件，我们只要其中的server和client3将这两个文件使用winscp工具传输到服务器上，最好改一下名字，下边使用命令执行时输入比较方便。 我这里改成了和，保留了版本号。 关于winscp的使用方法，很简单，下载一个winscp的安装包， 安装完之后打开根据提示输入服务器的IP和密码，远程连接就可以了。 4文件传输完成后，找到传输的目录，在xshell工具中开始进行安装。 xshell是一个用脚本操作linux的工具，下载和安装也很简单。 安装完之后远程连接就可以。 连上之后，假设你传的安装文件在/usr/local目录下，用xshell输入命令先进入到local目录,要先安装server；首先进入目录5安装server，输入文件名的过程中记住：大小写区分6安装client,如下图所示表示安装成功7安装成后找到/usr/share/mysql/,复制到/etc目录下，把名字改为修改默认编码在文件中加入如图所示的编码：这针对5.5以后的版本，因为mysqld在5.5版本后不识别default-character-set这个变量8修改完之后，使用service mysql start开启服务。 9启动成功之后就安装完成啦。
Linux的MYSQL安装包
Starting MySQL...................................[FAILED]启动MYSQL都失败了当然没办法用了，解决方法如下#chown -R mysql:mysql /var/lib/mysql#/etc/init.d/mysqld start启动 MySQL： [ 确定 ][root@localhost lib]# mysqladmin -uroot password 你需要设置的mysql密码[root@localhost lib]# mysql -uroot -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \ MySQL connection id is 3 to server version: 4.1.11Type help; or \h for help. Type \c to clear the buffer
发表评论