NAV: SLTechnology News&Howtos > Database >

• 

  Greenplum4.3.12 installation of CentOS6.8 in VMWare

  After viewing online videos and looking for online materials. GP4.3 installed successfully. The following is the directory of the installation process. The experimental environment is 41.1. Hardware environment 41.2. Virtual machine configuration 42. System setup (all master nodes and data nodes) 42.1. Base environment settings 42.1

  2022-06-01 08:51:15 Views: 238
• 

  [methods] how to restrict IP access to Oracle database

  [methods] how to limit IP access to Oracle database 1.1 BLOG document structure figure 1.2 introduction 1.2.1 introduction and precautions for technical enthusiasts, after reading this article, you can master the following skills, and you can also learn some other knowledge that you do not know.

  2022-06-01 08:51:11 Views: 230
• 

  Security Management and Optimization of mysql system

  1. Prohibit MySql from running as an administrator account. MySql should run under a non-administrator account and run mysqld hardening safely as a normal account: configure user=mysql2 in the my.cnf configuration file. Set root user password and modify login

  2022-06-01 08:51:05 Views: 299
• 

  Db file scattered read of Oracle waiting for event

  Db file scattered read official website explains: This event signifies that the user process is reading buffers into the SG

  2022-06-01 08:51:05 Views: 214
• 

  Introduction to HBase

  1. HBase is a distributed storage system based on column storage and built on HDFS. Its main function is to store massive structured data. HBase is built on top of HDFS, so HBase also improves the running and storage capacity of the system by adding cheap PCs. HBas

  2022-06-01 08:51:05 Views: 242
• 

  About how to view the datafile of seed pdb in the CDB_DATA_FILES view

  In the oracle 12c multi-tenant environment, we sometimes want to view the file information of the seed database (pdb$seed) through cdb_data_files, and we will find that there is no feedback, but you may find that in some cases on the Internet, we can use cdb_data_.

  2022-06-01 08:51:04 Views: 224
• 

  MySQL Learning Note data types and Operation data Table

  1. Data type [1] Integer: data type storage range byte TINYINT has symbolic type:-128 ^ 127 (- 2 ^ 7 ~ 2 ^ 7-1), unsigned 0255 (0 ~ 2 ^ 8-1) 1SMALLINT has symbolic type:-2 ^ 15 ~ 2 ^ 15

  2022-06-01 08:51:04 Views: 211
• 

  Detailed explanation of deployment on server side of zabbix3.0

  Yum configuration download yum configuration rpm-ivh http://mirrors.aliyun.com/zabbix/zabbix/3.0/rhel/7/x86_64/zabbix-release-3.0-1

  2022-06-01 08:50:58 Views: 267
• 

  Docker install postgreSQL 11.4

  1. Installation command: docker pull postgres:11.4 2. Run command: docker run-- name postgres_demo-e POSTGRES_PASSWORD=password

  2022-06-01 08:50:49 Views: 260
• 

  Xtrabackup remote stream backup script

  1. Xbstream stream. Local folders can be created by themselves, and remote folders must exist innobackupex-- host=127.0.0.1-- post=3306-- stream=xbstream-- c

  2022-06-01 08:50:48 Views: 283
• 

  Installation and use of zabbix

  Official website: www.zabbix.com system version: centos6.x software version: zabbix-2.4.7.tar.gz server IP=192.168.1.100 client IP=192.168.1.200 use source code

  2022-06-01 08:50:26 Views: 209
• 

  [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.

  2017-07-28T12:46:35.138596Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please

  2022-06-01 08:50:25 Views: 241
• 

  Oracle lock table

  SELECT 'Lock' "Status", a.username "user name", a.sid "SID", a.serial# "SERIAL#", b.type "lock type", DECODE (

  2022-06-01 08:50:25 Views: 251
• 

  LAMP environment building

  Build the Lamp environment: (move the extracted lamp directory to the "/" directory) 1. Prepare the work 1. Install the compilation tool gcc, gcc-c++ to solve the dependency, it is recommended to use yum installation, if you can not connect to the network, use the installation CD as the yum source-- 1) Edit y

  2022-06-01 08:50:25 Views: 254
• 

  Java manipulates MongoDB_3 (preliminary study of MongoDB)

  Click on the jar package of MongoDB to see that there are many methods for the Mongo class, including getAddress (), dropDatabase (String), getDB (String), and so on. Let's demonstrate Mongo.clas one by one.

  2022-06-01 08:50:25 Views: 209
• 

  Master-slave synchronization of MariaDB and MySQL databases

  1. Mysql master-slave synchronous asynchronous concept: the master server returns the synchronous completion message immediately after writing the log, which is not affected by the status and influence of the slave server. MySQL defaults to asynchronous working mode synchronization: the master server writes data to the local disk and records the binary log, and then waits for the slave server to discover

  2022-06-01 08:50:21 Views: 296
• 

  One of the new features of Oracle 11g-read-only meter (read only table)

  One of the new features of Oracle11g-read only table Oracle11g has introduced a new feature that allows table to be placed in the read only state, and table in this state cannot perform DML operations and some

  2022-06-01 08:50:21 Views: 261
• 

  Redis master-slave + sentinel configuration

  The common configuration of redis master-slave + sentinel mode is as follows: odd-numbered redis acts as master-slave, and odd-numbered sentinel nodes monitor redismaster nodes. If master nodes fail, master nodes can be transferred automatically. Sen

  2022-06-01 08:50:21 Views: 292
• 

  Oracle 11g ORA-12514:TNS: the listener currently does not recognize the service requested in the connection descriptor

  Oracle 11g ORA-12514:TNS: the listener currently does not recognize the service resolution process requested in the connection descriptor: 1. Locate the listener.ora listening file at D:\ app\ Administrator\ p

  2022-06-01 08:50:21 Views: 251
• 

  Detailed building process of MySQL MHA

  Environment: build MySQL MHA master node with 3 servers: 192.168.157.128 CentOS 7.6database: mysql-5.7.27-linux-glibc2.12-x86_64 slave node: 192.168

  2022-06-01 08:50:20 Views: 235