NAV: SLTechnology News&Howtos > Database >

• 

  Redis-AOF

  AOF is log-based, similar to Oracle's redo,Mysql binlog log. Aof configuration appendonly no # whether to turn on the aof log function appendfsync always # per life

  2022-06-01 13:51:28 Views: 293
• 

  Introduction of Mysql Master-Slave replication and Tomcat

  The problems often encountered in the database: 1. Upward expansion of scale up (individual hardware expansion) disadvantages: easy to reach the limit 2. Expand scale out (number of computers, grouped into clusters) Moore's Law: the technology of chips doubles every 18 months, and the price increases.

  2022-06-01 13:51:12 Views: 207
• 

  Install Oracle from the Linux command

  Before installing Oracle under the Linux command, the script is used to install it directly, so it is easy to have problems and do not know how to make mistakes, so try to install it step by step manually under linux. Some internal principles are not well understood, and it is best to install graphics several times more.

  2022-06-01 13:51:12 Views: 217
• 

  New course launch: Oracle Database 11gR2 (V): performance tuning

  Buy the Oracle database course package and enjoy a 15% discount! Oracle Database 11g (first quarter): development and advanced management of http://edu.51cto.com/pack/view/id-1040.htmlOracle data

  2022-06-01 13:51:11 Views: 269
• 

  The Learning Road of Mysql DBA Advanced Operation and maintenance-the problem of garbled Code in mysql Database

  1. The method of inserting non-garbled data into mysql database 1.1 to create test data (1) create a linzhongniao test database and view the table statement mysql > create database linzhongniao;Que

  2022-06-01 13:51:02 Views: 212
• 

  After oracle10g logs in to em, it prompts "java.lang.Exception: Exception in sending Request:: null"

  After oracle10g logs in to em, it prompts the interface that appears when logging in to Enterprise Manager when "java.lang.Exception: Exception in sending Request:: null" has an error.

  2022-06-01 13:50:44 Views: 249
• 

  Oracle numerical function

  Sort out the commonly used oracle numeric-related functions: divisor (rounded): round () for example, two decimal places after the decimal point: select round (3.2233) from dual returns the result 3.22. Find the average value

  2022-06-01 13:50:43 Views: 260
• 

  After installing oracle, the CentOS machine cannot log in from the command line interface.

  In the early days of National Day, Oracle 11 was installed on CentOS 6.5. everything was normal at that time. I took a day off before the festival and called me to say that the system could not log in from the command line. Enter the user name and password, then jump to the login interface and had no choice but to push.

  2022-06-01 13:50:40 Views: 224
• 

  12c DataGuard Broker configuration steps

  First, describe Oracle 12cRHEL 7.3.2.Configuring DataGuard Broker1. Source sqlplus / as sysdbaalter system set dg_broker_config_f

  2022-06-01 13:50:40 Views: 233
• 

  Detailed solution of Redis database and parameter tuning of centos 7 (built in

  Blog catalogue: first, the difference between relational database and non-relational database. Second, the introduction of Redis database. Third, installation and deployment of Redis. Fourth, Redis command tools and common commands. Fifth, Redis cluster configuration example. I. the difference between relational database and non-relational database

  2022-06-01 13:50:34 Views: 223
• 

  Oracle11g rac modifies host IP address

  1 background in response to the requirements of xx head office, the existing DMZ network of xx branch is modified. All IP addresses in this network segment need to be changed to new IP addresses, involving database oracle 11g rac. The following is a detailed test environment operation procedure for reference! Operating system: sles01:/u0

  2022-06-01 13:50:33 Views: 246
• 

  Upgrade Zabbix2.4 to 3.0

  Software upgrade before and after Php5.3.35.6.6 (requirements > 5.4) Apache2.2.152.2.15 (unchanged) Mysql5.1.735.1.73 (unchanged) CentOSCentOS 6.3 x86_64Cent

  2022-06-01 13:50:28 Views: 286
• 

  Oracle time synchronization

  Time synchronization between nodes is very important for Oracle. Before 11g version, time synchronization is often completed by setting up a NTP server. A new CTSS (Cluster Time Synchronizat) has been added to Oracle 11g

  2022-06-01 13:50:27 Views: 246
• 

  Characteristics and differences of Truncate/Delete/Drop table

  Before the understanding of Truncate/Delete/Drop is not very clear, so specially flipped through the MySQL5.7 Reference Manual, ready to systematically understand, here are some translations, plus a little bit of their own understanding. Tru

  2022-06-01 13:50:22 Views: 219
• 

  Mysql queries database proofreading rules through the command line

  Mysql through the command line query database proofreading rule 1. Grammar: SHOW COLLATION;2. Syntax parsing: SHOW COLLATION: view database proofreading rules; 3. Example: # View database proofreading rules SHOW COLLATIO

  2022-06-01 13:50:22 Views: 234
• 

  The Construction of oracle Virtual Environment

  In many books on database management of oracle, it is often talked about putting different types of files on different disks. In the process of individual self-study, it is not possible to achieve multiple disks. The following is how to construct a simulated environment by creating a directory on disk. Directory Backup

  2022-06-01 13:50:16 Views: 204
• 

  Sql optimization consideration point

  LEFT JOIN and IN and EXIST

  2022-06-01 13:49:46 Views: 284
• 

  Oracle stored procedure

  Stored procedure 1. Create create procedure procedure name (variable name in variable type... Variable name out variable type.) is// defines variables Note: statements executed by begin// do not need to be specified after the variable type end example: item

  2022-06-01 13:49:46 Views: 293
• 

  Oracle 12c installation manual

  Configure dns because oracle does not allow root users to install, so add 3 groups and add oracle to the group groupadd-g 54321 oinstallgroupadd-g 54322 dbag

  2022-06-01 13:49:46 Views: 300
• 

  Postgresql uses pg_rman backup to restore

  Os:centos 7.5postgresql: 10.01. Software download: https://github.com/ossc-db/pg_rman/releases/pg_rman-1.3.7-1.pg10

  2022-06-01 13:49:46 Views: 283