二手房公司网站建设,保定seo企业网站,高中同步测控优化设计答案,wordpress的标题字体一redis简介#xff1a;redis 是一个高性能的 key-value 数据库。 redis 的出现,很大程度补偿了memcached 这类 keyvalue 存储的不足,在部分场合可以对关系数据库起到很好的补充作用。它提供了 Python,Ruby,Erlang,PHP 客户端,使用很方便。Redis 的所有数据都是保存在内存中,然…一redis简介redis 是一个高性能的 key-value 数据库。 redis 的出现,很大程度补偿了memcached 这类 keyvalue 存储的不足,在部分场合可以对关系数据库起到很好的补充作用。它提供了 Python,Ruby,Erlang,PHP 客户端,使用很方便。Redis 的所有数据都是保存在内存中,然后不定期的通过异步方式保存到磁盘上(这称为“半持久化模式”);也可以把每一次数据变化都写入到一个appendonly file(aof)里面(这称为“全持久化模式”)。二主机环境 rhel6.5 selinx and iptales disabled1. Redis 安装实验环境 172.25.254.2 vm2.example.com 上首先得到 zxf redis-3.0.2.tar.gztar zxf redis-3.0.2.tar.gzcd redis-3.0.2make make install1.1. 配置并启动服务cd utils/./install_server.sh 这里一路回车都使用的默认点击(此处)折叠或打开[rootvm2 utils]# ./install_server.shWelcome to the redis service installerThis script will help you easily set up a running redis serverPlease select the redis port for this instance: [6379]Selecting default: 6379Please select the redis config file name [/etc/redis/6379.conf]Selected default - /etc/redis/6379.confPlease select the redis log file name [/var/log/redis_6379.log]Selected default - /var/log/redis_6379.logPlease select the data directory for this instance [/var/lib/redis/6379]Selected default - /var/lib/redis/6379Please select the redis executable path [/usr/local/bin/redis-server]Selected config:Port : 6379Config file : /etc/redis/6379.confLog file : /var/log/redis_6379.logData dir : /var/lib/redis/6379Executable : /usr/local/bin/redis-serverCli Executable : /usr/local/bin/redis-cliIs this ok? Then press ENTER to go on or Ctrl-C to abort.Copied /tmp/6379.conf /etc/init.d/redis_6379Installing service...Successfully added to chkconfig!Successfully added to runlevels 345!Starting Redis server...Installation successful!1.2简单测试如下就证明成功点击(此处)折叠或打开[rootvm2 utils]# redis-cli127.0.0.1:6379 pingPONG2 安装lnmp架构2.1 安装以下软件包点击(此处)折叠或打开[rootvm2 lnmp]# lsnginx-1.8.0-1.el6.ngx.x86_64.rpm php-fpm-5.3.3-38.el6.x86_64.rpmphp-5.3.3-38.el6.x86_64.rpm php-gd-5.3.3-38.el6.x86_64.rpmphp-cli-5.3.3-38.el6.x86_64.rpm php-mbstring-5.3.3-38.el6.x86_64.rpmphp-common-5.3.3-38.el6.x86_64.rpm php-mysql-5.3.3-38.el6.x86_64.rpmphp-devel-5.3.3-38.el6.x86_64.rpm php-pdo-5.3.3-38.el6.x86_64.rpm[rootvm2 lnmp]# yum install -y *2.2安装 php 的 redis 扩展首先得到 phpredis-master.zipunzip phpredis-master.zipcd phpredis-masterphpize./configuremake make installcd /etc/php.d/cp mysql.ini redis.inivim /etc/php.ini #添加以下行extensionredis.so #加载 redis 模块点击(此处)折叠或打开[rootvm2 php.d]# /etc/init.d/php-fpm startStarting php-fpm: [ OK ]2.3简单配置 nginxvim /etc/nginx/conf.d/default.conflocation / {root /usr/share/nginx/html;index index.php index.html index.htm;}location ~ \.php$ {root /usr/share/nginx/html;fastcgi_pass 127.0.0.1:9000;fastcgi_index index.php;fastcgi_param SCRIPT_FILENAME /usr/share/nginx/html$fastcgi_script_name;include fastcgi_params;}启动 nginx点击(此处)折叠或打开[rootvm2 php.d]# nginx -tnginx: the configuration file /etc/nginx/nginx.conf syntax is oknginx: configuration file /etc/nginx/nginx.conf test is successful[rootvm2 php.d]# nginx[rootvm2 php.d]# netstat -antlpe| grep nginxtcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 0 14520 6352/nginxvim /etc/php-fpm.d/www.conf 将这个配置文件中user和group改为nginx 默认是apacheuser nginxgroup nginx/etc/init.d/php-fpm restart点击(此处)折叠或打开[rootvm2 php.d]# /etc/init.d/php-fpm restartStopping php-fpm: [ OK ]Starting php-fpm: [ OK ]3 在另一台虚拟机上安装mysql实验环境 172.25.254.3 vm3.example.com 上yum install -y mysql-server点击(此处)折叠或打开[rootvm3 mnt]# mysqlWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.1.71 Source distributionCopyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type help; or \h for help. Type \c to clear the current input statement.mysql grant all on test.* to redis172.25.254.2 identified by redhat;Query OK, 0 rows affected (0.00 sec)mysql flush privileges;Query OK, 0 rows affected (0.00 sec)编写如下代码点击(此处)折叠或打开[rootvm3 mnt]# cat test.sqluse test;CREATE TABLE test (id int(7) NOT NULL AUTO_INCREMENT, name char(8) DEFAULT NULL, PRIMARY KEY (id)) ENGINEInnoDB DEFAULT CHARSETutf8;INSERT INTO test VALUES (1,test1),(2,test2),(3,test3),(4,test4),(5,test5),(6,test6),(7,test7),(8,test8),(9,test9);[rootvm3 mnt]# mysql test.sql4创建 php 测试页面在172.25.254.2上面进入nginx默认发布目录cd /usr/share/nginx/htmlvim test.php点击(此处)折叠或打开$redis new Redis();$redis-connect(127.0.0.1,6379) or die (could net connect redis server);# $query select * from test limit 9;$query select * from test;for ($key 1; $key 10; $key){if (!$redis-get($key)){$connect mysql_connect(172.25.254.3,redis,redhat);mysql_select_db(test);$result mysql_query($query);//如果没有找到$key,就将该查询sql的结果缓存到rediswhile ($row mysql_fetch_assoc($result)){$redis-set($row[id],$row[name]);}$myserver mysql;break;}else{$myserver redis;$data[$key] $redis-get($key);}}echo $myserver;echo ;for ($key 1; $key 10; $key){echo number is $key;echo ;echo name is $data[$key];echo ;}?然后在浏览器进行测试这时候我们已经实现了 redis 作为 mysql 的缓存服务器,但是如果更新了 mysql,redis中仍然会有对应的 KEY,数据就不会更新,此时就会出现 mysql 和 redis 数据不一致的情况。所以接下来就要通过 mysql 触发器将改变的数据同步到 redis 中。5配置 gearman 实现数据同步1. 安装 gearman 软件包:gearmand libgearman-devel libgearman libevent libevent-devellibevent-doc libevent-headers tokyocabinet2,启动服务点击(此处)折叠或打开[rootvm2 html]# /etc/init.d/gearmand startStarting gearmand: [ OK ]3.安装 php 的 gearman 扩展https://pecl.php.netyum install -y db*-develtar zxf gearman-1.1.2.tgzcd gearman-1.1.2./configure --with-php-config/usr/bin/php-configmake make install# vim /etc/php.iniextensiongearman.so/etc/init.d/php-fpm restart点击(此处)折叠或打开[rootvm2 html]# /etc/init.d/php-fpm restartStopping php-fpm: [ OK ]Starting php-fpm: [ OK ]4. 安装 lib_mysqludf_jsonlib_mysqludf_json UDF 库函数将关系数据映射为 JSON 格式。通常,数据库中的数据映射为 JSON 格式,是通过程序来转换的。https://github.com/mysqludf/lib_mysqludf_jsonyum install -y mysql-devel# unzip lib_mysqludf_json-master.zipcd lib_mysqludf_json-mastergcc $(mysql_config --cflags) -shared -fPIC -o lib_mysqludf_json.solib_mysqludf_json.c查看 mysql 的模块目录:5. 安装 gearman-mysql-udf这个插件是用来管理调用 Gearman 的分布式的队列。https://launchpad.net/gearman-mysql-udftar zxf gearman-mysql-udf-0.6.tar.gzcd gearman-mysql-udf-0.6./configure --with-mysql/usr/bin/mysql_config--libdir/usr/lib64/mysql/plugin/make# make install拷贝 lib_mysqludf_json.so 模块:cp lib_mysqludf_json.so /usr/lib64/mysql/plugin/注册 UDF 函数点击(此处)折叠或打开mysql CREATE FUNCTION json_object RETURNS STRING SONAMElib_mysqludf_json.so;mysql CREATE FUNCTION gman_do_background RETURNS STRING SONAMElibgearman_mysql_udf.so;mysql CREATE FUNCTION gman_servers_set RETURNS STRING SONAMElibgearman_mysql_udf.so;查看函数指定 gearman 的服务信息6. 编写 mysql 触发器(根据实际情况编写)点击(此处)折叠或打开vim test.sqluse test;DELIMITER $$CREATE TRIGGER datatoredis AFTER UPDATE ON test FOR EACH ROW BEGINSET RECVgman_do_background(syncToRedis, json_object(NEW.id asid, NEW.name as name));END$$DELIMITER ;查看触发器7. 编写 gearman 的 worker 端点击(此处)折叠或打开vim worker.php$worker new GearmanWorker();$worker-addServer();$worker-addFunction(syncToRedis, syncToRedis);$redis new Redis();$redis-connect(127.0.0.1, 6379);while($worker-work());function syncToRedis($job){global $redis;$workString $job-workload();$work json_decode($workString);if(!isset($work-id)){return false;}$redis-set($work-id, $work-name); #这条语句就是将 id 作 KEY 和name 作 VALUE 分开存储,需要和前面写的 php 测试代码的存取一致。}?后台运行 workernohup php worker.php 然后在3上更新数据库然后再浏览器中进行测试
