NAV: SLTechnology News&Howtos > Database >

• 

  Hadoop redis mongodb

  1. Environmental system CentOS7.0 64-bit namenode01 192.168.0.220namenode02 192.168.0.221datanode01 192.168.0.222datanode

  2022-06-01 09:52:27 Views: 296
• 

  Expdp+dblink realizes remote backup, which is especially practical.

  In many cases, there is not enough local space, but also want to backup how to do, some people say that in the production system to mount a disk, in fact, it is not necessary, expdp+dblink to help you get it! 1. Test environment description server: Oracle 11g rac client: Oracle 11

  2022-06-01 09:52:26 Views: 298
• 

  Oracle trigger-record modification history

  Select * from ordtaskremeb_logcreate table ordtaskremeb_log (timeinfo varchar (50), oldeqid varchar (20)

  2022-06-01 09:52:26 Views: 229
• 

  Oracle forcibly kills a user connection

  Query the values of sid and serial# to kill the user; select sid,serial# from v$session where username=' user name'; kill the user to connect to alter system ki

  2022-06-01 09:52:26 Views: 226
• 

  Oracle Tablespace Oracle10g Learning Series (10)

  Four states of the tablespace: online,offline,read write and ready onlySQL > select file#,status,enabled from vastly datafile

  2022-06-01 09:52:26 Views: 299
• 

  Linux MySQL 5.7 binary minor version upgrade

  Linux MySQL5.7 binary minor version upgrade MySQL5.7 binary installation on Unix/Linux when upgrading, it is divided into in-place and logical upgrade methods. 1 upgrade in place includes shutting down the old MySQL server and using the new MySQL service

  2022-06-01 09:52:26 Views: 215
• 

  Execute stored procedures through OCILIB connection to oracle

  # include # include "ocilib.hpp" using namespace std;using namespace ocilib;#pragma comment (lib, "ocilib

  2022-06-01 09:52:25 Views: 222
• 

  An example of website built by SQLServer

  Environment: SQLServer2008R2 one, web server one software support: iis, dynamic website source code topology: step: database part: 1, start-click SQLServer Management Studio2, enter SQLS

  2022-06-01 09:51:55 Views: 232
• 

  MongoDB fragmentation technology

  There is another kind of cluster in MongoDB sharding in Mongodb, that is, sharding technology, which can meet the needs of the massive growth of MongoDB data. When MongoDB stores large amounts of data, one machine may not be enough to store data or provide access

  2022-06-01 09:51:52 Views: 239
• 

  Full backup and recovery of MySQL data by XtraBackup

  Security code: it is impossible to have inner peace without a considerable degree of loneliness. 1. Overview Percona XtraBackup (PXB) is a backup tool developed by Percona for physical hot backup of MySQL databases, which supports MySQl

  2022-06-01 09:51:49 Views: 235
• 

  Redis Cluster-- installation configuration

  Background this article is mainly about the installation of Redis Cluster, let's use it first, feel what's going on, and then continue to learn about how to Cluster how to failover, add nodes, delete nodes, migrate slots and other functions. Redis

  2022-06-01 09:51:46 Views: 233
• 

  RHEL7.2 compilation and installation of mysql5.7.13

  1. Uninstall MySql or mariadb and boost [root@node1 ~] # rpm-qa | grep mysql [root@node1 ~] # rpm-qa | grep mariadbma

  2022-06-01 09:51:45 Views: 272
• 

  OGG operation and maintenance optimization script (III. V)-Information modification class-additional logs added

  File name: addtrandata.sh path: $HOME/ggscript/gginsert function: it is used to add table additional logs in batches, which is a function independent from the add table script, and is used to deal with the loss of table additional logs and add table additional logs.

  2022-06-01 09:51:45 Views: 237
• 

  Mysql-MMM highly available cluster deployment

  What is MMM? MMM (Master-Master replication manager for Mysql,Mysql Primary Primary replication Manager) is a set of scripts that support dual-master failover and dual-master day-to-day management. MMM uses Per

  2022-06-01 09:51:45 Views: 241
• 

  Oracle11G_JAVA operates the database

  There are two ways for JAVA to access Oracle: JDBC-ODBC bridge, JDBC;JDBC driver: located in the lib directory under the oracle home directory; JDBC-ODBC bridge: JAVA program converts JDBC calls into ODBC calls through bridges, ODBC

  2022-06-01 09:51:45 Views: 267
• 

  Oracle11.2.0.1 PSU upgrade 11.2.0.4

  1. First download the required PSU package p6880880 _ 112000_Linux-x86-64.zippatch package: p19121551_112040_Linux-x86-64-psu4.zip2, decompress p6880

  2022-06-01 09:51:44 Views: 228
• 

  Oracle copies files from ASM to the file system

  At work, sometimes it is necessary to copy files from ASM to the file system or vice versa, and do some maintenance operations. This paper introduces four methods to copy files: cp command in ASMCMD (11g) dbms_file_transfer package rman conve

  2022-06-01 09:51:44 Views: 276
• 

  ORACLE builds the library manually

  Manually build the database: find the official document, open the main index to find management-- create database stops the existing database and frees up memory 1. 5. Set the environment variable-- ORACLE_SID2. Create a password file 3. Create a parameter file for the text 4. Establish a binary parameter text

  2022-06-01 09:51:44 Views: 214
• 

  3. Ora_Sec-privileges (grant and revoke permissions)

  Authorization is divided into: grantee (grantor) grantee (grantee) grant and revocation permissions are divided into: system permissions and object permissions. There are about 200 system permissions, most of which affect the operation of the data dictionary. The common permissions are as follows: CREATE SES

  2022-06-01 09:51:43 Views: 215
• 

  Sqlplus is displayed as a question mark in Chinese

  Operating system language: [oracle@ocp01 ~] $echo $LANGzh_CN.UTF-8 query database language: SQL > select userenv ('language') from dual;USER

  2022-06-01 09:51:43 Views: 289