OneSQL装配

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

http://www.onexsoft.cn/?page_id=3391#toggle-id-2OneSQL定制官方5.6.25版本 ：onesql-5.6.25-all-intel-linux64.tar.gz官方5.6.26版本 ：onesql-5.6.26-all-intel-linux64.tar.gzOneSQL是平民软件以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启动onesqlsh /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/data2015-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 32015-08-27 00:01:42 5203 [Note] InnoDB: Using atomics to ref count buffer pool pages2015-08-27 00:01:42 5203 [Note] InnoDB: The InnoDB memory heap is disabled2015-08-27 00:01:42 5203 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2015-08-27 00:01:42 5203 [Note] InnoDB: Memory barrier is not used2015-08-27 00:01:42 5203 [Note] InnoDB: Compressed tables use zlib 1.2.32015-08-27 00:01:42 5203 [Note] InnoDB: Not using CPU crc32 instructions2015-08-27 00:01:42 5203 [Note] InnoDB: Initializing buffer pool, size = 512.0M2015-08-27 00:01:42 5203 [Note] InnoDB: Completed initialization of buffer pool2015-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 start2015-08-27 00:01:43 5203 [Note] InnoDB: 5.6.26 started; log sequence number 16259982015-08-27 00:01:43 5203 [Note] Server hostname (bind-address): '*'; port: 33072015-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 '[email protected]' 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 '@ [email protected]' ignored in --skip-name-resolve mode.2015-08-27 00:01:43 5203 [Note] Event Scheduler: Loaded 0 events2015-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