robrich

create database 'tpc_h';
use 'tpc_h';

CREATE TABLE IF NOT EXISTS `lineitem` (
`l_orderkey` bigint(11) NOT NULL,
`l_partkey` int(11) NOT NULL,
`l_suppkey` int(11) NOT NULL,
`l_linenumber` int(11) NOT NULL,
`l_quantity` decimal(15,2) NOT NULL,
`l_extendedprice` decimal(15,2) NOT NULL,

robrich

-- create a database with 2 master partitions
create database thedb partitions 2;

-- create sample data
use thedb;
create table data (msg varchar(200));
insert into data (msg) values ('the data');

-- notice how we're not using the database efficiently
show partitions;

robrich

-- create a database
create database cosmeticshop;

-- create a table
use cosmeticshop;
create table cosmeticshopfunnel
(
    event_time TIMESTAMP,
    event_type CHAR(18),
    product_id CHAR(10),

robrich

robrich

robrich

apiVersion: apps/v1
kind: Deployment
metadata:
  name: memsql-operator-envvar
  namespace: memsql
spec:
  replicas: 1
  selector:
    matchLabels:
      name: memsql-operator-envvar

robrich

apiVersion: apps/v1
kind: Deployment
metadata:
  name: myapp
  labels:
    app: myapp
spec:
  replicas: 3
  template:
    metadata:

robrich

Vagrant.configure("2") do |config|
  config.vm.box = "generic/ubuntu1904"

  # set the provider
  config.vm.provider "virtualbox"
  # configure the provider
  config.vm.provider "virtualbox" do |v|
    v.cpus = 4
    v.memory = 4096
  end

robrich

CREATE DATABASE hellomemsql;

USE hellomemsql;

CREATE TABLE test (
  message text NOT NULL
);

INSERT INTO test (message) VALUES ('this is a sample message');
 

robrich

version: '2'

services:
  memsql:
    image: 'memsql/cluster-in-a-box'
    ports:
      - 3306:3306
      - 8080:8080
    environment:
      LICENSE_KEY: ${LICENSE_KEY}