NAV: SLTechnology News&Howtos > Database >

• 

  MySQL sets master-slave replication

  Master-slave replication: one-way, two-way, ring, cascade, one master, multi-slave, two-machine replication 1, asynchronous master-slave (default regular) 2, double write (the former program writes to two databases at the same time, both sides must be implemented before the program returns success) 3, using plug-in software to achieve real-time master database Binlog log capture

  2022-06-01 14:45:54 Views: 261
• 

  Triggers and stored procedures

  Triggers and stored procedures 1. Triggers can listen to and respond to events when performing dml operations (insert,update,delete). This mechanism is called triggers in the database. A trigger is associated with a permanent table and can only be built on a permanent table, not a

  2022-06-01 14:45:54 Views: 267
• 

  Oracle table and table data recovery

  1. Table recovery for mistakenly deleted tables, as long as you do not use the purge permanent delete option, you can basically recover from the flashback table area. The data table and the data in it can be recovered, remember flashback tabl

  2022-06-01 14:45:54 Views: 225
• 

  Mongo fragment missing fragment index

  Mongodb cluster is used to store the information about the execution and call of the interface. The cluster is divided into two shard01,shard02, and each shard has one primary node and two slave nodes. Back up fragmented data on mongos and back up every day

  2022-06-01 14:45:54 Views: 267
• 

  Handling the failure of invalid index ORA-20000

  The author of dealing with invalid index ORA-20000 author: Zhao full text net name: guestart on Thursday morning, the developer reported that the database Oracle link would be broken after a period of time. He asked if it was because IIS and the database were not in the same network segment that a long connection was needed.

  2022-06-01 14:45:38 Views: 291
• 

  Oracle create tablespace script

  Oracle 10G script CREATE TABLESPACE "UCXM_DATA" LOGGING DATAFILE'd:\ oracle\ product\ 10.2.0\ oradata\ ora\ UC

  2022-06-01 14:45:37 Views: 241
• 

  [kclgclks_3] ADG

  Official SRAPPLIES TO:Oracle Database-Enterprise Edition-Version 12.1.0.2 to 12.1.0.2 [Release 12.1] is required

  2022-06-01 14:45:29 Views: 203
• 

  The method of starting Federated engine in MySQL under Linux

  To configure the Federated engine (function: cross-database operation), you need a version above mysql5.0. The specific configuration method is as follows: 1. First go to the MySQL database to see if the federated engine is installed. Enter the command: show engines

  2022-06-01 14:45:29 Views: 266
• 

  ORACLE series script 2: life-saving stored procedure emergency handling script

  Background: the long-term execution of stored procedures in the database leads to excessive resource consumption. Through the following expectations, we can quickly locate stored procedures, quickly intervene processing, and restore database performance. Long-term operation and maintenance through the following statements? t or above database? Yes, it works every time. -- query the executing stored procedure s

  2022-06-01 14:45:28 Views: 244
• 

  How to set password for mysql

  How to set the password for mysql the newly installed mysql does not have a password by default. Here are many ways for root users to enter mysql directly: 1. After entering mysql with root, mysql > set password = password ('you

  2022-06-01 14:45:28 Views: 279
• 

  Brief introduction of SQL Server Database

  The use of database can store data efficiently and clearly, so that people can manage data more quickly and conveniently. The database has the following characteristics: 1. It can store a large amount of data information structurally, which is convenient for users to retrieve and access effectively. 2. 2. It can effectively maintain the consistency and integrity of the data and information.

  2022-06-01 14:45:28 Views: 258
• 

  Create Scott users in Oracle under linux

  # Experimental environment: # Linux 5.4#Oracle 11g R2 # the process of creating Scott: su-oraclevi $ORACLE_HOME/rdbms/admin/utlsampl.sql#

  2022-06-01 14:45:28 Views: 254
• 

  Summary of SQL date and time functions (MSSQL)

  The time type is actually a floating-point Double type with a size of 8 bytes (Byte). Unit of time: 1 day = 1 minute = 1 day = 1 hour = 1 day = 1 hour = 1 minute = 1 minute = 1 day = 1 hour = 1 minute = 1 minute = 1 1/60/60/24Sql Server

  2022-06-01 14:45:28 Views: 252
• 

  How does Oracle view the execution plan

  1. How to view the execution plan in the Oracle database, we can usually use the following methods (including but not limited to) to get the execution plan of the target SQL: explain plan commands AUTOTRACE in the DBMS_XPLAN package SQLPLUS

  2022-06-01 14:45:27 Views: 255
• 

  Connect to the database using jsch

  Connect to the remote database through the jsch of java sometimes our local code may not be able to connect to the database because the database has added a whitelist, and only the server that specifies ip can connect to the database, but we can connect to the server of the specified ip and then connect to the database through the server

  2022-06-01 14:45:27 Views: 277
• 

  Oracle series: (21) access objects under other users [authorization]

  Declaration: scott or hr call user name / scheme name / space name scott--tigerhr-lion query who is the current user show user; query all objects under scott's own tablespace, with or without user name select

  2022-06-01 14:45:23 Views: 241
• 

  The design of database

  Database design process and data description 1. Requirements analysis stage (accurate understanding and analysis of user requirements, including data and processing) 2. Conceptual structure design stage (through the synthesis, induction and abstraction of user requirements to form an independent DBMS conceptual model) 3. Logical structure design phase (transfer of conceptual structure

  2022-06-01 14:45:22 Views: 282
• 

  MongoDB Replica Set replica set

  1. MongoDB replication is the process of synchronizing data on multiple servers, similar to MySQL Replication is a kind of asynchronous replication; replication provides redundant backup of data and stores copies of data on multiple servers, which improves the availability of data and ensures

  2022-06-01 14:45:22 Views: 232
• 

  Centos 6.5Installation of Atlassiana Crowd+JIRA+Confluence (Wiki) II Crowd (Crowd 2.8)

  Through my experience of continuous failure in installing the software, you'd better plan the overall environment before installing the software. there are the following points: it is best to install a software into a server without multiple software. plan the host of the system before installing on one server.

  2022-06-01 14:45:13 Views: 212
• 

  Hbase pre-built partition table to modify compression mode

  Hbase creates region, according to the division of rowkey: create 'BT_NET_LOG_000','cf', {SPLITS_FILE = >' splits.txt'} create 'BT_

  2022-06-01 14:45:12 Views: 229