热点CentOS 5.x RDPM MYSQL/nginx(平滑)升级脚本

7788

热点 RDPM SERVER 1.0介绍与安装方法见:http://www.free8.net/thread-33845-1-1.html

以下脚本只适合热点RDPM SERVER升级

本脚本只适合从热点CentOS 5.x RDPM  1.0上升级使用,因为升级有一定的风险,所以请用户备份好数据,脚本本身也有备份功能,首先确认你没有在安装热点CentOS 5.x RDPM以后修改过MYSQL数据库相关的路径

本次升级是mysql 5.1.38升级到mysql 5.1.42

升级过程中需要关闭mysql数据库,所以依赖mysql数据库的站点会出现不能正常访问的现象

1.MYSQL升级脚本
安装完成后,需要3-5分钟mysql才能正常使用!

1. wget http://vbets.googlecode.com/files/mysql_up.sh
   
2. chmod +x mysql_up.sh
   
3. ./mysql_up.sh

复制代码

以下是完整代码,方便大家以后升级其他版本的mysql
脚本原代码:

1. #! /bin/sh
   
2. # copyright by WWW.7QY.COM
   
3. 
   
4. mkdir -pv /tmp/down
   
5. /usr/local/webserver/mysql/bin/mysqladmin -u root -p shutdown
   
6. mv /usr/local/webserver/mysql /usr/local/webserver/mysql.5.1.38
   
7. mv /wwwroot/mysql /wwwroot/mysql.5.1.38
   
8. 
   
9. mkdir -pv /usr/local/webserver/mysql
   
10. mkdir -pv /wwwroot/mysql
    
11. 
    
12. cd /tmp/down
    
13. #wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.42.tar.gz/from/http://mysql.he.net/
    
14. wget http://192.168.1.5/mysql-5.1.42.tar.gz.zip
    
15. mv mysql-5.1.42.tar.gz.zip  mysql-5.1.42.tar.gz
    
16. tar xvf mysql-5.1.42.tar.gz
    
17. cd mysql-5.1.42/
    
18. ./configure --prefix=/usr/local/webserver/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=innobase
    
19. make && make install
    
20. chmod g-rwx,o-rwx /usr/local/webserver/mysql
    
21. chown -R mysql:mysql /usr/local/webserver/mysql /wwwroot/mysql
    
22. 
    
23. /usr/local/webserver/mysql/bin/mysql_install_db --basedir=/usr/local/webserver/mysql --datadir=/wwwroot/mysql --user=mysql
    
24. 
    
25. cat > /wwwroot/mysql/my.cnf << EOF
    
26. [client]
    
27. default-character-set = utf8
    
28. port    = 3306
    
29. socket  = /tmp/mysql.sock
    
30. 
    
31. [mysql]
    
32. prompt="(\u:localhost:)[\d]> "
    
33. no-auto-rehash
    
34. 
    
35. [mysqld]
    
36. #default-character-set = utf8
    
37. user    = mysql
    
38. port    = 3306
    
39. socket  = /tmp/mysql.sock
    
40. basedir = /usr/local/webserver/mysql
    
41. datadir = /wwwroot/mysql
    
42. open_files_limit    = 10240
    
43. back_log = 600
    
44. max_connections = 3000
    
45. max_connect_errors = 6000
    
46. table_cache = 614
    
47. external-locking = FALSE
    
48. max_allowed_packet = 32M
    
49. sort_buffer_size = 2M
    
50. join_buffer_size = 2M
    
51. thread_cache_size = 300
    
52. thread_concurrency = 8
    
53. query_cache_size = 32M
    
54. query_cache_limit = 2M
    
55. query_cache_min_res_unit = 2k
    
56. default-storage-engine = MyISAM
    
57. default_table_type = MyISAM
    
58. thread_stack = 192K
    
59. transaction_isolation = READ-COMMITTED
    
60. tmp_table_size = 246M
    
61. max_heap_table_size = 246M
    
62. long_query_time = 1
    
63. log_long_format
    
64. log-bin = /wwwroot/mysql/binlog
    
65. binlog_cache_size = 4M
    
66. binlog_format = MIXED
    
67. max_binlog_cache_size = 8M
    
68. max_binlog_size = 512M
    
69. expire_logs_days = 7
    
70. key_buffer_size = 256M
    
71. read_buffer_size = 1M
    
72. read_rnd_buffer_size = 16M
    
73. bulk_insert_buffer_size = 64M
    
74. myisam_sort_buffer_size = 128M
    
75. myisam_max_sort_file_size = 10G
    
76. myisam_max_extra_sort_file_size = 10G
    
77. myisam_repair_threads = 1
    
78. myisam_recover
    
79. 
    
80. skip-name-resolve
    
81. master-connect-retry = 10
    
82. slave-skip-errors = 1032,1062,126,1114,1146,1048,1396
    
83. 
    
84. server-id = 1
    
