automatic monitoring, continuous capture and backup data changes, the database for hot backup even if the server added a punctuation mark, "UPM database bodyguards" can also be real-time, accurate backup down. The first time the software is run, the UPM database bodyguard "will make a full backup of the main database, then the main database has any changes, the software will immediately back to the station, to ensure real-time data synchronization, to achieve real-time database backup effect, t
available disks without human intervention, thereby reducing the likelihood of hot spots appearing.
Stripe width: Segments in redo log files can be subdivided (K for faster transfer rates), and for data files, bands are slightly larger (MB, to one-time
Transfer a large number of data blocks).
Buffering: ASM file system does not buffer, direct input/output.
Mirroring: If hardware mirroring is not available, software mirroring can be easily established.
Core asynchronous I/O: implementation
replication, some are good at backup, while others have better performance in recovery and access control. Storage management software vendors tend to provide the most complete set of management packages. However, multi-platform support and optimal performance characteristics are not easy to achieve.
Several mirroring methods have been developed in the area of data replication. Many storage vendors provide a three-tier mirror structure, and VERITAS
large.Scenario: Small to restore on other servers Logical Backup features :Backup set is the structure and content information obtained from the database based on the query MySQL serviceBackup slower than physical backupThe data backup file is larger than the physical backup, because it is stored in a pure text, the data is not compressed, generally using gzip or tar compressionBackup and recovery granularity is more flexible, either at the service level (all databases) or some table in a libra
operations are faster under lock tables because MySQL does not empty the critical cache for locked tables until unlock table is called. Typically, the critical cache is emptied after each SQL statement.· If you are using a storage engine that does not support transactions in MySQL, you must use lock TABLES if you want to determine that there are no other threads between select and update. The example shown here requires lock TABLES for safe execution:· mysql> LOCK TABLES Trans READ, customer WR
cluster, node configuration is not the same, such as server model, CPU cores/frequency differences, etc., so more need to test to verify the robustness of the scheme.5) on-line maintenance is more complex and requires higher DBA requirements. Later, if you need to scale out horizontally, you have the same complexity and need the same human resources configuration.If the ASM solution is the natural advantage, I think that ASM does not need to synchronize the data through the San Network (third-p
Application and database development Cluster also need HA software? The so-called cluster technology (Cluster), also translated into clusters, covering three technical directions: Highly AvailableHA(High availability); Load BalancingLB(Load Balance); High Performance ComputingHPC(High performance Computing). For the business sectorITapplications are primarily concerned with high availabilityHAand load BalancingLBthese two parts. In order to ensure high availability of the application, the operat
considerations, because the query business module may need to involve some intermediate processing, if you need to process in the database (depending on the application requirements and design), so reader DB still needs to be writable. Let's talk about the problem of data synchronization technology selection: There are many techniques for real-time data synchronization, based on the OS layer (for example, VERITAS VVR), storage-based replication (whic
Hibernate. And Db4o's excellent performance, let us believe: more OO does not necessarily sacrifice performance. Figure 1. HSQLDB Benchmark Test At the same time, db4o is characterized by the need for DBA management, small footprint, which is ideal for embedded applications and Cache applications, so since Db4o was released, it has quickly attracted a large number of users to use db4o for a wide variety of embedded systems, including mobile software, medical devices, and real-time control syst
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.