MySQL

Master configuration:Code to copy code as followsLog-bin = Mysql-binServer-id = 1Binlog-do-db = Powerdns #要同步的数据库Master new Slave Account:Code to copy code as followsmysql> GRANT replication Slave on * * to ' slave ' @ ' 192.168.1.2 ' identified by '

Vi/data/mysql/my.cnfVi/etc/my.cnf1. Basedir ParametersThe original description is:Path to installation directory. All paths is usually resolved relative to this.Explain:This parameter specifies the installation path (MySQL installation directory)

----------------------------------------------------------------------------------------------------------- ---------------------------------------backup command. Transferred from: http://www.cnblogs.com/zhangzhu/archive/2013/07/04/3172486.html------

Infobright is an open source Data Warehouse (Datawarehouse) solution, which is based on a columnstore engine that enables massive data storage with a high data compression ratio of 10:1,40:1 or even larger, depending on data repeatability, The data

The MySQL system variable (variables) is actually a system parameter that initializes or sets the database's use of system resources, the location of files, and so on. These system variables can be divided into global and session-level levels to

Commands to back up the MySQL databaseMysqldump-hhostname-uusername-ppassword databasename > Backupfile.sqlBacking up the MySQL database to a format with a delete tableBacking up the MySQL database is a format with a delete table that allows the

mysql-master1:192.168.72.128mysql-master2:192.168.72.129OS Version: CentOS 5.4MySQL version: 5.5.9 (master and master copy are the same as the MySQL version in the slave server or the master version is higher than the slave version)First, MySQL

1. About the MySQL character setMySQL Character set support (Character set supports) has two aspects: The character set (Character set) and the Sort method (Collation). MySQL support for character sets is refined to four levels: server, database,

To add a field: ALTER TABLE ' User_movement_log 'Add column Gatewayid int not null default 0 after ' RegionID ' (which field is added later) To delete a field: ALTER TABLE ' user_movement_log ' drop column Gatewayid To adjust the order of fields:

Recently encountered in the development of some problems, here to record the solution to the method, has been prepared to forget.1, now create the role of the game, basically support the role of the name of the random, previously this function in

In some applications, you need to know who is working on the table, what has been done, and what is responsible for the pursuit. In MySQL, you can use a trigger implementation.1: Create a test table Mysql> CREATE Table A (a

If you encounter mysql-libs-5.1.73-3.el6_5.x86_64 conflicts with a file from the package Percona-server-server error, there are two situations that cause this problem:1) Uninstall the Mysql-libs package preinstalled by the operating systemRpm-qa |

Today's dev script colleague needs to connect to B server using MySQL command on a server A.The previous steps were to install a MySQL client onto a machine, so that using the command MySQL on a can connect to the B server. Testing Another method

basic commands for MySQLstart: net start MySQL; Enter: MySQL-U root-P/Mysql-h localhost-U root-p databaseName; list database: show databases; Select database: UsedatabaseName; List table: show tables; Show table column properties: Show Columns

How does the MySQL database query data for the previous day based on time? This article has sorted out several solutions that are needed by a friend under reference.The content of this section:How to use MySQL to query the data of the previous day

Sorting by index optimization: ORDER BYSingle-Table query:The order of the indexed columns is exactly the same as the ORDER BY clause, and all columns are sorted in the same direction,MySQL can use an index to sort the results. The ORDER BY clause

Mysql-proxy IntroductionMySQL Proxy is such an intermediary agent layer,The MySQL proxy is a connection pool that forwards the connection requests from the foreground application to the backend database, and through the use of Lua scripting, enables

MySQL ReplicationMySQL replication refers to the transfer of DDL and DML operations on the main library to the library from the binary log, keeping the master and the data from the library in syncMySQL Master-slave Architecture: Advantages: Can cut

Reprint: Http://blog.csdn.net/jaketseng/archive/2007/06/03/2206513.aspxMySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for

Install, configure, and set the encoding format for mysql 5.6.20. I,Install Installation environment System: Window 32 Version: Mysql 5.6.20 1,First download Mysql 5.6.20 Win32 version from the official website http://dev.mysql.com/downloads/mysql/