PHP

Galera is a tool that allows MySQL to synchronize and replicate data. it implements real dual-master and multi-master data. the client connects to different MySQL instances for read and write operations, just like the operation on the same instance,

Basic requirements: old data has the sequence encoding rules for old data and new data has the sequence encoding rules for new data. However, the encoding of old data must be updated accordingly, new data must also be updated in real time. the old

Note: The environment is a single master database instance with multiple slave databases. The main database open logbin, confirm serverid and slave database different [root @ dbbackup] # egreplog-bin | server-idetcmy.cnfserver-id1log-binmysql-bin

During optimization, it is found that the execution of a stored procedure for 20 seconds through profiler capture mainly consumes a select * from table. The problem is that it took nearly 20 seconds to select tens of thousands of data?

Usingfilesort generally appears in the orderby statement. Usingfilesort does not necessarily cause mysql performance problems. However, if the number of queries is very large, sorting in mysql will still be affected. The optimization method here is

MYSQL creates a database in UTF-8 format first mysql enters: code GBK: createdatabasetest2DEFAULTCHARACTERSETgbkCOLLATEgbk_chinese_ci; UTF8: CREATEDATABASE 'test2' DEFAULTCHARACTERSETutf8C .. MYSQL creates a database in UTF-8 format Start with

Table lock: The table lock is the most specific locking policy in mysql and the minimum overhead policy: it locks the entire table. A user needs to obtain the write lock before performing the lock operation (add, delete, modify) on the table. This

Create User createuser #39; username #39; @ #39; host #39; IDENTIFIEDBY #39; PASSWORD #39; authorize grantallonDBName to the specified user. * to #39; username #39; @ #39; host #39; refresh permission flushprivileges; check... create User Create

If you need to store a large number of URLs and search for them based on the URLs. If B-Tree is used to store the URL, the stored content will be large because the URL itself is very long. Under normal circumstances, there will be the following

When installing mysql5.0, did we encounter the 1607 exception? how did we solve it? The following small series will share with you how I solved the 1607 exception after installing MySQL5.0. if you need it, please refer to the recent projects, which

Role of MYSQL master-slave synchronization (1) Data Distribution (2) load balancing (3) Backup (4) High Availability (highavailability) and fault-tolerant MYSQL master-slave synchronization principle about MYSQL master-slave synchronization, the

This article describes how to export MySQL data in csv format. you can refer to the following solutions for more information: 1. into outfile The code is as follows: SELECT * FROM mytableInto outfile '/tmp/mytable.csv'Fields terminated

This article describes how to solve the MySQL5.0.16 garbled problem. For more information, see How can we solve the problem of garbled MySQL? The solution is as follows:Q: How can I solve the problem of MySQL 5.0.16 garbled characters? A: The

Connecting to the mysql service of another machine through the intranet, it is found that the speed is N slow! It takes about dozens of seconds to wait until the prompt to enter the password. Is there a way to solve the problem of slow mysql

The primary role of the mysql master-slave solution is read/write splitting, enabling the database to support larger concurrency. Especially important in reports. Some report SQL statements are very slow, leading to table lock and affecting

In Ubuntu15, mysql5.6.25 is garbled and does not support Chinese characters. how can this problem be solved? Let's take a look at how the small editor solves this problem. if you need it, you can refer to apt-get install for installation. it is not

This article mainly introduces how to operate mysql command lines, and also shares with you how to add environment variables to mysql. if you are interested, refer to the following section to introduce the mysql command line, the whole process from

This article introduces three methods for ubuntu to start mysql. one method is the simplest method by executing commands. The second method is to use the sysv-rc-cont tool, the third method is to use the chkconfig tool. for details about the above

This article mainly introduces the commands for selecting a MySQL database and the operation methods under the PHP script. In addition, it also introduces the basic data types of MySQL, if you need a database, you may have multiple databases that

This course allows you to learn about the high-availability architecture currently popular on the Internet to build MHA (MasterHighAvailability). The VIP mechanism does not adopt Keepalived (split-brain occurs) and is implemented by modifying