Database Administrator

Recently, a zabbix monitoring system has been set up in the company. Now we need to use zabbix to monitor the master-slave synchronization of mysql. Now let's take a look at the detailed configuration steps: 1. First assign a monitoring account to

1. Clustering factor) The storage order of the index row is similar to that of the row in the table. When the similarity is high, these data rows will be stored in a relatively small number of data blocks, which is a good condition for clustering

The backup and recovery capabilities are "broken. The principle is briefly introduced here: Oracle records the changes of all data files in the form of logs. Therefore, as long as all oracle data files are backed up in a certain period of time and

To eliminate the connection problem between the client and the server, first check whether the client configuration is correct (the client configuration must be consistent with the database server listening configuration), and then solve the problem

I believe that you will often encounter this kind of requirement. You can use the id/name of a staff member to obtain a list of all its employees (including non-subordinate employees, it may take a while to implement this function using java, but it

In Windows, you do not need to create a data directory or an authorization table after installing mysql. A set of pre-initialized account authorization tables exist in the MySQL database under the Data Directory. Do not run the mysql_install_db

Current Environment DescriptionOperating System: AIXCluster software: HACMPThe following are the storage usage of the existing B-Host: Hdisk2 00c8970083c14f90 xxoraHdisk3 00c8970083c150c6 xxoraHdisk4 00c8970083c151d8 xxoraHdisk5 00c897b01a96a7a4

I. Hardware requirements 1. Memory & swap Minimum: 1 GB of RAMRecommended: 2 GB of RAM or more Check memory # grep MemTotal/proc/meminfo # grep SwapTotal/proc/meminfo 2. Hard Disk Since CentOS is installed almost 4 ~ 5 GB, plus Oracle and so on, so

Background: Processing NULL values during sorting, In Oracle official documents, null values are a special value type in the sorting process. By default, null values are regarded as the maximum value. That is to say, during sorting, when a Null

When developing Oracle SQL or PL/SQL programs, we often encounter the need to convert the string type to the DATE type. We will use to_date to implement this conversion requirement. But sometimes this conversion will go wrong and the ORA-01843: not

1. Install the patch package required by Oracle11g, which is available on the installation disc. Enter the Server Directory of the disc: (it is best to use the official oracle documentation to determine which packages need to be installed) 2. Modify

If you use nagios to monitor mysql master and slave databases, you need to install the nrpe software package and the nagios software package on the monitoring host. The installation steps are not described. On the monitoring host: First, define the

I. Redo Log Concept 1. What Is the Redo Log? Redo Log is used to protect the data that modifies the database but is not written into the data file. Redo logs are classified into Online Redo Log (Online Redo log) files and Archived Redo Log (Archived

At present, many tutorials on the internet talk about MongoDB sharding configuration, but most of them have not gone through practical practices and are reproduced randomly. In addition, the different configurations of MongoDB versions are messy,

Recently, after reading the concept, I suddenly felt empty. Not much gossip. I used PLSQL to write a calendar printing function. Create or replace package display_date isProcedure display_spec_mon (year number, month number );End;   Create or

First, create a test table. Create table test1 (c1 number, c2 number, c3 number );Create table test2 (c1 number, c2 number, c3 number ); Start testing SQL> declare22 l_stat_ SQL varchar2 (2000): = 'select value from v $ mystat ms, v $ statname sn

1. Add the JNDI configuration file to the Project Xmlns: xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns: aop = "http://www.springframework.org/schema/aop"Xmlns: tx = "http://www.springframework.org/schema/tx" xmlns: jdbc =

References. Alter system set log_archive_dest = "location =/u01/app/Oracle/baklog" scope = spfile; A problem occurs after execution. After the database is closed, it cannot start, Bytes ----------------------------------------------------------------

Install Oracle 10gR2 on Solaris 10. 1. Create a user, group, and oracle directory Log on as the root user and create a directory: Mkdir-p/opt/app/oracle Mkdir-p/opt/app/oracle/product/10.2.0/db Create an oracle group and user and assign users and

Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/30615151 The experiment process is as follows: 1. Create the table guo_test1 gyj@PROD> create table guoyJoe_t1(id int,name varchar2(10));Table created.gyj@PROD>