MySQL Master master sync +keepalived

mysqlm-m SyncA Basic ConfigurationMaster Master IP:192.168.100.123from master IP:192.168.100.124Do the same on both servers firstpremise: Close iptables or add a policy otherwise will be error;Vi/etc/sysconfig/iptables-A input-m state–state new-m

CentOS 6.4 Under compile install MySQL 5.6.14

CentOS 6.4 Under compile install MySQL 5.6.14Overview:In CentOS 6.4, the installation of MySQL via Yum is version 5.1, older, so you want to install the high version of 5.6.14 via source code. Body:One: Uninstall the old versionUse the following

MySQL additions and deletions (supplemental)

DDL: Database Definition languagePrimarily used to define databases, tables, views, indexes, triggers, and moreCreate: Primarily for creating databases, creating tables, and creating viewsAlter: Primarily used to modify the definition of a table,

Python operation MySQL Database

Reference: http://www.w3cschool.cc/python/python-mysql.htmlAssume: MySQL has been installed and the database has been created TESTDB The user named "TestUser" is used to connect to the database TestDB and the password is "test123"

MySQL turns on master-slave replication

First step : Turn on all MySQL server's bin log, each server set a unique Server-id value (default is 1, generally take IP last paragraph)Modifying the my.cnf of the primary server (master)[mysqld] log-bin=Mysql-binserver-id=91Modify the MY.CNF from

Execute MySQL statement in shell script

For automated operations, such as backup recovery, DBAs often need to encapsulate SQL statements into shell scripts. This paper describes several methods of SQL statements for shell scripts in MySQL database under Linux environment, for your

MyBatis's MySQL Insert

INSERT INTO after get auto-insert Id:select @ @IDENTITY as IDIf SQL Server is best with select Scope_identity () as IDBecause @ @identity a globalThe same kind of ident_current (' table ')Ident_current returns the identity value that was last

Linux MySQL Storage Engine detailed

MySQL commonly used storage engine is myisam, InnoDB, memory, MERGE , Where InnoDB provides a transaction security table, the other storage engines are non-transactional security tables. &NBSP myisam is the default storage engine for MySQL.

Templates for MySQL cursor loops

CREATE PROCEDURE' db '. ' Test_procedure ' ()BEGIN--you need to define variables that receive cursor data DECLAREACHAR( -); --Cursors DECLARECurCURSOR for SELECTI fromdb.t; -- End Flag DECLAREDoneINT DEFAULTFALSE; --binding the end flag to a

Mybatis+mysql returns the inserted primary key ID

Requirement: After you insert a record into the MySQL database using MyBatis, you need to return the self-increment primary key value for that record. Method: Specify the Keyproperty property in Mapper, as shown in the following example: insert

MySQL installation configuration

In general, when the MySQL installation is complete, there will be some conditions: seconds back, system services, login not up, etc., need to make some settings.First, add the MySQL bin directory to the PATH environment variable.Then, install the

MySQL Primary master replication

MySQL Master Master replication setupSet the Bin-log, and configure the other person for their master1. Build1.1 Master1 is configured as a master for Master2Master configuration

MySQL Master configuration Note

1. The configuration my.cnf is invalid and the MySQL process cannot be startedStarting with version 5.1.7, the MY.CNF direct configuration master-host and other master-slave configuration options (still supported replicate-do-db) are no longer

Python operations on the MySQL database

In Python, you can use the MySQLdb module to connect to the MySQL database and manipulate the MySQL database" First step " MySQL InstallationReference Documentation: http://blog.csdn.net/Jerry_1126/article/details/20837397the second step connects to

MySQL Master Copy Build

MySQL Master Copy Build1. Build1.1 MasterMaster configuration (MY.CNF)[mysqld] log-bin=/usr/local/mysql-5.6.16/log/mysql-binserver_id=1Start Master./bin/mysqld_safe--defaults-file=/usr/local/mysql-5.6. /my.cnf--user=mysql &Create a user for

MySQL Installation StartService fork

Today re-installed MySQL, to the last step of the times wrong, is the third small step that hit the fork. At that time, I felt the trouble, I remember the original problem, but also deleted things, but also restarted.Later inadvertently found that

MySQL Knowledge summary (iv) binary log

1 definitionsThe Bin-log log records all of the DDL and DML statements, but does not include the query statement, which is saved as an event and describes the process of changing the data, which plays an important role in recovering data from a

MySQL stored procedures

A MySQL stored procedure is actually a function in which you can execute multiple SQL statements and create temporary variables.For example, the following main functions of the stored procedure are(1) Create two temporary variables to count the two

MySQL's fragmented knowledge points

Resolving MySQL data case sensitive issues with binary:Binary is not a function, it is a type conversion operator, and it is used to force the string following it to be a binary string, which can be understood to be case-sensitive when comparing

MySQL Execution analysis

Select_type: represents the type of select, the following are common Simple table, which does not use a connection or subqueryPRIMARY: main query, which is the outer queryUNION: The second or subsequent query statement in a unionsubquery: The first

Total Pages: 3233 1 .... 2751 2752 2753 2754 2755 .... 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.