testjetco
- Total activity 49
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 11
Activity overview
Latest activity by testjetco-
testjetco commented,
For tables not sync issue in SIT, it was caused by the same reason. Some tables were defined as MyISAM at the very beginning. Then ppl performed transactions. Later we discovered that the engine...
-
testjetco commented,
From the URL: https://mariadb.com/kb/en/library/create-tablespace/ it said... "The CREATE TABLESPACE command is not supported in MariaDB. It is only used in MySQL Cluster and in MySQL InnoDB 5.7." ...
-
testjetco commented,
The issue is caused by db engine. Some tables were defined as MyISAM, which is not compatible with Galera clustering. After changing them to InnoDB, clustering sync works.
-
testjetco commented,
There is already a 2-node cluster in SIT, MariaDB version 10.3.10. Galera clustering was adopted. After installation and cluster up and running, we don't stop it. Yesterday, I have checked all th...
-
testjetco created a post,
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...
-
testjetco commented,
If I specify --all-databases, will all the tablespaces be backed up?
-
testjetco created a post,
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?
-
testjetco commented,
I could decompress the backup files. Then I could use --prepare option to normalize the backup files. The file, backup-my.cnf, does exist inside the backup path after decompress. No need to crea...
-
testjetco commented,
Install qpress to /usr/bin solved the decompress issue
-
testjetco commented,
When I tried to perform --decompress, I got the following error: # mariabackup --decompress --target-dir /tmp/backup/mariadb-backup-20181214213349mariabackup based on MariaDB server 10.3.10-MariaDB...