Project URL: https://gitee.com/ghi/dbsyncer
DBSyncer (abbreviated as dbs) is an open-source data synchronization middleware that supports MySQL, Oracle, SqlServer, PostgreSQL, Elasticsearch(ES), Kafka, File, SQL, and more …
A MySQL instance on Alibaba Cloud experienced website anomalies. The MySQL error log showed the following error: Sort aborted: Error writing file '/home/mysql/log/tmp/MYFo1tXI' (Errcode: 28 – No space left on device …
Whether for CPU backups or daily export operations, you need to export tables as SQL files …
MariaDB is a great open-source MySQL fork alternative (alongside others like Percona MySQL), but before switching from MySQL to MariaDB, you really need to understand the basic version correspondence between them. Otherwise, you’re likely to run into many …
MariaDB 10 Parallel Replication — Latency Test Results sysbench –test=/root/sysbench0.5/sysbench/tests/db/insert.lua
–mysql-table-engine=innodb –oltp-table-size=1000000
–max-requ …
yum -y install sysbench
echo "* hard nofile 65535
* soft nofile 65535
">>/etc/security/limits.conf
ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlim …
yum -y install git
git clone https://github.com/phpredis/phpredis.git && cd phpredis
whereis phpize
/usr/bin/phpize #adjust to your own path
./configure –with-php-config=/usr/local/php/bin/php-confi …
Check the updated Redis version under Docker:
https://hub.docker.com/_/redis?tab=tags
docker pull redis:latest #Pull the image docker images #List images
Start the image: Below is an example of starting three Redis instances, mapped to external ports 637 …
Create user fs_cloud with password TMW7YxxjnaPc6kxX:
CREATE USER 'fs_cloud'@'%' IDENTIFIED BY 'TMW7YxxjnaPc6kxX';
Create database fs_cloud:
create database fs_cloud default charset utf8 c …
Redis reports a persistence error during program execution.
Solution:
1. Modify the configuration file:
vi redis.conf stop-writes-on-bgsave-error no # Change the value from yes to no. If this line does not exist, append it to the end.
Other optimizations can be applied as needed…
