运维支持 #3
Updated by Zhongbao Ye 29 days ago
*Task Details* * 1. Check EBS/EFS Usage eg： <pre> $df -h /dev/nvme0n1p1 10G 5.7G 4.4G 57% / fs-e2864107.efs.cn-northwest-1.amazonaws.com.cn:/ 8.0E 8.6G 8.0E 1% /efs </pre> * 2. Check Httpd Log /var/log/httpd/ssl_error_log /var/log/httpd/error_log * 3. Check PHP Log /var/log/php-fpm/www-error.log * 4. DB Data Backup |_. No. |_. Project |_. Time |_. Server |_. Script | | 1 |Redmine |00:00 daily | v3：52.83.77.219 | /var/www/html/shell/databasebk.sh| | 2 |OTS3.0 |00:00 daily | v3：52.83.77.219 | /var/www/html/shell/databasebk.sh| | 3 |OTS4.0 |00:00 daily | v4：52.83.144.236 | /var/www/shell/databasebk.sh | * 5. Monitor the amount of data in the *t_order_history* table, if it exceeds 100,000 entries, please provide feedback to the group to discuss a solution. <pre><code class="sql"> SELECT COUNT(*) FROM `t_order_history`; </code></pre> * 6. Transfer uploaded files from OTS to Onedrive(Jiuting Group - Documents\OTS-Backup\uploadedFile) once a year. * 7. Check starting service <pre> sudo netstat -nltp 1. httpd(80/443) 3. mysqld(3306/33060) </pre> * 8. Check the LifeCircle for the Amazon Linux 2 Some information shows: %{color:red}AL2 End of Life is 2025-06-30.% * 9. Check SSL * 10. Check php.ini (v4 only) <pre> upload_tmp_dir = /var/www/html/storage/upload/tmp </pre> ** 切换tmp的步骤 （Note: 因为php-fpm 服务开启了PrivateTmp 功能，/tmp 和 /var/tmp/ 与其他服务隔离。这需要php指定的tmp目录排除这2个目录。） <pre> 1. 创建临时目录： mkdir -p /var/www/html/storage/upload/tmp chown apache:apache /var/www/html/storage/upload/tmp chmod 700 /var/www/html/storage/upload/tmp 2. 编辑：/etc/php.ini upload_tmp_dir = /var/www/html/storage/upload/tmp 3. 重启服务 systemctl restart php-fpm systemctl restart httpd </pre> ** %{color:red}将来整个storage目录移动到EFS下，记得这里需要修改php.ini% *Input* # Domain: order.easydingzhi.com # AWS: www.amazonaws.cn Account ID->585080865408 IAM user name->XXX Password->XXX *Output* * Similar to the following example: # Check EBS usage: Used 5.7G (57%) # Check EFS usage: Used 8.6G (1%) # Check Httpd Log: Abnormal(found proxy_fcgi:error) # Check PHP Log: Normal # Backup DB: /efs/redmine_dbbackup/XXXX_20201116.zip /efs/ots_dbbackup/XXXX_20201116.zip *Others* * Maintenance cycle Just started: weekly execution (for example, Friday) Stable period: monthly execution (such as the end of the month)