NAV: SLTechnology News&Howtos > Database >

• 

  Installation and use of mariadb

  Install and use mariadbcentos 7 directly provide centos 6 universal binary installation process 1, prepare data directory take / mydata/data as an example 2, configure mariadb#groupadd-r-g 200 mysq

  2022-06-01 17:31:37 Views: 277
• 

  Problems encountered in real-time synchronous update of remote database by SQL Server

  When you encounter such a situation in your work, you need to update TableB (located in server ServerA 172.16.8.101) at the same time as the update table TableA (library Database An in server ServerB 172.16.8.100)

  2022-06-01 17:31:25 Views: 251
• 

  Detailed explanation of role types of MongoDB replication set

  MongoDB replication set role type MongoDB replication set role type 1, standard node: participate in primary election, when its own downtime or stop service will automatically give up primary2, passive node: can only become second does not participate in the election, is set to be

  2022-06-01 17:31:01 Views: 204
• 

  Orabbix installation error "received unexpected response"

  [pool-1-thread-5] WARN Orabbix-received unexpected response''for key' hitratio_body'

  2022-06-01 17:31:01 Views: 216
• 

  The problem of multi-path id confusion in oracle asm arbitration plate

  Some time ago, I received a response from my colleagues in Shenzhen that one of the oracle clusters was overloaded. In order to troubleshoot the problem, the system had been rebooted, but after the system restarted, six arbitration disks were lost. In order to find out the cause, after logging in to the system, execute df-h and find that the / boot partition of the system becomes

  2022-06-01 17:31:01 Views: 239
• 

  The difference between two commands of MySQL

  Display table attribute information mysql > describe table name; display table attribute information mysql > show columns from table name; display table content mysql > select * from table name

  2022-06-01 17:31:00 Views: 267
• 

  From JD.com and VIPSHOP's practice sharing of micro service choreography, API gateway and continuous integration (part I)

  Architect group meeting: each issue selects one of the hottest technical topics to share practical experience. The third phase: micro-service. Micro-service architecture is quickly concerned by architects and technical decision makers in various fields because of its high flexibility, flexibility and great improvement in efficiency. Its basic idea is to put a fat department

  2022-06-01 17:31:00 Views: 248
• 

  Oracle explain

  EXPLAIN PLAN FOR SELECT * FROM TB_USER; select * from table (dbms_xplan.display); Plan hash value:

  2022-06-01 17:31:00 Views: 239
• 

  Ora-12154 cannot parse the specified connection identifier

  Ora-12154 cannot resolve the specified connection identifier in net manage under oracle 11G.

  2022-06-01 17:30:56 Views: 278
• 

  The disk displays the data recovery methods that need to be formatted before using the CD in the drive

  You need to format the disc in the drive before using it, indicating that the file system structure of the disk is corrupted. In normal times, if the data is not important, you can use it by formatting it directly. But sometimes the data inside is very important, so you must recover the data before formatting. The specific recovery method can look at the text.

  2022-06-01 17:30:38 Views: 296
• 

  SQLServer authentication

  SQLServer supports both Windows authentication mode and mixed mode authentication mode. Classification: Windows authentication mode and mixed mode platform: Windows nature: authentication mode the differences between the two authentication modes are: (1) Wind

  2022-06-01 17:30:32 Views: 253
• 

  Oracle HA dual-computer active and standby is based on shared storage mode and uses keepalived management to achieve high availability.

  HA Overview HA (High Available), which consists of two computers and provides the same set of services to the outside world, is also called one-master-one-standby mode. Under normal circumstances, the service is provided by the main server, the standby server is on standby, and the standby machine can take over the work of the master server at any time. That is, when

  2022-06-01 17:30:32 Views: 206
• 

  [Oracle Database] Oracle RAC (IV): DBMS

  [root@wallet01 ~] # useradd-u 1101-g oinstall-G dba,asmdba oracle [root@wallet01 ~] # echo oracle |

  2022-06-01 17:30:01 Views: 225
• 

  Mysql failure case

  # # error: ERROR 1044 (42000): Access denied for user 'root'@'%' to database' dede'mysql > create database

  2022-06-01 17:30:01 Views: 272
• 

  Tell me how to do the SQL audit of oracle

  Talk about how to do the sql audit of oracle database: 1. How to do the syntax checking in advance? first of all, you should be familiar with the complicated oracle syntax specifications and be able to report errors in advance (this is not a problem). 2. Check the column of DDL statements, indexing

  2022-06-01 17:30:00 Views: 235
• 

  MariaDB create, change, delete database command

  Create a new MySQL database create a MySQL database with a specific character set (UTF8) Delete an existing MySQL database create a MySQL database only if it does not exist will you lose the database feature that changes db.opt only when the db.opt database exists

  2022-06-01 17:30:00 Views: 292
• 

  How to migrate from BasicFile to SecureFile Storage (2)

  SYS_IL0000072118C00005 $$INDEX PARTITION ASSM SYS_IL_P177 BASICFILESSYS_IL0000072118C00006 $$INDEX P

  2022-06-01 17:30:00 Views: 218
• 

  01-redis-introduction

  Key-value storage system. Official site: five data types: string, list (linked list), set (collection), sorted set (ordered collection), hash. Persistence: RDB, AOF. The total data format is to put the data in memory

  2022-06-01 17:29:59 Views: 289
• 

  [question] The coprocessor thread sto

  Kylin reported an error when executing the query statement as follows: Error while executing SQL "select t.

  2022-06-01 17:29:59 Views: 288
• 

  Mongodb performance monitoring

  Mongostat:mongostat-u admin-- authenticationDatabase admin

  2022-06-01 17:29:59 Views: 253