testjetco
- Total activity 49
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 11
Posts
Recent activity by testjetco Sort by recent activity-
Tables Cannot Sync Among Galera Clustering Nodes
I built a 3-node cluster using MariaDB 10.3.10. It is for production. When inserting records into MariaDB by 'source script', records can be sync to node 2 and 3. But when records were inserted b...
-
mysqldump option: --all-databases vs --all-tablespaces
What is the difference between using --all-databases and --all-tablespaces when using mysqldump command to back up MariaDB/mysql db? For me, they are the same, aren't they?
-
'mariabackup --prepare': Cannot open config file, backup-my.cnf
I am testing mariabackup. I could successfully make a mariadb backup using mariabackup utility. As the manual said before restore (--copy-back), we should use '--prepare' option first. Therefore,...
-
Insert Record in the node with wsrep_on=OFF. Cannot Sync after Rejoin the Cluster when wsrep_on=ON
3-node cluster in MariaDB 10.3.10. Restart node 2 with wsrep_on=OFF in server.cnf Insert a new record into a table in node 2. Insert a new record into the same table in node 1. The new record was...
-
MariaDB Crashed when I Updated WSREP_ON Global Variable
Today I performed testing on Galera Clustering with MariaDB 10.3.10. I have 3-node cluster. I updated the server.cnf with the following statement: wsrep_on=OFF I restarted mysql by ... # systemctl...
-
Create and Insert Work but not Drop or Delete for MariaDB Galera Clustering
I am using MariaDB 10.3.10 with 3-node clustering. I created table and inserted data at node 1. I could see new table and new data inserted in node 2 and 3. But if I perform delete or drop tabl...
-
Cannot join the New Cluster
I am using MariaDB 10.3.10 and tried to establish a 3-node cluster. First I dealt with the first two nodes. I have successfully started the 1st cluster node using command, 'galera_new_node'. But...
-
MariaDB Replication Setup between Two Clusters (Primary and DR)
I have reviewed the following url: https://severalnines.com/blog/architecting-failure-disaster-recovery-mysqlmariadb-galera-cluster and I want to implement the 'Active Passive Master-Slave C...
-
Data Sync Among Cluster Nodes After A Node Joining Back the Cluster
I have 3 Galera cluster nodes running MariaDB. After shutting down node 3, I started it up as a standalone MariaDB. I inserted a new table into node 3. Then I restarted node 3 as a cluster node....
-
MariaDB Installation - yum install vs rpm -Uvh
I have installed MariaDB 10.3.10 using the following command: # rpm --import RPM-GPG-KEY-MariaDB # ./setup_repository # yum install -y MariaDB-server Only the following 5 packages were installed. ...