OneSQL安装,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
版权声明:声明:本文档可以转载,须署名原作者。 作者:无为 qq:490073687
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。