MySQL

http://www.osyunwei.com/archives/7464.html (Learning operation and maintenance Knowledge good station)DescriptionOperating system: CentOS 5.X 64-bitMySQL master server: 192.168.21.126MySQL slave server: 192.168.21.127,192.168.21.128MySQL

When you create a foreign key in MySQL, you often fail because there are a lot of details in MySQL that we need to keep in mind, and the following are some common reasons why I have summarized and consulted the data myself.1. The type or size of the

MySQL installation is nothing more than the following, where Yum installation is also a RPM installation, but this does not need to download the installation package, directly according to the operating system comes with the MySQL package installed,

After studying the two-week Linux shell script, I finally wrote out a MySQL automation installation script. Plus today's full-day test, you can perform the installation of MySQL 5.5.40 normally. Other versions have not yet been tested. Now share.

MySQLdual-Machine hot standbyEnvironment description650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4C/C1/wKioL1RE0zbAm9B1AAJWSS3H_Mc796.jpg "title=" 1.jpg " alt= "Wkiol1re0zbam9b1aajwss3h_mc796.jpg"/>Msql Primary and standby structure1,

Mysql-u root-p DatabaseName When the database imports data, MySQL receives the following exception: ERROR 1153 (08s01): Got a packet bigger than ' Max_allowed_packet ' bytes.This is because the default configuration of MySQL is not adjusted, the

Working principle:How the query cache works can be broadly summarized as: caching the result set and SQL statements for the select operation or preprocessing query (Note: 5.1.17 start support), a new SELECT statement or a preprocessing query

What is the principle of MySQL's InnoDB engine lock, to do an experiment.Mysql> SELECT VERSION ();+-----------+| VERSION () |+-----------+| 5.5.20 |+-----------+1 row in Set (0.00 sec)CREATE TABLE Test(A INT (5),b VARCHAR (10),C VARCHAR (10));INSERT

Environment: CentOS 6.5,mysql 5.6.19Problem:Error when using Telnet to l0.0.1.120 3306 databaseKHost ' l0.0.1.120 ' is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts ' Connection closed by foreign host.Cause: The

In general, the default webserver is Apache. Zabbix is no exception, official documents are all recommended Apache.If you insist on using Nginx to do webserver, PHP boot needs to install a php-fpm. And in the Zabbix Web installation interface,

to install MySQL ODBC firstThe DSN is then created under ODBC and is under the System DSN. Final Executionexecsp_addlinkedserver @server=' XY ',       --This is the name of the linked server @srvproduct= ' MySQL ',   --you're free to do this

The newly installed MySQL will present anonymous users.Enter MySQL at the command line (if the prompt is not an external or internal instruction, add the bin directory under the MySQL server file to the path of the system paths)If there is no prompt,

Recently in the maintenance of a WordPress mall project, the mall is multi-station, will be independent of the station to create a few tables. Project on the test server, it seems to be a malicious crawler registration, resulting in thousands of

In large-scale web site is often the master from the design of the database, if read and write according to the design pattern is only the main library above, then from the server is often the role of intelligent backup, sometimes the backup port

1. Check the MySQL information that is already installedYum List installed mysql*Rpm-qa | grep mysql*2. List installed and installable MySQL informationYum List mysql*3. Installing the ClientYum install MySQL4. Install server-sideYum Install

/*****************************************************mysql 5.6.19 upgrade to 5.6.21************************************ /Pre-upgrade is required!----1. View the existing version of MySQL data directory location show variables like '%datadir% ';/usr/

Considerations for installing MySQL source code scr. rpm The rpm installation package is usually a Binary package or a Source package. When using the source code to install MySQL, the source code package downloaded on the official website is

Mysql production environment ____ master-slave synchronization repair case I. hardware environment Master: Dell R720 Intel (R) Xeon (R) CPU E5-2640 v2 @ 2.00 GHz MEM 64 GB, disk 4*2.5 SAS network 4 * Gigabit Slave: Dell R720 Intel (R) Xeon (R) CPU E5

Mysql table names in linux/centos are case-insensitive.Scenario: Recently, the company switched the database from ORACLE to MYSQL. Since the table names in ORACLE are case insensitive, the problem of table names not found in mysql occurs, it is

Mysql 5.5 Master/Slave configuration steps, mysql The last time I introduced the mysql 5.1 master-slave configuration tutorial, this time we will implement mysql 5.5 master-slave replication, in fact, the configuration is basically the same, only a