what ema

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

[[email protected] rman]# su-oracle[[email protected] ~]$ Rman target/Recovery manager:release 11.2.0.3.0-production on Fri Sep 19 09:47:47 2014Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.Connected to target

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

Transferred from: http://blog.chinaunix.net/uid-7270462-id-5777877.htmlOne, configuration centralized backup server 1.1 standby installation Backup Server Software dependency packageYum-y Install PERL-DBD-PG Perl-json perl-thread-queue 1.2 Standby

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

Mysql:Use sakila;--show fields from table_name;--show keys from table_name; SELECT ' referenced_table_name ' from ' information_schema '. ' Key_column_usage ' WHERE ' table_name ' = ' [table_containing _foreign_key] ' and ' column_name ' = '

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

12.17 Nginx Load BalancerProxy HTTP onlyvim/usr/local/nginx/conf/vhost/load.conf//write the following:Upstream qq_com{Ip_hash;Server 61.135.157.156:80;Server 125.39.240.113:80;}Server{Listen 80;server_name www.qq.com;Location/{Proxy_pass

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

Crontab Recurring Task Settings# yum Install cronie-y# systemctl status crond.service# systemctl start crond.service# systemctl enable Crond.service[[email protected] etc]# cat /etc/crontab shell=/bin/bashpath=/sbin:/bin:/usr/sbin:/

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