python database (mysql) operation

Foreword: Recently I began to learn django and web framework. I felt that I could learn a lot of knowledge. happy ~ ~ This blog collates and writes down the basic operation of the database, with very little content. Write SQL Alchemy tomorrow.   Basic operation of database 1. To allow writing Chinese in a database, use the following commands wh ...

Posted on Wed, 10 Apr 2019 23:30:30 -0400 by kenmay09

MySQL: A Case of Incremental Data Recovery in Database

For reprint, please indicate the source: http://blog.csdn.net/l1028386804/article/details/60326337 I. Use scenarios MySQL database is fully automated at 0:00 a.m. per day At 9 a.m. one day, Zhang San accidentally drop ped a database. We need full data files and incremental binlog files for data recovery 2. Main Ideas and Principles Find o ...

Posted on Wed, 10 Apr 2019 22:30:31 -0400 by ignace

Spring Boot [Configuration - Part I]

Guidance: In the last article, we learned how to build a simple Spring Book project. In this article, we focus on the externalization of Spring Boot files. Quick Start: Externalized Configuration First, a typical Spring Book project structure is as follows com +- example +- myproject +- Application.java | +- d ...

Posted on Wed, 10 Apr 2019 15:09:31 -0400 by essexboyracer

Ozie Common Statements

1. Introduction to oozie: oozie can be called a scheduling system, referring specifically to this blog: http://shiyanjun.cn/archives/684.html In this blog post, the functions and usage of oozie are described in detail. Second, oozie performs follow-up monitoring: the results of oozie execution can be written into the MySQL data table, and oo ...

Posted on Wed, 10 Apr 2019 06:06:31 -0400 by anthonyfellows

MySQL Single Computer and Master-Slave Monitoring of Nagios

All server systems in this chapter are CentOS release 6.4. Other information is as follows: Monitoring IP: 172.16.56.131, host name: monitors, nagios-core, nagios-plugins and NRPE have been installed and configured; MySQL main library IP: 192.183.3.145, host name: kk, MySQL version 5.6.32, has been installed and configured nagios-plugins a ...

Posted on Tue, 09 Apr 2019 22:12:34 -0400 by jmurch

Zabbix 3.2 Installation Notes

I. Installation of Virtual Machines Virtual Machine Configuration: 1 Core 2G, 20G Hard Disk Service packages selected at installation: Select base, large systems performance, legacy unix compatibility in base system Select mysql database client, mysql database server in database desktops full selection Select Chinese support in language ...

Posted on Tue, 09 Apr 2019 21:57:32 -0400 by macpaul

mysql master-slave replication (one-way synchronization)

0, environment System: ubuntu14.04 (Aliyun Tencent Cloud) Database: MySQL 5.6 Master: Ali Yunubuntu From:Tencent Yunubuntu The database that needs synchronization by default has been created beforehand. 1, principle We set up a Master and a Slave or Secondary. Copy data content from the slave library to the master library fo ...

Posted on Tue, 09 Apr 2019 17:54:30 -0400 by netcoord99

mariadb Master-slave Replication and Mutual Master-slave Configuration Process

Environmental preparation: Three mariadb databases have been installed and completed for this test. The experimental results show that two databases are mutually dominant and subordinate, realizing real-time synchronization of data, and one is for the purpose of backup of master and subordinate. A. Configure master-slave replication. 1. Bot ...

Posted on Tue, 09 Apr 2019 02:00:31 -0400 by swathin2

MySQL 5.7 Installation Configuration for CentOS 7

Please respect other people's work results, reprinted please be sure to indicate the source. Thank you! Download the tar package: wget -c http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz wget Is a free tool for automatically downloading files from the network, which supports HTTP,HTTPS and FTP Agreemen ...

Posted on Mon, 08 Apr 2019 21:00:31 -0400 by demophoon88

Development of SpringBoot Video and Video Program Imitating Tremble

I. Project Introduction Simulating the dithering of a short video micro-messaging program, using SpringBoot to build a small program background, using SSM framework to build a short video background management system, small program background through distributed zookeeper monitoring nodes automatically download or delete short video background ...

Posted on Mon, 08 Apr 2019 04:09:31 -0400 by Beans