HiF's Technical Blog

#!/bin/bash
# Container ID or Name
container_name="73eadb6f35e2"
# Database credentials
mysql_name="root"
mysql_pwd="123456"
# Backup directories
backup_dir="/data/mysqlBak/data"
bakup_log="/data/mysqlBak/log"
# Retention period in days
backup_clean_day=5

# Get list of databases, excluding system schemas
DATABASES=$(/usr/bin/docker exec -i ${container_name} mysql -u${mysql_name} -p${mysql_pwd} -e "show databases" | grep -Ev "Database|sys|information_schema|performance_schema|mysql|brp_log")

# Create backup directory if it doesn't exist
if [ ! -d $backup_dir ]; then
    mkdir -p $backup_dir
fi

# Loop through databases and backup
for db in $DATABASES
do
    echo "----------${db}_$(date "+%Y_%m_%d_%H_%M_%S").sql.gz BEGIN----------"
    /usr/bin/docker exec -i ${container_name} mysqldump -u${mysql_name} -p${mysql_pwd} --default-character-set=utf8mb4 --single-transaction --source-data=2 --flush-logs --hex-blob --triggers --routines --events --databases ${db} | gzip > ${backup_dir}/${db}_$(date "+%Y_%m_%d_%H_%M_%S").sql.gz
    
    # Log the backup
    echo "create $bakup_log/${db}-$(date "+%Y_%m_%d_%H_%M_%S").dupm" >> $bakup_log/log.txt
    echo "----------${db}_$(date "+%Y_%m_%d_%H_%M_%S").sql.gz COMPLETE----------"
done

echo "done"

# Delete backups older than X days
find ${backup_dir} -type f -mtime +${backup_clean_day} -delete

-- Option 1: Set the default connection collation globally
SET GLOBAL COLLATION_CONNECTION = 'utf8mb4_general_ci';

-- Option 2: Convert a specific table to a consistent collation
ALTER TABLE tableName CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

# 1. Find the MySQL container ID
docker ps

# 2. Create backup and log directories
mkdir -p /data/mysqlBak/data /data/mysqlBak/log

# Pull the specific Redis image
sudo docker pull redis:7.0.11

# Run the Redis container
sudo docker run -p 6379:6379 \
  --name redis \
  -v /docker/redis/conf/redis.conf:/etc/redis/redis.conf \
  -v /docker/redis/data:/data \
  -d redis:7.0.11 \
  redis-server /etc/redis/redis.conf --appendonly yes

@Slf4j
@RestController
public class DynamicController {
    @Resource
    DataSourceUtil dataSourceUtil;
    @Resource
    UrlClDao urlClDao;

    @GetMapping("/test")
    public Map<String, Object> dynamicDataSourceTest(){
        // 1. Query primary database
        List<UrlCl> urlCls = urlClDao.selectList(new QueryWrapper<>());

        // 2. Switch to a predefined slave database
        DynamicDataSourceHolder.setDynamicDataSourceKey(DataSourceConstant.DB_2);

        // 3. Dynamically create and add a new data source
        DataSourceInfo dataSourceInfo = new DataSourceInfo();
        dataSourceInfo.setUrl("jdbc:mysql://sql.xxxx.xxxxx.com:3306/xxxx...");
        dataSourceInfo.setUserName("xxxxx");
        dataSourceInfo.setPassword("xxxxx");
        dataSourceInfo.setKeyCode("test");

        DruidDataSource druidDataSource = dataSourceUtil.createDataSourceConnection(dataSourceInfo);
        if (Objects.nonNull(druidDataSource)){
            // Register the new source
            dataSourceUtil.addDefineDynamicDataSource(druidDataSource, dataSourceInfo.getKeyCode());
            
            // Set current thread to use the newly added data source
            DynamicDataSourceHolder.setDynamicDataSourceKey(dataSourceInfo.getKeyCode());
            
            // Query using the new data source
            urlCls = urlClDao.selectList(new QueryWrapper<>());
            
            // Close connection when finished
            druidDataSource.close();
        }
        return new HashMap<>();
    }
}

# View the current hardware clock time
sudo hwclock

# Set the software clock (OS time) to match the hardware clock
sudo hwclock -s

# Set the hardware clock to match the software clock (OS time)
sudo hwclock -w

@Data
@AllArgsConstructor
@NoArgsConstructor
public class DynamicDataSource extends AbstractRoutingDataSource {
    // Backup all datasource information
    private Map<Object, Object> defineTargetDataSources;

    /**
     * Determine which datasource the current thread uses
     */
    @Override
    protected Object determineCurrentLookupKey() {
        return DynamicDataSourceHolder.getDynamicDataSourceKey();
    }
}

#!/bin/bash
dd=`date +%Y%m%d%H%M%S`

echo "----------Deleting cache folder----------"
# Replace 'username' with your actual qshell user
rm -rf /root/.qshell/users/username/qupload

echo "----------Starting upload to Qiniu Cloud ${dd}----------"
/data/qiniu/qshell qupload /data/qiniu/config/upload.conf

echo "----------Upload successful!----------"