- Sep 30 Mon 2019 18:30
-
中醫十大類方 (黃煌) (僅有一個連結)
- Jun 20 Thu 2019 15:08
-
修復麻煩的Mongodb data engine WiredTiger
- Oct 08 Mon 2018 11:19
-
雞肋般的半同步複寫(Semi-Synchronous Replication)
- Aug 03 Fri 2018 17:53
-
安裝Percona Toolkit On RHEL 7
因為在centos / rhel上安裝會出現相依套件錯誤,
(儘管使用yum 也會出現下面的套件遺失)
Error: Package: percona-toolkit-3.0.11-1.el7.x86_64 (percona-release-x86_64)
Requires: perl(IO::Socket::SSL)
(儘管使用yum 也會出現下面的套件遺失)
Error: Package: percona-toolkit-3.0.11-1.el7.x86_64 (percona-release-x86_64)
Requires: perl(IO::Socket::SSL)
- Jan 25 Thu 2018 15:59
-
用oplog回復Recovering狀態 - Mongodb Replica Set
- Sep 08 Fri 2017 11:58
-
修復table marked as crashed
- Aug 30 Wed 2017 11:38
-
[記錄用]MariaDB收集的url decode/encode functions
- Aug 25 Fri 2017 15:25
-
MariaDB Lock - level比較
- Aug 23 Wed 2017 14:47
-
好用的MySql-Like熱備份方式innobackupex
- Jul 27 Thu 2017 18:14
-
實作簡單的MariaDB Replication
MariaDB HA有幾種類型
1. 同步 -> 也就是galera cluster
2. 半同步 -> Semisynchronous Replication
3. 異步 -> standard replication
1. 同步 -> 也就是galera cluster
2. 半同步 -> Semisynchronous Replication
3. 異步 -> standard replication
- Jul 27 Thu 2017 16:45
-
MariaDB 修改資料路徑
這類的文章很多,
先介紹正常的步驟
1. 停止服務
sudo systemctl stop mariadb
2. 搬移資料(會將整個mysql目錄搬過去,含權限)
sudo rsync -av /var/lib/mysql /new_path
3. 修改my.cnf設定檔
[mysqld]
...
socket = /new_path/mysql/mysql.sock
datadir = /new_path/mysql
...
[client]
...
port=3306
socket = /new_path/mysql/mysql.sock
...
4. 修改Selinux (RHEL/Centos 才有, 使用getenforce檢查)
4-1. 停用
sudo vi /etc/sysconfig/selinux
SELINUX=disabled
先介紹正常的步驟
1. 停止服務
sudo systemctl stop mariadb
2. 搬移資料(會將整個mysql目錄搬過去,含權限)
sudo rsync -av /var/lib/mysql /new_path
3. 修改my.cnf設定檔
[mysqld]
...
socket = /new_path/mysql/mysql.sock
datadir = /new_path/mysql
...
[client]
...
port=3306
socket = /new_path/mysql/mysql.sock
...
4. 修改Selinux (RHEL/Centos 才有, 使用getenforce檢查)
4-1. 停用
sudo vi /etc/sysconfig/selinux
SELINUX=disabled
