OneSQL安裝，onesql

OneSQL安裝，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 '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

著作權聲明：聲明：本文檔可以轉載，須署名原作者。 作者：無為 qq:490073687