NAV: SLTechnology News&Howtos > Database >

• 

  MySQL stand-alone multi-instance deployment

  1. MySQL multi-instance deployment version: 5.7.181. Software installation # tar xf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz-C / usr/local# cd / usr

  2022-06-01 13:32:50 Views: 207
• 

  Sysbench conducts stress tests on the database

  Sysbench is a stress testing tool that can be used to test the hardware performance of the system and can also be used to benchmark databases. Installation method: https://github.com/akopytov/sysbench/blob/master/

  2022-06-01 13:32:50 Views: 274
• 

  MySQL 5.7.15 compilation and installation

  To compile and install 1.MySQL, you need to use cmake and Boost C++ libraries, so you need to install cmake and compiler in advance before installation. [root@oel6 ~] # yum-y install gcc gcc-c+

  2022-06-01 13:32:30 Views: 210
• 

  Mongodb query and Index Optimization

  Index: query statement: db.products.find ({"details.manufacturer": "acme", "pricing.sale": {$lt: 7500}}) single key index: manufacturer (manuf)

  2022-06-01 13:32:30 Views: 219
• 

  Zabbix upgraded from 2.2.3 to the latest stable version 3.2.1

  At the end of 2013, I was lucky to enter the unit where I now work. At that time, the company used zennos monitoring system, due to the original zennos architecture design and its own functional limitations, can not meet the needs of the company's business. Responsible for zabbix monitoring system testing, including za, since 2014

  2022-06-01 13:32:23 Views: 229
• 

  Linux7.2 install ORACLE12C_RAC

  ASM disk space planning OCR+VOTING 8G three NORMAL redundancy MGMT 80g external redundancy 1, hardware inspection memory (minimum 8G) grep MemTotal / proc/meminfoswap space (4-16G e

  2022-06-01 13:32:23 Views: 260
• 

  Oracle self-study notes

  Oracle sentences learn SQL statements are case-insensitive, can be written on one or more lines, keywords cannot be abbreviated or divided, and use indentation to improve readability to change the password to oracle:alter user sys identified by orac

  2022-06-01 13:32:23 Views: 295
• 

  Mysql, MSSQL selection and comparison

  1. Background and questions Microsoft SQL Server is a commercial database, which requires a fee. The fee profile is as follows: the question is: is it worth buying and using Microsoft SQL Server licenses? Especially in the software industry where open source software prevails.

  2022-06-01 13:32:17 Views: 231
• 

  Real record of Hadoop+Hbase installation and configuration of Linux system

  Production environment: 3 machines: master (192.168.0.61), slave1 (192.168.0.62), slave2 (192.168.0.63) Note: hostname is set to master/slave1/

  2022-06-01 13:32:16 Views: 240
• 

  Modification and viewing of oracle implied parameters

  Oracle implicit parameter modification and view alter system set "_ allow_resetlogs_corruption" = false scope=spfile sid='*';col name fo

  2022-06-01 13:32:16 Views: 270
• 

  Principle of Redis-- master-slave replication

  The reason is the same as that of MySQL master-slave replication, although Redis reads and writes very fast, it also produces a situation of high read pressure. In order to share the reading pressure, Redis supports master-slave replication. The master-slave structure of Redis can adopt one-master-multi-slave or cascade structure, R

  2022-06-01 13:32:10 Views: 273
• 

  Mycat tutorial (1)-installation

  What is Mycat? In terms of definition and classification, it is an open source distributed database system and a Server that implements the MySQL protocol. Front-end users can think of it as a database agent, accessed by MySQL client tools and command line, and

  2022-06-01 13:32:09 Views: 260
• 

  Active MQ message Storage of JMS

  1. The way messages are stored ActiveMQ supports persistent messages and non-persistent messages in JMS specification persistent messages are usually used to ensure that messages will be consumed by consumers, regardless of whether consumers are online or not. When the message is confirmed to be consumed, the non-persistent message is deleted from the store, usually used for

  2022-06-01 13:31:54 Views: 284
• 

  M3DB cluster installation notes

  I will not introduce the simplest docker installation. Here I will talk about the problems I encountered when installing m3db stand-alone multi-instance cluster and the use of crawling process in order to match exporter + prometheus + grafana, promethe.

  2022-06-01 13:31:48 Views: 214
• 

  Three modes of binlog Log

  In statement level mode, each sql that modifies the data is recorded in the bin-log of the master. When Slave is copied, the sql process parses to the same sql that was executed on the original master side and executes again. Advantages: s

  2022-06-01 13:31:48 Views: 284
• 

  SQLServer parses JSON strings

  -parsing string function-

  2022-06-01 13:31:48 Views: 227
• 

  15 SQL Server replication skills in 15 minutes

  15 SQL Server copy tips 15 SQL Server replication tips in 15 minutes this list of tips and tips will help you enhance your replication skills. It is divided into three parts: sex

  2022-06-01 13:31:48 Views: 274
• 

  What's new in Oracle11g: reference partitions (reference partitioning)

  Reference partitions (reference partitioning) are a new feature of Oracle Database 11g Release 1 and above. It deals with parent / child peer partitions. That is to say, the child tables should be checked in some way

  2022-06-01 13:31:47 Views: 213
• 

  How to change the character set of a production MySQL database table

  In the past, when I was learning mysql, I saw the notes of the experiment today, so write down cheat 1 and export the table structure mysqldump-uroot-predhat12345-S / data/3306/mysql.sock.

  2022-06-01 13:31:47 Views: 202
• 

  Hot switching of database by inheriting AbstractRoutingDataSource in Spring+Mybatis project

  When doing an ERP project, there is a need to be able to manage and switch accounts, a set of accounts is a database, then you need to achieve the hot exchange of the database. Found a lot of information on the Internet and combined with the specific needs of the project to achieve a relatively easy to use database hot switch. The principle is to inherit Abst first.

  2022-06-01 13:31:47 Views: 232