MySQL has become one of the most widely used databases on the network, especially for Web applications. it occupies the absolute advantage of small and medium applications. All of this comes from its small and easy-to-use, secure and effective, open
Website:Program on:Web server 192.168.1.100 abovedatabase in: MySQL server 192.168.1.123 aboveImplementation Purpose: add a MySQL backup server (192.168.1.124), as a MySQL server (192.168.1.123) from the server, the two MySQL servers to achieve dual-
Detailed steps for implementing mysql hot backup in linux (mysql master-slave replication) bitsCN.com
Role of the master and slave:
1. it can be used as a backup method.
2. read/write splitting to relieve the pressure on a database
MySQL
Role of the master and slave:
1. It can be used as a backup method.
2. read/write splitting to relieve the pressure on a database
MySQL master-slave backup principle:
Mysql master-slave replication requires at least two Mysql services. Of course,
1. download MySql
1. download MySql
Open http://www.mysql.com/downloads/mysql/#downloads download in browser
My downloaded version is Red Hat 5 version of http://www.mysql.com/downloads/mirror.php? Id = 407552
Upload the file to the server, or
Install MySQL1. Download the MySQL Installation FileThe following two files are required to install MYSQL:MySQL-server-5.1.7-0.i386.rpm
To download the above two RPM files, locate the "server" and "client programs" items and find the items
Mysql Database Installation Steps
Redhat6.5
1. Preparations
Uninstall the mysql-server and mysql packages installed using the rpm packageInstall the ncurses-devel packageRpm-ivh/mnt/Packages/ncurses-devel-5.7-3.20090208.el6.x86_64.rpm① Decompress
This article mainly introduces how to install mysql database in centos. For more information, see CentOS.
1. first download the MySQL installation file. I have installed MySQL5.1.7 here,
2. install the MySQL database server
Go to the folder where
The role of Master and subordinate:
1. Can be used as a backup method
2. Used to achieve the separation of read and write, ease the pressure of a database
MySQL master-slave backup principle:
MySQL's master-slave replication is at least two
Install and configure the Mysql database under centos, import the database, authorize a remote ip address, and centos Mysql
Uninstall the original mysql
Because mysql databases are too popular on Linux, the mainstream Linux system versions currently
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.