NAV: SLTechnology News&Howtos > Database >

• 

  ELK (ElasticSearch+Logstash+Kibana) + redis Log Collection and Analysis system

  Logs mainly include system logs, application logs and security logs. Through the log, the system operation and developers can know the software and hardware information of the server, check the errors in the configuration process and the causes of the errors. Regular analysis of logs can understand the load, performance and security of the server, so as to take timely measures to correct.

  2022-06-01 20:05:45 Views: 234
• 

  Exceptions to rhn-client-tools and oraclelinux-release-6:6Server-5.0.2.x86_64

  Exception occurred during package installation: [root@200-70] # yum groupinstall "Desktop" (abbreviated) Transaction Summary====

  2022-06-01 20:05:44 Views: 269
• 

  ORA-28056 error resolution

  Login to oracle encountered the following error while learning oracle ORA-28056 according to the prompt, orcle failed to write audit information in the system event log, and use eventvwr (enter in start-> run) to view an according to the prompt

  2022-06-01 20:05:39 Views: 238
• 

  Lazy people's Notes: mysql Basics 2

  Too lazy to type, QQ screenshot.

  2022-06-01 20:05:09 Views: 283
• 

  Treatment of Oracle cold backup and hot backup

  Abstract there are three standard modes of backup and recovery of Oracle, which are roughly divided into two categories: backup recovery (physical) and import and export (logical), while backup recovery can be divided into non-archived mode (Nonarchivelog-st) according to the working mode of the database.

  2022-06-01 20:05:06 Views: 293
• 

  Vsftpd's pam_mysql-based Virtual user Mechanism for data Transmission

  Vsftpd is based on the mysql service implementation: check to see if there is pam-mysql in the maradb, under the directory / lib64/security/. Compile and install pam-mysql step without: 1. # yum-y groupin

  2022-06-01 20:05:05 Views: 245
• 

  Ignore the parameters of the library in master-slave replication

  Replicate-ignore-db sets replicate-ignore-db on the slave server = test (set in my.conf) executes use testdelete fro on master as follows

  2022-06-01 20:05:05 Views: 271
• 

  Greenplum stand-alone installation

  Environment: server version: centos 6.5.Database version: greenplum-db-4.2.8.5-build-1-RHEL5-x86_64.zip1. Create users and groups gpadmingroupadd-g 303

  2022-06-01 20:05:05 Views: 269
• 

  Oracle12C of ProxmoxVE, multiple CDB and PDB

  On the left above is my personal Wechat. For further communication, please add Wechat. On the right is my official account "Openstack Private Cloud". If you are interested, please follow us. After the last oracle12C RAC environment was built on the PVE environment (please refer to the blog post "Proxmox"

  2022-06-01 20:04:32 Views: 286
• 

  Things and isolation levels in Mysql

  A transaction is an operation unit composed of a set of sql, which either succeeds or fails. ACID attribute atomicity (atomicity) A thing must be regarded as an indivisible minimum unit of work, and the whole transaction is either all successful or all failed rollback

  2022-06-01 20:04:31 Views: 286
• 

  Keepalived+Mysql of MySQL high availability (dual master hot backup)

  Environment description: OS:CentOS6.5_X64MySQL-VIP:192.168.1.200MySQL-master1:192.168.1.201MySQL-master2:192.168.1.2021,

  2022-06-01 20:04:17 Views: 244
• 

  ORACLE 12C modifies spfile path

  The modification method is as follows: create pfile='/tmp/init0924.ora' from spfile;shutdown immediate-both nodes need to stop startup nomout pfile

  2022-06-01 20:03:56 Views: 229
• 

  Backup and recovery of Linux-MySQL- database

  . > redirect < reverse redirect show databases; displays database backup: mysqldump-uroot-p password + database name > / data/ database name. Sql-path database recovery:

  2022-06-01 20:03:56 Views: 284
• 

  View the AUTOTRACE switch for the execution plan

  Turning on the autotrace switch in the sqlplus can also get the execution plan of the target sql, and in addition, you can also get the resource consumption of the target sql during execution, that is, we can observe the additional consumption of the target sql execution by setting the AUTOTRACE switch.

  2022-06-01 20:03:55 Views: 207
• 

  Oracle database character set

  The database I use is oracle11.2.0.4, and the database character set is al32utf8. The client is the same machine windows 7 uses the window7 client connection to view the windows client Chinese character virtual machine 192.168.

  2022-06-01 20:03:55 Views: 222
• 

  What you need to know for beginners of Oracle (startup, shutdown and configuration)

  First, the main file structure of Oracle-Drive:\ Oracle\-Admin directory: log files-Ora90 directory: program files-Oradata directory: database files II, database startup and shutdown. 1. Start at least two services: number

  2022-06-01 20:03:55 Views: 243
• 

  Redis data migration

  1. The requirement needs to transfer part of the keys from one redis instance to another redis instance 2. Migration scenario 2.1 Source instance and target instance are the same version 2.1.1 use the dump command #! / bin/bash#redis source ipsrc_i

  2022-06-01 20:03:54 Views: 240
• 

  Mysqlbinlog usage

  Version number: mysqlbinlog Ver 3.4 for linux-glibc2.5 at x8634 usage: mysqlbinlog-- option-- option-- option.. M

  2022-06-01 20:03:54 Views: 239
• 

  Steps of oracle database migration

  Background: as a DBA,oracle database migration is a common thing, just recently I am also migrating a business system, the database is oracle, by the way. Description: for ease of illustration, the old database is called An and the new database is B. The user and password are IRP

  2022-06-01 20:03:51 Views: 304
• 

  Performance Analysis and Optimization suggestions of redis

  First of all, it is not that redis does not have any performance problems if it is not used well, or there will be all kinds of conditions, such as frequent RDB, too many fragments and so on. Performance analysis info information: after redis-cli enters the login interface, enter info all, or red

  2022-06-01 20:03:48 Views: 302