search
HomeDatabaseMysql Tutorial我的运维经验总结

我的运维经验总结

Jun 07, 2016 pm 04:31 PM
timeExperience summaryOperation and maintenance

到现在做运维有三个月时间了,从不熟悉到熟悉,从什么都不清楚到清楚手里所有服务器状态,从什么都不会到独立运维十几台服务器,独立搭建监控平台,独立制定了完整的一套打包备份策略。部门的运维只有我一个人做,所以什么问题都由我处理,在累之外的好处就

到现在做运维有三个月时间了,从不熟悉到熟悉,从什么都不清楚到清楚手里所有服务器状态,从什么都不会到独立运维十几台服务器,独立搭建监控平台,独立制定了完整的一套打包备份策略。部门的运维只有我一个人做,所以什么问题都由我处理,在累之外的好处就是我能接触的多,能学的多,这对个人能力的提升是有帮助的。日子也过得比较闷,随便做点总结吧,算是对三个月里技术之外自我提升的证明。

1、工欲善其事,必先利其器。先对自己用的电脑配置一下,保证其能方便操作。

2、添加虚拟主机时Option使用“-index”,禁止列目录。

3、有新站需要上线时请衡量一下服务器承受能力后做安排。尤其注意不要在低内存的服务器上放过多站点,在低内存主机上也要留意mysql内存分配问题。

4、在多网卡主机上分配网站上线时尽量考虑网卡负载,平衡网卡流量。

5、网站程序目录权限设置为755。

6、FTP用户名使用“申请人姓名@网站域名”,便于管理。

7、转移数据库尽量使用导出为sql文件。如果数据库太大不方便导出导入操作,可以在关闭mysql服务之后复制数据库文件,但这种做法无法恢复数据库中innoDB类型的表。

8、在收藏夹中收藏所有phpmyadmin的地址,定期打开所有phpmyadmin,检查是否正常运行。

9、转移网站时留意目录属性,尤其是跨平台转移时。网站转移后先通过添加hosts来访问,没有问题后再改域名指向。

10、对服务器的任何操作请做备份,确认一切OK之后再做清理。对于删除操作不要擅做主张。

11、服务器不能通过ssh连接上时打开其power panel,若power panel不能控制,请联系主机提供商客服。

12、手机请7×24小时开机,收到短信报警先打开网站确认是否确实出问题。连接上服务器后检查进程,检查资源使用,养成每天检查服务器的习惯。

13、Linux系统出现任何问题都是配置问题。如果必要请勿重启服务器。发现问题查日志,修改对应配置之后重启该项服务。

14、对服务器的任何操作请勿影响同事正常工作。

15、经常检查日志,检查脚本,看是否有不完善之处。

16、没事多练练正则表达式,多看看命令行,有好处。

17、以下命令要滚瓜烂熟:find grep sed awk top ps netstat ifconfig xargs egrep crontab,但不仅限于此。

18、熟悉mysql的命令,在phpmyadmin无法打开时只能用mysql的命令。

19、发现网站被挂黑链时,不要做任何修改,通知相关同事暂停修改站点。检查日志分析入侵途径,尽量寻找入侵者信息。可以有以下几个获取信息的途径:通过服务器记录下的IP,检查IP的地理位置,检查黑链中的域名,包括IP和地理位置,以及它们的whois相关信息,其中有些会有注册人,如果链接中注册人都是同一个,那可以基本肯定就是这个人,通过一些途径解决这个问题。

20、被挂马时,保存马之后分析马的特性。修改其源文件,添加短信报警内容,放在原位,如果对方再连接可以得到报警。当然别忘了找一下系统漏洞,把漏洞补好。

21、胆大心细,要有耐心。

22、不要将带有用户名密码的文档发送给任何人。

23、有问题多查文档,或者Google之。

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
When should you use a composite index versus multiple single-column indexes?When should you use a composite index versus multiple single-column indexes?Apr 11, 2025 am 12:06 AM

