Replicate a DB

In this example, we will replicate your database via API commands and CLI command.

• Replicate by CLI commands

  MySQL

  vme data-container-replicate mygolddb01 replica01

  MariaDB

  vme data-container-replicate mygolddb01 replica01

  SQL Server

  vme data-container-replicate mygolddb01 replica01

  MongoDB

  vme data-container-replicate mygolddb01 replica01

  PostgreSQL

  vme data-container-replicate mygolddb01 replica01

• Replicate by API commands

  MySQL

  Snapshot:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{"pool_name": "demo-pool", "source_name": "demo-source", "name": "snap"}' \
      "https://x.x.x.x/snapshot/create"

  Clone:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{"pool_name": "demo-pool", "source_name": "demo-source", "snapshot_name": "snap", "name": "demo-clone"}' \
      "https://x.x.x.x/clone/create"

  Create a db container:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{ "image": "mysql:latest", "name": "replica01", "volumes": ["/demo-pool/clones/demo-clone:/var/lib/mysql"], "environment": ["MYSQL_ROOT_PASSWORD=<my-secret-pw>", "MYSQL_USER=<example-user>", "MYSQL_PASSWORD=<my-cool-pw>"], "ports": 8889}' \
      "https://x.x.x.x/docker/container/create"

  MariaDB

  Snapshot:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{"pool_name": "demo-pool", "source_name": "demo-source", "name": "snap"}' \
      "https://x.x.x.x/snapshot/create"

  Clone:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{"pool_name": "demo-pool", "source_name": "demo-source", "snapshot_name": "snap", "name": "demo-clone"}' \
      "https://x.x.x.x/clone/create"

  Create a db container:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{ "image": "mariadb:latest", "name": "replica01", "volumes": ["/demo-pool/clones/demo-clone:/var/lib/mysql"], "environment": ["MARIADB_ROOT_PASSWORD=<my-secret-pw>", "MARIADB_USER=<example-user>", "MARIADB_PASSWORD=<my-cool-pw>"], "ports": 8889}' \
      "https://x.x.x.x/docker/container/create"

  SQL Server

  Snapshot:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{"pool_name": "demo-pool", "source_name": "demo-source", "name": "snap"}' \
      "https://x.x.x.x/snapshot/create"

  Clone:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{"pool_name": "demo-pool", "source_name": "demo-source", "snapshot_name": "snap", "name": "demo-clone"}' \
      "https://x.x.x.x/clone/create"

  Create a db container:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{ "image": "mcr.microsoft.com/mssql/server:latest", "name": "replica01", "volumes": ["/demo-pool/clones/demo-clone:/var/opt/mssql/data"], "environment": ["ACCEPT_EULA=Y","SA_PASSWORD=<my-cool-pw>"], "ports": 8889}' \
      "https://x.x.x.x/docker/container/create"

  MongoDB

  Snapshot:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{"pool_name": "demo-pool", "source_name": "demo-source", "name": "snap"}' \
      "https://x.x.x.x/snapshot/create"

  Clone:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{"pool_name": "demo-pool", "source_name": "demo-source", "snapshot_name": "snap", "name": "demo-clone"}' \
      "https://x.x.x.x/clone/create"

  Create a db container:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{ "image": "mongo:latest", "name": "replica01", "volumes": ["/demo-pool/clones/demo-clone:/data/db"], "environment": ["MONGO_INITDB_ROOT_USERNAME=<example-user>", "MONGO_INITDB_ROOT_PASSWORD=<my-secret-pw>"], "ports": 8889}' \
      "https://x.x.x.x/docker/container/create"

  PostgreSQL

  Snapshot:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{"pool_name": "demo-pool", "source_name": "demo-source", "name": "snap"}' \
      "https://x.x.x.x/snapshot/create"

  Clone:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{"pool_name": "demo-pool", "source_name": "demo-source", "snapshot_name": "snap", "name": "demo-clone"}' \
      "https://x.x.x.x/clone/create"

  Create a db container:

  curl -X POST \
      -H "Content-Type: application/json" \
      -H 'username: xxxxx' \
      -H 'api-key: xxxxx' \
      -d '{ "image": "postgres:latest", "name": "replica01", "volumes": ["/demo-pool/clones/demo-clone:/var/lib/postgresql/data","/demo-pool/ingests:/mys"], "environment": ["POSTGRES_USER=<example-user>", "POSTGRES_PASSWORD=<my-cool-pw>"], "ports": 8889}' \
      "https://x.x.x.x/docker/container/create"