NAV: SLTechnology News&Howtos > Database >

• 

  OGG operation and maintenance optimization script (14)-Information synchronization class-definition files are automatically issued

  File: resend.sh path: $HOME/ggscript/ggdef function: this script is designed to deal with the abnormal interruption of the process caused by the invalidation of the definition file on the target side, because the source business often does not notify the target side and the system group modifies the table structure on its own.

  2022-06-01 09:05:09 Views: 243
• 

  Introduction to the basic knowledge of solr

  1.1 introduction to solr ApacheSolr is used as a search server to achieve good encapsulation and expansibility of in-site search. Multi-portal communities often use solr to build search engines. ApacheSolr is an open source search server, and Solr uses

  2022-06-01 09:05:08 Views: 242
• 

  Pg streaming replication HA version upgrade steps

  HA Description:Master:192.168.1.10Slave:192.168.1.20VIP: eth0:pgvip (master and slave) 192.168.1.30

  2022-06-01 09:05:08 Views: 234
• 

  Linux/Centos resets the Mysql root user password

  Sometimes you may forget the root user password of MySQL. Here's how to reset the MySQL root user password and change it manually. 1. Stop the MySQL service execution: / etc/init.d/mysql stop, it may not be / etc on your machine.

  2022-06-01 09:05:05 Views: 228
• 

  ORA-09817: Write to audit file failed error reporting solution

  When I opened the virtual machine to log in to the database in the morning, I suddenly reported an error: ORA-09817: Write to audit file failed write failed? The disk is not full, is it? Of course, no space left on device hints

  2022-06-01 09:04:46 Views: 229
• 

  Solve the problem of "standard in must be a tty" when getting client data from zabbix_get of zabbix

  (1) as shown in the title, I have a script on my zabbix client: [root@mpdb01 scripts] # vim / usr/local/zabbix/scripts/paycompletion12.sh its

  2022-06-01 09:04:43 Views: 253
• 

  Using udev to do ASM under Oracle Linux6.7

  1. Oracle Linux6.7 is required to use udev as asm/dev/sdb <-- > / dev/asm-diskb/dev/sdc <-- > / dev/asm-diskc/dev/sdd <-- >

  2022-06-01 09:04:34 Views: 233
• 

  A brief discussion on the High availability Architecture of MySQL Cluster

  Foreword High availability Architecture is basically standard for Internet services, and both application services and database services need to be highly available. For a system, it may contain many modules, such as front-end application, cache, database, search, message queue, etc., each module needs to be highly available in order to guarantee

  2022-06-01 09:04:34 Views: 300
• 

  3: add a slave to the existing replication environment (based on binary log file location)

  Server 192.168.1.2 (master), server 192.168.1.3 (old slave) server 192.168.1.4 (new slave) you can add another slave to an existing replication

  2022-06-01 09:04:19 Views: 257
• 

  Mysql generates test data

  1. Create databasecreate database test;2. Create Datasheet Field Type: id: number uname: user name ucreatetime: creation time age: age CREATE TAB

  2022-06-01 09:04:19 Views: 264
• 

  EntityFramework Core 1.1 detailed explanation of how to use Add, Attach, Update and Remove methods efficiently

  The theory of EntityFramework Core 1.1 method explains that when we use EF Core to query the database, if we do not explicitly turn off change tracking, the entity is tracked. We will talk about change tracking in the next section. Just like we did in EF 6.x.

  2022-06-01 09:04:12 Views: 240
• 

  Mysql incremental backup and breakpoint recovery

  Incremental backup means that after a full backup or the last incremental backup, each subsequent backup only needs to back up the files that have been added or modified compared with the previous one. This means that the object of the first incremental backup is the added and modified files generated after the full backup, and the object of the second incremental backup is the

  2022-06-01 09:03:42 Views: 262
• 

  Tcprstat, a tool for measuring service response time

  Tcprstat is an open source percona tool for testing the response time of mysql services, but it can be used for any response time running on the TCP protocol, as long as you specify the corresponding port. For more information, please refer to percona official document https:/.

  2022-06-01 09:03:42 Views: 262
• 

  Mysql test table

  Mysql > CREATE PROCEDURE pro_testdata (IN inr int)-> BEGIN- > DECLARE i INT DEFAULT 0scape-> START TRANSACT

  2022-06-01 09:03:41 Views: 279
• 

  Oracle on the treatment of "ORA-30036"

  The reason for the problem with ORA-30036:unable to extend segment by 8 in undo tablespace 'UNDOTBS1': when importing a table in bulk, imp reported the following error: Export f

  2022-06-01 09:03:41 Views: 298
• 

  Oracle 11g-Lock

  Oracle 11g-lock Target:1, understand the concept of lock 2, master the use of select for update 3, understand the meaning of different locks the concept of lock: 1. Lock is a mechanism used by database to control concurrent access to shared resources. 2. Locks are used to protect the

  2022-06-01 09:03:41 Views: 275
• 

  Oracle Study-- Oracle wait event (2)

  Oracle Study-- Oracle wait event (2) Control file parallel write when there are copies of multiple control files in the database, Oracle needs to ensure that information is written to each control file synchronously, which

  2022-06-01 09:03:35 Views: 204
• 

  The first example of hibernate-saving objects

  The first example of 3.hibernate-the jar package that needs to be imported to save objects using the hibernate framework: antlr-2.7.6backport-util-concurrentc3p0-0.9.1commons-col

  2022-06-01 09:03:35 Views: 258
• 

  Redis of NoSQL (introduction + cluster building)

  First, the introduction of NoSQL what is NoSQLNoSQL, called non-relational database, its full name Not only sql. It can not replace the relational database and can only be used as a good supplement to the relational database. Classification of NoSQL: number of storage of key-value pairs (Kmurv)

  2022-06-01 09:03:35 Views: 217
• 

  Redis monitoring script

  With the redis-cli tool, the shell script is written. According to the rules, you can monitor all data information written on info pages. Redis-cli usage: # redis-cli-h 127.0.0.1-p 6379-a pass

  2022-06-01 09:03:33 Views: 289