teledb（tele for mysql）数据库安装

创建用户、用户组

groupadd teledb
useradd teledb -g teledb

安装Boost

链接：https://pan.baidu.com/s/1qjUg4YZIrSZ1yStcYwcf6A?pwd=zfu8
提取码：zfu8

# 安装依赖包
yum install -y gcc gcc-c++ bzip2 bzip2-devel bzip2-libs python-devel
cd /opt/
# 解压编译
tar -zxvf boost_1_59_0.tar.gz
cd boost_1_59_0
./bootstrap.sh
./b2 install

安装依赖rpm

cd /opt/
yum install -y libarchive
rpm -ivh cmake-2.8.12.2-2.el7.x86_64.rpm
链接：https://pan.baidu.com/s/1z8COipjzZnbdd2ZXteHItg?pwd=o8tb 
提取码：o8tb

yum install -y policycoreutils-python scl-utils
rpm -ivh rh-varnish6-runtime-4.1-6.el7.x86_64.rpm
链接：https://pan.baidu.com/s/1cV-tNom3hqa_-QK8ExZl8A?pwd=000z 
提取码：000z

rpm -ivh rh-varnish6-jemalloc-5.0.1-3.el7.x86_64.rpm
链接：https://pan.baidu.com/s/1iLZpJWlAFChd8wNFfRdzMg?pwd=5g0y 
提取码：5g0y

yum install -y perl
rpm -ivh rh-varnish6-jemalloc-devel-5.0.1-3.el7.x86_64.rpm
链接：https://pan.baidu.com/s/1X1kAtwuZj9uqRitQN87m8g?pwd=zvhw 
提取码：zvhw

rpm -ivh ncurses-base-5.9-14.20130511.el7_4.noarch.rpm
链接：https://pan.baidu.com/s/1IeSOA3WyEhBSg7asEaD6Zw?pwd=wwvm 
提取码：wwvm

rpm -ivh ncurses-libs-5.9-14.20130511.el7_4.x86_64.rpm
链接：https://pan.baidu.com/s/1gVL0gcC_oM8kgajDJQFOkQ?pwd=7kh3 
提取码：7kh3

rpm -ivh ncurses-5.9-14.20130511.el7_4.x86_64.rpm
链接：https://pan.baidu.com/s/1Fv2llzIV6V6Mdylm_4Q0PQ?pwd=puq1 
提取码：puq1

rpm -ivh ncurses-devel-5.9-14.20130511.el7_4.x86_64.rpm
链接：https://pan.baidu.com/s/1Vm615R3HI3WVqqZWzY96mQ?pwd=0chc 
提取码：0chc

编译teledb（注意空间大于10G）

下载包地址：https://gitee.com/teledb/teledb-for-mysql

cd /opt
yum -y install unzip
unzip teledb-for-mysql-master.zip
cd teledb-for-mysql-master

cmake -DCMAKE_INSTALL_PREFIX=/home/teledb -DMYSQL_DATADIR=/home/teledb/data -DSYSCONFDIR=/home/teledb -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/opt/boost_1_59_0 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/home/teledb/mysql.sock -DMYSQL_TCP_PORT=4406 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

 #编译安装
make && make install

配置文件my.cnf

vi /etc/my.cnf

[client]
port = 4406
socket = /home/teledb/mysql.sock
default-character-set = utf8mb4
 
[mysqld]
port = 4406
socket = /home/teledb/mysql.sock
basedir = /home/teledb
datadir = /home/teledb/data
pid-file = /home/teledb/teledb.pid
log_error = /home/teledb/mysql-error.log
user = teledb
 
default_storage_engine = InnoDB
max_connections = 1000
max_connect_errors = 6000
open_files_limit = 65535
table_open_cache = 128
max_allowed_packet = 64M
binlog_cache_size = 128M
max_heap_table_size = 128M
tmp_table_size = 128M
sort_buffer_size = 64M
join_buffer_size = 64M
 
innodb_file_per_table = 1
innodb_open_files = 500
innodb_buffer_pool_size = 1024M
innodb_log_buffer_size = 128M
innodb_log_file_size = 256M

修改权限

chown -R teledb:teledb /home/teledb

初始化实例

cd /home/teledb/bin
./mysqld --initialize --user=teledb --basedir=/home/teledb --datadir=/home/teledb/data

配置服务

cp /home/teledb/support-files/mysql.server /etc/init.d/teledb
 
chmod +x /etc/init.d/teledb

vi /etc/init.d/teledb
basedir=/home/teledb
datadir=/home/teledb/data

vi /etc/systemd/system/teledb.service

[Unit]
Description=TeleDb
After=network.target
 
[Service]
User=teledb
Group=teledb
ExecStart=/etc/init.d/teledb start
ExecStop=/etc/init.d/teledb stop
ExecReload=/etc/init.d/teledb reload
Type=forking
RemainAfterExit=yes
 
[Install]
WantedBy=multi-user.target

重新加载systemctl的配置文件，然后启动下看看效果:

sudo systemctl daemon-reload
systemctl start teledb
systemctl status teledb

配置远程连接

cd /home/teledb/bin/
./mysql -uroot -p
输入/home/teledb/mysql-error.log 文件中的root密码
# 修改密码
set password for root@localhost = password('123456');
# 配置远程访问
use mysql;
update user set user.Host='%' where user.User='root';
flush privileges;

数据库连接信息

账号：root
密码：123456
端口：4406