运维支持 #3
Updated by Xihua Fan over 1 year ago
*Task Details*
# 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>
# Check Httpd Log
/var/log/httpd/ssl_error_log
/var/log/httpd/error_log
# Check PHP Log
/var/log/php-fpm/www-error.log
# DB Data Backup
OTS and Redmine
# 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>
# Transfer uploaded files from OTS to Onedrive(Jiuting Group - Documents\OTS-Backup\uploadedFile) once a year.
# Check starting service
<pre>
sudo netstat -nltp
1. httpd(80/443)
3. mysqld(3306/33060)
</pre>
# Check the LifeCircle for the Amazon Linux 2
Some information shows: %{color:red}AL2 End of Life is 2025-06-30.%
*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)