NAV: SLTechnology News&Howtos > Database >

• 

  MariaDB 10.3 Master-Slave replication

  Basic Information Server 1: MariaDB01 192.168.10.178 Server 2: MariaDB02 192.168.10.179 operating system: CentOS 6.4 Database version: MariaDB-10.3.7

  2022-06-01 07:30:14 Views: 300
• 

  Redis stand-alone installation

  System: CentOS 6.8 64XRedis version: redis-3.2.5 download installation package # wget http://download.redis.io/releases/redis-3.2.5.tar.gz

  2022-06-01 07:30:12 Views: 282
• 

  Adg_redirect_dml

  Adg_redirect_dmlSQL*Plus for new features of Oracle 19c ADG: Release 19.0.0.0.0-Production on Thu Nov 28 11:35:05 2

  2022-06-01 07:30:08 Views: 292
• 

  Lists type and operation of redis

  Lists type and operation list is a linked list structure, the main functions are push, pop, getting all values in a range, and so on. Key is understood as the name of the linked list in the operation. The list type of Redis is actually a two-way where every child element is a string type.

  2022-06-01 07:30:08 Views: 246
• 

  Sysbench installation, use, drawing

  Background recently fascinated by performance testing, so learn a pressure artifact sysbenchsysbench is an open source project link on github address: https://github.com/akopytov/sysbench general installation method 1.c

  2022-06-01 07:30:05 Views: 260
• 

  MongoDB report instance-label membership Scheme

  A more complex, but flexible method for routing report queries to a dedicated node to use tags and read preferences. Because of the use of hidden members, set a member to priority: 0, but not set it to hidden. However, assign a tag use: reporting:

  2022-06-01 07:30:04 Views: 303
• 

  SQL SERVER sorts the search results

  1. Sort select column name by single column from table name order by column name; 2, sort by multi-column select column name 1, column name 2, column name 3 from table name order by column name 1, column name 2; Note: if column name 1 has multiple entries

  2022-06-01 07:30:04 Views: 225
• 

  The environment check before oracle11g client installation in XP system all failed.

  After running the oracle11g client program, the error message is as follows: / / available physical memory maoyej-7531: unable to perform physical memory check on node "LENOVO-F4F9938F"-Cause: unable to perform physical memory check on the indicated

  2022-06-01 07:30:04 Views: 265
• 

  PostgreSQL upgrade pg_upgrade upgrade

  For upgrades in PostgreSQL, if you upgrade from a small version, such as 9.6.1 to 9.6.2 (the current latest version), you only need to replace the 9.6.1 version with the 9.6.2 version, and no additional operation is required, because the whole major version is mutual.

  2022-06-01 07:29:57 Views: 230
• 

  Error resolution of oracle linux 4.8installation oracl 10g rac

  1. Error initializing asm automatic storage driver, unable to find module [root@rac10g01 Desktop] # / etc/init.d/oracleasm configureConfiguring the Oracle

  2022-06-01 07:29:57 Views: 204
• 

  Problems and Solutions in the process of mysql5.7 installation

  1. Problem description: the error reported when installing mysql5.7 during the initialization of database is as follows: solution: install Visual C++ 2013 library link: https://www.microsoft.com/zh-cn/do

  2022-06-01 07:29:57 Views: 281
• 

  Apache compilation and installation

  Download [root@localhost mysql] # cd / usr/local/src/ [root@localhost src] # wget http://syslab.comsenz.com/dow

  2022-06-01 07:29:56 Views: 217
• 

  MySQL sub-library backup script

  Vim / databind mysqlback.shallows! / bin/bashBAKPATH=/data/mysql-backMYUSER=rootMYPASS= "123456" SOCKET=/var/lib/

  2022-06-01 07:29:53 Views: 246
• 

  Brief introduction of commonly used character functions in MySQL

  Introduction to MySQL commonly used character functions < / H2 > CONCAT (S1Magazine S2Sn) concatenates S1Magazine S2SN as a string concat function that concatenates the passed parameters into

  2022-06-01 07:29:53 Views: 212
• 

  Using MongoDB module for SaltStack source code analysis

  MongoDB module / usr/lib/python2.6/site-packages/salt/modules/mongodb.pyMongoDB module will first check if PyMongo module is installed #-*-c

  2022-06-01 07:29:45 Views: 281
• 

  Recovery method of bad block damage of Oracle database file

  Data recovery failure description: open oracle database error "system01.dbf needs more recovery to maintain consistency, the database cannot be opened". The engineer inspected the database file and found that there were bad blocks in sysaux01.dbf. Sysaux01.dbf text

  2022-06-01 07:29:45 Views: 292
• 

  Change the JDK default code to solve the problem of DBeaver garbled

  Before, after adding Chinese character notes in DBeaver and selecting Save as, the annotated Chinese characters have garbled problems? Solution: add the JAVA_TOOL_OPTIONS option to the environment variable and add the parameter-Dfile.encoding=UTF-8

  2022-06-01 07:29:44 Views: 270
• 

  Three methods of renaming mysql Database

  When I went to the interview not long ago, I was asked how to change the database name of the table of the Innodb engine. At that time, I only answered how to change the MyISAM. I was defeated by some detailed questions. If it means MyISAM, then you can go directly to the database directory mv. Innodb is complete

  2022-06-01 07:29:44 Views: 267
• 

  Basic commands commonly used in database-- add, delete, change, check, sort

  Basic commands commonly used in databases: show databases; # View database use + database name; # enter database show tables; # view tables in the corresponding database select * from info; # View in

  2022-06-01 07:29:43 Views: 262
• 

  Easily master the way of database management-- the fifth part of operation and maintenance inspection (case-level parameters)

  In the preface, daily inspection is an important step in database management and maintenance, and it is necessary to register the date and result of each inspection, and a patrol report may be needed at the same time. The purpose of this series is to solve some common problems: do not know what to patrol, do not know how to facilitate the physical examination machine, there are too many physical examination troubles.

  2022-06-01 07:29:36 Views: 248