PHP

When multiple instances are created on a single server, it is very important to monitor their important parameters. The following are the load conditions for monitoring multiple instances on the server: redis instance QPS, memory usage, client

References: patrick-tang.blogspot.com201206redis-keepalived-failover-system.htmldeidara.blog.51cto.com400447302402my.oschina.n References: http://patrick-tang.blogspot.com/2012/06/redis-keepalived-failover-system.htmlhttp://deidara.blog.51cto.com/400

The current status is dg1, And the slave database is dg2. First, check the status of the master database: dg1SQLselectname, database_role, OPEN_MODE, SWITCHOVER_STATUSfromv $ database; DATABASE_ROLEOPEN_MODESWITCHO The current status is dg1, And the

The previous sections introduced the basic synchronization protocol of MySQL. MySQL 4.1 is an important turning point. In terms of the protocol package data format, CLIENT_PROTOCOL_41 should be set in the new version, the flag is serialized and

When I first walked into the door of the company in the morning and walked to my desk, my development colleagues worried and said, "You can come! Me: What happened? Developer: XX database is dead! Me: Very surprised! This library runs When I first

Table Structure (10 million rows record): mysqlshowcreatetablesbtest \ G; ***************************** 1. row ************************** Table: sbtestCreateTable: CREATETABLE's Table Structure (10 million rows record): mysqlshowcreatetablesbtest \

When the database needs to recover the media, in order to ensure that the database can smoothly perform the recovery process, restore the database to the current state. All we need to do is verify! What is verification? Of course, it is to verify

ORACLE Network Management 1. The configuration file describes the three network-related configuration files: listener. ora, tnsname. ora, and sqlnet. ora. the windows directory is in the ORACLE_HOMEdbhome_1NETWORKADMIN file. ORACLE Network

MySQL5.6 has been out for a year, and has an understanding of its new features. It is also basically stable. When the minor version is 5.6.20, you can consider upgrading the online database version. For more users to upgrade in the future, I have

Obtain a development SQL statement as follows: SELECTp. products_idFROMproductsASpJOINproducts_to_categoriesASpcUSING (products_id) JOINcategoriesAScUSING (categories_id) JOINproducts_r Obtain a development SQL statement as follows: SELECTp.

Implicit conversion causes index failure. this point should be paid attention. it is also a common mistake in development. because the table field tu_mdn is defined as varchar2 (20), this field is passed to m as the number type with the where

Install NRPE on HPUX, especially when there are some difficult points in monitoring the ORACLE database. When you try to sort it out, make a memo. 1. Download the pre-compiled depot source code package URL: www. mayoxi HPUX on the installation of

1. The relevant jar package mainly uses the core package of jedis, and the author uses version 2.1.0. In addition, related jar packages are also required for applications based on the "pool. Is a simple jedis test project created by the author: jar

Program error: Generally there are two possible causes for the System Buffer space insufficiency or the queue is full: a) the system memory is insufficient and the number of idle instances is lower than 200, the number of system handles is terrible,

This section describes the use cases of memcached in a production environment, mainly because memcached stores the query results of the relational database mysql, such as the download ranking of the website. This query increases every time it is

To test a DG problem, set up a test environment on Vmware and place primary and standby on the same host. We will not repeat the setup process, but at last we encountered some problems. Here we will record them for future reference. To test a DG

Recently, I have been clearing unnecessary jobs and found several MDW-related jobs. Although the Job has been Disable, it has not been deleted. The following error occurs when you try to delete TheDELETEstatementconflictedwiththeREFERENC. Recently,

Step 2 of the experiment: Then run selectcount (*) fromt04209_uname; selectsum (uvalue) fromt04209_uname; selectavg (uvalue) fromt04209_uname; selectmax (uvalue) on instance 1. Step 2 of the experiment: Then run selectcount (*) fromt04209_uname;

Progressive rehash in the previous section, we understand the rehash process of the dictionary. It should be noted that the rehash program is not executed immediately after activation, it is done multiple times and incrementally. Assume

REDIS_LIST (list) is the operation object of commands such as LPUSH and LRANGE. It uses the REDIS_ENCODING_ZIPLIST and REDIS_ENCODING_LINKEDLIST encoding methods: when encoding is selected to create a new list, Redis REDIS_LIST (list) is the