In database optimization, indexing strategies should be selected according to query requirements: 1. When the query involves multiple columns and the order of conditions is fixed, use composite indexes; 2. When the query involves multiple columns but the order of conditions is not fixed, use multiple single-column indexes. Composite indexes are suitable for optimizing multi-column queries, while single-column indexes are suitable for single-column queries.

How to identify and optimize slow queries in MySQL? (slow query log, performance_schema)How to identify and optimize slow queries in MySQL? (slow query log, performance_schema)Apr 10, 2025 am 09:36 AM

To optimize MySQL slow query, slowquerylog and performance_schema need to be used: 1. Enable slowquerylog and set thresholds to record slow query; 2. Use performance_schema to analyze query execution details, find out performance bottlenecks and optimize.

MySQL and SQL: Essential Skills for DevelopersMySQL and SQL: Essential Skills for DevelopersApr 10, 2025 am 09:30 AM

MySQL and SQL are essential skills for developers. 1.MySQL is an open source relational database management system, and SQL is the standard language used to manage and operate databases. 2.MySQL supports multiple storage engines through efficient data storage and retrieval functions, and SQL completes complex data operations through simple statements. 3. Examples of usage include basic queries and advanced queries, such as filtering and sorting by condition. 4. Common errors include syntax errors and performance issues, which can be optimized by checking SQL statements and using EXPLAIN commands. 5. Performance optimization techniques include using indexes, avoiding full table scanning, optimizing JOIN operations and improving code readability.

Describe MySQL asynchronous master-slave replication process.Describe MySQL asynchronous master-slave replication process.Apr 10, 2025 am 09:30 AM

MySQL asynchronous master-slave replication enables data synchronization through binlog, improving read performance and high availability. 1) The master server record changes to binlog; 2) The slave server reads binlog through I/O threads; 3) The server SQL thread applies binlog to synchronize data.

MySQL: Simple Concepts for Easy LearningMySQL: Simple Concepts for Easy LearningApr 10, 2025 am 09:29 AM

MySQL is an open source relational database management system. 1) Create database and tables: Use the CREATEDATABASE and CREATETABLE commands. 2) Basic operations: INSERT, UPDATE, DELETE and SELECT. 3) Advanced operations: JOIN, subquery and transaction processing. 4) Debugging skills: Check syntax, data type and permissions. 5) Optimization suggestions: Use indexes, avoid SELECT* and use transactions.

MySQL: A User-Friendly Introduction to DatabasesMySQL: A User-Friendly Introduction to DatabasesApr 10, 2025 am 09:27 AM

The installation and basic operations of MySQL include: 1. Download and install MySQL, set the root user password; 2. Use SQL commands to create databases and tables, such as CREATEDATABASE and CREATETABLE; 3. Execute CRUD operations, use INSERT, SELECT, UPDATE, DELETE commands; 4. Create indexes and stored procedures to optimize performance and implement complex logic. With these steps, you can build and manage MySQL databases from scratch.

How does the InnoDB Buffer Pool work and why is it crucial for performance?How does the InnoDB Buffer Pool work and why is it crucial for performance?Apr 09, 2025 am 12:12 AM

InnoDBBufferPool improves the performance of MySQL databases by loading data and index pages into memory. 1) The data page is loaded into the BufferPool to reduce disk I/O. 2) Dirty pages are marked and refreshed to disk regularly. 3) LRU algorithm management data page elimination. 4) The read-out mechanism loads the possible data pages in advance.

MySQL: The Ease of Data Management for BeginnersMySQL: The Ease of Data Management for BeginnersApr 09, 2025 am 12:07 AM

MySQL is suitable for beginners because it is simple to install, powerful and easy to manage data. 1. Simple installation and configuration, suitable for a variety of operating systems. 2. Support basic operations such as creating databases and tables, inserting, querying, updating and deleting data. 3. Provide advanced functions such as JOIN operations and subqueries. 4. Performance can be improved through indexing, query optimization and table partitioning. 5. Support backup, recovery and security measures to ensure data security and consistency.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)