Backup database using cp command

cp command backup is a warm, full backup, the backup process needs to maintain a global read lock, this lock is more lethal to the database, it is likely to make the database hang in production environment, so it is not recommended to use in production environment. 1. Backup 1. Add a global read lock to the backup library: fl ...

Posted by djopie on Thu, 16 Jan 2020 09:39:26 -0800

Complete Debian 7 configuration LAMP (Apache/MySQL/PHP) environment and building station - 2015

Learn from this In this article, I will share my other favorite DEBIAN system environment. It may be preferred by novices One click installation package , but this step installation is more clear about what you need to install, and it can save resources. Some components do not need to be installed, ...

Posted by l3asturd on Thu, 16 Jan 2020 09:27:57 -0800

Mysql - get [this month, last month] data to compare sql

When receiving business requirements, it is necessary to analyze the data comparison between current month and last month for each business type. During data query, one problem needs to be solved: all business types of current month and last month need to be displayed, but some business types of last mo ...

Posted by rockroka on Thu, 16 Jan 2020 06:40:42 -0800

Django framework: design model

1. Design model We used to operate the database by writing sql statements. Can we operate the database without writing sql statements? Of course, it's time to use the ORM framework. 1.1 ORM framework O is object, which means class object, R is relation, translated into Chinese is relation, which means data table in relational database, M is map ...

Posted by pocobueno1388 on Wed, 15 Jan 2020 03:06:21 -0800

EMQ X plug-in persistence series MySQL MQTT data store

In this paper, the actual example in CentOS 7.2 is used to illustrate how to store the relevant MQTT data through MySQL MySQL is a traditional relational database product. Its open architecture makes users highly selective. With the gradual maturity of technology, MySQL supports more and more functions, ...

Posted by bob on Wed, 15 Jan 2020 01:36:11 -0800

18 MySQL middleware proxysql realizes mysql read-write separation

1. The way of separating read from write in MySQL There are several ways for mysql to achieve read-write separation: The program modifies mysql operation, communicates with database directly, realizes load balance in a simple and quick way with separation of reading and writing and random way, and di ...

Posted by palace on Tue, 14 Jan 2020 21:33:23 -0800

MySQL learning - common database commands

Pycharmlog in to MySQL 1. Create project 2. Click the Database button on the right3. Enter the user name and password of mysql in the pop-up edit boxIf Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' profile error is prompted, please refer to: Problem solving Database ...

Posted by Giri J on Mon, 13 Jan 2020 19:51:16 -0800

ZABBIX 3.4 from entry to mastery

zabbix Foundation Chapter 1 about zabbix 1.1 why to use monitoring 1. Continuous real-time monitoring of the system2. Real time feedback system current status3. Ensure service reliability and safety4. Ensure the continuous and stable operation of business 1.2 how to monitor For example, we need to monitor disk utilization1. How to view disk u ...

Posted by PlasmaDragon on Mon, 13 Jan 2020 19:28:10 -0800

How do I view all foreign keys for a table or column?

stay MySQL How to get a list of all foreign key constraints to a specific table? Specific columns? This and The Oracle problem Same, but for MySQL. #1 building Post old answers to add some useful information. I have a similar problem, but I also want to look at constraint'u type and referred t ...

Posted by Bike Racer on Mon, 13 Jan 2020 18:04:15 -0800

Use Binlog logs to restore mistakenly deleted MySQL data

Preface "Delete library and run" is a topic that programmers often talk about. Today, I will teach you how to delete!Library!Run!Road! Just kidding, the topic of this article today is how to use Mysql's built-in Binlog log to recover mistakenly deleted data. After reading this article, you ...

Posted by m2babaey on Mon, 13 Jan 2020 16:54:40 -0800