Deploying a MySQL Database Using EC2
1332
Most types of scale-out topology that you would use with your own hardware can be used and applied
within the EC2 environment. However, use the limitations and advice already given to ensure that any
potential failures do not lose you any data. Also, because the relative power of each EC2 instance is so
low, be prepared to alter your application to use sharding and add further EC2 instances to improve the
performance of your application.
For example, take the typical scale-out environment shown following, where a single master replicates
to one or more slaves (three in this example), with a web server running on each replication slave.
You can reproduce this structure completely within the EC2 environment, using an EC2 instance for the
master, and one instance for each of the web and MySQL slave servers.
Note
Within the EC2 environment, internal (private) IP addresses used by the EC2
instances are constant. Always use these internal addresses and names
when communicating between instances. Only use public IP addresses when
communicating with the outside world - for example, when publicizing your
application.
To ensure reliability of your database, add at least one replication slave dedicated to providing an
active backup and storage to the Amazon S3 facility. You can see an example of this in the following
topology.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...