NAV: SLTechnology News&Howtos > Database >

• 

  Production environment postgresql master-slave environment configuration

  Master-slave server IP:192.168.11.131 postgreSQL master192.168.11.132 postgreSQL slave server system version: # cat / etc/redhat-rel

  2022-06-01 09:00:20 Views: 256
• 

  Building HADR with one Master and multiple Slave in db2V10.1

  In the new feature of HADR multi-standby, standby databases are divided into two categories, one is primary standby (Principal Standby) and the other is auxiliary standby (Auxiliary Standby). First, directory preparation mkdir-p / ho

  2022-06-01 09:00:20 Views: 242
• 

  Installation of MySQL5.7.28 source code under CentOS7.4

  Linux system version: CentOS7.4MySQL version: 5.7.28 there are RPM package, binary package and source package 3 in Linux platform. This article mainly takes the source package as an example to introduce how to install MySQL under the Linux platform.

  2022-06-01 09:00:19 Views: 222
• 

  Backup mysql with innobackup combined with scheduled tasks

  Write a script to make automatic full and incremental backups of vim / rootbind allbak.shallop full backup binapash bash [!-e / backup] & & mkdir / backup / / create a new folder for backup files

  2022-06-01 09:00:19 Views: 256
• 

  Orale user password expiration processing

  Log in with a user with administrative privileges 1, see which user's proifle is, usually default:SELECT username,PROFILE FROM dba_users;2, and view a specified profile (such as default

  2022-06-01 09:00:19 Views: 291
• 

  Install sql optimization tool SQLAdvisor under centos7

  1. Clone code # cd / usr/local/src/#git clone https://github.com/Meituan-Dianping/SQLAdvisor.git2. Install dependency package # yum in

  2022-06-01 09:00:18 Views: 209
• 

  Oracle 12C uses Rman Duplicate to build Data Guard

  Environment (only database software needs to be installed for database): main library: 192.168.1.100 OS: CentOS 7.3x64 DB: ORACLE12.2.0.1 SID: ORA12C db_unique_name:

  2022-06-01 09:00:18 Views: 203
• 

  Database middleware _ _ mycat

  Abstract: MyCat as of April 2015, it is conservatively estimated that there are more than 60 projects in use, mainly in the field of telecommunications, Internet projects, most of them are trading and management systems, and a few are information systems. In the larger system, the data scale is 3 billion per month. This article gives you a comprehensive picture.

  2022-06-01 08:59:57 Views: 231
• 

  Chapter I Random events and probabilities

  Chapter 1 Random events and probability §1.1 the task of probability theory of random events and sample space is to find out the possibility of occurrence of random phenomena, and to give a way to measure the probability and its algorithm. Random trials are observations of random phenomena. ① can repeat the possibility of each ② experiment under the same conditions.

  2022-06-01 08:59:52 Views: 299
• 

  CentOS7 terminal silently installs Oracle 11g R2

  The environment is ready to install package: linux.x64_11gR2_database_1of2.ziplinux.x64_11gR2_database_2of2.zip download address: http://download.ora

  2022-06-01 08:59:39 Views: 205
• 

  PostgreSQL for Linux installation mode

  1. Environmental planning directory name storage location Postgres user home directory / home/postgres software storage directory / home/soft installation directory / usr/local data directory / home/postgres/data/2, installation

  2022-06-01 08:59:39 Views: 249
• 

  Abnormal recovery of Greenplum segment nodes

  Segment detection and failover mechanism GP Master first detects the Primary state, and if the Primary is unreachable, it will detect the Mirror state. There are four Primary/Mirror states: Primary is alive.

  2022-06-01 08:59:38 Views: 269
• 

  [MySQL] Database Monitoring-- fpmmm (zabbix)

  Official website: http://www.fromdual.com fpmmm (FromDual Performance Monitor for MySQL and MariaDB) [root@wallet01 ~

  2022-06-01 08:59:38 Views: 228
• 

  Oracle RAC cluster migration to Oracle stand-alone _ Oracle RAC migration _ database migration and backup recovery 12

  Feng GE is familiar with production environment Oracle RAC cluster migration to Oracle database stand-alone project implementation Oracle RAC cluster migration to Oracle stand-alone _ Oracle backup recovery and data migration 12 course address: https://edu

  2022-06-01 08:59:35 Views: 259
• 

  Wget download jdk

  Wget-no-cookies-no-check-certificate header "Cookie: gpw_e24=http%3A%2F%2Fwww.oracle.com%2F; ora

  2022-06-01 08:59:08 Views: 277
• 

  PHP, MYSQLI to achieve simple add, delete, change, query functions (beginners)

  Index.php

  2022-06-01 08:59:08 Views: 238
• 

  MySQL Automation (full + incremental) backup script

  1. Daily backup scheme of MySQL: full backup + incremental backup: 1, full backup at 3: 00 am on Sunday; 2, incremental backup from Monday to Sunday. Instead of the usual full backup on Sunday, incremental backup from Monday to Saturday, so that if there is a problem with the database before the full backup on Sunday, there will be one day less on Sunday after the recovery is completed.

  2022-06-01 08:59:08 Views: 252
• 

  Oracle Study-- Oracle wait event (7)

  Oracle Study-- Oracle wait event (7) Free buffer waits when a session reads blocks of data from disk into memory, it needs to find free memory space in memory to store those blocks, when there is no free space in memory

  2022-06-01 08:59:07 Views: 263
• 

  MySQL temporary file size setting

  The size limit of individual files is determined by the operating system. File size can be more than

  2022-06-01 08:59:07 Views: 213
• 

  Oracle report-ORA-00922: solution to missing or invalid options

  This error occurred during the installation of Oracle 11g R2 while creating a new database instance, and an ora-28000 error will occur if you select ignore. Verified by the network query, this belongs to the previous configuration of the administrator password, using the password at the beginning of the number, Ora

  2022-06-01 08:58:58 Views: 214