MySQL

mysql master/slave hot standby configurationThe MySQL version of both servers is 5.5.41master:192.168.3.119slave:192.168.3.120MySQL master server configuration:1. Create a user for backupGrant Replication Slave on * * to ' slave ' @ ' 192.168.3.120 '

MyISAM is the default storage engine for MySQL, which is stored as three files on disk. MyD is a data file. Myi is the index file. frm is the storage table definition. We can consider the data files and index files to separate disk, to achieve the

CONVERT (Expr USING Transcoding_name)CONVERT (Expr,type)the type must be of the following type :Types of availableBinary, with binary prefix effect: binaryCharacter type, with parameters: CHAR ()Date: DateTime:DateTime Date/Time typefloating point

First, the experimental environment preparation:Main Library (Master): CentOS release 5.9 x86_64ip:10.45.172.40MySQL Ver 14.12 distrib 5.0.95From the library CentOS release 5.9 x86_64ip:10.45.172.37MySQL Ver 14.12 distrib 5.0.95,Test whether to

1, modify the index address: Any location can be, this article in E:\solr\ built a data folder, and then modify the dir under E:\solr\collection1\conf\solrconfig.xml : To create the index address path${solr.data.dir:E:/solr/data}2, establish a

1. Create a user on two MySQL, set permissions on a add: Grant Replication Slave,replication client,reload,super on*. * To'Sync_user'@'192.168.2.220'Identified by'123456'with GRANT option;//for b accessB: Grant replication slave,replication

Before installing MySQL, you need to install three components, one is CMake (MySQL software installation and compilation software), one is Ncurese (provide the terminal character processing library, one is Perl (called "Practical Report Extraction

Method 1: Use the Set password commandMysql-u Rootmysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');Method 2: Use Mysqladminmysqladmin-u root Password "Newpass"If Root has already set a password, use the following

1, first of all we want to determine a library from the repository, remember that only read from the library can not have other operations, if the operation is written by the master and slave failure, then see how we build the master-slave bar!2,

Received mail today, mysql3308, synchronization error, log as follows:650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/58/C7/wKioL1S8l_KypZBfAAFoPmRUszU909.jpg "title=" Untitled. png "alt=" wkiol1s8l_kypzbfaafopmruszu909.jpg "/>To modify

MySQL query results export/output/write to FileMethod One:Execute the command directly:Mysql> Select COUNT (1) fromtable into outfile '/tmp/test.xls ';Query OK, Rows Affected (0.00 sec)The file is generated under directory/tmp/Test.xlsProblems

Issue: Access denied for user ' * ' @ ' localhost ' using password YesMethod 1: Use the Set password commandMysql-u Rootmysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass '); (solved in this way)Method 2: Use Mysqladminmysqladmin-

The first is InnoDB's transaction implementation mechanism, on the csdn: point I download, here briefly introduced, it is controlled by redo and undo, and every second will be the log buffer flushed to redo log files, so for the larger transaction

Apache:If using RPM package installation, the installation path should be in the/ETC/HTTPD directoryApache configuration file:/etc/httpd/conf/httpd.confApache Module Path:/usr/sbin/apachectlWeb directory:/var/www/htmlLog directory:/VAR/LOG/HTTPDIf

1. Locate the mysql-cacti-templates MySQL template in the Data Templates console, edit:In this case, the use of Port Per-data Source value (Ignore this value) is selected, meaning that the value of this parameter is entered by the user and then

Monitoring host 192.168.24.69, the following with a for the monitored host 192.168.24.79, the following with the B ID remember to import monitoring MySQL templates files in the a server cacti 1. Install Snmp#yum installed on B

Tag:java   jdbc    database    url    Package Com.execlexport.util;import Java.sql.connection;import Java.sql.drivermanager;import Java.sql.preparedstatement;import java.sql.resultset;import java.sql.sqlexception;/** * DatabaseUtil * Creator:

Connection Query 1, Internal link queryINNER JOIN INNER join uses comparison operators to perform comparison operations on some column data between tables, and lists the data row groups in those tables that match the join criteria to synthesize new

Setup method:Step one setA service suit (192.168.1.43) user is backup, 123456, synchronized database is test;B Service Suit (192.168.1.23) user is root, 123456, synchronized database is test;Step Two configuration Mysql.ini:A server#Replication

Export:The following command-line specific usage is as follows: Mysqldump-u username-p password-D is the name of the script in the database name table;1, export the database as DBNAME table structure (where the username is root, the password is