Take the common user table, the article Class table, the log table to analyze the following CREATE table ' user ' ( ' id ' int (one) unsigned not NULL auto_increment COMMENT ' user ID ', ' Name ' varchar (255) NOT null COMMENT ' user name ', '
First modify the 1-node1. Modify the information for public in OCR[Email protected] ~]$ oifcfg delif-global eth0[[email protected]c1 ~]$ oifcfg setif-global Eth0/172.168.1.0:public[[ema Il protected] ~]$ oifcfg getifeth0 172.168.1.0 Global publiceth1
Metalink Note 283107.1 describes how to set up an IPMP for a VIP, where the setup process is recorded. o Existing 10g RAC installation ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ the ^^ ^^ ^^ ^^ ^^ ^ for Existing 10g RAC installations, use SRVCTL to Modify
Platform: centos6.4 Mysql:mysql-5.5.33-linux2.6-x86_64.tar.gz One, build LVM, and prepare before installation: #查看当前磁盘的分区 (here alone with a new plus disk for LVM) [Email protected] ~]# fdisk-l/dev/sdbdisk/dev/sdb:128.8 GB, 128849018880 bytes255
1. Open MySQL Access port 3306 Modify the firewall profile Vi/etc/sysconfig/iptables join port configuration Note: The added open 3306-port statement must be before icmp-host-prohibited-A input-m State--state new-m tcp-p TCP--dport 3306-j accept
First, MARIADB installationMARIADB is an open source branch of MySQL, mainly community maintenance, and fully compatible with MySQL, and can be easily known as the replacement of MySQL, Mariadb is born out of MySQL founder Michael Widenius Hand, The
How to add a local project to GitHub
1. System Environmentubuntu14.04
2. The system generates a key that interacts with GitHub (skip this step if you have already established a connection with GitHub)
$ cd ~/.ssh/
$ ssh-keygen-t rsa-c "own github
For the hot standby of MySQL database, Xtrabackup is the perfect addition to MySQL enterprise backup. The tool provides hot spares based on the InnoDB storage engine, supports full-volume, incremental, partial, point-in-time recovery, and redo slave
Kdb+ (K-based DB, enhanced version, or KDB) is a very small database, it has very high performance, rich and efficient time series functions, in the access and real-time analysis of large quantities of stocks, foreign exchange and other
One, the description database version 11g, single instance ADG. The operating system version is SuSE SP3. ip:192.168.1.11 Repository ip:192.168.1.12 Second, the requirements of the main library needs to modify the IP address, to ensure the normal
Specific error message:[ERR] 1055-expression #1 of ORDER by clause are not in GROUP by clause and contains nonaggregated column ' Information_sch Ema. PROFILING. SEQ ' which is not functionally dependent on columns in GROUP by clause; This was
Uses and techniques for compressed filesFor example, computers are measured in byte units, and 1byte is 8bit. If the number 1 is stored, then 1byte will empty 7bit. Using a certain calculation method, compressing these spaces can greatly reduce the
Three ways to install the package:
RPM Package
Yum Tool: A tool written in Py, also installs the RPM package, is the package that the automatic installation relies on.
Source Package Installation: Code installation
RPM Package
Shell Script IntroductionShell is a scripting languageYou can use logical judgments, loops, and other syntaxFunctions can be custom-definedThe shell is a collection of system commandsShell scripts enable automated operations, which can greatly
The previous introduction of disk storage this time to implement how to manage the disk, how to partition, create file system and other administrative partition commands1. LSBLK list all currently mounted devices[[email protected] ~]#lsblk NAME
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.