configuring MySQL master-slave replication

DescriptionMySQL version is 5.6.26The installation of the MySQL step is omitted.MySQL Master-slave replication note points1 , on the master side, to enable the Binlog log. Slave end without enabling Binlog log2 , master and slave, or Server-id.The

Zabbix monitoring MySQL master-slave status

First on the monitored script: #!/bin/bashstatus= ' Mysql-u root-p123-e "show Slave Status\g" | Egrep "Slave_io_running| Slave_sql_running "| Awk-f: ' {print $} ' | TR "\ n" "" ' arr_status= (' echo $status ') [[${arr_status[0]} =~ "yes"] && [[$

Stored procedures for MySQL database (i)

Stored procedures for MySQL databaseConventionalCreate routineAlterExecuteSecurityDefinerThe default is to select the appropriate database when creating the stored procedure (use db_name)Therefore, you cannot write this statement in a stored

MapServer using MySQL data

In open source databases, the best support for spatial data is that Postgresql/postgis,postgresql is another well-known database in the open source database that supports basic spatial data types such as point, line, polygon, box, PATH, etc. As this

How to allow an extranet to connect to a MySQL database

Here's how it's implemented:1, first check the MySQL server firewall, if the external network to 3306 port connection, then release the limitExecuted in Linux serverIptables-l can view the current firewall rulesIptables-f can empty all firewall

PHP7 + Apache2.4 + MySQL 5.7 + Windows7

Downloadphp7:http://windows.php.net/download#php-7.0Download extract to specified directory: C:/SOFT/PHP/PHP7mysql5.7:http://dev.mysql.com/downloads/mysql/Download extract to specified directory:

MySQL stored procedure function trigger

MySQL stored procedures and function stored proceduresDownloadDemoMysql> delimiter//--here//for modifying the default delimiter;mysql> CREATE PROCEDURE simpleproc (out param1 INT), BEGIN    SELECT COUNT (*) into param1 from T;      End//query OK, 0

MySQL Learning note (vi) Explain analysis query

Using explain, you can emulate the optimizer's execution of SQL statements to understand how MySQL handles your SQL and analyze the bottleneck of query statements or table structures.By Expain you can get:1) Table: Shows which table the data for

mysql-Prevent SQL injection

To escape a parameter using mysql_real_escape_stringIn conjunction with parameterized queries$query = sprintf ("select * from Users where username= '%s ' and password= '%s '", mysql_ Real_escape_string ($Username),

MySQL Modify database encoding to UTF8

Today in the Web page to insert data into the database, found that the inserted Chinese data in the database is displayed in the table is a question mark, in the online tutorial tried a lot of methods have no effect, and finally found a solution1.

MySQL Basics (HD video)

Course Description:Any development system can not be separated from the support of the database, Java Web Development is the same, this section on Java Web Development, the basic knowledge of the database language MySQL, operating points, practical

Monitoring the MySQL service is working

1 , processes, and ports are successful MySQL Service OK#!/bin/bashPort= ' netstat-ntl |grep 3306 |wc-l 'process= ' ps-ef |grep mysql |grep-v grep |wc-l 'If [$port-eq 1] && [$process-eq 2]Thenecho "MySQL is running"Else/etc/init.d/mysqld startFi2 ,

Linux compiling MySQL error about Mysql.sock

When I compiled MySQL, I pointed mysql.sock directly to the mysql/run/below:-dmysql_unix_addr=/usr/local/mysql/run/mysql.sock \Tip Mysql.sock File not found, I summed up the situation I encountered. The first: No mysql.sock path is specified, at

MySQL Build date dimension table

The first step is to create the function f_dim_dayCREATE PROCEDURE F_dim_day (in Start_date VARCHAR (a), in Date_count int)Begindeclare i int;Set i=0;DELETE from Dim_day;While IINSERT into

MySQL Master and slave settings

Preparatory work:Configuration of Master machine and slave machine1, modify the master machine MySQL configuration file my.cnf, the file in/etc directoryAdd the following fields to the [mysqld] configuration segmentServer-id=1Log-bin=logBINLOG-DO-DB=

MySQL Learning 9: A detailed explanation of foreign key constraints in MySQL

This article mainly explains the foreign key constraints in MySQL. A constraint overview The purpose of creating a constraint is to ensure the integrity and consistency of the data. Constraints are divided into table-level constraints and

MySQL: Table comments and Field notes

MySQL: Table comments and Field notes1 Write comments when creating a tableCREATE TABLE Test1(field_name int comment ' field comment ') comment= ' table notes ';2 Modifying a table's annotationsALTER TABLE TEST1 comment ' modified table comment ';3

MySQL Master-slave replication

Modify the profile under the master server:To modify the master server master:vim /etc/my.cnf[mysqld]log-bin=mysql-bin //[必须]启用二进制日志server-id=100 //[必须]服务器唯一ID,默认是1,一般取IP最后一段From the server:Modify the slave from the server:vim

Simple use of Mysql (III), use of mysql

Simple use of Mysql (III), use of mysql Simple use of Mysql (2) Merge two tables with the same structure in mysql: (Note that the structure of the two tables must be the same) There are two tables with the following structure: father and

MySQL ERROR 1045 (28000): Access denied for user & #39; root & #39; @ & #39; localhost & #39; (using password: NO) solutions and causes,

MySQL ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO) solution and cause,   I downloaded MySQL5.7.11 for installation in the past two days and found that no matter how many times I entered the password for the

Total Pages: 3233 1 .... 1802 1803 1804 1805 1806 .... 3233 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.