可能会出现的错误:
1. -- Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)
CMake Error at cmake/readline.cmake:82 (MESSAGE):
Curses library not found. Please install appropriate package,
remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.
====安装 ncurses-devel,然后删除CMakeCache.txt,重新编译即可
1
2
yum install ncurses-devel
rm -f CMakeCache.txt
2. CMake Error: CMAKE_CXX_COMPILER not set, after EnableLanguage
CMake Error: Internal CMake error, TryCompile configure of cmake failed
-- Performing Test HAVE_PEERCRED - Failed
====缺少gcc相关的包,然后删除CMakeCache.txt,重新编译
启动过程可能报错:
Starting MySQL.. ERROR! The server quit without updating PID file (/home/nc_onldb/DATA/xxx.pid).
====原因可能是配置的pid目录权限问题,此目录跟原有mysql的pid目录一样,但权限是原有mysql的用户,将/var/run/mysqld的所属用户和所属组改成nc_onldb
1
chown -R nc_onldb:nc_onldb /var/run/mysqld
3. 设置mysql主从
1. 配置主(10.0.2.87)
1
2
3
4
vi /usr/local/mysql/my.cnf
添加如下内容:
server-id=87
log-bin=mysql-bin
重启mysql
1
/etc/init.d/mysql restart
设置权限
1
2
3
4
5
/usr/local/mysql/bin/mysql -uroot
>grant replication slave on *.* to 'repl'@'10.0.2.111' identified by 'aabbcc';
>flush privileges;
>flush tables with read lock; #数据库加读取锁
>show master status; #查看主库状态,记住内容,配置从时会用到