NAV: SLTechnology News&Howtos > Database >

• 

  Oracle11g database migration to Oracle12C's PDB (using impdp/expdp)

  Migration of Oracle11g databases to Oracle12C's PDB (using impdp/expdp) alter pluggable database hrdb close immediate;DROP PLUGGA

  2022-06-01 13:44:54 Views: 276
• 

  Actions of MYSQL users

  Why should the authorization of MYSQL users be authorized? The default user of MYSQL is root. Because the authority of root is too large, and for security reasons, it is generally used only when managing the database. If you want to connect to a MYSQL database in the project, it is recommended.

  2022-06-01 13:44:53 Views: 218
• 

  An example of error reporting failure of Oracle 11g RAC two-node root.sh execution

  Record the installation process of Oracle 11g rac only once. This article is from: http://koumm.blog.51cto.com/1. Using RHEL6.5 multipath multipath software installation and udev configuration of ASM total

  2022-06-01 13:44:50 Views: 234
• 

  Mysql optimization and indexing

  Optimization of table 1. Fixed length and variable length are separated, such as int,char (4), time core and commonly used fields, built with fixed length and put in a table, while varchar,text,blob variable length field is suitable for putting a single table, with the primary key associated with the core table. two。 Commonly used fields and not

  2022-06-01 13:44:50 Views: 265
• 

  Special report on UNDO space sizing steps for MySQL database InnoDB storage engine

  The topic describes the standardized steps that need to be followed to adjust the innodb_log_file_size size or the number of filegroups for the configuration parameters of the already running MySQL database InnoDB storage engine. Solution 1 modifies the parameters to cl the next time MySQL shuts down

  2022-06-01 13:44:50 Views: 279
• 

  Learning and practice of MYSLQ incremental recovery

  The architecture of MYSQL is generally one-master, multi-slave or two-master high availability mode. Physical failure does not require incremental recovery. What circumstances do you need incremental recovery? It is generally caused by human misoperation that requires incremental recovery. Conditions that must be met for incremental recovery 1) enable MYSQL log-bin

  2022-06-01 13:44:35 Views: 276
• 

  Mongo shell startup configuration file .mongorc.js (IV)

  The mongo shell startup configuration file. Mongorc.js (IV) ~ / .mongorc.js file is described as follows: # mongorc.js= my mongorc.js file. Provide:-`

  2022-06-01 13:44:35 Views: 262
• 

  Command line for MySQL to create a datasheet

  In MySQL, you need to create a database first, and then create a data table. To create a data table, you must first design the fields of the data table, which are numeric type, text type, floating point type, string type, date type, and so on. 1, create datasheet command line CREATE TABLE tabl

  2022-06-01 13:44:35 Views: 208
• 

  Realize the real-time statistics of massive message data through Flink

  Background message reports are mainly used to count the distribution of message tasks. For example, the total number of APP users sent to a single push message, the number of successful push to mobile phones, and how many APP users click on the pop-up window to notify and open APP, and so on. Through the message report, we can see the elimination very intuitively.

  2022-06-01 13:44:35 Views: 270
• 

  Reconstruction of crs by oracle 10g rac

  The 1.crs file has been corrupted. Delete crs information rac10g1 node: [root@rac10g01 install] #. / rootdelete.shShutting down Oracle Cluster Re

  2022-06-01 13:44:28 Views: 231
• 

  ORACLE 12C three-node RAC installation error [INS-32025]

  Test and install three-node Oracle 12C RAC, the notebook is equipped with dual-core I5 16g memory, and each virtual machine is allocated 4G memory. During the installation of the database software, the primary instance restarted abnormally and reinstalled the database software, but an error was encountered. The error is as follows: [INS-320

  2022-06-01 13:44:28 Views: 207
• 

  Oracle11g ADG building

  Environment: Oracle 11.2.0.4 single instance two standby libraries only install Oracle software and monitoring. 1. Operation of master library 1. Backup pfile of master library to record the original parameters SQL > create pfile='/hom

  2022-06-01 13:44:25 Views: 235
• 

  Watch the new features of MongoDB3.6 in 3 minutes.

  After 3 minutes of reading the Default Bind to Localhost3.6 version of MongoDB3.6 's new feature, localhost (127.0.0.1) is used by default, and multiple ip are separated by commas: localhost,198.

  2022-06-01 13:44:25 Views: 209
• 

  Oracle kmp

  CREATE OR REPLACE PACKAGE KMP_ALGOR_PKGASTYPE next_arr_tt IS TABLE OF INT INDEX BY PLS_INTEGER;PROCE

  2022-06-01 13:44:15 Views: 244
• 

  Mongodb replica set

  In fact, mongodb can also act as a master-slave mechanism. Mongodb one master and one slave is similar to mysql, but slave is read-only in the architecture, and the master cannot be switched automatically after the host goes down. Now the official use is no longer recommended, use the copy set instead. In this mode there is a master (pr

  2022-06-01 13:44:15 Views: 216
• 

  Semi-synchronous replication of Mysql master-slave replication (based on gtid)

  Mysql Master-Slave replication mysql Master-Slave replication principle: there are two threads IO thread and SQL thread 1. The IO thread of the slave database sends a request to the master process of the master database, and the master database verifies the slave database and gives it to the IO thread of the master database to be responsible for data transmission. The main library IO thread compares the ma sent from the library

  2022-06-01 13:44:15 Views: 222
• 

  Redis-cluster deployment and data migration

  How it works is excerpted from the redis official document: http://www.redis.cn/topics/cluster-tutorial.htmlRedis Cluster introduction Redis Cluster is a service that provides a total of nodes across multiple Redis

  2022-06-01 13:44:15 Views: 245
• 

  Record a piece of python code (modify database string)

  Scene: due to the development of disgusting account login settings, and in view of the habits of Japanese players, Japanese players have just begun to log in to the game as tourists. If there is a change of package or equipment, the account ID needs to be replaced from the database. At first, it is purely manual, and then it is implemented by py, encapsulated as exe and executed directly in dos.

  2022-06-01 13:44:05 Views: 277
• 

  Checking and troubleshooting of insufficient disk space in mysql

  Today, the supervisor told me that the disk space on the mysql server was insufficient. I just logged in to the server to check: command: df-lh accounted for 99%. Is it cached. Entering > mysqlflush logs; has not changed much. Let's see which directory takes up space. Cd

  2022-06-01 13:44:05 Views: 252
• 

  Goldengate extracts ORACLE data to Hbase

  1. Software version note: Goldengate 12c 12.2.0.1 forOracle (source side) Goldengate 12c 12.2.0.1 for Bigdata (destination side) Oracle 11

  2022-06-01 13:43:53 Views: 278