NAV: SLTechnology News&Howtos > Database >

• 

  The whole process of redis4.0.11 installation available in production environment

  Redis4.0.11 is available for production environment to install the whole operating system version is centos6.5 first execute the initialization.sh optimization script for details see the initialization script we use redis- 4.0.11.tar.gz root online

  2022-06-01 15:51:59 Views: 267
• 

  OGG operation and maintenance optimization script (8) & # 160; query maintenance class-batch query

  File name: search.sh path: $HOME/ggscript/ggsearch function: this script is designed to meet the need to check the specific configuration of the goldengate process and is designed to call #! / bin/bashec through the edit script

  2022-06-01 15:51:59 Views: 209
• 

  Mysql to view the database currently in use

  1. View mysql > SELECT database () through the function database (); 2. Check mysql > status;3 through status. View via show tables

  2022-06-01 15:51:51 Views: 272
• 

  Install multiple instances and enable AlwaysOn availability group feature under SQL cluster

  SQL Cluster + install New instance + enable AlwaysOn availability Group function main content parallel installation different versions and instances of running SQL server enable AlwaysOn availability Group function Experimental Environment parallel installation of SQL Server 2012 + SQ

  2022-06-01 15:51:21 Views: 247
• 

  MySQL storage engine MyISAM and InnoDB configuration

  MySQL storage engine MyISAM and InnoDB configure MyISAM and InnoDB the biggest feature: MyISAM: ① does not support transactions. In the form of ② table-level locking, the data locks the entire table when updated. ③ does not support foreign key constraints

  2022-06-01 15:51:20 Views: 255
• 

  Differences between different versions of SQLPS

  The default instance of SQL Server 2014 is installed on the server, and the named instance of SQL Server 2017 SQL2017 $env:PSModulePath is% SystemRoot%\ system32\ Wind

  2022-06-01 15:51:15 Views: 259
• 

  Database built-in audit function

  As a dba, sometimes, we will always encounter a database, a table, a field exception, or data has been inexplicably deleted, at this time we all infer whether it is bug or hacked. At this time, an audit function is highlighted. Mariadb number

  2022-06-01 15:51:06 Views: 266
• 

  SQL Server remote backup error: Operating system error 1326

  SQL Server remote backup error: Operating system error 1326 problem description: execute the following command through SSMS under an account with remote UNC path write access: BACKUP DATABASE master

  2022-06-01 15:50:55 Views: 206
• 

  Mongodb pre-allocated data file

  Mongodb pre-allocates data files to avoid client timeouts #! / bin/bashfor I in {1.. 5} doecho $ihead-c 120000000 / dev/zero > test.$idon

  2022-06-01 15:50:49 Views: 289
• 

  Detailed tutorial on installing Oracle 11g based on RHEL 6.5 (9) & mdash;— Appendix

  9 Appendix 9.1 brief introduction to Linux LVM9.1.1 LVM LVM is short for Logical Volume Manager (logical Volume Management), which is implemented by Heinz Mauelshagen on the Linux 2.4 kernel

  2022-06-01 15:50:49 Views: 262
• 

  Mongodb replication set deployment

  Deploying a replication set consisting of three nodes provides sufficient redundancy for network failures or other system failures. The replication set also has sufficient ability for distributed read operations. The replica set should keep an odd number of nodes, which ensures that the election can be conducted normally using three existing mon

  2022-06-01 15:50:49 Views: 250
• 

  2 Redis startup mode, connect, shut down the service

  Redis startup mode F: default startup mode, which loads the redis.conf configuration file in the Redis installation folder R: the complete command is as follows: redis-server. / redis.conf the above startup mode is basically shown below

  2022-06-01 15:50:36 Views: 277
• 

  First acquaintance of optimizer in ORACLE database

  Oracle database is still the most widely used relational database (RDBMS). For the application of relational database, the optimizer is the core part, because it is responsible for parsing SQL, and then accessing the data stored in the database through SQL, that is, the optimizer is good or bad directly.

  2022-06-01 15:50:21 Views: 247
• 

  A case study of Database Design on the Road of DBA

  Here I quote the case of a teacher to explain to you, and I hope you will read the first two articles before reading this article, otherwise you will be a little confused: http://linuxclub.info/category/%E6%95%B0%E6%8D%AE%E5%BA

  2022-06-01 15:50:21 Views: 242
• 

  MySQL precompiled package installation configuration

  System environment: CentOS 7.6.Down firewall and other security mechanisms to check whether the system has a default installed database [root@mysqlmaster ~] # rpm-qa | grep mariadbmariadb-libs-5.5

  2022-06-01 15:50:20 Views: 221
• 

  OGG maintenance optimization script (22)-deployment preparation-script deployment preparation

  Sorry, the script deployment is ready to be put later. The following must be fully configured for all the scripts mentioned above to take effect successfully. The environment package is installed because the script is implemented through shell and perl. The system must support bshell to meet the running environment part of the AIX server due to lack

  2022-06-01 15:50:20 Views: 244
• 

  Install and configure MongoDB 3.0.x version database under Linux

  Description: operating system: CentOS 6.x 64-bit IP address: 192.168.1.111 purpose: install and configure MongoDB database specific operations: first, close SElinux, configure firewall 1, vi / etc/selinux/c

  2022-06-01 15:50:17 Views: 255
• 

  MySQL Database Promotion-stored procedures and functions

  Day06 MySQL database stored procedures and functions I. Overview of stored procedures and functions: database stored procedures and stored functions refer to a collection of sql statements defined in the database. These sq can be directly used by calling the names of these stored procedures or stored functions directly.

  2022-06-01 15:50:17 Views: 263
• 

  Java operation hbase api

  The jar package to be introduced (the jar here includes the jdbc connection of hbase,hive 's UDF,hive) java source package com.hbase.jdbc;import java.util.ArrayList

  2022-06-01 15:50:17 Views: 254
• 

  CentOS 7.4 install redis-4.0.10 cluster

  Introduction to redis cluster: after version 3.0, the design is decentralized. Different redis nodes can receive user requests and hold different data. Each node shares node innode information to facilitate finding data. Experimental preparation: test objective: 3 machines, 2 sections per machine

  2022-06-01 15:50:16 Views: 263