NAV: SLTechnology News&Howtos > Database >

• 

  MySQL sub-library backup

  The company has always been full + binlog, but what to do if there is a problem with a single database? in the process of full recovery, first, it will delay time, second, it will affect other databases, and third, if the amount of data is large, it will also be a problem for the recovery of the database, so I have proposed that in addition to full database backup, we should only do sub-database backup.

  2022-06-01 15:27:42 Views: 273
• 

  Mongo performance test

  Mongodb introduction Mongodb introduces a major feature MongoDB provides a document-oriented storage that is relatively simple and easy to operate. You can set the index of any property in the MongoDB record (such as: FirstName= "Sameer

  2022-06-01 15:27:41 Views: 249
• 

  Oracle uses UTL_FILE to export table data to txt files

  Environment: Red Hat Enterprise Linux Server release 6.6Oracle Database 11g Enterprise Edition Release 11.2.0.

  2022-06-01 15:27:41 Views: 221
• 

  Overview of NoSQL and Memcached, Redis, MongoDB

  1. NoSQL introduces non-relational databases (while mysql, oracle and sqlserver are all relational databases). There is no relationship between the characteristic data, the storage of random expansion data is simple, it can be stored in memory, and the fast reading and writing speed does not need to build tables and fields. Custom format

  2022-06-01 15:27:35 Views: 263
• 

  Database Management of OracleDBA

  The following things are stored in my wheat bank to share with you the study notes of Oracle at that time. Please indicate the source when reproduced. The version of Oracle used below is 10g. When I use the operating system of WinServer 2003, there may be some commands and Orac.

  2022-06-01 15:27:35 Views: 275
• 

  Separation of read and write based on mysql-proxy of Relational Database

  Summary: as a mysql test project, mysql-proxy can achieve read-write separation architecture. Companies with development capabilities use secondary development to improve bug applications in the production environment. Here we use mysql-proxy to achieve read-write separation through a case study. Prepare for

  2022-06-01 15:27:31 Views: 230
• 

  Migrate from oracle database to mysql database

  Pay attention to mysql.jar package version conflicts if you use an application container. (for example, the weblogic container comes with mysql, but the version is relatively low. It is recommended to use the mysql.jar package under your own application) to_date-> > date_forma

  2022-06-01 15:27:31 Views: 226
• 

  The solution to the failure of login caused by the Oracle user password containing special characters

  My system/sys user's password contains an @ character. For example, if my password is 123cm 456, it will be understood as sqlplus system/123@456@webdata when logging in using sqlplus, so sqlplu

  2022-06-01 15:27:31 Views: 261
• 

  ORA-01017: invalid username/password; logon denied solution

  ORA-01017: invalid username/password; logon denied solution environment introduction: operating system RHEL6.4 X64, database: ORACLE 11.2.0.4.0; in the existing

  2022-06-01 15:27:22 Views: 247
• 

  Use Java.util.UUID to generate a unique ID (used as a database primary key)

  UUID (Universally Unique Identifier) globally unique identifiers are numbers generated on one machine that are guaranteed to be unique to all machines in the same space-time. Calculated according to the standards established by the Open Software Foundation (OSF)

  2022-06-01 15:27:21 Views: 298
• 

  Oracle database uses cursors to convert uppercase numbers to lowercase numbers

  The project meets requirements and needs to convert uppercase numbers to lowercase. The code is as follows: declaret_zl varchar2, t_ts varchar2, number;hh varchar2, xx

  2022-06-01 15:27:21 Views: 292
• 

  The method of finding the login password of WordPress

  Method 1: retrieve it via email if your host space supports sending email, so you can click "forget your password?" on the WordPress login page. Press the action to find it. Method 2: modify the database information and log in to phpMyadmin to access the corresponding database of the website.

  2022-06-01 15:27:18 Views: 216
• 

  Matters needing attention in the process of Procedure writing in Oracle

  Oracle needs to pay attention to things in establishing procedure: 1. When writing procedure, if the quantity specification refers to the bit attribute of other tables, such as em_card.card_tm%type, you should be careful to refer to it.

  2022-06-01 15:27:17 Views: 295
• 

  About the construction of the option function of checking and automatic synchronization for the selection of grid components

  Business requirements: select enterprise personnel in batch, fill them into the grid parts, and achieve the check effect of the personnel list, and automatically synchronize the selected personnel list items. First of all, we need to build a list of selected people and a selection list of enterprise personnel. The construction of this form is quite simple. We will not explain it in detail.

  2022-06-01 15:27:16 Views: 267
• 

  Mysql- master-slave-binlog- format, parameters (3)

  Log format ROW: based on [data row] mode, is to record all changed data: advantages: stability without bug disadvantages: log file large STATEMENT: based on [sql statement] mode, that is, to record all executed sql statements. Advantages: day

  2022-06-01 15:27:15 Views: 228
• 

  MySQL-MMM High availability

  About MMM MMM (Master-Master relication manager fro MySQL, MySQK Master replication Manager) is a set of procedures that support dual-master failover and dual-master day-to-day management. It is mainly used for monitoring

  2022-06-01 15:27:15 Views: 232
• 

  Backup ASM disk header

  The first 4K of the ASM disk head is mainly used to record disk information, which is very important. It is strongly recommended to make daily backups in the production environment. Backup method: 1. Dd if=/dev/oracleasm/disks/OCRVOTE of=/backup/asm

  2022-06-01 15:27:15 Views: 200
• 

  Convert Varchar type to numerical type in oracle

  If the values of string types are compared in oracle, incorrect comparison results may occur once the number of digits is different, such as 999 and 1000 ratios. Only numeric values can be compared correctly. Therefore, in order to prevent the occurrence of the above bug, it is recommended to use

  2022-06-01 15:27:15 Views: 267
• 

  Oracle Command Line activity

  1. With the environment variables configured, click the command # > sqlplus2. Enter user name / password to login oracle # > default we use first, user name: scott, password: tiger login 3.a. When you log in, you can just click sqlplus.

  2022-06-01 15:27:14 Views: 216
• 

  AIX RAC build error-Default Gateway is not configured

  AIX RAC build error-not configured Default Gateway environment: operating system: AIX 5300-09 Cluster Software: CRS 10.2.0.1 Database: Oracle 10.2.0.1 failure phenomenon: building AI

  2022-06-01 15:27:14 Views: 291