MySQL

This chapter introduces the MySQL relational database management system (RDBMS) and its Structured Query Language SQL ). This article provides the basic terms and concepts that should be mastered, introduces the sample database used in this book,

1. Mysql databases do not have an incremental backup mechanism. When the data volume is too large, backup is a big problem. Fortunately, the mysql database provides a master-slave backup mechanism, which is to write all the data of the master

Install MySQLSuppose you put all the necessary source code or packages under/tmp. If you download an RPM package, it is relatively simple; if you download a binary package, you do not have an rpm program or you want to customize it), it will be a

MySQL is a star in relational databases, and MongoDB is a leader in document-based databases. The following is a design example to compare the two: assume that we are maintaining a mobile phone product library, which includes not only the phone name,

When installing software, you need to useMysql databaseTo create a database and corresponding users in the database, execute the database creation script. The database is successfully created, but an error occurs during user authorization:

This article mainly introducesMySQL transactionThe following describes some operation examples and precautions. Transaction Features: Atomicity (Atomicity) Consistency (stability, Consistency) Isolation (Isolation)

MySQL ProxyOne of the most powerful features is the end of"Read/write splitting(Read/Write Splitting )". The principle is to allow the primary database to process transactional queries, but to process SELECT queries from the database. Database

MySQL databaseThe default encoding is alreadyUtf8Default-character-set = utf8, but when inserting Chinese characters into a table in the database, it always appears .... \ xB5 \ xA5 \ xD1 \ xA1 for column... after checking the online errors, I found

If you want to installSphinxFull-text search engine), but you do not want to re-compile and installMySQL databaseWhat should I do? The answer is that if your mysql version is 5.0.45 or above, you will not need to re-compile and install it. If your

Why?MySQL databaseOfMaster/Slave serversIs there a gap between data? The reason is that the master server is busy and the hardware difference between the master server and the slave server is large, which may lead to a large data gap between the

MySQL databaseHow to delete some keyRepeated Fields? In this article, we use an example to introduce this deletion method. Let's talk about this example first. First, let's take a look at the Statistic table structure: Processing sample: Main

In terms of scalability, customers' requirements become more and more, and 20, 50, or even more than 100 requirements appear on the function list. However, in general, we can shorten them to five categories and solve the scalability problem through

We know that exceptions in any database are inevitable. In this article, weMySQL databaseUsageException HandlingIn conclusion, let's take a look at this part. Question 1:When mysql is started, Starting MySQL... Manager of pid-file quit without

This article mainly introducesMySQL Database ClusterImplementationServer Load balancerNext, let's take a look at this part of content. The MySQL Database Cluster relationship is as follows: Ndbd: the actual storage location of the database node

We know that the database query function is frequently used, soMySQL databaseHow is the query performed? This article introduces the MySQL database query steps andCacheNext, let's take a look at this part. When MySQL receives the query statement

MySQL supports millions of trafficThe deployment method of highly concurrent websites is what we will introduce in this article. Once we understand this part, we can use MySQL to support websites with millions of High-concurrency traffic, next we

PhpMyAdminIs a Web interface that allows you to manage your MySQL database. So how can ICentOS 1, 6.0What about phpMyAdmin installation? This article introduces the installation process, hoping to help you. First, let's import the GPG key of

This article starts from the execution process of a select statement and traverses multiple subsystems of MySQL. First, let's take a picture to start our adventure. After the client connects to the MySQL server and sends a request, the server thread

MySQL releases the latest stable version 5.5.21. : Http://dev.mysql.com/downloads/mysql/5.5.html Improvement record: Http://dev.mysql.com/doc/refman/5.5/en/news-5-5-21.html You can use MySQL Installer 5.5.21 to install this version. MySQLIs an open-

Main Content 1. Get; 2. Install; 3. Configure; 4. Run; 5. Test; 6. Stop; 7. Conclusion 1. Get You don't have to talk about this. Just download it from the MySQL website. The MySQL Cluster deployment test manual in English is very concise, and its