In Part 1 of this blog series I shared how to create a Pure Storage FlashBlade S3 compliant Object Storage account, user and bucket. I also demonstrated how to download the MySQL airportdb database, and upload objects into the Object Store S3 bucket.
In Part 2, I showed how we can use the MySQL Shell to install the aiportdb database dump into a MySQL 8 database using the S3 Object Storage bucket.
In this blog post I will show how we can also use the MySQL Shell to dump a MySQL 8 database to an S3 Compatible Object Storage bucket.
Create Bucket
Let’s start by creating a new Bucket in our previously configured S3 Compatible Object Storage.
Use the s3cmd ls command or aws s3api list-buckets command to confirm Object Storage access and that the bucket name does not already exist, for example.
$ ENDPOINT=http://192.168.4.180
$ PROFILE=fbstaines03
$ aws s3api list-buckets --query "Buckets[].Name" --endpoint-url ${ENDPOINT} --profile ${PROFILE}
--------------------
| ListBuckets |
+------------------+
| airport-bucket |
+------------------+
$ s3cmd ls
2023-07-05 13:17 s3://airport-bucket
We can use the aws s3api create-bucket command to create a new bucket for example.
$ ENDPOINT=http://192.168.4.180
$ PROFILE=fbstaines03
$ BUCKET=airport-dump
$ aws s3api create-bucket --bucket ${BUCKET} --endpoint-url ${ENDPOINT} --profile ${PROFILE}
$ aws s3api list-buckets --query "Buckets[].Name" --endpoint-url ${ENDPOINT} --profile ${PROFILE}
--------------------
| ListBuckets |
+------------------+
| airport-bucket |
| airport-dump |
+------------------+
MySQL Shell
The MySQL Shell supports dumping a MySQL 8 database to Oracle Cloud Infrastructure (OCI) Object Storage, Azure Blob Storage, AWS S3 Object Storage and other S3 compatible Object Storage solutions, such as Pure Storage FlashBlade Object Storage.
S3 Compatible Services
The MySQL Shell provides the following parameters for s3 compatible services:
| Argument | Description |
|---|---|
| s3BucketName: “string“ | The name of the S3 bucket where the dump files are located. By default, the default profile in the Amazon Web Services (AWS) CLI config and credentials files located at ~/.aws/ are used to establish a connection to the S3 bucket. |
| s3CredentialsFile: “string“ | A credentials file that contains the user’s credentials to use for the connection, instead of the one in the default location, ~/.aws/credentials. Typically, the credentials file contains the aws_access_key_id and aws_secret_access_key to use for the connection. |
| s3ConfigFile: “string” | An AWS CLI configuration file that contains the profile to use for the connection, instead of the one in the default location ~/.aws/config. Typically, the config file contains the region and output type to use for the connection. |
| s3Profile: “string“ | The profile name of the s3 CLI profile to use for the connection, instead of the default profile in the AWS CLI configuration file used for the connection. |
| s3Region: “string” | The name of the region to use for the connection. |
| s3EndpointOverride: “string“ | The URL of the endpoint to use instead of the default. |
Consult the documentation for full details of MySQL Dump Loading Utility
Dumping MySQL Data
The MySQL Dump Loading Utility provides the ability to dump data at the Instance, Schemas and Table level using the following:
util.dumpInstance(outputUrl[, options])
util.dumpSchemas(schemas, outputUrl[, options])
util.dumpTables(schema, tables, outputUrl[, options])Let’s start at the Instance level.
Dump Instance
Using the same details we used the aws s3api command we can dump the MySQL database to the FlashBlase airport-dump S3 bucket with util.dumpInstance, using the syntax below:
util.dumpInstance("airport-db",{s3bucketName: "airport-dump", s3EndpointOverride: "http://192.168.4.180", s3Profile: "fbstaines03", threads: 4, compatibility: ["strip_restricted_grants", "strip_definers", "ignore_missing_pks"]})In the above we can see the first argument provided, airport-db, this is the name of a folder which will be created within the s3BucketName airport-bucket.
We can also see s3EndPointOrverride and s3Profile arguments are set to the same values as the aws s3api command.
The s3CredentialsFile, s3ConfigFile and s3Region arguments have been left unset, using default values.
The number of parallel threads is the default value of 4.
And the compatibility options used are:
strip_restricted_grants, to remove specific privileges that are restricted by MySQL HeatWave Service from GRANT statements, so users and their roles cannot be given these privileges.
strip_definers to remove the DEFINER clause from views, routines, events, and triggers, so these objects are created with the default definer.
ignore_missing_pks to make the instance dump utility ignore any missing primary keys when the dump is carried out.
Ok, let’s see that in action.
$ mysqlsh --mysqlx -u root -h localhost -P 33060
MySQL Shell 8.0.33
Copyright (c) 2016, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.
Type '\help' or '\?' for help; '\quit' to exit.
Creating an X protocol session to 'root@localhost:33060'
Fetching schema names for auto-completion... Press ^C to stop.
Your MySQL connection id is 27 (X protocol)
Server version: 8.0.33 MySQL Community Server - GPL
No default schema selected; type \use <schema> to set one.
MySQL localhost:33060+ ssl JS >
MySQL localhost:33060+ ssl JS > util.dumpInstance("airport-db",{s3bucketName: "airport-dump", s3EndpointOverride: "http://192.168.4.180", s3Profile: "fbstaines03", threads: 4, compatibility: ["strip_restricted_grants", "strip_definers", "ignore_missing_pks"]})
Acquiring global read lock
Global read lock acquired
Initializing - done
1 out of 5 schemas will be dumped and within them 14 tables, 0 views.
1 out of 4 users will be dumped.
Gathering information - done
All transactions have been started
Locking instance for backup
Global read lock has been released
Writing global DDL files
Writing users DDL
NOTE: User 'root'@'localhost' had restricted privileges (AUDIT_ABORT_EXEMPT, AUDIT_ADMIN, AUTHENTICATION_POLICY_ADMIN, BACKUP_ADMIN, BINLOG_ADMIN, BINLOG_ENCRYPTION_ADMIN, CLONE_ADMIN, CREATE TABLESPACE, ENCRYPTION_KEY_ADMIN, FILE, FIREWALL_EXEMPT, FLUSH_OPTIMIZER_COSTS, FLUSH_STATUS, FLUSH_TABLES, FLUSH_USER_RESOURCES, GROUP_REPLICATION_ADMIN, GROUP_REPLICATION_STREAM, INNODB_REDO_LOG_ARCHIVE, INNODB_REDO_LOG_ENABLE, PASSWORDLESS_USER_ADMIN, PERSIST_RO_VARIABLES_ADMIN, PROXY, RELOAD, REPLICATION_SLAVE_ADMIN, ROLE_ADMIN, SENSITIVE_VARIABLES_OBSERVER, SERVICE_CONNECTION_ADMIN, SESSION_VARIABLES_ADMIN, SET_USER_ID, SHOW_ROUTINE, SHUTDOWN, SUPER, SYSTEM_USER, SYSTEM_VARIABLES_ADMIN, TABLE_ENCRYPTION_ADMIN, TELEMETRY_LOG_ADMIN) removed
Running data dump using 4 threads.
NOTE: Progress information uses estimated values and may not be accurate.
Writing schema metadata - done
Writing DDL - done
Writing table metadata - done
Starting data dump
100% (59.50M rows / ~59.33M rows), 2.68M rows/s, 103.29 MB/s uncompressed, 29.13 MB/s compressed
Dump duration: 00:00:20s
Total duration: 00:00:21s
Schemas dumped: 1
Tables dumped: 14
Uncompressed data size: 2.03 GB
Compressed data size: 656.55 MB
Compression ratio: 3.1
Rows written: 59502421
Bytes written: 656.55 MB
Average uncompressed throughput: 97.06 MB/s
Average compressed throughput: 31.33 MB/s
MySQL localhost:33060+ ssl JS >
Great, using the aws s3 ls command we can list bucket objects, and by greping for ‘Total Objects’ we can see the total number of objects written.
$ aws s3 ls s3://airport-dump --endpoint-url http://192.168.4.180 --profile fbstaines03 --recursive --human-readable --summarize | grep "Total Objects" Total Objects: 139
Logging onto the FlashBlade and navigating to Storage -> Object and selecting the airport-dump bucket we can confirm the size and number of objects written agree.
Dump Schemas
We can also use the MySQL Shell Dump Loading Utility util.dumpSchemas command to dump a list of one or more schemas from a MySQL instance using the as similar syntax as util.dumpInstance, thus:
util.dumpSchemas(["airportdb"],"airport-db",{s3bucketName: "airport-schemas", s3EndpointOverride: "http://192.168.4.180", s3Profile: "fbstaines03", threads: 4, compatibility: ["strip_restricted_grants", "strip_definers", "ignore_missing_pks"]})Let’s logon to the MySQL 8 database and give it a schema level dump.
$ mysqlsh --mysqlx -u root -h localhost -P 33060
MySQL Shell 8.0.33
Copyright (c) 2016, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.
Type '\help' or '\?' for help; '\quit' to exit.
Creating an X protocol session to 'root@localhost:33060'
Fetching schema names for auto-completion... Press ^C to stop.
Your MySQL connection id is 27 (X protocol)
Server version: 8.0.33 MySQL Community Server - GPL
No default schema selected; type \use <schema> to set one.
MySQL localhost:33060+ ssl JS >
MySQL localhost:33060+ ssl JS > util.dumpSchemas(["airportdb"],"airportdb-schemas",{s3bucketName: "airport-schemas", s3EndpointOverride: "http://192.168.4.180", s3Profile: "fbstaines03", threads: 4, compatibility: ["strip_restricted_grants", "strip_definers", "ignore_missing_pks"]})
Acquiring global read lock
Global read lock acquired
Initializing - done
1 schemas will be dumped and within them 14 tables, 0 views.
Gathering information - done
All transactions have been started
Locking instance for backup
Global read lock has been released
Writing global DDL files
Running data dump using 4 threads.
NOTE: Progress information uses estimated values and may not be accurate.
Writing schema metadata - done
Writing DDL - done
Writing table metadata - done
Starting data dump
100% (59.50M rows / ~59.33M rows), 2.75M rows/s, 104.38 MB/s uncompressed, 29.94 MB/s compressed
Dump duration: 00:00:20s
Total duration: 00:00:20s
Schemas dumped: 1
Tables dumped: 14
Uncompressed data size: 2.03 GB
Compressed data size: 656.55 MB
Compression ratio: 3.1
Rows written: 59502421
Bytes written: 656.55 MB
Average uncompressed throughput: 99.17 MB/s
Average compressed throughput: 32.00 MB/s
Dump Tables
The MySQL Shell Dump Loading Utility util.dumpTables option can be used to dump a list of tables from a MySQL schema using the following:
util.dumpTables("airportdb",["airline","airplane","airport"],"airport-tables",{s3bucketName: "airport-tables", s3EndpointOverride: "http://192.168.4.180", s3Profile: "fbstaines03", threads: 4, compatibility: ["strip_restricted_grants", "strip_definers", "ignore_missing_pks"]})And again logon to the MySQL 8 database and run the command.
$ mysqlsh --mysqlx -u root -h localhost -P 33060
MySQL Shell 8.0.33
Copyright (c) 2016, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.
Type '\help' or '\?' for help; '\quit' to exit.
Creating an X protocol session to 'root@localhost:33060'
Fetching schema names for auto-completion... Press ^C to stop.
Your MySQL connection id is 27 (X protocol)
Server version: 8.0.33 MySQL Community Server - GPL
No default schema selected; type \use <schema> to set one.
MySQL localhost:33060+ ssl JS >
MySQL localhost:33060+ ssl JS > util.dumpTables("airportdb",["airline","airplane","airport"],"airport-tables",{s3bucketName: "airport-tables", s3EndpointOverride: "http://192.168.4.180", s3Profile: "fbstaines03", threads: 4, compatibility: ["strip_restricted_grants", "strip_definers", "ignore_missing_pks"]})
Acquiring global read lock
Global read lock acquired
Initializing - done
3 tables and 0 views will be dumped.
Gathering information - done
All transactions have been started
Locking instance for backup
Global read lock has been released
Writing global DDL files
Running data dump using 4 threads.
NOTE: Progress information uses estimated values and may not be accurate.
Writing schema metadata - done
Writing DDL - done
Writing table metadata - done
Starting data dump
101% (15.55K rows / ~15.39K rows), 0.00 rows/s, 0.00 B/s uncompressed, 0.00 B/s compressed
Dump duration: 00:00:00s
Total duration: 00:00:00s
Schemas dumped: 1
Tables dumped: 3
Uncompressed data size: 335.43 KB
Compressed data size: 168.02 KB
Compression ratio: 2.0
Rows written: 15550
Bytes written: 168.02 KB
Average uncompressed throughput: 335.43 KB/s
Average compressed throughput: 168.02 KB/s
MySQL localhost:33060+ ssl JS >
Before we move on, let’s have a look at the objects written to the S3 airport-tables bucket for the airline, airport and airplane tables.
$ aws s3 ls s3://airport-tables/airport-tables --endpoint-url http://192.168.4.180 --profile fbstaines03 --recursive --human-readable --summarize 2023-08-22 15:51:05 387 Bytes airport-tables/@.done.json 2023-08-22 15:51:05 1.2 KiB airport-tables/@.json 2023-08-22 15:51:05 240 Bytes airport-tables/@.post.sql 2023-08-22 15:51:05 240 Bytes airport-tables/@.sql 2023-08-22 15:51:05 354 Bytes airport-tables/airportdb.json 2023-08-22 15:51:05 478 Bytes airport-tables/airportdb.sql 2023-08-22 15:51:05 678 Bytes airport-tables/airportdb@airline.json 2023-08-22 15:51:05 1.2 KiB airport-tables/airportdb@airline.sql 2023-08-22 15:51:05 1.6 KiB airport-tables/airportdb@airline@@0.tsv.zst 2023-08-22 15:51:05 8 Bytes airport-tables/airportdb@airline@@0.tsv.zst.idx 2023-08-22 15:51:05 679 Bytes airport-tables/airportdb@airplane.json 2023-08-22 15:51:05 1.1 KiB airport-tables/airportdb@airplane.sql 2023-08-22 15:51:05 23.5 KiB airport-tables/airportdb@airplane@@0.tsv.zst 2023-08-22 15:51:05 8 Bytes airport-tables/airportdb@airplane@@0.tsv.zst.idx 2023-08-22 15:51:05 663 Bytes airport-tables/airportdb@airport.json 2023-08-22 15:51:05 1.2 KiB airport-tables/airportdb@airport.sql 2023-08-22 15:51:05 139.1 KiB airport-tables/airportdb@airport@@0.tsv.zst 2023-08-22 15:51:05 8 Bytes airport-tables/airportdb@airport@@0.tsv.zst.idx Total Objects: 18 Total Size: 172.4 KiB
To dump all of the views and tables from the specified schema, use the all option and set the tables parameter to an empty array, as in this example:
util.dumpTables("airportdb",[],"airport-all-tables",{s3bucketName: "airport-tables", s3EndpointOverride: "http://192.168.4.180", s3Profile: "fbstaines03", threads: 16, compatibility: ["strip_restricted_grants", "strip_definers", "ignore_missing_pks"], "all": true })And repeat for all tables.
$ mysqlsh --mysqlx -u root -h localhost -P 33060
MySQL Shell 8.0.33
Copyright (c) 2016, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.
Type '\help' or '\?' for help; '\quit' to exit.
Creating an X protocol session to 'root@localhost:33060'
Fetching schema names for auto-completion... Press ^C to stop.
Your MySQL connection id is 27 (X protocol)
Server version: 8.0.33 MySQL Community Server - GPL
No default schema selected; type \use <schema> to set one.
MySQL localhost:33060+ ssl JS >
MySQL localhost:33060+ ssl JS > util.dumpTables("airportdb",[],"airport-all-tables",{s3bucketName: "airport-tables", s3EndpointOverride: "http://192.168.4.180", s3Profile: "fbstaines03", threads: 16, compatibility: ["strip_restricted_grants", "strip_definers", "ignore_missing_pks"], "all": true })
Acquiring global read lock
Global read lock acquired
Initializing - done
14 tables and 0 views will be dumped.
Gathering information - done
All transactions have been started
Locking instance for backup
Global read lock has been released
Writing global DDL files
Running data dump using 16 threads.
NOTE: Progress information uses estimated values and may not be accurate.
Writing schema metadata - done
Writing DDL - done
Writing table metadata - done
Starting data dump
100% (59.50M rows / ~59.33M rows), 8.73M rows/s, 286.28 MB/s uncompressed, 91.98 MB/s compressed
Dump duration: 00:00:07s
Total duration: 00:00:07s
Schemas dumped: 1
Tables dumped: 14
Uncompressed data size: 2.03 GB
Compressed data size: 656.55 MB
Compression ratio: 3.1
Rows written: 59502421
Bytes written: 656.55 MB
Average uncompressed throughput: 281.55 MB/s
Average compressed throughput: 90.87 MB/s
MySQL localhost:33060+ ssl JS >
And again, let’s have a look at objects written to the S3 airport-tables bucket for all tables.
$ aws s3 ls s3://airport-tables/airport-all-tables --endpoint-url http://192.168.4.180 --profile fbstaines03 --recursive --human-readable --summarize 2023-08-22 16:03:17 3.2 KiB airport-all-tables/@.done.json 2023-08-22 16:03:10 1.2 KiB airport-all-tables/@.json 2023-08-22 16:03:10 240 Bytes airport-all-tables/@.post.sql 2023-08-22 16:03:10 240 Bytes airport-all-tables/@.sql 2023-08-22 16:03:10 1.1 KiB airport-all-tables/airportdb.json 2023-08-22 16:03:10 478 Bytes airport-all-tables/airportdb.sql 2023-08-22 16:03:10 678 Bytes airport-all-tables/airportdb@airline.json 2023-08-22 16:03:10 1.2 KiB airport-all-tables/airportdb@airline.sql 2023-08-22 16:03:10 1.6 KiB airport-all-tables/airportdb@airline@@0.tsv.zst 2023-08-22 16:03:10 8 Bytes airport-all-tables/airportdb@airline@@0.tsv.zst.idx 2023-08-22 16:03:10 679 Bytes airport-all-tables/airportdb@airplane.json 2023-08-22 16:03:10 1.1 KiB airport-all-tables/airportdb@airplane.sql 2023-08-22 16:03:10 23.5 KiB airport-all-tables/airportdb@airplane@@0.tsv.zst 2023-08-22 16:03:10 8 Bytes airport-all-tables/airportdb@airplane@@0.tsv.zst.idx 2023-08-22 16:03:10 656 Bytes airport-all-tables/airportdb@airplane_type.json 2023-08-22 16:03:10 1.1 KiB airport-all-tables/airportdb@airplane_type.sql 2023-08-22 16:03:10 177.2 KiB airport-all-tables/airportdb@airplane_type@@0.tsv.zst 2023-08-22 16:03:10 8 Bytes airport-all-tables/airportdb@airplane_type@@0.tsv.zst.idx 2023-08-22 16:03:10 663 Bytes airport-all-tables/airportdb@airport.json 2023-08-22 16:03:10 1.2 KiB airport-all-tables/airportdb@airport.sql 2023-08-22 16:03:10 139.1 KiB airport-all-tables/airportdb@airport@@0.tsv.zst 2023-08-22 16:03:10 8 Bytes airport-all-tables/airportdb@airport@@0.tsv.zst.idx 2023-08-22 16:03:10 825 Bytes airport-all-tables/airportdb@airport_geo.json 2023-08-22 16:03:10 1.3 KiB airport-all-tables/airportdb@airport_geo.sql 2023-08-22 16:03:10 399.0 KiB airport-all-tables/airportdb@airport_geo@@0.tsv.zst 2023-08-22 16:03:10 8 Bytes airport-all-tables/airportdb@airport_geo@@0.tsv.zst.idx 2023-08-22 16:03:10 633 Bytes airport-all-tables/airportdb@airport_reachable.json 2023-08-22 16:03:10 1010 Bytes airport-all-tables/airportdb@airport_reachable.sql 2023-08-22 16:03:10 9 Bytes airport-all-tables/airportdb@airport_reachable@@0.tsv.zst 2023-08-22 16:03:10 8 Bytes airport-all-tables/airportdb@airport_reachable@@0.tsv.zst.idx 2023-08-22 16:03:10 697 Bytes airport-all-tables/airportdb@booking.json 2023-08-22 16:03:10 1.3 KiB airport-all-tables/airportdb@booking.sql 2023-08-22 16:03:12 16.5 MiB airport-all-tables/airportdb@booking@0.tsv.zst 2023-08-22 16:03:12 368 Bytes airport-all-tables/airportdb@booking@0.tsv.zst.idx 2023-08-22 16:03:12 16.4 MiB airport-all-tables/airportdb@booking@1.tsv.zst 2023-08-22 16:03:12 376 Bytes airport-all-tables/airportdb@booking@1.tsv.zst.idx 2023-08-22 16:03:12 16.4 MiB airport-all-tables/airportdb@booking@10.tsv.zst 2023-08-22 16:03:11 384 Bytes airport-all-tables/airportdb@booking@10.tsv.zst.idx 2023-08-22 16:03:12 16.3 MiB airport-all-tables/airportdb@booking@11.tsv.zst 2023-08-22 16:03:12 384 Bytes airport-all-tables/airportdb@booking@11.tsv.zst.idx 2023-08-22 16:03:13 16.4 MiB airport-all-tables/airportdb@booking@12.tsv.zst 2023-08-22 16:03:13 384 Bytes airport-all-tables/airportdb@booking@12.tsv.zst.idx 2023-08-22 16:03:12 16.5 MiB airport-all-tables/airportdb@booking@13.tsv.zst 2023-08-22 16:03:12 384 Bytes airport-all-tables/airportdb@booking@13.tsv.zst.idx 2023-08-22 16:03:12 16.5 MiB airport-all-tables/airportdb@booking@14.tsv.zst 2023-08-22 16:03:12 384 Bytes airport-all-tables/airportdb@booking@14.tsv.zst.idx 2023-08-22 16:03:14 16.5 MiB airport-all-tables/airportdb@booking@15.tsv.zst 2023-08-22 16:03:14 384 Bytes airport-all-tables/airportdb@booking@15.tsv.zst.idx 2023-08-22 16:03:14 16.4 MiB airport-all-tables/airportdb@booking@16.tsv.zst 2023-08-22 16:03:14 384 Bytes airport-all-tables/airportdb@booking@16.tsv.zst.idx 2023-08-22 16:03:14 16.6 MiB airport-all-tables/airportdb@booking@17.tsv.zst 2023-08-22 16:03:14 384 Bytes airport-all-tables/airportdb@booking@17.tsv.zst.idx 2023-08-22 16:03:14 16.4 MiB airport-all-tables/airportdb@booking@18.tsv.zst 2023-08-22 16:03:14 384 Bytes airport-all-tables/airportdb@booking@18.tsv.zst.idx 2023-08-22 16:03:14 16.5 MiB airport-all-tables/airportdb@booking@19.tsv.zst 2023-08-22 16:03:14 384 Bytes airport-all-tables/airportdb@booking@19.tsv.zst.idx 2023-08-22 16:03:12 16.3 MiB airport-all-tables/airportdb@booking@2.tsv.zst 2023-08-22 16:03:12 376 Bytes airport-all-tables/airportdb@booking@2.tsv.zst.idx 2023-08-22 16:03:14 16.3 MiB airport-all-tables/airportdb@booking@20.tsv.zst 2023-08-22 16:03:14 384 Bytes airport-all-tables/airportdb@booking@20.tsv.zst.idx 2023-08-22 16:03:14 16.4 MiB airport-all-tables/airportdb@booking@21.tsv.zst 2023-08-22 16:03:14 384 Bytes airport-all-tables/airportdb@booking@21.tsv.zst.idx 2023-08-22 16:03:14 16.5 MiB airport-all-tables/airportdb@booking@22.tsv.zst 2023-08-22 16:03:14 384 Bytes airport-all-tables/airportdb@booking@22.tsv.zst.idx 2023-08-22 16:03:14 16.4 MiB airport-all-tables/airportdb@booking@23.tsv.zst 2023-08-22 16:03:14 384 Bytes airport-all-tables/airportdb@booking@23.tsv.zst.idx 2023-08-22 16:03:14 16.4 MiB airport-all-tables/airportdb@booking@24.tsv.zst 2023-08-22 16:03:14 384 Bytes airport-all-tables/airportdb@booking@24.tsv.zst.idx 2023-08-22 16:03:14 16.6 MiB airport-all-tables/airportdb@booking@25.tsv.zst 2023-08-22 16:03:14 384 Bytes airport-all-tables/airportdb@booking@25.tsv.zst.idx 2023-08-22 16:03:15 16.6 MiB airport-all-tables/airportdb@booking@26.tsv.zst 2023-08-22 16:03:15 384 Bytes airport-all-tables/airportdb@booking@26.tsv.zst.idx 2023-08-22 16:03:15 16.3 MiB airport-all-tables/airportdb@booking@27.tsv.zst 2023-08-22 16:03:15 384 Bytes airport-all-tables/airportdb@booking@27.tsv.zst.idx 2023-08-22 16:03:15 16.5 MiB airport-all-tables/airportdb@booking@28.tsv.zst 2023-08-22 16:03:15 384 Bytes airport-all-tables/airportdb@booking@28.tsv.zst.idx 2023-08-22 16:03:15 16.4 MiB airport-all-tables/airportdb@booking@29.tsv.zst 2023-08-22 16:03:15 384 Bytes airport-all-tables/airportdb@booking@29.tsv.zst.idx 2023-08-22 16:03:13 16.4 MiB airport-all-tables/airportdb@booking@3.tsv.zst 2023-08-22 16:03:12 368 Bytes airport-all-tables/airportdb@booking@3.tsv.zst.idx 2023-08-22 16:03:16 16.2 MiB airport-all-tables/airportdb@booking@30.tsv.zst 2023-08-22 16:03:15 384 Bytes airport-all-tables/airportdb@booking@30.tsv.zst.idx 2023-08-22 16:03:16 16.6 MiB airport-all-tables/airportdb@booking@31.tsv.zst 2023-08-22 16:03:16 384 Bytes airport-all-tables/airportdb@booking@31.tsv.zst.idx 2023-08-22 16:03:16 16.4 MiB airport-all-tables/airportdb@booking@32.tsv.zst 2023-08-22 16:03:16 384 Bytes airport-all-tables/airportdb@booking@32.tsv.zst.idx 2023-08-22 16:03:16 16.3 MiB airport-all-tables/airportdb@booking@33.tsv.zst 2023-08-22 16:03:16 384 Bytes airport-all-tables/airportdb@booking@33.tsv.zst.idx 2023-08-22 16:03:16 16.3 MiB airport-all-tables/airportdb@booking@34.tsv.zst 2023-08-22 16:03:16 384 Bytes airport-all-tables/airportdb@booking@34.tsv.zst.idx 2023-08-22 16:03:12 16.3 MiB airport-all-tables/airportdb@booking@4.tsv.zst 2023-08-22 16:03:11 376 Bytes airport-all-tables/airportdb@booking@4.tsv.zst.idx 2023-08-22 16:03:12 16.3 MiB airport-all-tables/airportdb@booking@5.tsv.zst 2023-08-22 16:03:12 376 Bytes airport-all-tables/airportdb@booking@5.tsv.zst.idx 2023-08-22 16:03:12 16.4 MiB airport-all-tables/airportdb@booking@6.tsv.zst 2023-08-22 16:03:12 384 Bytes airport-all-tables/airportdb@booking@6.tsv.zst.idx 2023-08-22 16:03:12 16.9 MiB airport-all-tables/airportdb@booking@7.tsv.zst 2023-08-22 16:03:12 384 Bytes airport-all-tables/airportdb@booking@7.tsv.zst.idx 2023-08-22 16:03:12 16.4 MiB airport-all-tables/airportdb@booking@8.tsv.zst 2023-08-22 16:03:12 384 Bytes airport-all-tables/airportdb@booking@8.tsv.zst.idx 2023-08-22 16:03:12 16.4 MiB airport-all-tables/airportdb@booking@9.tsv.zst 2023-08-22 16:03:11 384 Bytes airport-all-tables/airportdb@booking@9.tsv.zst.idx 2023-08-22 16:03:14 263 Bytes airport-all-tables/airportdb@booking@@35.tsv.zst 2023-08-22 16:03:14 8 Bytes airport-all-tables/airportdb@booking@@35.tsv.zst.idx 2023-08-22 16:03:10 934 Bytes airport-all-tables/airportdb@employee.json 2023-08-22 16:03:10 2.0 KiB airport-all-tables/airportdb@employee.sql 2023-08-22 16:03:10 87.8 KiB airport-all-tables/airportdb@employee@@0.tsv.zst 2023-08-22 16:03:10 8 Bytes airport-all-tables/airportdb@employee@@0.tsv.zst.idx 2023-08-22 16:03:10 763 Bytes airport-all-tables/airportdb@flight.json 2023-08-22 16:03:10 1.8 KiB airport-all-tables/airportdb@flight.sql 2023-08-22 16:03:10 9.7 MiB airport-all-tables/airportdb@flight@@0.tsv.zst 2023-08-22 16:03:10 256 Bytes airport-all-tables/airportdb@flight@@0.tsv.zst.idx 2023-08-22 16:03:10 1.1 KiB airport-all-tables/airportdb@flight_log.json 2023-08-22 16:03:10 1.8 KiB airport-all-tables/airportdb@flight_log.sql 2023-08-22 16:03:10 9 Bytes airport-all-tables/airportdb@flight_log@@0.tsv.zst 2023-08-22 16:03:10 8 Bytes airport-all-tables/airportdb@flight_log@@0.tsv.zst.idx 2023-08-22 16:03:10 880 Bytes airport-all-tables/airportdb@flightschedule.json 2023-08-22 16:03:10 1.6 KiB airport-all-tables/airportdb@flightschedule.sql 2023-08-22 16:03:14 168.0 KiB airport-all-tables/airportdb@flightschedule@@0.tsv.zst 2023-08-22 16:03:14 8 Bytes airport-all-tables/airportdb@flightschedule@@0.tsv.zst.idx 2023-08-22 16:03:10 684 Bytes airport-all-tables/airportdb@passenger.json 2023-08-22 16:03:10 1.2 KiB airport-all-tables/airportdb@passenger.sql 2023-08-22 16:03:10 483.3 KiB airport-all-tables/airportdb@passenger@@0.tsv.zst 2023-08-22 16:03:10 8 Bytes airport-all-tables/airportdb@passenger@@0.tsv.zst.idx 2023-08-22 16:03:10 799 Bytes airport-all-tables/airportdb@passengerdetails.json 2023-08-22 16:03:10 1.5 KiB airport-all-tables/airportdb@passengerdetails.sql 2023-08-22 16:03:10 1.6 MiB airport-all-tables/airportdb@passengerdetails@@0.tsv.zst 2023-08-22 16:03:10 32 Bytes airport-all-tables/airportdb@passengerdetails@@0.tsv.zst.idx 2023-08-22 16:03:10 824 Bytes airport-all-tables/airportdb@weatherdata.json 2023-08-22 16:03:10 1.3 KiB airport-all-tables/airportdb@weatherdata.sql 2023-08-22 16:03:17 10.8 MiB airport-all-tables/airportdb@weatherdata@0.tsv.zst 2023-08-22 16:03:16 560 Bytes airport-all-tables/airportdb@weatherdata@0.tsv.zst.idx 2023-08-22 16:03:17 10.8 MiB airport-all-tables/airportdb@weatherdata@1.tsv.zst 2023-08-22 16:03:17 568 Bytes airport-all-tables/airportdb@weatherdata@1.tsv.zst.idx 2023-08-22 16:03:17 10.9 MiB airport-all-tables/airportdb@weatherdata@2.tsv.zst 2023-08-22 16:03:17 560 Bytes airport-all-tables/airportdb@weatherdata@2.tsv.zst.idx 2023-08-22 16:03:16 5.9 MiB airport-all-tables/airportdb@weatherdata@@3.tsv.zst 2023-08-22 16:03:16 304 Bytes airport-all-tables/airportdb@weatherdata@@3.tsv.zst.idx Total Objects: 138 Total Size: 626.2 MiB
Summary
In this blog post I have shared how to use the MySQL Shell Dump Loading Utility to perform MySQL 8 instance, schema and table level dumps to an on-premises FlashBlade S3 Object Store.