NAV: SLTechnology News&Howtos > Database >

• 

  Installation and deployment of monitored zabbix + configuration of alerts

  Host environment redhat6.5 64-bit experimental environment server 1 ip172.25.25.1 hostname: server1.example.com server 2 ip172.25.25.2 hostname: server2.exam

  2022-06-01 08:26:05 Views: 303
• 

  Detailed explanation of compilation and installation of MySQL5.6 binary package (3)

  Software environment [root@localhost] # uname-r3.10.0-862.el7.x86_64 [root@localhost ~] # cat / etc/redhat-release C

  2022-06-01 08:25:35 Views: 242
• 

  MongoDB official document Learning (1)

  Concurrency MMAPv1MongoDB 3.0provides table-level locks. Multiple clients are allowed to modify documents of different tables at the same time. MongoDB 2.2-2.6 only allows simultaneous reads in the same library, but the same library does not support concurrent write operations. WiredTig

  2022-06-01 08:25:34 Views: 250
• 

  MySQL SQL optimized'%'

  The main purpose of designing an index is to help us get query results quickly, while like queries that start with% cannot use B-Tree indexes. Considering that the tables in innodb are clustered tables (similar to the index organization tables in oracle), and the structure of the records in the secondary index leaf node

  2022-06-01 08:25:28 Views: 240
• 

  Resolve mysql binary log recovery Datagram error: @ @ GLOBAL.GTID_MODE = OFF.

  Solve the problem that mysql uses binary logs to recover data reporting errors: ERROR 1781 (HY000) at line 16: @ @ SESSION.GTID_NEXT cannot be set to UUID:NUMBER

  2022-06-01 08:25:28 Views: 278
• 

  Two ways to realize Socket VS NIO in simple chat system

  It is said that a simple chat system is not a system at all, but a prototype at best. The focus of this paper is not on the design and implementation of the chat system, but to show the difference between NIO and Socket programming methods by achieving similar effects. It is said that it is the programming way of Socket and NIO, not quite.

  2022-06-01 08:25:28 Views: 212
• 

  Oracle GoldenGate Learning-- the Monitoring of GoldenGate

  Oracle GoldenGate Learning-GoldenGate Monitoring 1. Use the GGSCI command to monitor (1) enter the GoldenGate installation directory, run GGSCI, and then use info all to view the overall health GGS

  2022-06-01 08:25:27 Views: 203
• 

  Mongodb cluster building

  A total of 2 servers, each of the above a route, a configuration, a shard, mongodb version 3.4 server 1VR 10.2.4.214 server 2VR 10.2.4.2151. First, write the configuration files for the two servers, and build the path folder in the configuration file

  2022-06-01 08:25:27 Views: 265
• 

  Set the database to automatic memory management

  Setting database automatic memory management is mainly to set two parameters: memory_max_targetmemory_target, if these two parameters are set to 0, the database memory is managed manually, otherwise it is automatically managed. Shut down the database. SQL > star

  2022-06-01 08:25:27 Views: 207
• 

  Mysql database coding

  First, looking at the current database encoding show variables like'% character%';, you can see the default character_set_database encoding format. Here you can see that the default is latin1. Modify a

  2022-06-01 08:25:19 Views: 208
• 

  Oracle linux 4.8install cluster installation for oracle 10g rac environment

  Installation environment: operating system: oracle linux 4.864-bit cluster software: 10201_clusterware_linux_x86_64.cpio.gz database: 10201_database_linux_x8

  2022-06-01 08:25:11 Views: 290
• 

  How to solve mysqlERROR 1064

  The difference between backquotes and single quotes in Mysql is usually below the ESC key. It is a symbol introduced to distinguish between reserved words and ordinary characters in MYSQL. For example: SELECT select FROM test WHERE select=

  2022-06-01 08:25:08 Views: 290
• 

  12C you should know about DMON!

  The Oracle Data Guard monitor process (DMON) is an Oracle background process that runs on every data

  2022-06-01 08:25:05 Views: 212
• 

  Windows configure redis Sentinel

  Redis master-slave mode must have a single point of problem, so redis's sentinel mechanism is to make up for this problem. Next, let's configure redis sentinels in Windows environment. 1. Download Windows version of redis address: https://githu

  2022-06-01 08:24:53 Views: 257
• 

  Pomelo+mongodb configuration

  If you report a bunch of errors at this time of npm install pomelo installation, you can npm config set msvs_version 2012-- globalpomelo installation is very simple npm remove cr

  2022-06-01 08:24:52 Views: 240
• 

  ORA-03113: end-of-file on communication channel

  Failure phenomenon: ORALCE Startup Times error: ORA-03113: end-of-file on communication channelSQL > startupORACLE instance start

  2022-06-01 08:24:47 Views: 229
• 

  CentOS6.8 manually installs MySQL5.6

  CentOS6.8 manual installation of MySQL5.6yum install perl libaio as we all know, there are a lot of unfilled holes after the launch of mysql5.7, and there are also problems with the compatibility of old systems and projects, so now the common web project

  2022-06-01 08:24:47 Views: 228
• 

  Centos7 mariadb-galera-cluster-5.5+HAProxy+keepalived

  1 Server mysql00 192.168.20.104mysql01 192.168.20.102mysql02 192.168.20.103haproxy 192.168.20.105haproxy

  2022-06-01 08:24:47 Views: 214
• 

  1.sql data processing problem

  1. Find out the names of students whose scores are greater than 80 for each course: create table test2 (id int not null auto_increment,name varchar (10), kecheng v).

  2022-06-01 08:24:46 Views: 265
• 

  The Construction of JD.com Database Operation and maintenance Automation system

  Operation and maintenance automation comes from the pain point in the work. JD.com 's database team is faced with thousands of R & D engineers in the mall. This pressure drives us to change constantly, but the change is not achieved overnight. It has also experienced a difficult transition from manual to scripted, automated, platform and intelligent, so it is said that demand is driving.

  2022-06-01 08:24:43 Views: 253