Oracle Cloud Infrastructure Documentation

Removing Cloud SQL from a Cluster

Remove Oracle Cloud SQL from a Big Data Service cluster.

Important

Removing Cloud SQL from a cluster deletes the query server node and deletes any files on that node. The VM is deleted. This action is irreversible.

Removing Cloud SQL from a cluster has the following additional results:

  • Removes Cloud SQL cells from the cluster worker nodes
  • Deletes the query server node and deletes any files or work that you have on that host. (The VM is deleted.)
  • Ends the billing for Cloud SQL. You no longer pay for Cloud SQL after it's removed.
  • Removing Cloud SQL from a cluster has no impact on Hive metadata or the sources that Cloud SQL accesses.
    1. Open the navigation menu and click Analytics & AI. Under Data Lake, click Big Data Service.
    2. Under Compartment, select the compartment that contains the cluster.
    3. In the list of clusters, click the name of the cluster.
    4. On the Cluster details page, click More actions, and then select Remove cloud SQL.
    5. In the Remove cloud SQL panel, enter the cluster administrator password.
    6. Click Remove.

  • Use the oci bds cloudsql remove command and required parameters to remove Cloud SQL from the cluster.

    oci bds cloudsql remove --bds-instance-id <bds_instance_id> --cluster-admin-password <cluster_admin_password> [OPTIONS]

    For a complete list of flags and variable options for CLI commands, see the Command Line Reference for Big Data.

  • Use the RemoveCloudSql operation to remove Cloud SQL to the cluster.