Database Administrator

16.3 MySQL Cluster configuration details (config. ini)Config. in ini, each type of node has two (or more) corresponding configuration item groups. The configuration items of each type of node are mainly composed of two parts, and one part is the

Mysql of the binary version has been compiled. You do not need to perform configure, make install, or other steps. You only need to configure the mysql version and delete it directly;Now we will introduce mysql-5.1.47-linux-i686-glibc23.tar.gz:1. #

Let's take a look at the following example: Two system tables in Oracle. emp, dept. example: 1: not exists (not in) Not exists: This statement returns the result set that the select * from scott. dept d where e. deptno = d. deptno and d. deptno = 10

Only scripts are provided here, which is exactly the same as the previous "automatic backup of multiple Oracle instances under Aix 5.3, If you want to add at or crontab, refer to automatic backup of MySQL database under CentOS5.4. # MySQL User

Mysql> select * from test;+ -------- + ------ + --------------- + --------- + ------------------------------- +| P_id | g_id | p_name | p_price | p_desc |+ -------- + ------ + --------------- + --------- + ------------------------------- +| Beef1 | 1

Recently, my NC project runs in Linux. Write down the installation process.============= Manually start Oracle ======## note: in this example, the oralce command is in the/home/oracle/product/10.2.0/db_1/bin directory. # You can change it to your

First, log on to Oracle as a super AdministratorSqlplus sys/bjsxt as sysdbaThen, unlock the scott user.Alter user scott account unlock;Then the user name can be used.(Default Global Database Name orcl)1. select ename, sal * 12 from emp; // calculate

　　To delete an archive file of the master database in the Maximum Availability and Maximum Performance modes of Oracle Data Guard, the archive file must be deleted after the backup database is applied. 　　For Maximum Protection mode, logs in this

Although MySQL is easy to use, it is prone to Chinese garbled characters. The following lists several common Chinese garbled characters in Java Web development: 1. JSP page display problems 2. garbled Chinese characters stored in MySQL DATA 3.

In today's project, you need to create a materialized view for multi-table join and refresh it once every two minutes. Oracle ORA-02063 error Solution As shown in:   The refresh method of my refresh statement is force. This method will first try to

Symptom description: Log on to Oracle11g ERROR: ORA-28002: the password will expirewithin 7 days Alarm information: ERROR: ORA-28002: the password will expire within 7 days Cause analysis: SELECT * FROM dba_profiles s WHERE s. profile =

Part 1 configure MASTER (10.0.0.1) 1. Enable binary logging on the master database server and assign a unique server-id. Open the configuration file/etc/qa_my.cnf and add the command under the [mysqld] group: [Mysqld]Log-bin = mysql-binServer-id = 3

MySQL authorization and status query Create database odi; -- CREATE an ODI DATABASEGrant all privileges on *. * TO odi @ '%' identified by 'odipasswd'; -- remote authorization;Flush privileges; -- refresh the authorization tableDelete from user

Oracle bad block processing script Applies:Oracle Database-Enterprise Edition-Version 8.1.7.0 to 12.1.0.1.0 [Release 8.1.7 to 12.1]Information in this document applies to any platform. GoalThe purpose of this plsql script is to create a new table

This article introduces flume data insert hdfs and common directory (), this article continues to introduce flume-ng to insert data into the hbase-0.96.0. First, modify the flume-node.conf file in the conf directory under the flume folder in node

First look at the example Example 1: select ltrim ('caolingxiong ', 'cao') from dual; ------ The returned result is ---------- Lingxiong This result is expected because the beginning of the first parameter is the same as that of the second

Introduction Replace is similar to an insert statement.If an old record in the table has the same value as a new record used for the primary key or a UNIQUE index, the old record is deleted before the new record is inserted. Unless the table has a

1. Introduction to Xtrabackup 1. What is Xtrabackup? Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to InnoDB Hotbackup.Xtrabackup has two

At the underlying layer of Hibernate, SQL statements are still used to perform database operations. Although all relational databases support standard SQL statements, all databases have extended standard SQL statements, therefore, there are some

ORA-01438: The value is greater than the allowed precision specified by this columnFor example, if the value is defined as number (200.12) but is inserted, an error occurs because of number (p, s. Number (p, s), where p indicates the total length