NAV: SLTechnology News&Howtos > Database >

• 

  6\ MySQL master-slave synchronization, MySQL read-write separation, MySQL performance tuning

  Day06 1, mysql master-slave synchronization 2, data read and write separation 3, MySQL optimization + + 1, mysql master-slave synchronization 1.1 master-slave synchronization introduction? Automatically synchronize the number of master libraries from the library server

  2022-06-01 12:58:02 Views: 242
• 

  Oracle 11gR2 enables auditing of sys user actions

  In oracle 11gR2, login audit information for sys users is recorded by default in the audit_file_dest directory, but the actions are not audited. Enable auditing of sys user actions SQL > alter system set a

  2022-06-01 12:58:02 Views: 215
• 

  Installation and uninstallation of oracle 11g (2)

  2. Oracle installation 1. Manual Summary this manual mainly describes how to install oracle database2 with the default options. Login as root to install the system with a graphical interface requires the execution of xhost + 3. Hardware requirements Detection 3.1 memory requirements minimum memory

  2022-06-01 12:58:02 Views: 237
• 

  Oracle 11g R2 architecture

  Install oracle software-create database-create tables in the database-store information in tables-these table files need to be stored on the physical hard disk. If there is a user (this user can be a remote user, a local user, or an application)

  2022-06-01 12:57:46 Views: 290
• 

  Concise user Manual of Database Middleware OneProxy

  Database middleware OneProxy concise user manual http://mp.weixin.qq.com/s?__biz=MzA3MzYwNjQ3NA==&mid=2651296386&idx=1&sn=92d3f

  2022-06-01 12:57:46 Views: 294
• 

  Backup of mysql very large database

  Xtrabackup tool is a data backup tool for InnoDB, which supports full bright backup and incremental backup. Backup of MyISAM databases is not supported, but Xtrabackup has a tool, innobackupex, which supports MyISAM

  2022-06-01 12:57:46 Views: 258
• 

  Comparison between redis and memcached

  What I summed up: a more authoritative comparison of the summary of these two technology options: reference: https://db-engines.com/en/system/Memcached%3BRedishttps://cloud.oracle.c

  2022-06-01 12:57:31 Views: 209
• 

  RMAN-06023: no backup or copy

  RMAN > restore database;Starting restore at 2017-03-02 12:03:05using target database control file ins

  2022-06-01 12:57:25 Views: 217
• 

  CentOS+Nginx+Tomcat+Mysql+PHP Environment Construction and system deployment

  = install centos 7.0 installation = Select the minimum installation and select the relevant "debugging tools", "compatibility libraries" and "development tools". This is done to reduce post-installation or compilation

  2022-06-01 12:57:25 Views: 234
• 

  APPARENT DEADLOCK!!! Error resolution process

  Project environment database: oracle middleware: WAS2. The problem description is May 21, 2015 (a good day). The was background error was found in the morning as follows: [15-5-21 7 Syste 31-01 CST] 00000027 Syste

  2022-06-01 12:57:25 Views: 308
• 

  Navicat usage tutorial: how to delete duplicate lines with different ID in MySQL

  Download the latest version of Navicat Premium Navicat Premium is a management tool that can connect to multiple databases. It allows you to connect to MySQL, Oracle and PostgreSQL databases in a single program at the same time.

  2022-06-01 12:57:21 Views: 244
• 

  OGG silent installation

  1. Download the corresponding OGG installation package and decompress it. 2. Configure auto answer file (oggcore.rsp). Main modifications: INSTALL_OPTION=ORA12c-installation option. Select ORA11gSOFT for oracle11g.

  2022-06-01 12:57:18 Views: 228
• 

  The case of Oracle Study-data recovery artifact Flashback (3)

  The case of Oracle Study-data recovery artifact Flashback (3) Flashback Database: case study: flashback database: using flashback log for the whole dat

  2022-06-01 12:57:15 Views: 215
• 

  I fight with oracle odbc! Win2008 R2 64-bit installation oracle instantclient odbc method and troubleshooting

  This article introduces: install oracle instantclient odbc in windows server 2008 R2 (x64) environment background introduction: because the server I built is a 64-bit system, but the application is 32-bit, so

  2022-06-01 12:57:00 Views: 291
• 

  ETL tool-- DataX3.0 actual combat

  ETL tool-DataX3.0 operational DataX is a tool for high-speed data exchange between heterogeneous databases / file systems, which realizes the data exchange between arbitrary data processing systems (RDBMS/Hdfs/Local filesystem).

  2022-06-01 12:56:59 Views: 245
• 

  Oracle Forall

  FORALLNote: [from official document] Example 12-7DELETE Statement in FOR LOOP StatementDROP TABLE empl

  2022-06-01 12:56:59 Views: 236
• 

  Oracle 12.1.0.1 GI+DATABASE play PSU

  12.1.0.1 dozen Patch Set Update 12.1.0.1.9 (Oct2015) machine: two OLE6.5 and 12.1.0.1 RAC pre-preparation: download p6880880 121010

  2022-06-01 12:56:59 Views: 275
• 

  Rebuild the index of all tables in the database

  It is recommended to rebuild the index when the business is idle; declare @ sql varchar (max) set @ sql=''select @ sql=@sql+'dbcc dbreindex ('+ name+');

  2022-06-01 12:56:59 Views: 220
• 

  Oracle Study-- Oracle regular expression

  Oracle Study's-- Oracle regular expression case requires: to establish a check constraint, the field input must be "00 [number] [number] [Amurz]": establish the following through the regular expression

  2022-06-01 12:56:58 Views: 228
• 

  Configuration of commonly used authorization and authorization recovery parameters in database

  Title index official help common cases official help when using the database is essential to check help help, through help help to find common commands and parameters again, the following is help grant information: MariaDB [(none)] > help gr

  2022-06-01 12:56:58 Views: 281