MySQL

There are many solutions for MySQL-HA, such as heartbeat, drbd, mmm, and shared storage, but they have their own advantages and disadvantages. The heartbeat and drbd configurations are complex. You need to write your own scripts to achieve automatic

When people mention reusable queries, the stored procedure is often immediately reflected in their minds. Although these stored procedures are an integral part of the preparation of reusable code, remember that they are only a small part, not all.

MySQL can be said to be the most widely used database for programmers. I will share some common knowledge about MySQL database development and the selection of storage engines, design and use of indexes and optimization of SQL statements when a

The lock mechanism enables multiple threads to operate a table at the same time. As shown in, user A, user B, and user C may query or update data table A at the same time or successively (the previous job has not been completed. When a thread

MySQL-VIP: 192.168.1.200 2-MySQL-master1: 192.168.1.201 3 MySQL-master2: 192.168.1.202 4 5 OS: CentOS 5.4 6. MySQL version: 5.0.89 7 Keepalived version: 1.1.20 1. MySQL master-master Configuration 1. Modify the MySQL configuration file To enable the

Instance Host:Dbasky = 192.168.1.120Dbaskyback = 192.168.1.121 Objective: To synchronize data in the test database of the dbasky host on the dbaskyback host Install mysql[Root @ dbasky] # wget ftp://ftp.cronyx.ru/pub/FreeBSD/ports/distfiles/mysql-5.0

The previous article explains how to install and test MySQL. After the environment is set up, we can continue our learning. This article is familiar with Common commands. 1. Start the MySQL server. In fact, the previous article describes how to

1. My current backup solution is:A (master) -----> B (slave) for real-time synchronization, complete backup at every Sunday on B (slave), do from Monday to SaturdayIncremental backup, Incremental backup time selection, flexible modification

Recently, an application used Amoeba to read tables containing longblob fields from MySQL from several databases. Session was killed is always reported. The result is the cache size of the readable channel in Amoeba. In the com.meidusa.amoeba.net.

1. Create a stored procedure.2. Create an event (scheduled execution of the stored procedure ).For example, if the STUDENT field of a table contains id, name, age, and login_time (logon time );The logon time is updated to the current time every 30

  1: Use the SHOW statement to find out the current database on the server:Mysql> show databases;2: Create a database MYSQLDATAMysql> create database mysqldata;3: select the database you createdMysql> use mysqldata; (when you press the Enter key to

  This is what happened yesterday. It was encountered when I wrote a resume searcher. I checked a lot of information. Here I will record some of the problems encountered in the SELECT joint query with a solution. The first example is as follows: $

  The following is a prompt after mysql is restarted: ____________________________________________________ Initialize The MySQL database: WARNING: The host 'cdh' cocould not be looked up with resolveip. This probably means that your libc libraries

Today, after setting up a new SLAVE database server, we found that there were a large number of TIME_WAIT database connections between the MASTER and SLAVE servers:Tcp 0 0 19.2.33.156: 56247 19.424228: 3306 TIME_WAITTcp 0 0 19.2.33.156: 56241 19.4242

Reset the root passwordMethod 1: Add the following content to the [mysqld] field of my. ini:Skip-grant-tablesRestart the mysql service. mysql can log on to the database without a password.Then go to mysqlMysql> use mysql;Mysql> update user set

CFLAGS = "-O3" CXX = gcc CXXFLAGS = "-O3-felide-constructors-fno-exceptions-fno-rtti-fomit-frame-pointer-ffixed-ebp"Export CFLAGS CXX CXXFLAGS. /Configure -- prefix =/usr/local/mysql -- enable-validator -- with-mysqld-ldflags =-all-static --

Mysql aotu_increment is often used in master-slave relationships. MySQL does not have a specific sequence of oracle. In addition, the previous project used select max (*) to implement this function. Later, compared to the max (*) method, it was

Mysql user authorization By default, mysql enters and operates as the root user, to access the database as another user and add, delete, modify, and query the database, you must enter the database as the root user and authorize the database to the

If the MySQL data file is too large, can it be compressed? The answer is yes. The following describes how to compress MySQL data files.After using MySQL for a period of time, the MySQL Data File ibdata will grow significantly (mainly for innodb

Create a mysql masterServer‑mysql: 192.168.1.108Server2_mysql: 192.168.1.110Topology:Serverslave MySQL ------- server2_mysql1. Create and authorize a userServer1:Mysql> grant replication slave on *. * TO 'server2' @ '192. 168.1.110'Identified by