MariaDB

https://www.howtoforge.com/tutorial/how-to-install-and-configure-galera-cluster-on-ubuntu-1604/

http://dockone.io/article/128 http://container42.com/2014/11/18/data-only-container-madness/ http://dockone.io/article/129 在volume产生时，是docker run的准备阶段（create），而执行entrypoint.sh则是在启动阶段（start）

ssh-copy-id better use root ssh-copy-id finish Reboot clustercontrol server ======sysbench====== [sysbench] select sysbench –num-threads=128 –report-interval=3 –max-requests=0 –max-time=300 –test=/usr/share/sysbench/tests/include/oltp_legacy/select.lua –mysql-table-engine=innodb –oltp-table-size=5000000 –mysql-user=root –mysql-password=“E<8r)^t-E<8r)^t-” –oltp-tables-count=1 –db-driver=mysql –mysql-host=192.168.xxx.xxx –mysql-port=3306 prepare sysbench –num-threads=128 –report-interval=3 –max-requests=0 –max-time=300 –test=/usr/share/sysbench/tests/include/oltp_legacy/select.lua –mysql-table-engine=innodb –oltp-table-size=5000000 –mysql-user=root –mysql-password=“E<8r)^t-E<8r)^t-” –oltp-tables-count=1 –db-driver=mysql –mysql-host=192.168.xxx.xxx –mysql-port=3306 run Oltp read/write * 产生数据 sysbench –num-threads=128 –report-interval=3 –max-requests=0 –max-time=300 –test=/usr/share/sysbench/tests/include/oltp_legacy/oltp.lua –mysql-table-engine=innodb –oltp-table-size=5000000 –mysql-user=root –mysql-password=“E<8r)^t-E<8r)^t-” –oltp-tables-count=1 –db-driver=mysql –mysql-host=192.168.xxx.xxx –mysql-port=3306 prepare * 执行 sysbench –num-threads=128 –report-interval=3 –max-requests=0 –max-time=300 –test=/usr/share/sysbench/tests/include/oltp_legacy/oltp.lua –mysql-table-engine=innodb –oltp-table-size=5000000 –mysql-user=root –mysql-password=“E<8r)^t-E<8r)^t-” –oltp-tables-count=1 –db-driver=mysql –mysql-host=192.168.xxx.xxx –mysql-port=3306 run ...

https://severalnines.com/docs/requirements.html#operating-system-user

https://bobcares.com/blog/database-crash-rescue-how-we-re-built-an-innodb-mysql-database-when-ibdata1-file-was-corrupted/ https://www.percona.com/blog/2014/10/14/recover-orphaned-innodb-partition-tablespaces-in-mysql/