| About the Authors |
|
xiii | |
| About the Technical Reviewer |
|
xv | |
| Acknowledgements |
|
xvii | |
| Introduction |
|
xix | |
|
Part I Cloud Computing Fundamentals |
|
|
1 | (22) |
|
Chapter 1 Introduction to Cloud Computing |
|
|
3 | (8) |
|
|
|
3 | (1) |
|
|
|
3 | (2) |
|
Benefits of Cloud Computing |
|
|
4 | (1) |
|
Challenges of Cloud Computing |
|
|
4 | (1) |
|
Cloud Computing Service Models |
|
|
5 | (1) |
|
Infrastructure as a Service (IaaS) |
|
|
6 | (1) |
|
Platform as a Service (PaaS) |
|
|
6 | (1) |
|
Software as a Service (SaaS) |
|
|
6 | (1) |
|
|
|
6 | (4) |
|
|
|
6 | (2) |
|
|
|
8 | (1) |
|
|
|
8 | (1) |
|
|
|
9 | (1) |
|
|
|
10 | (1) |
|
|
|
10 | (1) |
|
Chapter 2 Introduction to Database as a Service |
|
|
11 | (12) |
|
What Is Database as a Service? |
|
|
11 | (1) |
|
DBaaS Public Cloud Offerings |
|
|
12 | (7) |
|
Oracle Public Cloud Offering |
|
|
12 | (4) |
|
AWS Public Cloud Offering |
|
|
16 | (2) |
|
Microsoft Azure Public Cloud Offering |
|
|
18 | (1) |
|
|
|
19 | (1) |
|
DBaaS in Managed Services Model |
|
|
19 | (1) |
|
Getting Started with Database as a Service |
|
|
20 | (1) |
|
Selecting Your DBaaS Vendor |
|
|
20 | (1) |
|
Selecting the DBaaS Services |
|
|
20 | (1) |
|
Choosing the Right DBaaS Subscription |
|
|
20 | (1) |
|
Getting Acquainted with the Basic Terminology in Database as a Service |
|
|
21 | (1) |
|
|
|
21 | (1) |
|
Amazon Web Services Terminology |
|
|
21 | (1) |
|
Microsoft Azure Terminology |
|
|
22 | (1) |
|
|
|
22 | (1) |
|
Part II Database Administration in Cloud |
|
|
23 | (188) |
|
|
|
25 | (26) |
|
Database Provisioning Overview |
|
|
25 | (1) |
|
Database Provisioning in Oracle Cloud |
|
|
26 | (13) |
|
Creating Oracle Cloud Subscription |
|
|
26 | (3) |
|
Selecting Oracle Database Cloud Offering |
|
|
29 | (1) |
|
|
|
30 | (6) |
|
|
|
36 | (3) |
|
Database Provisioning in AWS |
|
|
39 | (11) |
|
Selecting the Proper Engine |
|
|
39 | (2) |
|
Specifying the DB Environment |
|
|
41 | (1) |
|
Specifying the DB Details |
|
|
41 | (3) |
|
Configuring the Advanced Settings |
|
|
44 | (3) |
|
Accessing Your AWS RDS Instance |
|
|
47 | (3) |
|
|
|
50 | (1) |
|
Chapter 4 High Availability Options |
|
|
51 | (20) |
|
Need for High Availability with Cloud-Based DBs |
|
|
51 | (1) |
|
Database High Availability Overview |
|
|
51 | (2) |
|
HA Options in Oracle Cloud |
|
|
53 | (1) |
|
Oracle RAC Provisioning in Oracle Cloud |
|
|
53 | (6) |
|
Connecting to Your RAC Database Servers Using PuTTY |
|
|
59 | (1) |
|
Connecting to Your RAC Database Using SQL Developer |
|
|
60 | (4) |
|
|
|
64 | (1) |
|
|
|
64 | (1) |
|
Overview of Oracle RAC Provisioning in AWS |
|
|
64 | (1) |
|
Overview of the Multi-AZ Deployment Option |
|
|
65 | (5) |
|
Multi-AZ Deployment Method |
|
|
66 | (3) |
|
Failover in Multi-AZ Deployment |
|
|
69 | (1) |
|
|
|
70 | (1) |
|
Chapter 5 Disaster Recovery Options |
|
|
71 | (16) |
|
Need for Disaster Recovery with Cloud-Based DBs |
|
|
71 | (1) |
|
Database Disaster Recovery (DR) Overview |
|
|
71 | (1) |
|
DR Options in Oracle Cloud |
|
|
72 | (1) |
|
Provisioning of DataGuard in Oracle Cloud |
|
|
73 | (2) |
|
DataGuard Administration in Oracle Cloud |
|
|
75 | (10) |
|
Checking the DG Configuration Details |
|
|
76 | (1) |
|
Performing DB Switchover Using the Console |
|
|
76 | (2) |
|
Performing DB Switchover Using dbaascli |
|
|
78 | (4) |
|
Performing DB Failover Using the Console |
|
|
82 | (1) |
|
Reinstating Failed Primary Database |
|
|
83 | (2) |
|
|
|
85 | (1) |
|
|
|
85 | (2) |
|
|
|
87 | (12) |
|
Need for Database Security with Cloud-Based DB |
|
|
87 | (1) |
|
|
|
87 | (1) |
|
Security Configurations in Oracle Cloud |
|
|
88 | (2) |
|
Transparent Data Encryption (TDE) |
|
|
89 | (1) |
|
|
|
90 | (1) |
|
Security Configurations in AWS |
|
|
90 | (8) |
|
Security at the Account Level |
|
|
91 | (2) |
|
Security for Oracle Running on Amazon RDS |
|
|
93 | (2) |
|
Security for Oracle Running on Amazon EC2 |
|
|
95 | (3) |
|
|
|
98 | (1) |
|
|
|
98 | (1) |
|
Chapter 7 DB Migration to the Cloud |
|
|
99 | (40) |
|
DB Migration Key Considerations |
|
|
99 | (2) |
|
|
|
101 | (1) |
|
|
|
102 | (1) |
|
|
|
102 | (1) |
|
|
|
102 | (1) |
|
|
|
103 | (1) |
|
|
|
103 | (4) |
|
|
|
103 | (2) |
|
Traditional Migration Methods |
|
|
105 | (1) |
|
Lesser Known Migration Methods |
|
|
106 | (1) |
|
Comparison of Migration Methods |
|
|
107 | (1) |
|
Detailed Migration Steps for Data Migration from the Local Database to Amazon RDS |
|
|
107 | (6) |
|
Detailed Migration Steps for Data Migration Using Oracle Data Pump Utility |
|
|
113 | (4) |
|
Sample Comparison Between SQL Developer and Data Pump Migration |
|
|
116 | (1) |
|
Migration Using RMAN Backup Restore |
|
|
117 | (1) |
|
Migration By Cloning a PDB into the Cloud |
|
|
118 | (14) |
|
Multitenant Setup On-Premise (Local) |
|
|
119 | (1) |
|
Create Oracle 12c PDB Database in Oracle Public Cloud |
|
|
120 | (1) |
|
Clone LocalPDB (Optional) |
|
|
120 | (2) |
|
Open the Cloned LocalPDB in READWRITE Mode (Optional) |
|
|
122 | (1) |
|
|
|
123 | (1) |
|
Convert LocalPDB into READONLY Mode |
|
|
123 | (1) |
|
|
|
124 | (1) |
|
Copy the XML and Data Files to the Cloud DB Server |
|
|
124 | (5) |
|
Using EM Express to Plug LocalPDB into the Cloud |
|
|
129 | (2) |
|
Open LocalPDB in the Cloud |
|
|
131 | (1) |
|
|
|
132 | (3) |
|
Migration Using AWS Snowball |
|
|
135 | (2) |
|
|
|
137 | (1) |
|
|
|
137 | (2) |
|
Chapter 8 Backup and Restore |
|
|
139 | (34) |
|
Overview of Database Backup and Restore from the Cloud Perspective |
|
|
139 | (1) |
|
Using the Cloud as a Backup Destination for an On-Premise Database |
|
|
140 | (1) |
|
Using Backup and Restore Options (Within the Cloud) for a Cloud Database |
|
|
141 | (1) |
|
DB Backup and Restore in Oracle Cloud |
|
|
141 | (14) |
|
Oracle Database Cloud Backup Service |
|
|
142 | (5) |
|
|
|
147 | (2) |
|
Oracle Database Backup Service |
|
|
149 | (6) |
|
Database Recovery in Oracle Cloud |
|
|
155 | (7) |
|
DB Backup and Restore in AWS |
|
|
162 | (10) |
|
On-Premise Backup to Amazon Cloud Using Amazon S3 |
|
|
162 | (5) |
|
DB Backup and Restore in Amazon RDS |
|
|
167 | (5) |
|
DB Backup and Restore in Amazon EC2 |
|
|
172 | (1) |
|
Backup and Restore Best Practices |
|
|
172 | (1) |
|
|
|
172 | (1) |
|
Chapter 9 Manage and Monitor |
|
|
173 | (38) |
|
Overview of Cloud DB Monitoring and Management |
|
|
173 | (1) |
|
DB Monitoring and Management in Oracle Cloud |
|
|
174 | (25) |
|
|
|
176 | (9) |
|
|
|
185 | (9) |
|
|
|
194 | (3) |
|
|
|
197 | (2) |
|
DB Monitoring and Management in AWS |
|
|
199 | (10) |
|
AWS RDS Monitoring Using OEM |
|
|
201 | (3) |
|
|
|
204 | (5) |
|
DB Monitoring and Management Best Practices |
|
|
209 | (1) |
|
|
|
209 | (2) |
| Epilogue |
|
211 | (2) |
| Index |
|
213 | |