OneSQL installation, onesql

OneSQL installation, onesql

To install Onesql, you must install MySQL first, and both versions must be consistent. You can complete OnwSQL configuration by using mysqld or mysqld_safe of OnSQL.

Http://www.onexsoft.cn /? Page_id = 3391 # toggle-id-2OneSQL customization official 5.6.25 version: onesql-5.6.25-all-intel-linux64.tar.gz official 5.6.26 version: onesql-5.6.26-all-intel-linux64.tar.gzOneSQL is civilian software to MySQL/PostgreSQL based, integrates more than ten years of Architecture Experience in Internet O & M, data, and application, and provides in-depth database versions tailored for important scenarios such as e-commerce and Internet Finance. It is compatible with the original official version 100% and provides many practical technical improvements in terms of high concurrency, transaction processing, Master/Slave switchover, and data protection, so that the performance of thousands of concurrent connections is not reduced, there is an optimal solution for the second kill scenario, which provides better transaction processing performance on shared cloud disks. Master/Slave switchover adopts more rigorous steps and zero data loss solutions, and make Slave no longer lag behind. Test the simple Select on a PC with 16 Interl E5-2680 CPUs, which can measure 0.36 million QPS per second (download and unzip to the "/usr/local" directory to complete the installation ). Leader Ye's onesql test benchmark (mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz) creates a user # groupadd mysql # useradd-g mysql-d/opt/mysql-s/sbin/nologin mysql # password mysql (mysql) create directory # mkdir-p/data/mysql/mysql_3307/{data, mysqlbinlog, tmp, logs} # chown-R mysql: mysql/data # chmod-R 775/data will be saved to the installation package in the local hard disk and uploaded to the/u01/soft directory of the target machine through FTP or other methods. # 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 reference configuration file: (omitted) installer #/usr/local/mysql5.6.26/script S/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 check the log after installation, check whether any error is reported. # Cat/data/mysql/mysql_3307/logs/error3307.log unzip the onesql-5.6.26-all-intel-linux64.tar.gz tar-zxvf onesql-5.6.26-all-intel-linux64.tar.gz-C/usr/local start 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/startup & start onesql information 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 ). 00:01:42 0 [Note]/usr/local/onesql5.6/bin/mysqld (mysqld 5.6.26-log) starting as process 5203... 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 '::'; 00:01:43 5203 [Note] Server socket created on IP :'::'. 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 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

Copyright Disclaimer: This document can be reproduced and must be signed by the original author. Author: Wuwei qq: 490073687