NAV: SLTechnology News&Howtos > Database >

• 

  Solution 3 for dealing with Zabbixl historical database-expanding the capacity of Zabbix database using MySQL middleware

  An application scenario describes two solutions for dealing with Zabbix historical data, but it is not enough to solve the problem if the monitoring data continues to grow. Method 2 for dealing with Zabbix historical database-using MySQL table to partition Zabbix historical database

  2022-06-01 14:04:52 Views: 234
• 

  WebView.loadDataWithBaseURL method of Chinese garbled Code problem in webView loadData

  WebView.getSettings (). SetDefaultTextEncodingName ("UTF-8"); webView.loadData (mMerchandise.productDescr)

  2022-06-01 14:04:22 Views: 242
• 

  PLSQLDeveloper connects to Oracle bit database

    test environment description Oracle database server operating system: windowsserver2008x64Oracle database version: Oracle11.2.0.4x64PLSQLDeveloper version: PLSQLDevel

  2022-06-01 14:04:22 Views: 224
• 

  One order to take care of ADG

  Recently, we have been building ORACLE 12C ADG, including stand-alone to stand-alone ADG, RAC to RAC ADG, and RAC to stand-alone ADG. I have encountered a lot of minor problems, so make a note here. Oracle 12c R1 RAC modification startup

  2022-06-01 14:04:10 Views: 288
• 

  A preliminary understanding of 8--GTID Master-Slave replication of MariaDB

  1. Background introduction before MySQL5.6, master-slave replication is realized through binlog and position. When host A goes down, host B becomes the new master node, so you need to use SQL statement: CHANGE MASTER TO MAS on host C.

  2022-06-01 14:04:10 Views: 296
• 

  MongoDB on Azure: how to choose the correct instance type?

  MongoDB on Azure: how to choose the correct instance type? Original English text: http://blog.mongodirector.com/mongodb-on-azure-how-to-choose-the-rig

  2022-06-01 14:04:07 Views: 270
• 

  Add or to the cluster to remove the database

  Add db# su-oracle$ srvctl add database-d cfcdb-o / u01/app/oracle/product/11.2.0/db_1 $srvctl add i

  2022-06-01 14:04:06 Views: 216
• 

  CRS-0184: Cannot communicate with the CRS daemon

  Kill the unknown process by adding the process name to crs_stop-f, and then delete the / etc/oracle/scls_scr/rac1/oracle/cssfatal file on the machine in star1. If you don't delete this file, run

  2022-06-01 14:04:06 Views: 289
• 

  Installation and deployment of ZABBIX3.0 on CentOS6.6

  The Zabbix3.0 interface has taken on a new look, changing the old face of more than 10 years. The update of alpha4 is recorded as follows: http://www.zabbix.com/rn3.0.0alpha4.phpWhat's New in 3.0.0

  2022-06-01 14:03:56 Views: 230
• 

  Centos6.5 install MySql

  There are many ways to install MySql, such as the following figure: serial number MySql installation method shows that the installation of 1yum/rpm package is simple and fast, but it can not be customized. Beginners often use this method of binary installation and decompression software, which can be used after simple configuration without installation.

  2022-06-01 14:03:55 Views: 215
• 

  Ovi ovobj file, converted to shp file, then changed into sql file and imported into pgsql

  Change the KML file first. Then use the vector of QGIS to become a shp file. * * finally. Shp2pgsql-W utf8-s 4326 / home/manbug/ningbo/NB.shp ningbo_524

  2022-06-01 14:03:47 Views: 229
• 

  How to generate and use CRUD stored procedures in SQL Server

  Most database systems are based on the four simplest data operations, called CRUD. The acronym stands for create, read, update, and delete. When developing and managing a database, you can use CRUD stored procedures to perform all data-related tasks. This kind of stored procedure is good.

  2022-06-01 14:03:34 Views: 286
• 

  Rpm package management

  Linux package Management RPM = # ldd View dynamic link libraries called by binary programs

  2022-06-01 14:03:33 Views: 246
• 

  Redis Sentinel-- operation and maintenance management

  In the last blog, we introduced the installation and configuration of Redis Sentinel. For more information, please refer to the link: Redis Sentinel-- installation and configuration. Today, we mainly do a few simple tests that CaseRedis Sentinel APIping works.

  2022-06-01 14:03:33 Views: 225
• 

  Delete backup.sql from 30 days ago

  The company requires: now the company's business database backup at 00:00 every day to implement a full backup, and then go on like this, it will take up a lot of disk capacity, and then communicate with developers, and then decide to save the database backup on the server for 30 days (deleted 30 days ago)! #! / bin/bas

  2022-06-01 14:03:27 Views: 246
• 

  Query expression exercise

  Third query knowledge note: the following query based on the ecshop website goods table (ecs_goods) can only take part of the column during the exercise, easy to view .1: basic query where exercise: find out the goods that meet the following conditions: db.goo with the main key of 32

  2022-06-01 14:03:27 Views: 285
• 

  When Oracle_rac is installed on vmware, the udev disk has no scsi_id return value

  During this period of time, a set of oracle11g_rac was installed on the customer vmware, which is based on the redhat6.4 system. Before doing the redhat5 version, there were ready-made asmlib tools available, but there was no corresponding version of asml in Red Hat 6 at first.

  2022-06-01 14:03:26 Views: 292
• 

  Data import and export

  Data import / export settings data import / export using directory 1. Check to see if the default usage directory exists. Mysql > show variables like "secure_file_priv"; secure_file_priv

  2022-06-01 14:03:26 Views: 207
• 

  MySQL master master replication

  MySQL master replication is actually a two-way synchronization based on master-slave replication. Master-slave replication: operations on master will be synchronized to slave, operations on slave will not be synchronized to master; master replication: operations can be performed on two MySQL, and both can be synchronized to another

  2022-06-01 14:03:26 Views: 248
• 

  Theory-the difference between DELETE and TRUNCATE?

  There are mainly the following three: 1. The DELETE statement is a delete mark that does not really delete the data, so it can be recovered through the tool; the TRUNCATE statement is to empty the data row directly, so the ibd file of the DELETE statement cannot be restored through the tool, and the ibd file will not be reduced

  2022-06-01 14:03:25 Views: 277