mysql cnf

....tar.gz $ MCnN} 3D 8jS; av 3. add users and groups mysql: JC! A; RX = T "r Groupadd mysql> Js] * O-b5 @ QbgV + Useradd-g mysql +,) 9 ^ YC * V/B "'B 4. create a symbolic connection:/usr/local # ln-s mysql-standard-5.x... mysql LQdx1w + Q A LYGx6 5. cd

data /Usr/local/mysql # chgrp-R mysql -------------------------------------------------------------------------------- 8. create and modify/etc/my. cnf as needed. refer to the configuration: [Mysqld] # Set the default value to the INNODB table and support transactions: Default-storage-engine = INNODB # Set the default character set UTF-8: Character-set-server =

/nologin mysql # mkdir/mydata/data-p # chown-R mysql. mysql/mydata/data/# chown-R root. mysql/usr/local/mysql/* # cp support-files/my-large.cnf/etc/my. cnf # cp support-files/mysql. se

authorized_keys 192.168.1.248:/root/. ssh/Authorized_keys 100% 1800 1.8KB/s[Root @ tong3. ssh] # scp authorized_keys 192.168.1.247:/root/. ssh/Root@192.168.1.247's password:Authorized_keys 100% 1800 1.8KB/s[Root @ tong3. ssh] # ssh tong1 dateTue Apr 28 8 12:57:02 CST 2015[Root @ tong3. ssh] # ssh tong2 dateTue Apr 28 8 12:59:57 CST 2015[Root @ tong3. ssh] # ssh tong3 dateTue Apr 28 8 12:57:25 CST 2015[Root @ tong3. ssh] # 5. Edit the configuration file on the Management Node [Root @ tong3. ssh

I haven't written anything for a long time. On these days of work, I got some methods to install Mysql. This method can install multiple Mysql on a Linux service at the same time. The source code of mysql. the serial number is mysql-5.0.20a.tar.gz. Of course, the other code can be used only for testing. Red Hat Linux a

transactions and roll back uncommitted transactions !) -- Copy-backCopy the backup data back to the datadir of the server. It depends on the datadir parameter in my. cnf. In addition, the datadir directory must be empty during restoration and the mysql database must be shuffled! -- No-timestampInnobackupex -- defaults-file =/etc/my. cnf -- user = root -- no-time

use the log parameter in the startup option, it will be displayed in the err log. ---- Modify the my. cnf file and add log parameter settings [Root @ node4 mysql5.5] # vi my. cnf [root @ node4 mysql5.5] # cat. /my. cnf | grep '^ log = 'Log =/tmp/mysqlgen. log ---- clear err logs [root @ node4 mysql5.5] # cat/dev/null>/tmp/mysql3306.err [root @ node4 mysql5.5] #

/# initialize mysql 4) Configure my. cnf $ sudo vi /usr/local/mysql/my.cnf This example only ensures normal operation, so you can configure the following three items. basedir = /usr/local/mysql datadir = /data/mysql port = 3306 Create a soft connection my.

MySQL has the following common backup solutions: mysqldump + binloglvm + binlogxtrabackup. In this example, the data in the database is empty. Next start mkdiroptbackup # create Backup Directory mkdir-pdata3309 {data, binlog} cdusrlocalmysqlscriptsmysql_install_db -- usermysql- MySQL has the following common backup solutions: mysqldump + binlog lvm + binlog xtrabackup. In this example, the data in the datab

install # Modifying users and permissions Java code /Usr/sbin/groupadd MySQL /Usr/sbin/useradd-G MySQL Chmod + w/usr/local/MySQL Chown-r MYSQL: MySQL/usr/local/MySQL Mkdir-P/var/

Innodb does not have such restrictions, so the proportion of Innodb table types in the database is greater, it is more advantageous. In actual application, the innobackupex method is generally used directly. There are three main operation methods, as described in the Manual: Usage: Innobackup [-- sleep = MS] [-- compress [= LEVEL] [-- include = REGEXP] [-- user = NAME] [-- Password = WORD] [-- port = PORT] [-- socket = SOCKET] [-- no-timestamp] [-- Ibbackup = IBBACKUP-BINARY] [-- slave-info] [-

need master-slave replication, it will end here. You can skip it later. All the changes in A can be automatically synchronized to B, but the changes to B cannot be synchronized to. Because it is unidirectional. If bidirectional synchronization is required, A copy from B to A is required. Basically the same as above: Let's briefly introduce: 1. create a user in B; 2. open/etc/my. cnf and enable binarylog of B: Note the newly added part in the r