MySQL

Environment: mater:centos7.1 5.5.52-mariadb 192.168.108.133 slave:centos7.1 5.5.52-mariadb 192.168.108.140 1. Export the main service data and synchronize the primary and standby initial data Master Export database information that needs to be

Dump command Backup 1. Back up a database: Mysqldump-uroot (Root is User name)-P-Database (library name) table (table name) >d:\backup.sql (where to back up, file name) 2. Back up multiple databases: (plus the--databases option, followed by

Today, the following SQL statement was executed, and the result was an error. CREATE table Car_user_content Select Addr_id,comm_userid,group_concat (comm_content) as content from (SELECT * from Forum_ Comment Union SELECT * from Forum_comment1) as

091 Database Deadlock Concepts In most cases, you can assume that if a resource is locked, it will always be released at a later time. A deadlock occurs when multiple processes access the same database, where each process has locks that are

MySQL Compile installation shell> Groupadd MySQL shell> useradd-g MySQL MySQL Shell> Gunzip Shell> CD Mysql-version shell>./configure--prefix=/usr/local/mysql Shell> make shell> make Install shell> CP support-files/my-medium.cnf/etc/my.cnf

Confirm that the have_dynamic_loading is open on master and slave Master MASTER (none) 10:54:58>show variables like ' have_dynamic_loading '; +----------------------+-------+ | variable_name | Value | +----------------------+-------+ |

installing MySQL with Yum Enter the following command: [Root@mysql ~]# yum-y Install Mysql-server//automatically search for resources from the Internet and automatically download the installation [Root@mysql ~]# chkconfig mysqld on//set boot up

InnoDB is a transaction-safe storage engine designed to draw on many Oracle architecture ideas, and in general, in OLTP applications, InnoDB should be the first storage engine for the core application table. InnoDB was developed by a third party

Last night in the group and some netizens talked to the topic of MySQL multiple instances, the first contact with more than MySQL instances or more than 1 years ago, that will I have just entered the operation of the industry, has done a number of

MySQL is divided into logical and physical backups in the form of backup recovery A logical backup is a backup SQL statement that performs a backup of the SQL statement at the time of recovery to realize the recurrence of the database data

The following error was reported when deleting data from a table in MySQL: mysql> delete from upload_images; ERROR 1175 (HY000): You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column mysql> show

This article is limited to the Web Server section, as the implementation of load balancing can be done according to requirements, can be based on DNS resolution load balancing, can also use LVS or dedicated load balancer (such as F5 or Randware)

First of all, let's elaborate on the following points: Figure: When a user accesses virtual machine 2, you can access the Discuz forum, which is mounted via NFS, where the data is stored in virtual machine 1, to ensure that when the content of

MySQL 4.1 adds code support, so it's a little bit cumbersome to transform old data, but just keep the following points in mind: 1, before the conversion must first the original data dump out, the general original data are gb2312 code it, the dump

With MySQL, security issues cannot be noticed. Here are 23 things to note about MySQL tips: 1. If the client and server-side connections need to cross over and pass through an untrusted network, you need to use an SSH tunnel to encrypt the

It is important to back up your database if your database tables are missing or corrupted. If a system crash occurs, you will want to be able to recover as few data from your table as possible to the state at which the crash occurred. Sometimes it

Optimizing MySQL at compile timeIf you install MySQL from the source code, note that the compilation process will have an important impact on the performance of future target programs, different compilation methods may get similar target files, but

The main clue to this problem is that you can't connect to the server through '/tmp/mysql.sock ', and PHP standard configuration is using '/tmp/mysql.sock ', but some MySQL installation method will mysql.sock in/var/lib/ Mysql.sock or any other

Install version mysql-5.0.40 need to compile Download some of the tools needed for compiling, which may not be available on the default installed Ubuntu and need to be installed manually sudo apt-get install g++ gcc make Automake perl Install all

At the same time, the amount of online access continues to increase for 1G memory server Obviously feel the difficulty of severe when even every day will panic or occasional server card This problem once bothered me for more than half a month MySQL