MySQL

MySQL Dual master-high availability Single DB instance InstallationPlease refer to: Binary package installation MySQL Resource planning Host Name OS Version MySQL version Host IP MySQL VIP

Environment: centos6.5 mysql-5.6.22 Master 192.168.3.11centos6.5 mysql-56.22 Slave 192.168.3.150MySQL supports one-way, asynchronous replication, during which one server acts as the primary server, and one or more other servers act as slave servers.

A.ShowTables orShowTables from database_name; --Displays the names of all tables in the current databaseB.ShowDatabases --DisplayMySQLName of all databases inC.ShowColumns from table_name to database_name; OrShowColumns from Database_name.table_name;

How to configure Codeblocks to compile mysql~Category: Linux mysql2012-09-03 15:51 872 people read reviews (2) favorite reports MysqlcompilerlinkerincludesearchbuildLinux, using the Codeblocks, has a variety of code to write the convenience of,

This article will introduce the installation and use of memcachedWhat is Memcached?Free & Open Source, High-performance, distributed memory object caching system, generic in nature, and intended for us E in speeding to dynamic Web applications by

Contact PHP is equivalent to a step closer to the background, has been doing the front end, but also learning PHP, but has not dared to write a blog, now finally have the courage to step forward, but also please bo friends more magnanimous.Server is

1 MySQL InstallationRHEL7 after the default database is MARIADB, if you want to install MySQL must go to the MySQL official website download the corresponding Yun installation source RPM packagehttp://dev.mysql.com/downloads/repo/yum/Then yum

1. What is a database indexIndexes are used to quickly look for records with specific values, and all MySQL indexes are saved as B-trees. If there is no index, MySQL must start scanning all records of the entire table from the first record until it

unsignedThis type can be used to increase the length of the data, both non-negative numbers! For example if tinyint max is 127, that tinyint unsigned max can go to 127 * 2 The unsigned property is only for integral types, whereas the binary property

First, install and set the lamp environmentyum-y Install httpd mysql* php*Second, installation RsyslogServer-side:Yum Install Rsyslog Rsyslog-mysqlRsyslog-mysql: Transferring logs to the MySQL databasemysql-uroot-p1234 Configure Data permissions #

1 Replication OverviewMySQL's built-in replication capabilities are the foundation for building large, high-performance applications. The distribution of MySQL data across multiple systems is done by copying data from one of the MySQL hosts to the

InnoDB in implementing a layer of logical storage space management based on file IO, table space uses a logical hierarchical structure: space, segment Inode, Extent and page. The logic in the implementation layer uses the disk-linked list structure

A while ago, due to write a program to use the database, it was downloaded in the book, but there are a lot of small problems (their desktop is not the problem, it may be my book too slag it), tangled up a good burst, think back, find problems,

1 Installing MySQLYum-y Install Mariadb-serverSystemctl Start Mariadb.serviceSystemctl Enable Mariadb.serviceThe default installation is 5.5.40-MARIADB, the personal favorite version, is no longer the one of the 5.1.　　2 Installing Apache　Yum Install-

Error details: [ERR] [IMP] 2006-mysql server has gone awayThe mood was really ... Nothing to say. Calm down on the internet to check a bit, sure enough, many predecessors have encountered these problems.The reason for the error is because the

1. First tgz the package in the local decompression, the inside of the tar package to the/root directory of CentOS, using TAR-XVF unzip the tar package, extract out the xdebug-2.2.4, Package.xml,2. Enter Xdebug, execute phpize3. Do not error

LOAD DATA [low_priority] [LOCAL] INFILE ' file_name.txt ' [REPLACE | IGNORE]Into TABLE tbl_name[Fields[TERMINATED by ' \ t '][Optionally] Enclosed by "][escaped by ' \ \ '][LINES TERMINATED by ' \ n '][IGNORE number LINES][(Col_name,...)]Custom

If the binary logs that need to be restored are more complex, it is highly recommended that you use MySQL's own replication to recover Binlog instead of using Mysqlbinlog.Directory [Hide] 1. How to Operate 1.1 Execute the Binlog

In the project, the data is processed by time, and in the database, the time processing format2014-12-09 06:30:17The time query comes up as follows:Now to query the specific day of the data, apply the SUBSTRING function, SQL is as follows:Select

based on the previous article method, the batch command is added to enable automatic backup. It is only because the name of the backup file in the batch command is special in terms of time, so it's a special sort of article. 1. Copy the date folder