Tags: exception rationale schema query distribution href character request portChapter 1th IntroductionWith the widespread popularization of Internet application, the storage and access of massive data has become the bottleneck problem of system design. For a large-scale Internet application, billions of of PV per day is undoubtedly a very high load on the database. The stability and scalability of the system caused great problems. With data slicing to improve site performance, scaling out the d
1. OverviewWhen we consider the highly available architecture of the MySQL database, we mainly consider the following aspects:
If the database is down or an unexpected outage, and so on, can restore the availability of the database as soon as possible to reduce downtime, to ensure that the business will not be interrupted due to database failure.
Data for non-primary nodes that are used as backups, read replicas, and so on, should be in r
database: Can reduce the load of a single machine, while minimizing the loss caused by downtime;
Load balancing strategy: can reduce the access load of a single machine, reduce the possibility of downtime;
Cluster Solution: Solves the problem that the single point database can not be accessed by the database outage;
Read and write separation strategy: maximize the speed and concurrency of reading data in the application;
2nd Chapter
file does not require seek, even if the log contains incomplete commands for some reason (such as a write-in disk full, write-down, etc.), The Redis-check-aof tool can also easily fix this problem. Redis can automatically override AOF in the background when the AOF file volume becomes too large: The rewritten new AOF file contains the minimum set of commands required to restore the current dataset. The entire rewrite operation is absolutely secure, as Redis will continue to append commands to
Long time not to come here to write things, a bit of today, come here to write something recently encountered. Some time ago, a telecommunications business users due to a core production library several times the recent outage restart, multi-personnel involved in the fruitless, sent me an email, probably meaning that now the problem has caused more serious consequences, hoping to help intervene in the analysis, diagnosis and solve the problem. By the
Fsync each time you execute a write command. The default policy for AOF is Fsync once per second, in which Redis can still maintain good performance and, even if there is a failure, it will lose at most one second of data (Fsync will execute in a background thread, so the main thread can continue to work on the command request). The AOF file is an append-only log file (append only), so the write to the AOF file does not require seek, even if the log contains incomplete commands for some reason
First, look at the high-availability scenarios for common MySQL:Description of the pair:1) heartbeat through the serial line or Ethernet network cable directly connected to the end of the service to do health checks, and is responsible for the implementation of DRBD,MYSQL,VIP and other resources automatic switching.2) Data-1-2 as a data-1-1 high-usable hot sub, under normal circumstances data-1-1 provide a partition SDB1 for MySQL to use.3) physical disks are RAID10 or RAID0, and are selected ba
Label:Disclaimer: This text is reproduced (non-original), the article analysis is very thorough, has added the original link, if there are any infringement issues, please inform, I will immediately delete. Chapter 1th IntroductionWith the widespread popularization of Internet application, the storage and access of massive data has become the bottleneck problem of system design. For a large-scale Internet application, billions of of PV per day is undoubtedly a very high load on the database. The
First, EXT2 and EXT3The file system that was used by default in Linux before is Ext2,ext2 file system is really efficient and stable. However, with the application of Linux system in the key business, the weakness of Linux file system is gradually revealed: the Ext2 file system which the system uses by default is a non-log file system. This application in key industries is a deadly weakness. The Ext3 file system is developed directly from the Ext2 file system, and the current Ext3 file system is
. Often generated by the computer peripherals or some interface functions, such as keyboards, printers, serial ports, etc. this type of interrupt can be blocked or ignored by the software when the CPU is handling other emergency operations. For example, if the printer is interrupted, the CPU can respond faster or slower to the printer interrupt request, because it is perfectly reasonable to have the printer wait a little longer.Non-shielded interrupts. Caused by an unexpected event, such as powe
, service provider, service consumers are long connections between the three, except the monitoring centerThe registry will immediately push events to inform consumers of the presence of a long-connected-aware service provider, service provider downtimeThe Registry and Monitoring Center are all down, without impacting the already running providers and consumers, who cache the provider list locallyRegistries and monitoring centers are optional and service consumers can connect directly to service
, service provider, service consumers are long connections between the three, except the monitoring centerThe registry will immediately push events to inform consumers of the presence of a long-connected-aware service provider, service provider downtimeThe Registry and Monitoring Center are all down, without impacting the already running providers and consumers, who cache the provider list locallyRegistries and monitoring centers are optional and service consumers can connect directly to service
Apache's "maxclients" option is improperly configured because the system memory is only 2GB in size and the "maxclients" option is configured to 2000, and too many user access processes run out of system memory; Modify the "maxclients" option of the httpd.conf configuration file to reduce this value from 2000 to 1500; Continue to observe that the site is still frequent downtime, and then the "maxclients" option value to 1024, observe a period of time to find, Website service
, service provider, service consumers are long connections between the three, except the monitoring centerThe registry will immediately push events to inform consumers of the presence of a long-connected-aware service provider, service provider downtimeThe Registry and Monitoring Center are all down, without impacting the already running providers and consumers, who cache the provider list locallyRegistries and monitoring centers are optional and service consumers can connect directly to service
and standby two Namenode metadata information in real time (actually Editlog), a shared storage system can be provided, either NFS, QJM (Quorum Journal Manager) or Bookeeper, The active Namenode writes the data to the shared storage system, and standby listens to the system and, once new data is found to be written, reads the data and loads it into its own memory to ensure that its memory state remains basically consistent with the active Namenode, Standby can be quickly cut into active namenod
: 192.168.7.44 redis-cli-h 192.168.7.44-p 6379 shutdown #查看 Sentinel status Redis-cli -H 192.168.7.46-p 26379 info Sentinel #可以看到 The IP address of the Redis server master has become 192.168.7.142. #查看192.168.7.40 status, if configured properly, its main 142 # OK auto-switch has been implemented. # If it's not the main outage, but from the outage, then there will be no switching behavior, only the
First into the CMOS settings of the main interface, select [Power MANAGEMENT Setup], and then select [PWR Lost Resume State], this item has three options.
Select the [Keep off] entry, the computer does not start automatically when you call after a power outage.
SELECT [Turn on], the computer will start automatically when you call again after a power outage.
Selected [Last state], then on behalf of the po
Tags: query error ready to validate close binary mode out ErroToday, in a demo environment, our products experienced the entire engine room power outage, there is a MongoDB binary file corruption, the following is a breakdown of the analysis of the recording process: 1. In the customer support colleagues found that the entire engine room power outage and recovery, 3 MongoDB replication set, 1 hosts on the M
Chapter 1th IntroductionWith the widespread popularization of Internet application, the storage and access of massive data has become the bottleneck problem of system design. For a large-scale Internet application, billions of of PV per day is undoubtedly a very high load on the database. The stability and scalability of the system caused great problems. With data slicing to improve site performance, scaling out the data layer has become the preferred way for architects to develop.
Hori
no Fsync, Fsync per second, or fsync each time a write command is executed. The default policy for AOF is Fsync once per second, in which Redis can still maintain good performance and, even if there is a failure, it will lose at most one second of data (Fsync will execute in a background thread, so the main thread can continue to work on the command request). The AOF file is an append-only log file (append only), so the write to the AOF file does not require seek, even if the log contains incom
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.