Shulou(Shulou.com)06/01 Report--

Foreword:

AliSQL is a branch of Alibaba based on the official version of MySQL, which is used in Alibaba Group business and Ali Cloud database service. It is currently maintained by Ali Cloud Database team.

The AliSQL version has undergone a great test in terms of strength and breadth. The latest AliSQL version gets help from other open source branches such as Percona,MariaDB,WebScaleSQL and other communities, as well as Alibaba's experience and solutions in the MySQL field.

According to Li Jin, senior director of Aliyun, more than 300 improvements have been given to AliSQL.

It is reported that AliSQL adds more monitoring indicators and provides personalized solutions for e-commerce second kill, Internet of things big data compression, financial data security and other scenarios. It can help small and medium-sized enterprises and developers to improve their data operation ability.

Another expert said, "in the general benchmark scenario, the AliSQL version has a 70% performance improvement over the official MySQL version. In the second kill scenario, the performance is improved by 100 times."

Https://github.com/alibaba/AliSQL git source code

First of all: uninstall the original native Mysql

[root@data05 ~] # yum remove mysql mysql-server mysql-libs compat-mysql51

Step 1: delete the original mysql configuration file, depending on the system

[root@data05 ~] # rm-rf / var/lib/mysql [root@data05 ~] # rm / etc/my.cnf

Step 2: check to see if the uninstall is clean

[root@data05 ~] # rpm-qa | continue to uninstall grep mysql if any

Step 3: the environment required to install the software

[root@data05 ~] # yum install gcc gcc-c++ ncurses-devel perl

Step 4: install cmake in the environment required to install the software, or download the required version from https://cmake.org/download/

[root@data05 ~] # wget http://down1.chinaunix.net/distfiles/cmake-2.8.10.2.tar.gz

[root@data05 ~] # cd cmake-2.8.10.2 [root@data05 cmake-2.8.10.2] #. / bootstrap; make; make install

Step 5: install the software install bison, download the required version or yum install bison from http://ftp.gnu.org/gnu/bison/

[root@data05 cmake-2.8.10.2] # wget

[root@data05 bison-2.7] # tar-zxvf bison-2.7.tar.gz [root@data05 cmake-2.8.10.2] # cd bison-2.7 [root@data05 bison-2.7] #. / configure [root@data05 bison-2.7] # make- j 8 & & make install

Step 6: set up AliSQL users and groups

[root@data05 bison-2.7] # groupadd mysql groupadd: group 'mysql' already exists [root@data05 bison-2.7] # useradd-r-g mysql mysqluseradd: user' mysql' already exists

Step 7: create a new directory required for AliSQL

New AliSQL installation directory [root@data05 bison-2.7] # mkdir-p / usr/local/mysql New AliSQL database data file directory [root@data05 bison-2.7] # mkdir-p / data/mysqldb

Step 8: download the AliSQL source code and decompress it

[root@data05 ~] # yum install git [root@data05 ~] # git clone https://github.com/alibaba/AliSQL.git [root@data05 ~] # unzip AliSQL-master.zip [root@data05 ~] # cd AliSQL-maste

Step 9: install and compile AliSQL

[root@data05 AliSQL-master] # cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_ARCHIVE_STORAGE_ENGINE=1-DWITH_BLACKHOLE_STORAGE_ENGINE=1-DMYSQL_TCP_PORT=3306-DENABLE_DOWNLOADS= 1 [root @ data05 AliSQL-master] # make [root@data05 AliSQL-master] # make install

Step 10: modify the AliSQL directory owner and group

Modify the permissions of AliSQL installation directory [root@data05 AliSQL-master] # cd / usr/local/mysql [root@data05 mysql] # chown-R mysql:mysql. Modify the AliSQL database file directory [root@data05 mysql] # cd / data/mysqldb

Step 11: initialize the AliSQL database

[root@data05 mysqldb] # cd / usr/local/mysql [root@data05 mysql] # scripts/mysql_install_db-user=mysql-datadir=/data/mysqldb

Step 12: copy the AliSQL service startup configuration file

[root@data05 ~] # cp / usr/local/mysql/support-files/my-default.cnf / etc/my.cnf [root@data05 mysql] # cp support-files/mysql.server / etc/init.d/mysqld [root@data05 mysql] # vim / etc/profile join PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH

Step 12: start the AliSQL service and join boot self-startup

[root@data05 mysql] # service mysqld start [root@data05 mysql] # chkconfig-- level 35 mysqld on

Step 13: enter mysql

[root@data05 mysql] # mysql-u root-p password:. / bin/mysqladmin-u root password' new-password'. / bin/mysqladmin-u root-h data05 password' new-password'

Reference:

Https://github.com/alibaba/AliSQL/tree/master/Docs

Http://blog.csdn.net/kouyanqiu/article/details/53103249

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.