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-
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
Mysql console operation command
1. connect to the mysql database
1. open cmd to enter the dos window.
2. switch to the directory: D:/MySql5.0/mysql-5.0.51b-win32/bin (I .e., the bin directory under the mysql installation directory, which contains a
MySQL常用指令,java,php程序员,数据库工程师必备。程序员小冰常用资料整理MySQL common commands (for reference)The most common display commands are:1. Display the list of databases.show databases;2. Display the data table in the library:Use MySQL;Show tables;3, display the
Mysql console operation bitsCN.com
1. connect to the mysql database
1. open cmd to enter the dos window.
2. switch to the directory: D:/MySql5.0/mysql-5.0.51b-win32/bin (I .e., the bin directory under the mysql installation directory, which
Recommended settings:
For a single running web server, we recommend that you add:
Skip-locking
Skip-name-resolve
Skip-networking
Use "localhost" when connecting to the database in PHP. In this way, the mysql client library will overwrite and try to
CACTI: Use templates to monitor mysql and cactimysql on local or other servers
Mysql templates, online are using this address http://mysql-cacti-templates.googlecode.com has not been accessed
Google found this URL:
Introduction: http://www.percona.
This article will cover another high-availability implementation of MySQL, namely MHA (Masterhigh avaliable). Master HA. is an open source high-availability program that provides MySQL's master-slave architecture with the ability to automatically
DownloadOpen: https://www.mysql.com/downloads/1. Click on the entry:,2. Click after entering:3. To the Real download page, select the platform, select the version (install version and install free version), download4, I now download the free install
First, MySQL IntroductionWhen it comes to databases, we mostly think of relational databases, such as MySQL, Oracle, SQL Server, and so on, which are very easy to install on Windows, and if you want to install a database on Linux, I have to
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.