Index
A
Application Express (APEC)
Audit services
Automatic backup
Availability domains (AD)
B
Backup in DB Systems
automatic backup
final backup
full backups
incremental backups
manual backup
operator backups
Bare metal host
Bastion
gateway
key terminology
prerequisites
sessions
Bastion Service
create session
creation
MySQL Bastion
opc user
port forwarding session
public key
Sessions context menu
sessions list
Session TTL
subnets
Billing usage (OCI console)
Binary logs
Block storage device
Block volume, OCI
AD
Attached Block Volumes
attachment
compute instance
connecting/disconnecting
creation
detail page
device
fdisk/sudo
iSCSI commands
iSCSI information
list
main menu
mount point
OCID
operations
resources menu
set list scope
size
SSH connection
xfs file system
Boot volume, OCI
C
Classless Inter-Domain Routing (CIDR)
Cloud computing
characteristics/technologies
forms/models
Cloud computing hygiene
Cloud services
components
costs
data storage
forms/models
Cloud systems
Command-line interface (CLI)
for common MDS operations
oci mysql backup command
Command-line interface (CLI)
capabilities
for common MDS operations
availability-domain subcommand
DB System, creation
DB System details page
DB System Example Command
listing backups for a DB System
listing compartments
masked OCIDs
MySQL Shapes, listing
OCI console
optional parameters
start/stopping a DB System
subnets for a compartment, listing
DB System option
DevOps tools
documentation
installation
links to the documentation
macro-level interface
main commands
Python-based application
subcommands and parameters
Comma-separated value (CSV) file
Compartments
Compatibility between on-prem MySQL servers and MDS
MySQL version
security
Compute instance
add SSH keys
boot volume parameters
command
connection
create instance dialog
detail page
list
main menu
networking
PuTTY
set list scope
and SSH
SSH client
termination
work requests list
Compute resources
Connector/J
downloading
features
inserting data
installation
CLASSPATH
connection
demonstration
DriverManager class
error message
folder
getConnection() method
JDK
macOS
main() method
MySQLTest.java
platform independent option
URL
verification
MySQL
text editor
Connector/Python
downloading
features
inserting data
installation
pip command
prerequisites
verification
MySQL
Python scripts
Connectors
Conventional computing
Core services, OCI
compute services
networking services
storage services
block volumes
file storage
IAM
NVMe
object storage
uses
create_db_system() method
D, E
Database (DB) Systems
administrator credentials
backup plan
Bastion and Session setup
Bastion Service
Bastion Session
compute instance
connection
creation
ingress rule
MySQL
OPC user
public IP address
security lists
SSH key
subnets
uses
VCN
configure hardware
connection mechanisms
creation
details page
areas
information tab
map
status and buttons
tags tab
editing
information
issues
MySQL
MySQL Shell
network configuration
OpenVPN Access Server
packages
placement
private IP address
resource menu
backups
channels
endpoints
HeatWave
metrics
uses
work requests
Resource Page
response
results
SSH command
stopping/starting
URI
VPN connection
work requests
Database systems
Data definition language (DDL)
Data manipulation language (DML)
Data masking
Data migration process
Data migration to MDS
availability features
OCI
announcements page
communication with Oracle
documentation
troubleshooting page
Data objects
DB System backups
See alsoBackup in DB Systems
automatic and manual backups
backup details
block volume backup
block volume service
compute instance
delete a backup
edit backup feature
enable/disable automatic backups
manual backup, creation of
move a backup
parameters
restore operation
tags
DB System restore
DB System storage
delete_db_system () method
Deletion plan
Development operations (DevOps)
Documentation
Domain name service (DNS)
Dump utilities
F
Fault domains (FD)
Final backup
Full backups
G
get_db_system() method
GNU Public License (GPL)
Group replication
H
Hardware failures
HeatWave
High availability
engineering principles
inbound replication
levels
limitations for using HA DB Systems
MDS
failover
failover conditions
group replication
methods
primary
secondary
switchover
outbound replication
prerequisites with DB Systems
reliability
setting up HA on DB System
creation, DB System
disable HA
enabling HA
switchover
Human error
I
IAM policies
Identity and Access Management (IAM)
Incremental backups
Infrastructure as a service (IaaS)
Input/output operations per second (IOPS)
Integrated development environment (IDE)
Internet
Internet of Things (IoT)
Internet protocol (IP)
In-transit encryption
J, K
Java database connectivity (JDBC)
Java Development Kit (JDK)
Java Runtime Environment (JRE)
JavaScript methods
JavaScript object notation (JSON)
.json file
JSON format
JSON options link
JSON output format
L
list_db_systems() method
list_mysql_shapes.py
list_shapes() method
M
Manual backup
Master-detail relationship
MDS API
basic_api.py
creation, DB System
delete operation, DB System
getpass and OCI modules
MySQL shapes, listing
oci.config class
oci.mysql.ChannelsClient
oci.mysql.ChannelsClientCompositeOperations
oci.mysql.DbBackupsClient
oci.mysql.DbBackupsClientCompositeOperations
oci.mysql.DbSystemClient
oci.mysql.DbSystemClientCompositeOperations
oci.mysql.MysqlaasClient class
oci.mysql.MysqlaasClientCompositeOperations
oci.mysql.WorkRequestsClient
oci.mysql.WorkRequestsClientCompositeOperations
Python SDK, installation
stop/start, DB System
MDS automation mechanisms
MDS backups list
MDS high availability
MDS troubleshooting page
Migrating data from MDS
using Bastion gateway
exporting data using MySQL Shell
importing data on local MySQL Server
using compute instance
export data using MySQL Shell
importing data from directory
local MySQL server
using ObjectStore Bucket
creation, ObjectStore bucket
exporting data from MySQL Server
importing ObjectStore Bucket into a DB System
PC to MDS
Migrating data to MDS
using Bastion gateway
exporting data using MySQL Shell
importing data
and network layers
setting up
SSH command
using compute instance
directory exported data
importing data from directory
local MySQL server
using ObjectStore bucket
compute instance
creation, ObjectStore bucket
exporting data from MySQL Server
importing ObjectStore Bucket into a DB System
installation and testing, OCI CLI
OCI configuration file
pre-authenticated request (PAR)
MySQL
access
advantages
commands
community editions
configuration files
connectors
create users
downloading
macOS
Windows installer
ingress rule
installation
license
mechanisms
overview
responsibilities
sample database
security
servers
version
MySQL 5.7.9
MySQL 8.0.23
MySQL authentication
MySQL client
MySQL connection control
MySQL Database Service (MDS)
benefits
data security
DB System
database storage
networking
shapes
systems administration and planning
definition
Enterprise Edition
features
limitations
migrating data
migration
SeeData migration to MDS
MySQL HeatWave
MySQL menu
OCI
Audit Service
IAM
regional availability
requirements
resource page
resources
security
shape
Storage Engines
use cases
versions
mysql-data-bucket
MySQL data file storage
MySQL DB System
MySQL documentation
mysqldump
MySQL Enterprise Backup (MEB)
See alsoDB System backups
MySQL failures
MySQL Group Replication
MySQL metadata databases
MySQL password validation
mysqlpump
MySQL security
MySQL server
MySQL Shell
connections
individual options
SSL
URI
downloading
dump utilities
features
launching
modes
NoSQL
uses
N
Networking gap
Networking load balancer
Network interface card (NIC)
O
ObjectStore
exported data in a bucket
storage resource
.oci folder
oci-tutorial-mysql
On-prem server databases
Open Source Initiative (OSI)
Open source software
Operator backups
Oracle
Oracle Autonomous Databases
Oracle Cloud Identifier (OCID)
Oracle Cloud Infrastructure (OCI)
account
account information
agreement checkbox
always free resources
banner, MDS
email
limitation
login creation page
mailing address and phone number
message
payment information
prerequisites
start notice
tenancy name
tier account
upgrade
billing email
CLI main documentation
console
documentation
block volume
SeeBlock volume, OCI
capabilities/features
cloud console
compartments
child compartments
Cloud Console
compartment page
create component dialog
detail page
list
main menu
tags
components
core services
SeeCore services, OCI
group
Create Group dialog
details page
domains details page
domains resource page
information
list
mysql-users
MySQL
potential problem alert email
problem resolved email
regions
resource allocation
resources
security zone
service usage and limits
block volume service
landing page
tenancy’s limits
tenancy
termination
boot volume
cloud console
compute instance
costs
resources
terms and concepts
user guide
user interfaces
API
CLI
Cloud Console
Cloud Shell
REST
users
add to group
create user dialog
domain details page
email address
lists
mysqladmin
virtualization
web-based console
Oracle Corporation
Oracle FastConnect
Oracle’s automation layer
P, Q
Physical backups
Platform as a service (PaaS)
Pluggable Authentication Modules (PAM)
Point-in-time recovery (PITR)
Backup section
Edit Backup Plan dialog
list of backups
recovery of DB System
recovery window
Policies
compartment_name option
Create Policy dialog
data items
details page
OCI-tutorial-compartment
privileges
requirements, MDS
resource page
security policies
statements
substitute
Pre-authenticated request (PAR)
Primary keys
Programming language
Provisioning
PyCharm
Python API
Python OCI API
Python programming language
Python programming style
Python SDK
Python SDK API reference
R
Realms
Region
Regular backups
Relational database management system (RDBMS)
Reliability
RemoteSigned execution policy
Restore DB System
Restore to New DB System
S
sakila database
Security
ShapeSummary classes
Software as a Service (SaaS)
Software-defined networking (SDN)
Software development kits (SDK)
documentation and examples
MDS CLI, components
for OCI
.sql file
SQL statement execution
SSH key pair
stop_db_system.py
Structured Query Language (SQL)
commands
data
AVG() function
COUNT() function
creation
deletion
FROM clause
GROUP BY clause
ORDER BY clause
SELECT statements
sensors
updation
WHERE clause
databases/tables
indexes
joins
column name
database
foreign keys
JOIN clause
online reference manual
tables
uses
objects
rule
stored routines
triggers
views
Sun Microsystems
Surrogate key
T
Tags
Tenancy
Thonny
Transparent data encryption (TDE)
Transport Layer Security (TLS)
.tsv.zst files
U
Universal resource locator (URL)
util.dumpInstance() method
util.loadDump() method
UUID
V
Virtual cloud networks (VCNs)
cloud console
connection restrictions
detail page
internet connectivity
main menu
network list
provisioning
review/creation
security groups
set list scope
wizard
Virtualization
Virtual machines (VMs)
Virtual networks
Virtual private networking (VPN)
Virtual resources
W, X, Y, Z
Web Application Firewall (WAF)
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.