NAV: SLTechnology News&Howtos > Database >

• 

  A brief understanding of memcache

  one。 What is memcache?memcache is a distributed cache system, for some large, frequent access to the database of the website access speed is very significant, is a set of open source software. By maintaining a unified, huge has in memory

  2022-06-01 11:15:56 Views: 223
• 

  Pglogical2.0 logical backup

  Note: only versions above 9.5 are supported. 2. Refer to https://www.2ndquadrant.com/en/resources/pglogical/pglogical-installation-ins for compilation and installation.

  2022-06-01 11:15:55 Views: 227
• 

  Flashback form from Recycle Bin

  Check whether the Recycle Bin is enabled. The default is SQL > show parameter recyNAME TYPE VALUEbuffer_pool_recycle stringdb_recycle_cache_s.

  2022-06-01 11:15:52 Views: 237
• 

  Fixed the problem that the php toolkit (phpStudy) Apache started successfully and MySql could not start.

  What is very troublesome is that Apache starts normally, but MySql cannot start, and what is said on Baidu is not very useful (the predecessor of the final solution is still Baidu). Most of them are talking about port problems on Baidu. Apache is 80Jing MySQL is 3306, but

  2022-06-01 11:15:35 Views: 210
• 

  Sql_server basic learning

  SQL DML and DDL can divide SQL into two parts: data manipulation language (DML) and data definition language (DDL). SQL (structured query language) is the syntax used to execute queries. But the SQL language also contains information for updating, inserting, and

  2022-06-01 11:15:17 Views: 224
• 

  Detailed implementation of backup and restore of MySQL and mariadb databases based on logical Volume LVM

  The premise is that the database data is placed on the logical volume; the database data and logs are stored separately; normally, the data and logs are placed on two separate disks, and if it is raid, then it doesn't matter. Create a partition: [root@mysql ~] $f

  2022-06-01 11:15:11 Views: 269
• 

  Analysis of double write consistency Scheme for distributed Database and Cache

  Let's make it clear that, in theory, setting an expiration time for the cache is the solution to ensure ultimate consistency. Under this scheme, we can set the expiration time for the data stored in the cache. All write operations are based on the database, and we just try our best to cache the data. That is, if the database

  2022-06-01 11:15:11 Views: 244
• 

  The use of Mycat-04. Transaction support

  03 Global sequence number section introduces the sharding table in detail. When using sharding tables, businesses may naturally encounter data operated in a transaction distributed on multiple shard nodes, that is, distributed transactions. First, let's intuitively feel the process of dealing with transactions in Mycat. Log in to the dnTes of the tb3 table

  2022-06-01 11:15:09 Views: 219
• 

  Linux operation and maintenance MySQL must meet with 100 questions.

  1. Open the MySQL service 2. Check whether the port is running 3. Set or change the password for MySQL. 4. Log in to the MySQL database. 5. View the character set of the current database 6. View the current database version 7. View the currently logged in user. 8. To create the GBK character set

  2022-06-01 11:15:09 Views: 272
• 

  Do dg preparation and execute duplicate target database for standby nofilenamecheck report to RMAN-06023

  The RMAN duplicate for standby failure resolution process is always unsuccessful when generating a standby library with rman duplicate to standby. Many attempts are due to the following error: RMAN > duplicate

  2022-06-01 11:15:09 Views: 278
• 

  Query instructions commonly used in Linux (which, whereis, find, locatae)

  We often look for a file in linux, but we don't know where we put it. We can search it with the following commands: Which to see the location of the executable file. Whereis views the location of the file. Locate works with the database to view the file location. Find

  2022-06-01 11:14:49 Views: 311
• 

  Non-recursive traversal algorithm of middle order, first order and post-order traversal of binary tree (using stack, implemented by loop)

  Typedef struct TreeNode * BinTree;typedef BinTree Position; struct TreeNode {ElementType Data

  2022-06-01 11:14:43 Views: 296
• 

  Java manipulates MongoDB_2 (applies scene settings)

  The application scenario setting takes the student information management system as an example to demonstrate the addition, deletion, modification and query of student information. Here, the student's Bean class is defined as: Student.javapublic class Student {private String studen

  2022-06-01 11:14:43 Views: 290
• 

  Oracle 11g-R2 installation

  F Annex: http://down.51cto.com/data/2367194

  2022-06-01 11:14:42 Views: 228
• 

  Redis Learning 5Murray-single Node, Master-Slave, Sentinel and Cluster comparison

  Single node mode: does not have automatic fault tolerance and recovery capabilities. The server went down unexpectedly and redis was unable to provide service. The server disk is damaged and data is lost. It is used for applications that can penetrate business scenarios, such as DB storage at the backend and little impact when offline. Master-slave mode: no automatic fault tolerance and automatic recovery

  2022-06-01 11:14:39 Views: 230
• 

  Determination of the timeline to which the recovery is initiated by PostgreSQL

  1. When starting the recovery, determine the timeline to which the recovery is recoveryTargetTLI1) the archive recovery point is larger than the timeline recorded in checkpoint, then select the archive recovery point as the target timeline 2) otherwise, the timeline in the checkpoint record

  2022-06-01 11:14:39 Views: 253
• 

  Redis main memory database

  Introduction to Redis main memory database: Redis is completely open source and free, complies with the BSD protocol, and is a high-performance key-value database. Characteristics of Redis:-> based on memory-> persistence: RDB, AOF- >

  2022-06-01 11:14:39 Views: 212
• 

  Parameters that MySQL5.7 should pay attention to

  Introduction: this article mainly introduces the parameters that should be paid attention to in MySQL initialization, and these parameters should also be paid attention to for instance migration between different environments. Note: the parameters described in this article are all in the [mysqld] section of the configuration file. Server_id and log_b

  2022-06-01 11:14:38 Views: 254
• 

  DNS services forward and reverse resolution zone, master / slave zone database replication, subdomain authorization and basic security control

  DNS is an application layer protocol, which uses port 53 of UDP by default and port 53 of TCP by default. DNS name resolution method: name-> IP: forward parsing the first paragraph is called a recursive query, and the answer is returned to it after only one request is sent; the second paragraph is iterated in this way

  2022-06-01 11:14:35 Views: 294
• 

  A new feature of MySQL5.7-- online contraction of undo tablespace

  1. Undo log in the MySQL5.5 era in MySQL5.5 and before, you will find that as the database goes online longer and longer, the ibdata1 file (that is, the shared tablespace of InnoDB, or system tablespace) will become larger and larger, resulting in two

  2022-06-01 11:14:22 Views: 275