Skip to content

Latest commit

 

History

History
88 lines (69 loc) · 3.37 KB

run-application.md

File metadata and controls

88 lines (69 loc) · 3.37 KB

Run Application

  1. Create and evaluation key to enable the Enterprise features. This is required as we will be creating a multi-region database.
./crl-lic -type Evaluation -org 'Mike-Pet-Project' -site -expiration '2032-01-10 23:00 GMT'
  1. Once you have don't that we can then apply the generated code to the cluster.
SET CLUSTER SETTING cluster.organization = 'Mike-Pet-Project';
SET CLUSTER SETTING enterprise.license = 'crl-0-EPDAraUHGAIiEE1pa2UtUGV0LVByb2plY3Q';
  1. By running the command below you are able to list the regions configured in your.
SHOW REGIONS FROM CLUSTER;
  1. Now run the SQL script below to create the schema for the MOVR database.
SET sql_safe_updates = FALSE;

DROP DATABASE IF EXISTS movr CASCADE;

CREATE DATABASE movr PRIMARY REGION "eastus" REGIONS "eastus", "westus", "northeneurope";

USE movr;

CREATE TABLE IF NOT EXISTS users (
  id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
  city STRING NOT NULL,
  first_name STRING,
  last_name STRING,
  email STRING,
  username STRING,
  password_hash STRING,
  is_owner bool,
  UNIQUE INDEX users_username_key (username ASC)) 
  LOCALITY REGIONAL BY ROW;

CREATE TABLE vehicles (
    id UUID PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
    type STRING,
    city STRING,
    owner_id UUID,
    date_added date,
    status STRING,
    last_location STRING,
    color STRING,
    brand STRING, 
    CONSTRAINT fk_ref_users FOREIGN KEY (owner_id) REFERENCES users (id))
    LOCALITY REGIONAL BY ROW;

CREATE TABLE rides (
  id uuid PRIMARY KEY NOT NULL DEFAULT gen_random_uuid(),
  city STRING NOT NULL,
  vehicle_id uuid,
  rider_id uuid,
  start_location STRING,
  end_location STRING,
  start_time timestamptz,
  end_time timestamptz,
  length interval,
  CONSTRAINT fk_city_ref_users FOREIGN KEY (rider_id) REFERENCES users (id),
  CONSTRAINT fk_vehicle_ref_vehicles FOREIGN KEY (vehicle_id) REFERENCES vehicles (id)) 
  LOCALITY REGIONAL BY ROW;

INSERT INTO users (id, city, first_name, last_name, email, username)
  VALUES ('2804df7c-d8fd-4b1c-9799-b1d44452554b', 'new york', 'Carl', 'Kimball', 'carl@cockroachlabs.com', 'carl');

INSERT INTO vehicles (id, city, type, owner_id, date_added, status, last_location, color, brand)
  VALUES ('142b7c9e-6227-4dbb-b188-b1dac57d5521', 'new york', 'scooter', '2804df7c-d8fd-4b1c-9799-b1d44452554b', current_date(), 'available', 'Time Square', 'Blue', 'Razor');

INSERT INTO rides (city, rider_id, vehicle_id, start_location, end_location, start_time, end_time, length)
  VALUES ('new york', '2804df7c-d8fd-4b1c-9799-b1d44452554b', '142b7c9e-6227-4dbb-b188-b1dac57d5521', 'Cockroach Labs, 23rd Street', 'Time Square', '2020-01-16 21:20:48.224453+00:00', '2020-01-16 21:20:52.045813+00:00', '00:00:03.82136');
  1. What you are able to do to simulate the load of an application (Don't create the schema above as this is not compatible with 'cockroach workload movr')
cockroach workload init movr 'postgresql://uesr:password@cockroachdb-public:26257/movr?sslmode=verify-full&sslrootcert=/cockroach-certs/ca.crt'

cockroach workload run movr --duration=99999m 'postgresql://user:password@cockroachdb-public:26257/movr?sslmode=verify-full&sslrootcert=/cockroach-certs/ca.crt'

cockroach workload run movr --duration=10m 'postgresql://user:password@crdb-northeurope-node1.private.cockroach.internal:26257/movr?sslmode=verify-full&sslrootcert=/home/ubuntu/cockroach/certs/ca.crt'