• [MySQL] xtrabackup full incremental backup script


    Full backup script #!/bin/sh # add ling INNOBACKUPEX=innobackupex INNOBACKUPEXFULL=/usr/bin/$INNOBACKUPEX TODAY=`date +%Y%m%d%H%M` YESTERDAY=`date -d”yesterday” +%Y%m%d%H%M` USEROPTIONS=”–user=user –password=123456″ TMPFILE=”/logs/mysql/innobackup_$TODAY.$$.tmp” MYCNF=/etc/my.cnf MYSQL=/usr/local/mariadb/bin/mysql MYSQLADMIN=/usr/local/mariadb/bin/mysqladmin Backupdir = / backup / home directory of MySQL # backup Fullbackupdir = $backupdir / full # full backup directory Incrbackupdir = $backupdir / incr # incremental backup directory Keep = 1 # keep several […]

  • Mongodb database recovery backup


    get ready: The tools used for database backup and recovery are mongodump and mongorestore. The tools used for data table import and export are mongoimport and mongoexport. Therefore, you must enter the files with these four tools. Generally, these four files are under / usr / local / mongodb / bin () 1、 Backup and […]

  • 14k Star! A fast, safe and efficient backup program!


    brief introduction Restic is a fast, efficient and secure backup program. It supports three major operating systems (Linux, MacOS, windows) and some smaller operating systems (FreeBSD, OpenBSD). Project address: https://github.com/restic/restic install Here we only introduce the installation methods of the three operating systems. For other types of operating systems, please refer to the official website. […]

  • What if GitHub access is not smooth? Wait online, hurry


    In daily work, life and studyWe often encounter unexpected situations such as unable to access GitHub, unstable access, etcNo, today’s friends are having problems once again. In order to facilitate users to quickly back up the open source warehouse from GitHub and access it stably, coding is now supportedImport GitHub warehouse! Coding provides a variety […]

  • Kemang released boomx-d pro, upgrading its strength to onboard recording wireless microphone!


    On November 5, 2021, Kemao released boomx-d pro. Kemao has been pursuing excellent sound quality. This time, it has reached an unprecedented height, added onboard recording and safe track functions, double backup, improved the reliability of recording, and supported digital and analog output, which has brought great radio convenience to the creator. Dual backup makes […]

  • “Transportation worries and lying”, winning thousands of miles | tcallus DB7 Pay tribute to every O & M person on the 24th


    In today’s Internet age, especially under the complex background of big data. There is always a group of people. The earth doesn’t explode. They don’t have holidays and are on standby for 7×24 hours. Others up to 996, they 007 a week Yes, they are the operators of “Yun Chou Wei Wo”. Today, we finally […]

  • Back up the Mongo database in the docker container


    preface I wrote a personal blog before. The overall technical stack is Vue + node + Mongo. Before, it was a little white. I didn’t know anything, didn’t set permissions, didn’t modify ports, and didn’t restrict Remote Login Host Suddenly one day, I found that all the data were gone (hacked): Later, Xiaobai continued to […]

  • MySQL lock: 01 Overview


    catalogue Lock overview Function of lock Locking process Impact of lock on Database Lock wait deadlock Lock type Lock range Lock mode Global lock Global read lock Global QC lock Problems with QC lock: Backup lock MDL lock MDL lock type MDL lock compatibility Confirm MDL lock source and elimination method Watch lock Read lock […]

  • Consumer lookup command


    1. View consumer cluster detailscurl xxxx:8050/v1/operator/raft/configuration2. Consumer cluster read / write testcurl –connect-timeout 10 -X PUT —data “test” http://${hostip}/v1/kv/foocurl http://${hostip}/v1/kv/foo3. Consumer backup datacurl http://xxx:8050/v1/snapshot?d… -o registry_31.tgzcurl http://xxx:8050/v1/snapshot?d… -o registry_30.tgz

  • Backup, disaster recovery, business continuity? What’s the difference?


    The concepts of backup, disaster recovery, disaster recovery and business continuity are often heard in the disaster recovery industry. They seem to be the same things. What is the difference between them? Backup Backup is actually very easy to understand. It is to copy one copy of your files or data to another place. Suppose […]

  • Deploying node server environment under Ubuntu – database mongodb


    Install mongodb on Ubuntu Install mongodb https://docs.mongodb.com/manu… withUbuntu 14.04For example: 1、sudo apt-key adv –keyserver hkp://keyserver.ubuntu.com:80 –recv 0C49F3730359A14518585931BC711F9BA15703C6 2、echo “deb [ arch=amd64 ] http://repo.mongodb.org/apt/ubuntu trusty/mongodb-org/3.4 multiverse” | sudo tee /etc/apt/sources.list.d/mongodb-org-3.4.list 3、sudo apt-get update 4、sudo apt-get install -y mongodb-org Modify default port number27107 1. Change/etc/mongod.conf 2. Reset configurationsudo service mongod restart3. Firewall rules/etc/iptables.up.rulesAdd to allow database access […]

  • MYCAT read / write separation + MySQL master / slave (one master and one slave)


    Database has always played a core role in the project and is the bottom layer of all project structures. To put it bluntly, our programmers are dealing with data in project development, and the data are stored in the database, such as mysql, Oracle, PostgreSQL, etc. if the database collapses in a project, the data […]