Install Zabbix3.2 Handwriting based on entOS7.3

1. Install virtual machines Don't repeat here 2. Configuring yum sources Install epel source [root@localhost ~]# yum -y install epel-release Install webtatic source [root@localhost ~]# rpm -Uvh http://mirror.webtatic.com/yum/el7/webtatic-release.rpm Configure zabbix source vim /etc/yum.repos.d/zabbix.repo [zabbix] name=zabbix b ...

Added by fredted40x on Mon, 27 May 2019 20:16:11 +0300

Construction of Ali Cloud Server Deployment Environment

We are in the age of cloud, system operation and maintenance is simpler and more direct than any other era. Record your recent steps in deploying the Aliyun server environment and share them with you. Make a record of yourself. OS information: Linux version 2.6.32-696.3.2.el6.x86_64 (mockbuild@c1bl.rdu2.centos.org) (gcc version 4.4.7 201 ...

Added by mikefn on Sun, 26 May 2019 01:54:03 +0300

mysql custom function (matching the IP interval to the database by IP to include the IP)

mysql custom string query function A function is suitable for processing data formats (fields with','-partitioned data, as well as'-'connected intervals) Example 1: Data "39570" needed to be judged for field "53678, 45672, 39543-39600" in the table Example 2: Data "DD.B1.C1.A3,DD.B1.C1.A1-BA,DD.B1.C1.B0" needed ...

Added by bashaash on Sat, 25 May 2019 03:24:41 +0300

MySQL Create & Delete Datasheets

MySQL Create Data Table Creating a MySQL data table requires the following information: Table Name Table field name Define each table field grammar The following is the general SQL syntax for creating MySQL data tables: CREATE TABLE table_name (column_name column_type); In the following example, we will create the data table runoob_tb ...

Added by j007ha on Thu, 23 May 2019 20:45:50 +0300

A Brief Introduction to Hibernate and Examples of Getting Started

A Brief Introduction to Hibernate   In summary, Hibernate is a lightweight persistence framework for ORM that addresses the mismatch between tables in object and relational databases (impedance mismatch) and the advantage that development code does not inherit hibernate classes or interfaces (non-intrusive).The implementation of the Hibernate ...

Added by tony.j.jackson@o2.co.uk on Thu, 23 May 2019 19:42:20 +0300

MySQL UPDATE & DELETE Query

MySQL UPDATE Query If we need to modify or update the data in MySQL, we can use the SQL UPDATE command to operate. . grammar Following is the UPDATE command to modify the general SQL syntax for MySQL table data: UPDATE table_name SET field1=new-value1, field2=new-value2 [WHERE Clause] You can update one or more fields at the same time. Yo ...

Added by zzz on Thu, 23 May 2019 00:02:17 +0300

day12--Database (Mysq)

1. Introduction to databases What is a database?(https://www.cnblogs.com/alex3714/articles/5950372.html) A Database is a warehouse that organizes, stores, and manages data according to its structure.Each database has one or more different API s for creating, accessing, managing, searching, and replicating stored data.We can also store data in f ...

Added by Acs on Wed, 22 May 2019 22:14:39 +0300

Batch installation of mysql in ansible-playbook

brief introduction _install mysql-5.6.22 through ansible-playbook batch compilation and initialization, then we only need to start the database to build the database. ansible-playbook configuration idea: 1. Configure variables through main.yml in vars, mainly source code storage directory and installation directory. 2. Transfer source file ...

Added by rockroka on Wed, 22 May 2019 03:07:02 +0300

Definition and usage of cursors in MySql

Create a Cursor First create a data table in MySql: CREATE TABLE IF NOT EXISTS `store` (     `id` int(11) NOT NULL AUTO_INCREMENT,     `name` varchar(20) NOT NULL,     `count` int(11) NOT NULL DEFAULT '1',     PRIMARY KEY (`id`)   ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7;      INSERT INTO `sto ...

Added by powergen on Tue, 21 May 2019 22:49:25 +0300

Read-Write Separation of Mysql Master-Slave Configuration

I. Several schemes for master-slave replication of MySQL Database read-write separation is an indispensable and important function for large-scale systems or high-volume Internet applications. From the database point of view, for most applications, from centralization to distribution, the most basic requirement is not the bottleneck of data s ...

Added by cap2cap10 on Tue, 21 May 2019 03:18:58 +0300