Shulou(Shulou.com)05/31 Report--

This article introduces what is the daily management responsibility of the MySQL database system, the content is very detailed, interested friends can refer to, hope to be helpful to you.

The main duty of daily management is to manage the operation of MySQL server program mysqld, so that database users can access MySQL server smoothly. The following are the main responsibilities of this job:

Startup and shutdown of the server. The specific contents of this responsibility include:

1) manually start and shut down the MySQL server from the command line

2) arrange for the MySQL server to start and shut down automatically during system startup and shutdown.

3) restore the MySQL server to its normal running state when it crashes or starts abnormally.

Manage user accounts. The specific contents of this responsibility include:

1) learn the difference between MySQL user account and UNIX or Windows registered account

2) set up a MySQL user account to restrict users to connect to MySQL servers only from specified machines

3) notify new users of the correct connection parameters so that they can connect to the MySQL server smoothly-their job is to use the database instead of setting up accounts!

4) if the user (or yourself) forgets the password, you also need to know how to reset a new password.

Manage log files. The specific contents of this responsibility include:

1) know which types of log files you can manage

2) when and how to manage

3) develop and implement log looping and failure mechanisms to prevent log files from running out of free space in the file system.

Back up and move the database. When the system crashes, database backup will play a vital role. You must want to be able to restore the system to the state it was before the crash with as little data loss and as little time as possible. However, it should be noted that the database backup work is different from the general system backup work (such as the backup work carried out with the UNIX tool program dump). System backups are usually done by the system administrator, who does not necessarily shut down the MySQL server before the backup begins. As a result, in the course of a system backup, the contents of some data tables may change because the MySQL server is still reading and writing to them-using such a backup to restore the system will lead to confusion in the contents of those data tables. The backup files generated by the mysqldump program are more suitable for database recovery operations, and it does not require you to shut down the MySQL server before the backup begins. You may also need to move the database when the disk is full.

Database relocation refers to the transfer of a database from one hard disk to another. When there is little free space left on the disk, or when you want to transfer some databases to another faster host, you need to move the relevant databases. Here I would like to remind you of such a problem: database files depend on the specific operating system, so the relocation of the database may not always be completed with a simple file copy command.

Establish database mirroring. If the backup or copy of the database is compared to taking "photos" of the database, the establishment of database mirroring is equivalent to taking a "video" of the database. To establish database mirroring, you need to run two database servers at the same time and make them form a master-slave relationship. In this way, changes made to a database managed by the master server will be reflected synchronously (with a slight delay) in the corresponding database managed by the slave server.

Configure and optimize the server. Database users want the database server to run at its best, and the easiest way to improve server performance is to add more memory and faster hard drives. But this must not be a reason not to delve into how the database works-after such a "brute force", the server still needs to be configured and optimized. The specific contents of this responsibility include:

1) know what parameters can be used to optimize the server

2) how to optimize these according to the specific situation. Most of the queries on some sites are data retrieval operations, while those on others are mostly data insertion and modification operations. Specific to your site, should be based on the actual observation of the query "mixing ratio" to select the most effective parameters to change.

"localizing" the database server (such as setting the appropriate character set and time zone, etc.) is also part of its configuration.

Running multiple servers at the same time. In some cases, you need to run multiple servers at the same time. You may be testing against a new version of MySQL software, but you must keep the existing server running, or you may want to provide a better privacy protection mechanism for each group of users by letting different user groups use different servers. (the latter case is particularly suitable for ISP. In either case, you need to master the technology of installing and starting multiple MySQL servers at the same time.

Upgrade the MySQL software. Like other software products, MySQL is constantly updating. If you want to apply the new version with fewer vulnerabilities but richer features, you must master the software upgrade technology. The specific contents of this responsibility include:

1) know how to upgrade MySQL software

2) under which circumstances it is more reasonable not to upgrade

3) how to choose between a stable version and a test version. On the MySQL database system what is the daily management responsibilities to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.