NAV: SLTechnology News&Howtos > Database >

• 

  Xtrabackup study notes

  Wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.7/binary/tarball/percona-xt

  2022-06-01 11:18:44 Views: 270
• 

  PostGIS related database parameters

  1. Definition of table structure-- Table: public.tbl_buildings-- DROP TABLE public.tbl_buildings;CREATE TABLE public.tbl_buil

  2022-06-01 11:18:44 Views: 204
• 

  Introduction to atlas Management Command

  Through atlas management commands, you can easily go online, offline server, add users, add ip whitelist, and save configuration changes to the configuration file. Environment introduction: master: 192.168.6.91 from: 192.168.6.85 to be added: 192.16

  2022-06-01 11:18:44 Views: 260
• 

  SQL Server 2017 AlwaysOn on Linux configuration and maintenance (15)

  2.5.2 delete availability group if the cluster type is EXTERNAL or NONE, run the command on each SQL Server instance that hosts one copy. DROP AVAILABILITY GROUP group_name

  2022-06-01 11:18:44 Views: 273
• 

  Linux silently installs Oracle

  Environment preparation: 1. Hostname: vim / etc/sysconfig/network2, local domain name interprets vim / etc/hosts# necessary dependencies #

  2022-06-01 11:18:44 Views: 297
• 

  Mongodb library backup

  Create recovery user db.createUser ({user: "huifu", pwd: "123456", roles: [{role: "restore", db: "admin"}]}) create backup user db.createU

  2022-06-01 11:18:43 Views: 246
• 

  Oracle-11g Database installation tutorial

  Oracle is a relational database management system of Oracle. The system has good portability, easy to use and strong function, and is suitable for all kinds of large, medium, small and microcomputer environments. It is a database solution with high efficiency and good reliability, which adapts to high throughput. I believe that every IT god is interested in OR.

  2022-06-01 11:18:28 Views: 239
• 

  Brief introduction of Monitoring system

  First, why the monitoring system in an IT environment there will be a variety of devices, such as hardware equipment, software equipment, the composition of the system is also very complex. A variety of applications constitute a complex IT business system, and it is the responsibility of a company's IT department to ensure the normal operation of these resources. And want

  2022-06-01 11:18:19 Views: 256
• 

  Oracle Snapshot Control File (snapshot control file)

  CONFIGURE SNAPSHOT CONTROLFILE NAME TO'C:\ APP\ ADMINISTRATOR\ VIRTUAL\ PRODUCT\ 12.2.0\ DBHOME_2\ DATABAS

  2022-06-01 11:18:16 Views: 262
• 

  Simultaneous loss of parameter files, control files and incomplete recovery of redo log file (hot backup and archiving of data files)

  Please indicate the source of the reprint: preparation work before http://blog.csdn.net/guoyjoe/article/details/30839817########## recovery 1. Make a hot backup select'

  2022-06-01 11:18:12 Views: 267
• 

  Pyqt5_ site Administration _ db_windows

  From PyQt5.QtWidgets import QWidget,QLabel,QLineEdit,QGroupBox,QGridLayout,QVBoxLayout,QPushButton,Q

  2022-06-01 11:18:12 Views: 291
• 

  Windows does not display uppercase table names after authorizing users with a single table

  Problems encountered in the simulated production environment 1. Description of the problem: 1.Windows2.mysql-5.7.18 version configuration mysql parameters lowercasetablenames=0 restart can not start, can only choose the second, configure lowerc

  2022-06-01 11:18:12 Views: 232
• 

  A simple understanding of master-slave synchronization in MySQL

  MySQL master-slave synchronization simple understanding of many large websites in order to reduce the performance problems of a large number of users to the server concurrent visits, will use a lot of solutions, database master-slave separation is a mainstream solution at present. Imagine that every user invokes server data through the control layer business layer

  2022-06-01 11:18:12 Views: 244
• 

  Oracle next_day,add_month function

  Next_day () gets the date of the next week of the current date, which is easily understood literally as the date of the next few days of getting the current date. For example: select next_day (to_date) ('20160330century recording yyyymm

  2022-06-01 11:18:11 Views: 229
• 

  Oracle erroneous deletion of tablespaces-recovery method (1)

  For Oracle 11.2.0.4 single-instance version test demonstration process: misoperation to delete tablespaces. As long as there is no restart of the library. [oracle@oracle fd] $sqlplus / as sysdbaSQL*Plus: Re

  2022-06-01 11:17:53 Views: 292
• 

  Cause Analysis and solution of MySQL Err 1418

  MySQL has a parameter log_bin_trust_function_creators. The official document introduces and explains this parameter as follows: This variable applies when binary logg

  2022-06-01 11:17:53 Views: 265
• 

  Database data type

  Data type is an attribute of data, which can determine the data storage format, valid range and corresponding restrictions. The types in Mysql are: integer type, floating point type, date and time type, string type and so on. Different data types have different characteristics and scope of use. Integer types are the most basic in the database.

  2022-06-01 11:17:47 Views: 228
• 

  Oracle tablespace management

  Create tablespace command: CREATE TABLESPACE userdataDATAFILE'/ u01amoradata SIZE 100MAUTOEXTEND ON NEXT Userdata01.dbf'

  2022-06-01 11:17:46 Views: 293
• 

  Application scenarios corresponding to various data types of reds

  1.String type application scenario String is the most commonly used data type, ordinary key/value storage. 2. List type application scenarios are more suitable for list storage, and the order is relatively fixed, such as provinces, city list brands, manufacturers, cars,

  2022-06-01 11:17:46 Views: 212
• 

  SQL gets the first letter of the field string

  Have Chinese and English, get Chinese initials information. SELECT person_name_cn, ELT (INTERVAL (CONV (HEX) (CONVERT (person_name_cn USING gbk))

  2022-06-01 11:17:40 Views: 228