docker Mariadb

1. install

https://linoxide.com/containers/setup-use-mariadb-docker-container/


2. docker network setting in container
https://philipzheng.gitbooks.io/docker_practice/content/network/linking.html

3. mariadb explain
https://mariadb.com/kb/en/library/installing-and-using-mariadb-via-docker/
https://mariadb.com/kb/en/library/configuring-mariadb-for-remote-client-access/
https://tableplus.com/blog/2018/09/mariadb-how-to-create-new-user-and-grant-privileges.html


4. db with network
http://arder-note.blogspot.com/2018/05/docker-container-link-network.html


5.
http://benjr.tw/95284

https://mariadb.org/get-involved/getting-started-for-developers/get-code-build-test/


6. download data
https://relational.fit.cvut.cz/dataset/NBA


7. testing
sqlslap:
https://www.digitalocean.com/community/tutorials/how-to-measure-mysql-query-performance-with-mysqlslap
https://codertw.com/%E7%A8%8B%E5%BC%8F%E8%AA%9E%E8%A8%80/187279/

https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html

https://www.techrepublic.com/blog/how-do-i/how-do-i-stress-test-mysql-with-mysqlslap/


sysbech:
https://github.com/akopytov/sysbench
https://severalnines.com/database-blog/how-benchmark-performance-mysql-mariadb-using-sysbench
https://codertw.com/%E7%A8%8B%E5%BC%8F%E8%AA%9E%E8%A8%80/187279/


linkbech:
https://mariadb.org/performance-evaluation-of-mariadb-10-1-and-mysql-5-7-4-labs-tplc/


8. cluster:
http://benjr.tw/95381

http://benjr.tw/12461

https://abcg5.pixnet.net/blog/post/113914391

http://akuma1.pixnet.net/blog/post/172611248-mariadb-cluster-%E6%9E%B6%E8%A8%AD%EF%BC%8D%EF%BC%8D%EF%BC%88%E4%B8%89%EF%BC%89%E8%A8%AD%E5%AE%9Amariadb-cluster


https://kknews.cc/zh-tw/code/nv8jxaq.html

https://mariadb.com/kb/en/library/what-is-mariadb-galera-cluster/

https://linuxize.com/post/how-to-install-mariadb-on-ubuntu-18-04/

# replicate
https://noter.tw/4508/mariadb-replication-%E8%A8%AD%E5%AE%9A/

https://allen-fjl.blogspot.com/2018/02/centos-7-mysqlmariadb-replication.html

https://www.ithome.com.tw/tech/87416

9.  replicate
https://kknews.cc/zh-tw/code/l3b3eeb.html

https://www.itread01.com/content/1548326306.html

https://www.itread01.com/p/1136578.html

https://abcg5.pixnet.net/blog/post/117473364-%E5%AF%A6%E4%BD%9C%E7%B0%A1%E5%96%AE%E7%9A%84mariadb-replication

https://blog.toright.com/posts/5062/mysql-replication-%E4%B8%BB%E5%BE%9E%E5%BC%8F%E6%9E%B6%E6%A7%8B%E8%A8%AD%E5%AE%9A%E6%95%99%E5%AD%B8.html

https://www.itread01.com/content/1525956033.html

10.
http://benjr.tw/95644

http://benjr.tw/95473

https://mariadb.com/kb/en/library/installing-galera-from-source/

http://random168.blogspot.com/2018/11/mariadbmysql-galera-cluster.html

https://blog.wu-boy.com/2012/11/innodb-as-the-default-mysql-storage-engine/

http://hank20.blogspot.com/2018/04/centos7mariadb103galera-cluster.html

https://www.itread01.com/articles/1494275901.html

http://benjr.tw/95381

https://galeracluster.com/library/documentation/galera-parameters.html

https://galeracluster.com/library/documentation/mysql-wsrep-options.html#wsrep-node-name

https://severalnines.com/database-blog/running-mariadb-galera-cluster-without-container-orchestration-tools-part-one

https://galeracluster.com/library/documentation/quorum-reset.html

https://www.cnblogs.com/nulige/articles/8470001.html

https://galeracluster.com/library/documentation/docker.html

https://codertw.com/%E8%B3%87%E6%96%99%E5%BA%AB/11036/

https://severalnines.com/database-blog/galera-cluster-recovery-101-deep-dive-network-partitioning


11. Galera ok
A. install : 
B. usigin safe start  , start2
C. cluster container
D.  other
E. other 2
F.other 3


12. Other pameter
https://galeracluster.com/library/documentation/mysql-wsrep-options.html#wsrep-cluster-address


https://www.dreamvps.com/tutorials/install-mysql-galera-cluster-centos-7/

http://hank20.blogspot.com/2018/04/centos7mariadb103galera-cluster.html

http://it2record.blogspot.com/2014/07/centos65-mariadb-55-galera-server.html

https://blog.wu-boy.com/2013/03/galera-cluster-for-mysql-multi-master-replication/

https://galeracluster.com/library/documentation/notification-cmd.html

good

https://www.centos.bz/2017/07/centos-7-2-install-mariadb-galera-cluster10-1-21-mariadb-3-master-cluster/

EMC api for isilon

1. login
https://community.emc.com/community/products/isilon/blog/2015/10/29/onefs-api-tutorial-insightiq-performance-metrics

2.  api
http://doc.isilon.com/onefs/8.1.0/api/02-ifs-br-intro-to-onefs-api.htm

3. system api
http://doc.isilon.com/onefs/8.1.0/api/04-ifs-br-file-system-access-apis.htm

unicode and utf8

https://pjchender.blogspot.com/2018/06/guide-unicode-javascript.html


PHP to character


print_r(json_decode('{"t":"\u00ed"}'));

$str = "\u9060\u50b3\u96fb\u4fe1";
echo unicode2utf8($str);

function unicode2utf8($str){
        if(!$str) return $str;
       
        $decode = json_decode($str);
        if($decode) return $decode;

        $str = '["' . $str . '"]';
        $decode = json_decode($str);
        if(count($decode) == 1){
                return $decode[0];
        }
        return $str;
}

ref  1