NAV: SLTechnology News&Howtos > Database >

• 

  Introduction to mycat self-study finishing

  Because of the format problem of 51 blog writing, the future documents are mainly based on well-documented links, which have been sorted out to Youdao cloud notes. At present, notes include cloud computing operation and maintenance big data, application operation and maintenance, DBA, testing, if Xiaobai wants to learn, you can add me qq:936172842,. Please indicate 51 Xueyou, no remarks.

  2022-06-01 14:24:39 Views: 232
• 

  Configure SQL Server settings using environment variables on Linux

  You can configure SQL Server 2017 on Linux with different environment variables. These variables are used in two scenarios: use the mssql-conf setup command to configure initialization settings. Configure SQL Serv in a new Docker container

  2022-06-01 14:24:39 Views: 292
• 

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

  2.3.3 configuring Pacemaker on Cluster Explorer PacemakerLinux is introduced on the Windows Server operating system by Windows Server Failover Cluster (WSFC)

  2022-06-01 14:24:39 Views: 299
• 

  The answer to the questions of Linux operation and maintenance on the Internet (3)

  Source: most of http://2358205.blog.51cto.com/2348205/1688449http://mofansheng.blog.51cto.com/8792265/1627702

  2022-06-01 14:24:38 Views: 267
• 

  MongoDB automatic startup script

  After installing mongodb, always start as follows, specify dbpath,logpath, verify auth, etc. / mongod-- dbpath=/usr/bin/mongodb/mongodb/data-- logpa

  2022-06-01 14:24:38 Views: 245
• 

  Oracle 10G DataGuard building

  Earlier we talked about the construction of Oracle 11G DataGuard, while the construction of 10G is more or less the same. However, Oracle 10G does not support Standby open environment: role hostname IP database version operating system version Primaryf

  2022-06-01 14:24:38 Views: 240
• 

  Centos7 MariaDB10.1.22 compilation and installation

  Current system environment # hostnamectlStatic hostname: localhost.localdomainIcon name: computer-vmChassis: vmMachine ID

  2022-06-01 14:24:38 Views: 242
• 

  Mysql to resurrect one.

  First of all, our aim is to query all the data in these two tables and then delete the duplicate records. Each data is kept only one first step: query the duplicate records of the following two tables (duplicate key fields > 1) ks_examcity, ks_examd.

  2022-06-01 14:24:37 Views: 205
• 

  [MongoDB Learning Notes 22] Index Management of MongoDB

  Use the ensureIndex function to create an index of the collection. For the collection, each index only needs to be created once, and repeated creation has no effect; > all the numbers of show collections system.indexes users

  2022-06-01 14:24:37 Views: 237
• 

  SQL command

  SELECT-extract data from database UPDATE-update data in database DELETE-delete data INSERT INTO from database-insert new data CREATE DATABASE into database-create new number

  2022-06-01 14:24:37 Views: 269
• 

  Oracle View deadlock and unlock

  1. Check the deadlock SELECT s. Username LOCK_LEVEL,o.owner,o.o decode (l.typethschild "TMJ"TABLE") LOCK_LEVEL,o.owner,o.o

  2022-06-01 14:24:37 Views: 218
• 

  11g asm pfile & spfile

  The default database installation is complete, and the pfile and spfile of ASM are not found in the ORACLE_HOME/dbs directory. Manually create pfile and pfile as follows: $exit# su-grid$ srvctl config

  2022-06-01 14:24:37 Views: 229
• 

  Start to write some articles today

  Learn some techniques, mainly oracle and linux, hoping to find your own direction as soon as possible.

  2022-06-01 14:24:14 Views: 292
• 

  Open phpmyadmin to show that advanced features have not been fully set up and some functions are not activated

  Question: open phpmyadmin to show that advanced functions have not been fully set up and some functions are not activated. How should I solve this problem? A total of three steps can be done 1, import relevant files into the database 2, change the configuration file config.inc.php3, give root users the relevant permissions in detail

  2022-06-01 14:24:14 Views: 274
• 

  Oracle lock

  1. Definition: the lock mechanism is used to manage concurrent access to shared resources (serializing concurrent access to these shared resources), while providing data integrity and consistency. 2. Oracle lock features: locks are not rare resources in Oracle; Oracle will not

  2022-06-01 14:24:13 Views: 225
• 

  Writing and querying Redis Cluster data (experiment)

  Data writing test: # redis-cli-h 192.168.2.100-c-p 6379 / /-c indicates connection cluster 192.168.2.100 set name zhangsan- > Red

  2022-06-01 14:24:06 Views: 251
• 

  First acquaintance with 10--MariaDB Galera Cluster of MariaDB

  Background introduction: whether using binlog or GTID, its essence is synchronization in the form of I/O_thread and sql_thread, which has been criticized for being unable to avoid replication delay. Based on the above MariaDB, Galera is introduced.

  2022-06-01 14:24:06 Views: 241
• 

  Oracle transactions and common data objects

  Transaction is the core of data processing and a logical unit of the business, which can ensure that all operations on the data are either successful or fail. DBMS coordinates the concurrent behavior of users through transaction management and reduces conflicts when users access resources. .1) Show commit: when a transaction encounters

  2022-06-01 14:23:36 Views: 240
• 

  Hbase source code compilation and import eclipse

  First of all, go to Apache's official website to download the hbase1.0.1 source package because the source package is managed by maven, you need to install maven1. Install MAVEN to download the installation package unzipped file, Maven needs the support of JDK, configure JAVA_HOME and Pat

  2022-06-01 14:23:06 Views: 263
• 

  How to use rowid fields in the view

  In the oracle database, creating a view will not generate a corresponding rowid, but will only generate a pseudo column rownum;. Directly using select rowid from view 1 in the view will directly report an error. "ORA-01446: cannot use DISTIN.

  2022-06-01 14:23:06 Views: 205