NAV: SLTechnology News&Howtos > Database >

• 

  MySQL MHA important configuration

  1. Cluster information [root@es3 local] # cat / etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localho

  2022-06-01 11:20:27 Views: 237
• 

  7. Python Django connects to the database

  Python Django connect to database 1, install database # yum-y install mysql mysql-devel mysql- server II, check to see if python database component # rpm-Q is installed

  2022-06-01 11:20:26 Views: 216
• 

  MongoDB Note 3-Update Operation

  Update operation and query operation are extensive and profound. It needs to be understood. 1. Tough document replacement update operation 2. Error will be reported when the primary key conflicts and the update operation will be stopped because it is a tough replacement. When the replaced document conflicts with the existing document ID, the system will report error 3, insertOrUpda

  2022-06-01 11:20:26 Views: 272
• 

  Migrate the mysql database to another hard drive

  Archliun system mysql database 1, partition and format new hard disk 1) # fdisk / dev/sdb2) # mkfs.ext4 / dev/sdb12, stop MYSQL service systemctl stop my

  2022-06-01 11:20:26 Views: 211
• 

  Redis Cluster capacity expansion

  In the previous article, I introduced the actual deployment of Redis Cluster. "Redis Cluster Cluster deployment". How to expand the capacity because the business cannot support the existing access or expand the capacity in the future? You can make a script for rapid expansion in advance, carry out one-click expansion or hand

  2022-06-01 11:20:22 Views: 279
• 

  How to get Message from Error Code

  How to get Message1 from Error Code. Under Windows, the command Net helpmsg "displays information about Windows netwo" prints error messages according to error code numbers.

  2022-06-01 11:20:22 Views: 291
• 

  Pit of invalid characters in oracle

  In fact, there is just one more;! This habit can't be changed.

  2022-06-01 11:20:22 Views: 261
• 

  CentOS 6.8 compile and install MySQL5.5.32 (two multiple instances)

  MySQL multi-instance configuration is compiled and installed MySQL5.5.32 through CentOS 6.8 above. We have completed the compilation and installation, and then configure multi-instance. This figure draws lessons from Xu Liangwei's "mind Diagram" 5 and adds a multi-instance directory [root@db01 applic]

  2022-06-01 11:20:16 Views: 250
• 

  Centos7 compilation and installation of mysql-5.7.25

  Install the dependent component yum-y install cmake gcc-c++ ncurses-devel bison-devel to get mysql-5.7.25.tar.gz and extract wget cd mysql-

  2022-06-01 11:20:15 Views: 268
• 

  Example of basic operations for importing and exporting Oracle data

  Oracle data import and export basic operations sample data export a. Export the database orcl completely, and export the user name user password password to D:\ dc.dmp exp user/password@orcl file=d:\

  2022-06-01 11:20:15 Views: 288
• 

  PDB unplug

  1. Use SQL DEVELOPER2. Use the statement SQL > col pdb_name format A20SQL > col status format A20SQL > select pdb_name, s

  2022-06-01 11:20:00 Views: 263
• 

  On-line analytical processing

  1. OLAP is defined as online analytical processing. 1:OLAP is defined as online data access and analytical processing for specific problems. Through a variety of possible forms of information (which is converted from the original data to reflect the true "dimension" of the enterprise that users can understand).

  2022-06-01 11:19:59 Views: 204
• 

  Mariadb compiles the installation script

  #! / bin/bash#Date:2017-04-23 authorized Authorize Allenlisted Jolly Mariadbaud installed installed v1.0.shroomVersionRu Mariadbmure 10.1.22MARIADB _

  2022-06-01 11:19:59 Views: 235
• 

  Error installing sql2008R2 in win2003

  Start-Control Panel-Uninstall programs-MSXML 6 Service Pack2 (KB973686) start installing sql2008R2

  2022-06-01 11:19:59 Views: 246
• 

  Column-to-row function uses SQL

  Select down.downparaversionid | |'|'| | e.unionnoforce down.downparaversionreage.unionnogradlistagg (o.organname)

  2022-06-01 11:19:59 Views: 220
• 

  RMAN cross-version recovery-restore from Oracle10.2.0.5 to Oracle11.2.0.4

  Directory 1, database upgrade route 2, source side database full backup RMAN 2.1 before backup, execute utlu112i.sql script 2.2 Source side database full backup 3. Target side perform off-machine operation 3.1 restore Spfile3

  2022-06-01 11:19:58 Views: 298
• 

  Tuning it through case study-- null usage Index in Oracle

  Optimize it through case study-- null use index in Oracle. By default, Oracle database, null is not stored on Index, and the index cannot be used when the index column is accessed in the way of "is null". In this case, we will mainly demonstrate such as

  2022-06-01 11:19:58 Views: 215
• 

  Frequently asked questions about patching oracle

  Psu download document ID Master Note for Database Proactive Patch Program (document ID 756671.1) url: https://support.orac

  2022-06-01 11:19:28 Views: 241
• 

  Multi-backup and read-write Separation Construction of mysql Database

  Version 1 of the database. Community version 2. Enterprise Edition 3. Installation of cluster database 1. Dedicated software package manager (binary) related programs required by mysql MySQL client programs such as deb, rpm and shared library mysql-server MySQL server

  2022-06-01 11:19:28 Views: 237
• 

  Btrfs, disk, rpm, etc.

  The characteristics of btrfs: 1. Scalability: extent is the smallest logical unit, each extent is composed of a continuous set of block; the number of inode of ext file system is certain, and the number of inode of btrfs is dynamically adjustable; 2. Multiple physics

  2022-06-01 11:19:27 Views: 235