OneSQL安装

安装Onesql需要先安装好MySQL，而且两者的版本必须都要一致。启动的时候只要用OnSQL的mysqld或者mysqld_safe来启动，就可以完成OnwSQL的配置。

http://www.onexsoft.cn/?page_id=3391#toggle-id-2

OneSQL定制
官方5.6.25版本 ：onesql-5.6.25-all-intel-linux64.tar.gz
官方5.6.26版本 ：onesql-5.6.26-all-intel-linux64.tar.gz

OneSQL是平民软件以MySQL/PostgreSQL为基础，融合了超过十年的互联网运维、数据、应用三个层面的架构经验，
为电子商务、互联网金融等重要场景进行深层定制的数据库版本。保持了与原官方版本100%的兼容，
在高并发、事务处理、主备切换及数据保护方面有多项实用的技术改进，可以做到数千并发连接下性能不减，
有针对秒杀场景的最优解决方案，在共享云硬盘上有更好的事务处理性能，
主备切换采用更加严谨的步骤，零数据丢失方案，以及让Slave不再落后等。
在16颗Interl E5-2680 CPU的PC上测试简单的Select，可以压测到每秒36万QPS
（下载后请解压到”/usr/local”目录即完成安装）。

叶老大的onesql测试
http://imysql.com/2014/06/07/mysql-percona-mariadb-onesql-tpcc-benchmark.shtml

安装mysql（mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz）



创建用户
#groupadd mysql
#useradd -g mysql -d /opt/mysql  -s /sbin/nologin mysql
#password mysql
（mysql）

创建目录
#mkdir -p /data/mysql/mysql_3307/{data,mysqlbinlog,tmp,logs}
#chown -R mysql:mysql /data
#chmod -R 775 /data


将保存到本地硬盘中的安装包通过FTP或其它方式上传到目标机器的/u01/soft目录中。
# cd /u01/soft/
# tar -zxvf mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz
# tar -zxvf mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz -C /u01/soft/
# cd /usr/local
# ln -s /u01/soft/mysql-5.6.26-linux-glibc2.5-x86_64 mysql5.6.26
# chown -R mysql:mysql mysql5.6.26
# chown -R mysql:mysql /u01/soft/mysql-5.6.26-linux-glibc2.5-x86_64

#vi /data/mysql/mysql_3307/my_3307.cnf
参考配置文件如下：(省略)

安装程序
# /usr/local/mysql5.6.26/scripts/mysql_install_db --defaults-file=/data/mysql/mysql_3307/my_3307.cnf --user=mysql --datadir=/data/mysql/mysql_3307/data --plugin-dir=/usr/local/mysql5.6.26/lib/plugin --basedir=/usr/local/mysql5.6.26
安装后查看日志，检查是否有报错。
#cat /data/mysql/mysql_3307/logs/error3307.log 

 
 解压 onesql-5.6.26-all-intel-linux64.tar.gz
 tar -zxvf onesql-5.6.26-all-intel-linux64.tar.gz -C /usr/local

启动onesql
sh /usr/local/onesql5.6/bin/mysqld_safe    --defaults-file=/data/mysql/mysql_3307/my_3307.cnf --user=mysql --datadir=/data/mysql/mysql_3307/data --plugin-dir=/usr/local/onesql5.6/lib/plugin --basedir=/usr/local/onesql5.6 &


启动onesql的信息
150827 00:01:42 mysqld_safe Starting mysqld daemon with databases from /data/mysql/mysql_3307/data
2015-08-27 00:01:42 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-08-27 00:01:42 0 [Note] /usr/local/onesql5.6/bin/mysqld (mysqld 5.6.26-log) starting as process 5203 ...
2015-08-27 00:01:42 5203 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2015-08-27 00:01:42 5203 [Warning] option 'innodb-flush-log-at-trx-commit': unsigned value 1 adjusted to 3
2015-08-27 00:01:42 5203 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-27 00:01:42 5203 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-27 00:01:42 5203 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-08-27 00:01:42 5203 [Note] InnoDB: Memory barrier is not used
2015-08-27 00:01:42 5203 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-08-27 00:01:42 5203 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-27 00:01:42 5203 [Note] InnoDB: Initializing buffer pool, size = 512.0M
2015-08-27 00:01:42 5203 [Note] InnoDB: Completed initialization of buffer pool
2015-08-27 00:01:43 5203 [Note] InnoDB: Highest supported file format is Barracuda.
2015-08-27 00:01:43 5203 [Note] InnoDB: 128 rollback segment(s) are active.
2015-08-27 00:01:43 5203 [Note] InnoDB: Waiting for purge to start
2015-08-27 00:01:43 5203 [Note] InnoDB: 5.6.26 started; log sequence number 1625998
2015-08-27 00:01:43 5203 [Note] Server hostname (bind-address): '*'; port: 3307
2015-08-27 00:01:43 5203 [Note] IPv6 is available.
2015-08-27 00:01:43 5203 [Note]   - '::' resolves to '::';
2015-08-27 00:01:43 5203 [Note] Server socket created on IP: '::'.
2015-08-27 00:01:43 5203 [Warning] 'user' entry 'root@node3' ignored in --skip-name-resolve mode.
2015-08-27 00:01:43 5203 [Warning] 'user' entry '@node3' ignored in --skip-name-resolve mode.
2015-08-27 00:01:43 5203 [Warning] 'proxies_priv' entry '@ root@node3' ignored in --skip-name-resolve mode.
2015-08-27 00:01:43 5203 [Note] Event Scheduler: Loaded 0 events
2015-08-27 00:01:43 5203 [Note] /usr/local/onesql5.6/bin/mysqld: ready for connections.
Version: '5.6.26-log'  socket: '/tmp/mysql_3307.sock'  port: 3307  (OneSQL) Source distribution