Responsibilities of the database administrator
Startup and shutdown of the server
User Account Maintenance
Log file Maintenance
Backup and copy of the database
Optimization of the server
Software updates for database management systems
Security of
PHP advanced mysql courseware 12th page. Responsibilities of database administrators server startup and shutdown user accounts maintenance log files maintenance database backup and copy server optimization database management system software updates
Responsibilities of the database administrator
Startup and shutdown of the server
User Account Maintenance
Log file Maintenance
Backup and copy of the database
Optimization of the server
Software updates for database management systems
Security of
Use Xtrabackup to back up and restore the database,
Install Xtrabackup
wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.9/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.9-1.el7.x86_64.rpmyum install percona-xtrabackup-24-2.4
Centos7 mobile mysql5.7.19 data storage location operation method, centos7mysql5.7.19
Scenario: as the data volume increases, the disk of mysql is full and data needs to be moved to a large disk.
Method:
1. Disable mysql Service
service mysqld stop
The following article describes how to restart the MySQL database. cnf, You need to restart the MySQL database. The following article describes the actual operation solution for restarting the MySQL database.
Because MySQL is installed from the
Centos Build LampTo install the Roundcube, first need to build a LAMP operating environment,LAMP is the acronym for Linux, Apache, MySQL, and PHP, which is the installation of a Web server with PHP5 and MySQL-supported Apache on a CentOS5.3 server.1.
Directory1, Database Full backup2. Preparing the LVM Volume3. Data recovery to LVM volume4. Backup data based on LVM snapshot5. Data Disaster recovery6. SummaryWrite in front:The MySQL 5.5.36 database is already installed in the test environment,
There are many ways to install software under Linux, which is installed using the simple and convenient yumFirst, using Yum to install the MySQL service, the client1. Check whether you have installed: Yum List installed | grep MySQL2. Yum List
Yum--releasever=6 List installed mysql* view to install MySQL
Yum--releasever=6 list mysql* view installable MySQL
Yum--releasever=6 Install Mysql-sever
Yum--releasever=6 linstall mysql-devel
MySQL config file/etc/my.cnf add
First, the way to start
1, use service to start: Service mysqld start
2. Start with mysqld script:/etc/inint.d/mysqld start
3. Start with Mysqld_safe: Mysqld_safe &
Second, stop
1, use service to start: Service mysqld stop
2. Start with mysqld
Check to see if the program is installed:which Nginx #查看nginx是否存在which PHP #查看php是否存在which MySQL #查看mysql是否存在
2Yum List Nginx #列出nginxYum Install Nginx #安装nginx#看见 {complete! The installation was successful.
3which Nginx #查看nginx是否存在Service
Also called the Master from replication, is done through binary log files, note: MySQL database version, two database versions to the same
System environment:
Master server Master ip:192.168.0.88
Slave ip:192.168.0.99 from server
One-way sync
Note
This question haunts me for a few hours to see the problem.
Summary sentence: Permission issues. How do you authorize that?
First step: Stop service
Command line:
/etc/init.d/mysql stop
If not, execute the next line:
Service Mysqld
MySQL login and set password under Linux (this article is based on centos6.4, mysql5.7.3), MySQL installed in the/usr/local/mysql directory:
[Root@lnmp ~]#/usr/local/mysql/bin/mysqladmin-uroot password ' admin123 ' #修改mysql密码为admin123[Root@lnmp ~]#/
In this step, you will configure your MySQL database server.Note: If you try to connect your confluence to a MySQL database server that already exists. We strongly recommend that you run the configuration steps in MySQL in accordance with the
2nd MySQL architecture and basic Management 2.1 client and server-side model 2.1.1 MySQL service structureMySQL is a typical C/s mode, the server and the client are composed of two parts Server-side program mysqld client program MySQL
Pre-configured Oracle database for JIRA, Oracle service once started, it takes up the system 2G of memory, it is very scary. So decided to switch to MySQL, more lightweight. Usually in the work did not use MySQL, so download a summary of the
For half a day.Kill process again, change the settings file, and restart the computer, it will not workTurn to the solution on StackOverflow and implement success:Original link:
A proper way to restart MySQL under Linux1. mysql service mysqld restart installed via RPM package2. mysql installed from the source packageLinux shutdown mysql Command$mysql _dir/bin/mysqladmin-uroot-p shutdownLinux commands to start MySQL$mysql
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.