Linux MySQL compilation and installation commands

Do you want to know the truth about Linux MySQL? Do you want to know the inherent meanings hidden in Linux MySQL? I only want to give you a full introduction to Linux MySQL nearly a year ago, I wrote an article about ing Linux MySQL Data to Memcached. At that time, both Linux MySQL and Memcached Functions for MySQL were not mature enough. One year later, Memcached Functions for MySQL was upgraded to version 0.8, mySQL has also released the GA version, and many friends have responded that the implementation in the previous article has failed due to various reasons. Therefore, this article should be an upgraded version of the previous article.

The test environment is run in Linux MySQL. The version system is CentOS5. the following are the related software, including the version and:

 
 

  
  
Download mysql-5.1.30
  
  
Download memcached-1.2.6
  
  
Download libevent-1.4.7-stable
  
  
Download memcached_functions_mysql-0.8
  
  
Download libmemcached-0.26
 
 

Compile and install Linux MySQL. The installation depends on your individual requirements. Many compilation details and parameters irrelevant to the test are omitted.

 
 

  
  
[root@localhost ~]#tar xzf mysql-5.1.30.tar_001.gz  
  
  
[root@localhost ~]#cd mysql-5.1.30  
  
  
[root@localhost ~]#./configure --prefix=/usr/local/mysql51  
  
  
[root@localhost ~]#make  
  
  
[root@localhost ~]#make install  
  
  
[root@localhost ~]#./scripts/mysql_install_db --user=mysql --skip-name-resolve  
  
  
[root@localhost ~]#/usr/local/mysql51/bin/mysqld_safe 
 
 

The commands for installing memcached and libevent are omitted. Install libevent by default and install memcached in the/usr/local/memcached directory.
Start memcached.

/Usr/local/memcached/bin/memcached-d-m 50-u root-p 11211 compile and install libmemcache.

 
 

  
  
[root@localhost ~]#tar xzf libmemcached-0.26.tar.gz  
  
  
[root@localhost ~]#cd libmemcached-0.26  
  
  
[root@localhost ~]#./configure --with-memcached=/usr/local/memcached/bin/memcached  
  
  
[root@localhost ~]# make && make install 
 
 

Compile and install Memcache UDFs for MySQL.

 
 

  
  
[root@localhost ~]# tar xzf memcached_functions_mysql-0.8.tar.gz  
  
  
[root@localhost ~]# cd memcached_functions_mysql-0.8  
  
  
[root@localhost ~]# ./configure --with-mysql-config=/usr/local/mysql51/bin/mysql_config  
  
  
[root@localhost ~]# make && make install 
 
 

After compilation, copy the compiled library file to the mysql plug-in directory to facilitate loading and usage. Cp/usr/local/lib/libmemcached_functions_mysql */usr/local/mysql51/lib/mysql/plugin/enter the source code directory of memcached_functions_mysql, there is an SQL file in the directory for UDF initialization. [Root @ localhost ~] # Mysql <SQL/install_functions. SQL Note: if you are not familiar with or do not understand these UDFs, refer to README in the source code directory and provide relevant instructions.

So far, the compilation and installation of related software are complete for testing. The purpose is to insert a new MySQL record to Memcached at the same time, when the record is updated, records in Memcached are synchronously updated. When the record is deleted, Memcached related records are also deleted. Therefore, Three triggers are created for this purpose, if you are not familiar with the MySQL trigger program, refer to Chapter 21st of the MySQL manual. In the following SQL statement, memcached is the name of the table to be operated. The SQL statement is as follows:

 
 

  
  
# Insert Memcached when inserting data
  
  
Create trigger mysqlmmci after insert on memcached for each row set @Tmp=Memc_set(NEW. key, NEW. value );
  
  
# Update Memcached when updating records
  
  
Create trigger mysqlmmcu after update on memcached for each row set @Tmp=Memc_set(NEW. key, NEW. value );
  
  
# Deleting a Memcached record
  
  
Create trigger mysqlmmcd before delete on memcached for each row set @Tmp=Memc_delete(OLD. key );
 
 

The following is a test record. You can operate Memcached while operating Linux MySQL. Of course, you can also use the-vv parameter when starting Memcached to view related information.

Linux MySQL operation records:

 
 

  
  
[Root @ localhost ~] # Mysql-S/tmp/mysql51.sock
  
  
Welcome to the MySQL monitor. Commands end with; or \ g.
  
  
Your MySQL connection id is 6
  
  
Server version: 5.1.30 Source distribution
  
  

  
  
Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.
  
  

  
  
Mysql>Use test;
  
  
Database changed
  
  

  
  
Mysql>Create table 'memcached' ('key' varchar (10), 'value' varchar (100 ));
  
  
Query OK, 0 rows affected (0.00 sec)
  
  

  
  
Mysql>Create trigger mysqlmmci after insert on memcached for each row set @Tmp=Memc_set(NEW. key, NEW. value );
  
  
Query OK, 0 rows affected (0.00 sec)
  
  

  
  
Mysql>Create trigger mysqlmmcu after update on memcached for each row set @Tmp=Memc_set(NEW. key, NEW. value );
  
  
Query OK, 0 rows affected (0.00 sec)
  
  

  
  
Mysql>Create trigger mysqlmmcd before delete on memcached for each row set @Tmp=Memc_delete(OLD. key );
  
  
Query OK, 0 rows affected (0.00 sec)
  
  

  
  
Mysql>Insert into memcached values ("keyi", "valuei"), ("keyu", "valueu"), ("keyd", "valued ");
  
  
Query OK, 3 rows affected (0.00 sec)
  
  
Records: 3 Duplicates: 0 Warnings: 0
  
  

  
  
Mysql>Update memcached set 'value' = "update" where 'key' = "keyu ";
  
  
Query OK, 1 row affected (0.00 sec)
  
  
Rows matched: 1 Changed: 1 Warnings: 0
  
  

  
  
Mysql>Delete from memcached where 'key' = "keyd ";
  
  
Query OK, 1 row affected (0.00 sec)
  
  

  
  
Mysql>Quit
  
  
Bye
  
  
Memcache viewing records:
 
 

 
 

  
  
[root@localhost ~]#telnet 127.0.0.1 11211  
  
  
Trying 127.0.0.1...  
  
  
Connected to 127.0.0.1.  
  
  
Escape character is '^]'.  
  
  
get keyi  
  
  
VALUE keyi 0 6  
  
  
valuei  
  
  
END  
  
  
get keyu  
  
  
VALUE keyu 0 6  
  
  
valueu  
  
  
END  
  
  
get keyd  
  
  
VALUE keyd 0 6  
  
  
valued  
  
  
END  
  
  
get keyu  
  
  
VALUE keyu 0 6  
  
  
update  
  
  
END  
  
  
get keyd  
  
  
END  
  
  
quit  
  
  
Connection closed by foreign host. 
 
 

So far, we have basically implemented synchronizing data from Linux MySQL to Memcached, and the performance has not yet been tested. Of course, the above is just a simple data ing function, if the implementation of the production environment, you need to consider the namespace, high reliability issues, these are all through the database name-table name-keywords to achieve the unique purpose of KEY, high reliability is a big problem.

1. Linux mysql Command installation allows remote connection
2. Linux MYSQL command to modify the method of various connections
3. Linux MySQL program service built-in security mechanism
4. Install and modify the root password service in Linux mysql
5. Use the source code to compile and install the Linux Mysql Server