下载好最新版mysql-5.6.14.tar.gz首先 建好mysql用户与用户组，#：groupadd -g 45 mysql && useradd -c "MySQL Server" -d /srv/mysql -g mysql -s /bin/false -u 45 mysql解压mysql,进入mysql目录。#：make . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1-DWITH_PARTITION_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DMYSQL_USER=mysql或是用以下方法，会有报错。 #：sed -i "/ADD_SUBDIRECTORY(sql\/share)/d" CMakeLists.txt && sed -i "s/ADD_SUBDIRECTORY(libmysql)/&\\nADD_SUBDIRECTORY(sql\/share)/" CMakeLists.txt && sed -i "s@data/test@\${INSTALL_MYSQLSHAREDIR}@g" sql/CMakeLists.txt && sed -i "s@data/mysql@\${INSTALL_MYSQLTESTDIR}@g" sql/CMakeLists.txt && sed -i "s/srv_buf...

mysql5.6源代码编译安装 /*安装CMake*/ /*进入CMake源代码所在目录*/ cd # /*解压CMake源代码*/ tar zxf cmake-2.8.3.tar.gz /*进入CMake源代码目录*/ cd cmake-2.8.3 /*配置安装参数*/ ./configure --prefix=/usr/local/cmake /*编译*/ gmake /*安装*/ make install /*设置软连接*/ ln -s /usr/local/cmake/bin/cmake /usr/bin ########################################################################## /*创建用户组*/ groupadd mysql /*创建用户并加入用户组，并取消永不的sbin权限*/ useradd -g mysql -s"/sbin/nologin" mysql /*进入root目录[源文件所在目录]*/ cd # /*解压mysql源代码*/ tar zxf mysql-5.5.8.tar.gz /*进入解压后的MYSQL源代码目录*/ cd mysql-5.5.8 /*用cmake配置编译选项*/ cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/home/mysql -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/t...

源码编译安装 MySQL 5.6.10最佳实践 经过与cmake的参数对照之后，去除掉已经被取消的参数（大多数是因为新版本已经默认启用），cmake的参数配置如下： cmake -DCMAKE_INSTALL_PREFIX=/usr/mysql \ -DSYSCONFDIR=/usr/mysql/etc \ -DMYSQL_DATADIR=/usr/mysql/data \ -DMYSQL_TCP_PORT=3306 \ -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \ -DMYSQL_USER=mysql \ -DEXTRA_CHARSETS=all \ -DWITH_READLINE=1 \ -DWITH_SSL=system \ -DWITH_EMBEDDED_SERVER=1 \ -DENABLED_LOCAL_INFILE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITHOUT_PARTITION_STORAGE_ENGINE=14.1参数：-DWITHOUT_PARTITION_STORAGE_ENGINE=1  在64位机器上编译不过，会出现如下错误:(64位机器的浮点数运算上出错,导致找不着相应的函数) libsql.a(handler.cc.o): In function `get_ha_partition(partition_info*)’: /data/mysql-5.5.14/sql/handler.cc:269: undefined reference to `ha_partition::ha_partition(handlerton*, partition_info*)’ /data/mysql-5.5.14/sql...

�����ڵ�����Ȩ�鿴����־

�����ڵ�����Ȩ�鿴����־

�����ڵ�����Ȩ�鿴����־

nstallation of MySQL For security reasons, running the server as an unprivileged user and group is strongly encouraged. Issue the following (as root) to create the user and group: groupadd -g 40 mysql && useradd -c "MySQL Server" -d /srv/mysql -g mysql -s /bin/false -u 40 mysql If the MySQL server is not needed, it is possible to build only the client libraries of MySQL. To do this you need to add -DWITHOUT_SERVER=ON to the cmake command below. MySQL contains an embedded server library. By default, it is built as a statically linked library, libmysqld.a, but by applying the optional patch, a shared version of this library can be built. The library is needed by certain applications, such as Amarok and it is recommend to use the shared libraries whenever it is possible. There are numerous o...

再编译安装cmake之前，已经将编译安装了最新版的GCC 4.8.1与最新版内核 Kernel  3.11.6从cmake官网下载最新的cmake版本， 下载的是cmake-2.8.10.2.tar.gz，地址http://www.cmake.org/cmake/resources/software.html1、解压cmake-2.8.12.tar.gz #：tar -xvf cmake-2.8.12.tar.gz2、在cmake-2.8.10.2同级目录下新建一个编译目录 #：mkdir cmake-bulid #：cd cmake-build3、编译cmake #：.././bootstrap --prefix=/usr#：gmake#：make install查看cmake是否安装成功： cmake --versionoutput: cmake version 2.8.10.2恭喜你，安装成功了。

yum 时提示Transaction Check Error的问题在用yum install 时 出现 Transaction Check Error 是因为软件冲突导致的。以下红色部分就是冲突的软件，如果是rpm安装的，可以直接rpm 卸载掉，重新yum install 安装。安装包冲突了，卸载掉mysql-5.0.95-1.el5_7.1.i386 再试试看 rpm -e mysql-5.0.95-1.el5_7.1.i386 或是 yum -y remove mysql-5.0.95-1.el5_7.1.i386[root@localhost ~]# yum install mysql Loaded plugins: fastestmirrorLoading mirror speeds from cached hostfile * base: ftp.cuhk.edu.hk * extras: ftp.cuhk.edu.hk * updates: ftp.cuhk.edu.hkSetting up Install ProcessResolving Dependencies--> Running transaction check---> Package mysql.i386 0:5.0.95-5.el5_9 set to be updated--> Processing Dependency: perl(DBI) for package: mysql--> Running transaction check---> Package perl-DBI.i386 0:1.52-2.el5 set to be updated--> Finished Dependency ResolutionDependencies Resolved============================================================================================================...

缓存服务varnish安装配置一、varnish优点1、数据存储，可以使用内存缓存，也可以使用磁盘大文件存储，减少小文件频繁读写2、充分利用多核cpu,支持http/1.1协议3、可以使用正则匹配缓存，配置灵活，思路清晰，管理端口，工具工具使用方便二、工作原理流程 三、安装及其配置官方地址https://www.varnish-cache.org/tar varnish-3.0.0.tar.gzcd varnish-3.0.0./configure --prefix=/usr/local/varnish3.0make && make install配置实例及说明vim /usr/local/varnish3.0/etc/varnish/default.vcl#设置后端服务backend test1 {    .host = "192.168.100.5";    .port = "80";    .connect_timeout = 1s;    .first_byte_timeout = 5s;    .between_bytes_timeout = 2s;}backend test2 {    .host = "192.168.100.6";    .port = "80";    .connect_timeout = 1s;    .first_byte_timeout = 5s;    .between_bytes_timeout = 2s;}#定义负载均衡director lb_test ra...