aster.cloud aster.cloud
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
  • Tools
  • About
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
  • Tools
  • About
aster.cloud aster.cloud
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
  • Tools
  • About
  • Platforms

How To Create A Spanner Instance In GCP

  • root
  • November 15, 2020
  • 2 minute read

In this guide you will be able to provision a Spanner instance. 

1. Login in to the Google Cloud Platform console. If you don’t have any account yet, follow the steps here on how to create a Google Cloud Platform account.


Partner with aster.cloud
for your next big idea.
Let us know here.


cyberpogo

 

Create the Spanner Instance

2. Once authenticated, you will be shown the Dashboard. Click on the hamburger icon on the top-left to open the navigation menu. Select Spanner under the Storage section. 

 

3. You will be taken to the Spanner instances page. In the following image there are no instances created yet.

If this is your first time accessing Spanner, you will need to enable the API and the following will be shown. Click on the “Enable” button to enable it and be able to manage Spanner instances.

 

4. Select on the “Create Instance” 

 

5. A form where you enter the details of the instance will be shown. 

 

Name your instance
Instance name The name of your spanner instance. This is for display purpose and can still be updated later.
Instance ID By default, after selecting an instance name, the Instance ID will be created based on the name. But can still be changed. This must be unique across the project.

Cannot be changed after creation.

Choose a configuration
Configuration type
  • Regional
  • Multi-regional

Cannot be changed after creation.

Location Depending on the type, the values will change. Multi-regional has 2 or more locations.
Allocate node
Nodes The number of nodes to assign to this instance. Note that this can still be updated later.

 

A summary will also be shown on the right side. This contains Replicas that will be created automatically by GCP, percent of availability or SLA, node cost and storage cost.

 

6. Select the “Create” button once you have reviewed the setting. The following image shows the setting we are using in this guide.

 

7. Instance creation is fast and the details will be shown. 

 

Create a Database

8. Next, we create the database. Click on the “Create Database” on the top section or on the bottom.

 

9. We will be creating a school-themed database. Starting with the school name as the database. Naming the database and school as “geek_school”. Then select the “Continue” button.

Allowed characters for the database name are

  • Only lower case letters
  • Numbers
  • Hyphens
  • Underscores

 

10. There are 2 options for creating the database tables. Using DDL (SQL Script) or by disabling the “Edit as text” radio button. Select the “Edit as text” and enter the following script.

CREATE TABLE classes (

id INT64,

name INT64,

) PRIMARY KEY (id);

CREATE TABLE students (

id INT64,

name STRING(MAX),

) PRIMARY KEY (id);

CREATE TABLE class_students (

class_id INT64 NOT NULL,

student_id INT64 NOT NULL,

) PRIMARY KEY (class_id, student_id);

 

 

11. Review the DDL or Data Definition Language which describes the structure of the database and its tables. Then select the “Create” button.

 

12. The Spanner instance now has a database and tables created. 

 

13. You have now created the following resources

  • Spanner instance
  • Database
  • Table

 

To view the details of a spanner instance go to Cloud Storages – GCP – Spanner – Read/View and Query next.

Read More  SAP Positioned As A Leader In Gartner 2020 Magic Quadrant For Enterprise Integration Platform-as-a-Service

Our humans need coffee too! Your support is highly appreciated, thank you!

root

Related Topics
  • Cloud Spanner API
  • GCP
  • google
  • Google Cloud Platform
  • Spanner Instance
You May Also Like
View Post
  • Architecture
  • Platforms
  • Software
  • Solutions
  • Technology

What To Expect From Apple’s WWDC 2023

  • June 1, 2023
View Post
  • Platforms

Build Next-Generation, AI-Powered Applications On Microsoft Azure

  • May 26, 2023
View Post
  • Platforms
  • Solutions

MongoDB And Alibaba Cloud Extend Global Partnership

  • May 25, 2023
View Post
  • Computing
  • Platforms

Oracle Cloud Infrastructure Adds To Growing List Of Government Approved Cloud Services

  • May 22, 2023
View Post
  • Engineering
  • People
  • Platforms

KubeCon Europe 2023 Highlights Kubernetes Explosion And Need For Instant Platform Engineering

  • May 17, 2023
View Post
  • Data
  • Platforms
  • Technology

Cloudflare’s R2 Is The Infrastructure Powering Leading AI Companies

  • May 16, 2023
View Post
  • Platforms

Oracle Opens Cloud Region In Serbia

  • May 12, 2023
View Post
  • Computing
  • Engineering
  • Platforms

The Next Generation Of Cloud Management And Automation

  • May 9, 2023

Stay Connected!
LATEST
  • 1
    Building A Kubernetes Platform: How And Why To Apply Governance And Policy
    • June 4, 2023
  • 2
    Leave, This “United” “Kingdom”, This “Great” “Britain”
    • June 4, 2023
  • 3
    Amazing Federated Multicloud Apps
    • June 2, 2023
  • 4
    What’s The Future Of DevOps? You Tell Us. Take The 2023 Accelerate State Of DevOps Survey
    • June 2, 2023
  • 5
    Resolving Deployment Issues With Ts-node And Azure Development Pipelines
    • June 1, 2023
  • 6
    What To Expect From Apple’s WWDC 2023
    • June 1, 2023
  • 7
    What Is Platform Engineering And Why Adopt It In Your Company?
    • June 1, 2023
  • 8
    Four Steps To Managing Your Cloud Logging Costs On A Budget
    • May 31, 2023
  • 9
    Red Hat Puts Podman Container Management On The Desktop
    • May 30, 2023
  • 10
    The Agile Mindset: A Path to Personal Fulfillment and Growth
    • May 30, 2023
about
Hello World!

We are aster.cloud. We’re created by programmers for programmers.

Our site aims to provide guides, programming tips, reviews, and interesting materials for tech people and those who want to learn in general.

We would like to hear from you.

If you have any feedback, enquiries, or sponsorship request, kindly reach out to us at:

[email protected]
Most Popular
  • 1
    Huawei ICT Competition 2022-2023 Global Final Held In Shenzhen — 146 Teams From 36 Countries And Regions Win Awards
    • May 27, 2023
  • 2
    Huawei OceanStor Pacific Scale-Out Storage Tops IO500 Rankings
    • May 26, 2023
  • 3
    MongoDB And Alibaba Cloud Extend Global Partnership
    • May 25, 2023
  • 4
    Tricentis Launches Quality Engineering Community ShiftSync
    • May 23, 2023
  • 5
    G7 2023: The Real Threat To The World Order Is Hypocrisy.
    • May 27, 2023
  • /
  • Technology
  • Tools
  • About
  • Contact Us

Input your search keywords and press Enter.