Linux

MariaDB Galera Cluster 筆記

原本 MySQL 加Cluster 的方法實在很麻煩,又要mysqldump又長downtime,仲要好難SET。今日無意中發現MariaDB Galera Cluster加入Cluster Node 係方便好多!

基本上跟住呢個教學做就OK
https://ahmermansoor.blogspot.com/2019/02/install-mariadb-galera-cluster-on-centos-7.html
( mysql_secure_installation 嗰一步唔使做 )

但有個卡關位係,因為本身個MariaDB 比較大,Cluster Node 開始Sync 嘅時候,多過1分30秒,systemd 當start fail!

解決方法係喺 /etc/systemd/system/mysqld.service, 喺 [Service] 下面加返 TimeoutStartSec = 60m

另外/etc/my.cnf 如果有啲特別設定,最好都複雜埋去啲 Cluster Node 。

仲有只支援 InnoDB,MyISAM 同步唔到新加的資料,要留意。

Install Windows 7 x86 on KVM VPS using dd

Support KVM only. OpenVZ is not supported.

  1. Backup your files on your VPS.
  2. Install CentOS on your VPS.
  3. Install these packages:
    yum install -y gawk sed grep glibc-common
  4. Install Windows by running the following command:
    wget --no-check-certificate -qO DebianNET.sh 'https://moeclub.org/attachment/LinuxShell/DebianNET.sh' && bash DebianNET.sh -dd 'https://moeclub.org/get-win7embx86-auto'

    It may takes up 40 to 90 mins, depends on your VPS. The ssh session will be closed. You cannot see the progress on the ssh.

  5. If your VPS provider supports VNC, you may see “Starting up the partitioner”. It is normal, just pay attend.
  6. After that, you can login to the Windows by RDP or VNC using this Windows Account:
    Username: Administrator
    Password: Vicer

     

(Source: https://moeclub.org)