how to set session

DirectoryPrinciple 1Master-Slave Synchronization configuration 2Master server Synchronization User Authorization 2Configuring MY.CNF files for MySQL master server 3Standby configuration: 4Common commands: 5Dual master Configuration my.cnf

A. Description:To make the database read-only, PostgreSQL does not have a strictly read-only mode (such as temporary tables that are available in read-only transactions). You can set the session or the current transaction for subsequent logons to

(1) ErrLogContains the phase when MYSQD starts and stops, and when the server has any serious errors during operation.related information;You can use the--log-error[=file_name] option to specify where MYSQLD saves the error log file. If no file_name

first, the principle of MySQL master and slave1. Replication ThreadMySQL's Replication is an asynchronous copy process (mysql5.1.7 above is divided into asynchronous and semi-synchronous modes), copied from one MySQL instace (what we call Master) to

Ext.: http://www.cnblogs.com/gaizai/p/3248207.htmlhttp://www.cnblogs.com/gaizai/archive/2013/03/15/2961868.html MySQL table Data Migration automationhttp://www.cnblogs.com/gaizai/archive/2012/10/23/2735556.html Ubuntu10 under MySQL build Master

First, Binlog Introduction The server's binary log records all of the database's operations log (provided that Binlog is opened on its own server) and the execution time of these operations. In order to display these binary content, we can use the

Description Open the MySQL binlog log server, if you do not set automatic cleanup log, the default Binlog log has been retained for a long time, the server disk space is Binlog log full, resulting in a MySQL database error. Use the following

//Send SMS features the following is the tool class exception return 0 Send SMS failure can be result==0 to judge then return failure information If successful, return the validation code information can save session and set session time

http://blog.itpub.net/28218939/viewspace-1975856/Concurrent Replication ( Parallel Replication ) Series three:MySQL 5.7 and MariaDB parallel replication ContrastMa Pengfei Technology MySQL database engineer After two mysql/mariadb on the

Mysql Database Master-slave experience finishingManagement MySQL master and slave has more than 2 years, managed more than 200 sets of MySQL master and slave, almost related to each version of the master and slave, this blog is summarized, part of

1. Slave cannot execute any SQL, including Super user2, Read_only=on, this must be opened to avoid business execution SQL3. Ensure that the transaction ID of the current slave is 1When a problem occurs in the slave sync, manually skip the issue that

BackgroundWe have a legacy system with our production environment A, keeps track of if a user takes an action on causes.com (joins A cause, recruits a friend, etc). I say legacy, but I really mean a prematurely-optimized system. This 500m record

In MySQL 5.1, the improvement in replication is the introduction of new replication technologies: row-based replication.Several modes of MySQL replicationIn MySQL 5.1, the improvement in replication is the introduction of new replication

This paper summarizes the understanding of local variables, user variables and system variables in MySQL.First, local variablesLocal variables are declared by the Declare statement:DECLARE var_name[,... ][DEFAULT value]The default value is declared

Mysql connection is initialized via Init_connect, website description:The string that the server executes for each connected client. The string consists of one or more SQL statements separated by a semicolon character. For example, the auto-commit

1. Error log(1) Description of error logError log: Log the error message encountered by the MySQL service process mysqld during Auto/close or travel(2) Adjustment of error logCheck the error log inside the MY.CNF configuration file

MySQL Master-slave replicationMySQL supports unidirectional two-way chaining cascading real-time asynchronous replication, where one server acts as the primary server (master) during replication, while one or more other servers act as slave servers (

Management MySQL master and slave has more than 2 years, managed more than 200 sets of MySQL master and slave, almost related to each version of the master and slave, this blog is summarized, part of it is from the network, most of it is based on

Mysqldump backup description mysqldump is a utility used by mysql to store databases. It mainly generates an SQL script, including the CREATETABLEINSERT command required to re-create a database from scratch, and is suitable for backing up databases

MySQL (1)-basic syntax and common statements, mysql basic syntax A collection of data that is processed by a computer and can be accessed efficiently is called a Database (DB ).Save the data such as name, address, phone number, email address,