NAV: SLTechnology News&Howtos > Database >

• 

  Reids configuration Cluster

  Why do we already talk about the concept of master and slave before there is a cluster? one master can follow more than one master. If the number of visits at the same time is too large (1000W), the master service will definitely fail. Large companies will have a lot of servers (East China, South China, Central China,

  2022-06-01 08:50:17 Views: 274
• 

  MySQL innodb full-text indexing uses

  1. Mysql 5.7 full-text indexing the following parameters (configuration file / etc/my.cnf) # controls the minimum length of innodb full-text retrieval word segmentation. If set to 2, then a Chinese character and a letter will not be able to find ngram_token_size=1

  2022-06-01 08:50:17 Views: 200
• 

  How to return multiple rows of data from a PL/pgSQL function

  PgSQL has supported SRF (Set Returning Func. Collection return functions) are combined with some new function permission options to make schema settings more flexible. SRF in addition to the built-in function genera mentioned in the manual

  2022-06-01 08:50:17 Views: 286
• 

  Oracle script to create ASM instance

  Environment: Oracle 11g (11.1.0.6) Windows Server 2003 description: there is a difference between Oracle asm instances created before and after 11gR2. 11gR2 introduces Grid infrastru.

  2022-06-01 08:50:16 Views: 242
• 

  OGG Operation and maintenance Optimization script (12)-Information synchronization Class-Information upload

  File: upload.sh path: $HOME/ggscript/ggupload function: this script will not be used directly. It is designed to meet the requirements of other scripts for information upload. He will read the system information configuration file sy by directly calling upload the corresponding file information in the script.

  2022-06-01 08:50:16 Views: 258
• 

  The solution to the error of configuring SQl server 2008 ODBC under win 7 (port 1433 does not work)

  Configuring ODBC under win 7 installation SQl server2008 always prompts similar errors: the above figure indicates that there may be a problem with the port, and there are many online solutions. After our own testing and screening, the solutions are as follows: 1. We know that sqlserver2008 has passed

  2022-06-01 08:50:02 Views: 297
• 

  Php7 connects to mongodb to add data in batches

  1. Create the index.php file with the following code

  2022-06-01 08:49:51 Views: 274
• 

  A complete Collection of MYSQL statements

  The sections listed are Mssql statements and cannot be used in access. SQL Classification: DDL- data definition language (CREATE,ALTER,DROP,DECLARE) DML- data manipulation language (SELECT,DELETE,UPDA)

  2022-06-01 08:49:50 Views: 303
• 

  Zabbix3.0 installation

  This installation is going to install zabbix (LNMP) 3.0. the first step is to install zabbix's official zabbix source at the following address: http://repo.zabbix.com/zabbix/3.0/rhel/6/x86_64/

  2022-06-01 08:49:50 Views: 248
• 

  Lie SQL Server performance optimization (MSSQL high concurrency, performance regulation, practice)

  Lie SQL Server performance optimization (MSSQL high concurrency, performance control, practice) network disk address: https://pan.baidu.com/s/1KxdfcQD0XGD3M2ja_Y7UWQ extraction code: 435v spare address (Teng)

  2022-06-01 08:49:50 Views: 276
• 

  Mysql basic command

  End with the; sign or\ gshow databases; / / to show which database use test; / / use + database name, enter the database show tables; / / display the table show tables from in the database

  2022-06-01 08:49:50 Views: 284
• 

  Install the php redis extension in ubuntu

  Execute php-m first. If you don't see redis, you need to install the php redis extension to download the source code. Let's assume that there is a git folder in the home directory to manage the git file $cd ~ / git/$ git clone.

  2022-06-01 08:49:50 Views: 271
• 

  Mybatis if test is not empty to determine why the number 0 is false

  1. Remove the empty string to judge xxxxx2 and add 0 value to judge xxxxx

  2022-06-01 08:49:49 Views: 201
• 

  Back up the oracle database

  Database backups are roughly divided into two types. I am used to importing and exporting on the database server. Of course, you can also use sqlplus for database import and export, import must be in the directory of the dmp file. I have tried to use the full path of the file to import, but it is not successful. I guess it is because of the directory character.

  2022-06-01 08:49:49 Views: 224
• 

  How to use DGBroker to close redo applications (1)

  A LITTLE EFFORT EVERY DAY.YOU WILL MAKE A BIG DIFFERENCE. How to use DGBroker to close redo applications 1, describe Oracle 12crhel 7 2, real

  2022-06-01 08:49:49 Views: 217
• 

  Oracle Linux course by Ice Glass

  The first lesson of introduction to Linux: why learn Linux? This is the first question I asked when I contacted Linux. The answer I got at the time was that Linux was more secure than any other system. Well, for this reason, I began the journey of learning Linux. -

  2022-06-01 08:49:34 Views: 237
• 

  Sql server database error data recovery-database data recovery

  1. Server hardware listing 2. Fault description the server that needs data recovery is an R520 storage, a total of 7 SAS hard drives form raid1 and raid5 disk arrays respectively. The main sql server database is stored in C disk, in the process of use

  2022-06-01 08:49:22 Views: 292
• 

  PLSQL collection

  PLSQL collection index table (or associative array, associative array) nested table (nested table) variable length array (varray) two-dimensional array (multi-level set) index table-the syntax for creating an index table type is as follows: t

  2022-06-01 08:49:21 Views: 210
• 

  Bug of pt-online-schema-change

  Mysql5.6 and mysql5.7 have greatly enhanced the function of online DDL, but there is still a situation that the master library executes DDL and the slave library has a large delay, so the current production environment is still through pt-online-schema-change tools.

  2022-06-01 08:49:21 Views: 218
• 

  Zabbix proxy 3.0 RPM installation

  Preparation before installation: 1. Zabbix proxy itself needs to install mysql, which can be imported into the yum source of mysql5.6 on the official website of mysql, install and start the database 2, create zabbix_proxy database mysql > CREAT

  2022-06-01 08:49:21 Views: 243