Synchronize Server Resources in Google Cloud​

Overview

QueryPie supports integration with Google Cloud Platform (GCP) for server registration and management. By synchronizing resources from GCP, you can register and manage servers within QueryPie, grant access permissions to users and groups, and configure policies for the synchronized servers.

Registering GCP Integration in QueryPie

1. Navigate to the Administrator > Servers > Connection Management > Cloud Providers menu.

2. Click the Create Provider button in the upper right corner.

3. Name: Enter a name to distinguish the provider.

4. Cloud Provider: Select Google Cloud Platform.

5. Project ID: Enter the Project ID for the resources to be synchronized.

6. If you want to synchronize resources from a specific region and zone, check the Use Region and Zone option and select the desired Region and Zone.

7. Credential: Enter the necessary credential information. Currently, only synchronization via GCP's Service Account is supported.

   1. The Service Account method supports only manual synchronization. On the provider’s details page, click the Synchronize button, enter the Service Account JSON, and synchronize once.

8. Search Filter: Use this option to fetch a list of resource types you want to synchronize.

   1. The search filter operates similarly to AWS search methods, allowing you to use values such as names and tags for filtering.

      1. Enter the Key value → Select the search condition → Enter the Value

   2. For more detailed usage instructions, refer to the User Guide for Linux Instances (AWS).

9. Replication Frequency: Choose the synchronization method.

   • Manual: A method where synchronization is performed manually only when desired.

   • Scheduling: A method that synchronizes resources through periodic scheduling. Cron expressions are provided.

10. Port: Allow you to specify the default ports of the servers to be synchronized when importing servers. This applies only during the initial synchronization.

11. Click the Save button to store the Cloud Provider settings.

Synchronizing and Managing GCP Cloud Providers

1. Navigate to the Administrator > Servers > Connection Management > Cloud Providers menu.

2. Click on the registered Cloud Provider to open the details screen.

3. Click the Dry run button in the upper right corner to preview the servers that will be synchronized from GCP. Note that the Dry run results are not saved.

4. Click the Sychronize button in the upper right corner to sync resources from GCP.

5. You can monitor synchronization progress in the Synchronization Log or view the history under Administrator > General > Systems > Jobs.

6. Once a Cloud Provider is registered, certain provider details cannot be modified:

   1. Name: Changeable

   2. Cloud Provider: Not changeable

   3. Project ID: Not changeable

   4. Region and Zone: Not changeable

   5. Credential: Not changeable

   6. Search Filter: Changeable

   7. Replication Frequency: Not changeable