85. 
    
86. innodb_additional_mem_pool_size = 16M
    
87. innodb_buffer_pool_size = 2048M
    
88. innodb_data_file_path = ibdata1:1024M:autoextend
    
89. innodb_file_io_threads = 4
    
90. innodb_thread_concurrency = 8
    
91. innodb_flush_log_at_trx_commit = 2
    
92. innodb_log_buffer_size = 16M
    
93. innodb_log_file_size = 128M
    
94. innodb_log_files_in_group = 3
    
95. innodb_max_dirty_pages_pct = 90
    
96. innodb_lock_wait_timeout = 120
    
97. innodb_file_per_table = 0
    
98. [mysqldump]
    
99. quick
    
100. max_allowed_packet = 32M
     
101. EOF
     
102. 
     
103. cat > /wwwroot/mysql/mysqld << EOF
     
104. #!/bin/sh   
     
105.   
     
106. function_start_mysql()   
     
107. {   
     
108.     printf "Starting MySQL...\n"  
     
109.     /bin/sh /usr/local/webserver/mysql/bin/mysqld_safe --defaults-file=/wwwroot/mysql/my.cnf 2>&1 > /dev/null &   
     
110. }   
     
111.   
     
112. function_stop_mysql()   
     
113. {   
     
114.     printf "Stoping MySQL...\n"  
     
115.     /usr/local/webserver/mysql/bin/mysqladmin -u mysqladmin -p mysqladmin -S /tmp/mysql.sock shutdown   
     
116. }   
     
117.   
     
118. function_restart_mysql()   
     
119. {   
     
120.     printf "Restarting MySQL...\n"  
     
121.     function_stop_mysql   
     
122.     sleep 5   
     
123.     function_start_mysql   
     
124. }   
     
125.   
     
126. function_kill_mysql()   
     
127. {   
     
128.     kill -9 \$(ps -ef | grep 'bin/mysqld_safe' | grep /usr/local/webserver/mysql | awk '{printf \$2}')   
     
129.     kill -9 \$(ps -ef | grep 'libexec/mysqld' | grep /usr/local/webserver/mysql | awk '{printf \$2}')   
     
130. }   
     
131.   
     
132. if [ "\$1" = "start" ]; then   
     
133.     function_start_mysql   
     
134. elif [ "\$1" = "stop" ]; then   
     
135.     function_stop_mysql   
     
136. elif [ "\$1" = "restart" ]; then   
     
137. function_restart_mysql   
     
138. elif [ "\$1" = "kill" ]; then   
     
139. function_kill_mysql   
     
140. else  
     
141.     printf "Usage: /wwwroot/mysql/mysqld {start|stop|restart|kill}\n"  
     
142. fi  
     
143. EOF
     
144. 
     
145. mv /wwwroot/mysql /wwwroot/mysql.5.1.42
     
146. mv /wwwroot/mysql.5.1.38 /wwwroot/mysql
     
147. chmod +x /wwwroot/mysql/mysqld
     
148. /wwwroot/mysql/mysqld start
     
149. ulimit -SHn 51200
     
150. /usr/local/webserver/php/sbin/php-fpm restart
     
151. /usr/local/webserver/nginx/sbin/nginx
     
152. cd /tmp
     
153. rm -rf down

复制代码

2.只适合热点CentOS 5.x RDPM 的nginx升级,从原来的nginx0.8.29升级到0.8.33
升级前先备份你的重要文件以免出错

1. wget http://vbets.googlecode.com/files/nginx_up.sh
   
2. chmod +x nginx_up.sh
   
3. ./nginx_up.sh

复制代码

本脚本也适合以后升级其他nginx版本,只要修改里面的目录和文件名就可以了

以下是脚本的内容以供参考:

1. #! /bin/sh
   
2. # copyright by WWW.7QY.COM
   
3. 
   
4. ##########nginx up##########
   
5. mkdir -pv /tmp/down
   
6. cd /tmp/down
   
7. wget http://nginx.org/download/nginx-0.8.33.tar.gz
   
8. tar xvf nginx-0.8.33.tar.gz
   
9. cd nginx-0.8.33
   
10. ./configure --user=www --group=www --prefix=/usr/local/webserver/nginx --with-http_stub_status_module --with-http_ssl_module
    
11. make
    
12. mv /usr/local/webserver/nginx/sbin/nginx /usr/local/webserver/nginx/sbin/nginx.bak
    
13. cp /tmp/down/nginx-0.8.33/objs/nginx /usr/local/webserver/nginx/sbin/
    
14. killall -9 nginx;/usr/local/webserver/nginx/sbin/nginx
    
15. ulimit -SHn 51200
    
16. /usr/local/webserver/php/sbin/php-fpm restart
    
17. /usr/local/webserver/nginx/sbin/nginx

复制代码

a4330413

我不懂的 都是错的

爱睡小猪

好好学习天天向上！！