The most basic MMM installation must require at least 2 database servers and a monitoring server the MySQL cluster environment to be configured contains four database servers and a monitoring server, as follows:
function
IP
The original Oracle database server uses rman to back up the entire database, and then restores the same database on the remote server.
The original Oracle database server uses rman to back up the entire database, and then restores the same database
The original database server uses Rman for a full-library backup, and then restores the exact database on the offsite server1.1Original Server Backup DatabaseThe first step is to view the database instance name and DBIDConnected to target
Cloud Platform is a good thing, the typical configuration of mysql-mmm is to need five machines, one as MMM admin, two master, two slave. It's hard to find five machines at once, not to mention installing the same operating system. And with the
This section holds
Storage Engine Introduction (Learn)
Table additions and deletions to change
One, storage engine (Learn)The first few sections we know that MySQL built in the Library = = = folder, the table in the Library = = =
Build the MySQL MMM architecture from scratch and build the mysqlmmm Architecture
The cloud platform is a good thing. A typical configuration of MySQL-mmm requires five machines, one as the mmm admin, two masters, and two slave servers. It is really
Library additions and deletions to search
System Database
Create a database
Related operations of the database
Operation of the table
Introduction to the storage engine (a little bit too much)
SQLite Introduction
In the introduction of System. data. SQLite is a single-host database management system similar to Access. It defines all databases (including definitions, tables, indexes, and data) are saved in a single file. In addition,
When data is inserted in SQLite, a default statement is a transaction, and disk operations are performed on every piece of data.
If you need to execute SQL statements frequently, you can enable transactions explicitly to improve efficiency.
One, Operation folder (operation to the library): IncreaseCreate Database db1 charset UTF8;Check# View the database you are currently creating show CREATE Database db1;# view all databases show databases;ChangeALTER DATABASE DB1 CharSet GBK;By
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.