MySQL

1.SOLR IntroductionSOLR is a high performance, JAVA5 developed, SOLRSOLR full-text Search server based on Lucene. At the same time, it is extended to provide a richer query language than Lucene, while it can be configured, extensible and optimized

MySQL replication Problem of the last one, on the two-way synchronous replication architecture design of some design points and constraints.Problems and constraintsThe two-master double-write and bidirectional synchronization scenarios of the

Processing of RDS MySQL connections with a full number of cases2 cases of RDS MySQL connections1. Too many idle connectionsReason: Applications use long connection mode-for long connection modes (such as Java apps), the application side

##################################################################################Start off and Login##################################################################################1 Single InstanceMysqld_safe--user=mysql &

Introduction:1, phpmyadmin program server: 192.168.1.1, Access address is: http://192.168.1.1/phpmyadmin2, MySQL database server: 192.168.1.2, has allowed the database outside the chain, MySQL database user name: admin password: 1234563, now to

MySQL for Linux database installation processL installation Version: Mysql-advanced-5.6.12-linux-glibc2.5-x86_64.tar.gz, this version is a green version, just need to extract it to the relevant directory.PS: This installation method is not a common

The MySQL master and slave feature is set on CentOS 6.5 and recorded.Server 1 (primary)ip:192.168.137.144System version: CentOS 6.5MySQL version: MySQL 5.5Server 2 (from)ip:192.168.137.185System version: CentOS 6.5MySQL version: MySQL 5.5The system

MySQL deadlock problem related knowledge is the main content of this article, we will introduce this part of the content, we hope to be able to help you.1. The lock mechanism of MySQL common storage engineMyISAM and memory with table-level lock

workaround: MySQL> Set global read_only=0; (Turn off read-only properties of the new Main library) flush privileges; Set global read_only=1 = STATEMENT and at least one table uses a storage enginelimited to row-based logging. InnoDB is limited to

COROSYNC/OPENAIS+PACEMAKER+NFS offers mariadb high availabilityNode I, one, 172.16.249.122/16, 172.16.0.1, CentOS6.6, mariadbNode two, 172.16.249.123/16, 172.16.0.1, CentOS6.6, mariadbNode III, three, 172.16.249.124/16, 172.16.0.1, CentOS6.6, NFSvip:

What if MySQL forgets the root password?What if MySQL forgets the root password? In general, there are two ways of thinking: Retrieve the password and reset the password. In the actual work, the MySQL database forgot the root password is generally

First of all, why divide the tableWhen a piece of data reaches millions of, you spend more time searching for it, and if you have a joint query, I think it's possible to die there. The purpose of the sub-table is to reduce the burden on the database

The section on SQL and index optimization has finally finished learning, today began to enter the second level of learning, database structure optimization, the first part, select the appropriate data type.The choice of data type, with emphasis on

If the UTF8 character set is a Java server, when the store contains a emoji expression, it throws an exception similar to the following:Java.sql.SQLException:IncorrectStringValue' \xf0\x9f\x92\x94 'For column' Name ' at row1      at

The MySQL server suddenly fails to start, looking at the last boot log as follows:080825 09:38:04 Mysqld started080825 9:38:04 [ERROR] Can ' t start server:bind on Unix socket:permission denied080825 9:38:04 [ERROR] Do you already has another MYSQLD

Several Web servers have been configured recently to post the installation notes. There is no time like before, the article written as the system, please forgive me. Detailed configuration, you can see the previous old article:

In MySQL, both now () and sysdate () two functions can return the current time, but there is a difference between the two. Let's take a look at the official MySQL explanation: NOW()Returns a constant time that indicates the time at which the

What is the storage engine? For a database, the storage engine is the module or function that implements the data structure definition, storage and query of the database.Different databases have different underlying storage mechanisms, which are

Using the SAE database is very good. It is not available externally. It is not very good to use it inside the SAE. So it took a little bit of time to write something for external invocation. The code is simple. Part of the server is the client.

Mysql slow query log analysis tool1. mysql-log-filter tool script usage instructions: an analysis tool found on google code provides two executable scripts: python and php. Http://code.google.com/p/mysql-log-filter/ (need to move the ladder to climb