NAV: SLTechnology News&Howtos > Database >

• 

  MySQL recovery: restore the database using slave backup, master binlog, trunk log from the library

  Xiaosheng blog: http://xsboke.blog.51cto.com-Thank you for your reference, if in doubt, welcome to exchange environment description: mysql master-slave replication, master library A downtime, slave library

  2022-06-01 08:38:31 Views: 244
• 

  On the handling of the limited number of calls to third-party services

  Friends who have come into contact with api services know that there is a limit to the number of api calls per day. So, if the actual business requirements need to frequently obtain the data returned by api, there are duplicate requests and non-duplicate requests. How to solve this problem? As shown in the picture: train of thought: first

  2022-06-01 08:38:31 Views: 288
• 

  Learning practice of Symantec NetBackup backup

  It is recorded that a company in Nanjing has been engaged in system integration for half a year, during which time I have learned all aspects of the knowledge system. Due to the recent needs of the company's project, the department leader gave me a small stove training to learn the principle and architecture of NBU. I also messed up for a few days later to have a deeper understanding of NBU.

  2022-06-01 08:38:30 Views: 268
• 

  The use and opening foundation of SQLCLR

  Summary SQLCLR I don't quite understand either. Not to mention that here I use VS TOOLS to develop a starter, and I need to know some of his configuration when using SQLCLR, and he has a lightweight pool advanced settings that are a little related, he doesn't support sqlclr, I

  2022-06-01 08:38:27 Views: 278
• 

  Mysql5.6.35 compilation and installation

  Before installing, make sure that the local mysql has been uninstalled: rpm-e mysql / / normal delete mode rpm-e-- nodeps mysql / / does not solve the dependency installation mysql: install the package needed to compile the code: yum

  2022-06-01 08:38:24 Views: 262
• 

  The use of Mycat-01. Concept, and installation

  First acquainted with Mycat1. Mycat what is Mycat is a database middleware, it is used for sub-database sub-table, but also achieve read-write separation, failover and other functions. 2. The working principle of Mycat is summarized as "intercept", which intercepts the S sent by the user.

  2022-06-01 08:38:20 Views: 262
• 

  Mongodb passive (passive) node configuration

  Modify a normal data node of a mongodb to a passive node, that is, it can synchronize data and vote, but cannot become a primary node. Except for the arbitration node, each node has a value that represents the priority priority, which we can set by setting the priority

  2022-06-01 08:38:20 Views: 224
• 

  MySQL master-slave handoff

  MySQL master-slave switching is based on traditional master-slave switching: when the master downtime occurs, method 1. All slave IO threads will be interrupted because of the master downtime. At this time, stop SLAVE IO_THREAD and wait for the SQL thread to complete the execution of events in relay log. 2. Select

  2022-06-01 08:37:59 Views: 285
• 

  Pt (Percona Toolkit) tool installation

  Pt (Percona Toolkit) tool installation. PT (Percona Toolkit) tool is a tool set written in Perl language developed by Percona, which contains many functions, such as changing the structure of the data table online and verifying the master-slave number.

  2022-06-01 08:37:58 Views: 216
• 

  Query parameters such as the number of file handles and connections opened by oracle

  Number of 1.oracle open file handles SQL > select count (*) from vastly opencursorterCOUNT (*)-connections of 15652.oracle SQL > select

  2022-06-01 08:37:58 Views: 256
• 

  Fix ORA-01578 and ORA-26040 errors of standby library caused by NOLOGGING operation of main library

  Fix bad blocks caused by standby ORA-01578 and ORA-26040 errors caused by main library NOLOGGING operations ORA-01578 and ORA-26040--NOLOGGING operations-error interpretation and solution: http://

  2022-06-01 08:37:52 Views: 296
• 

  CDB/PDB in-depth learning

  Change PDB size SQL > show pdbsCON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$SEED READ

  2022-06-01 08:37:52 Views: 233
• 

  Db2 sync master-slave configuration parameters

  Master-slave parameters: modify date:ntpdate asia.pool.ntp.org master-slave configuration communication port: db2h_erpinst1 70000/tcp master library configuration: db2 update db cfg for erpd

  2022-06-01 08:37:52 Views: 226
• 

  Oracle 11g R2 process

  User process ps-elf | grep oracleorcl | grep-v grep database process ps-elf | grep oracleorcl daemon Ps-elf | grep oha large pool: in SGA

  2022-06-01 08:37:33 Views: 297
• 

  Mysql3

  MHA (Master High Availability) is a relatively mature solution in the high availability of MySQL. When MHA monitors the failure of master nodes, it will upgrade the slave nodes with the latest data to the new mas.

  2022-06-01 08:37:33 Views: 234
• 

  Two methods of resetting password for single instance of MySQL

  Two methods of MySQL single instance password reset in work and study, we sometimes forget the database password. Here are the steps of MySQL single instance password reset. Description: (1) [root@mysql1 ~] # cat / etc/redhat-rele

  2022-06-01 08:37:18 Views: 203
• 

  A node in RAC cannot start the resolution step

  Problem phenomenon: a set of two-node RAC cluster, in which node 2 cluster cannot be started, ohas process has been started but CRS and CSS process has not been started 1. First, check the alert log in RAC and find that the following error has been reported in the log: file rotation

  2022-06-01 08:36:48 Views: 232
• 

  The 11th phase of the mongodb syllabus (already taught)

  1. The theoretical basis of NoSQL 1.1.What is the technology commonly used by NoSQL?1.1.1 NoSQL 1.1.2 the advantages and disadvantages of NoSQL 1.1.3 NewSQL and its common implementation 1.1.2 CA problems faced by distributed systems

  2022-06-01 08:36:48 Views: 272
• 

  How to create the best and safest online user for Oracle!

  How to create the best and safest online user for Oracle! Consider the knowledge point 1.undo tablespace setting 2. Business tablespace setting 3. Temporary tablespace setting 4. The choice of table space quota 5.profile, self-built or default 6. Password security 7. Permission restriction

  2022-06-01 08:36:48 Views: 247
• 

  Oracle automatic diagnosis Information Base (Automatic Diagnostic Repository,ADR)

  Introduction to ADR in ORACLE 11G: oracle log view of ADRCI in the 11g version of Oracle, the location of the alert file has changed, while Oracle provides a command line tool ADRCI, which can be very convenient

  2022-06-01 08:36:48 Views: 208