Skip to content

Instantly share code, notes, and snippets.

@iSignal

iSignal/gist:a9d9ca44a0a48e511b71da615ee949f5 Secret

Created September 26, 2020 19:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save iSignal/a9d9ca44a0a48e511b71da615ee949f5 to your computer and use it in GitHub Desktop.
Save iSignal/a9d9ca44a0a48e511b71da615ee949f5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
dev-server-sanketh-3 12:35 ~/code/charts [master] $
kubectl create namespace yb-sanketh-test1
namespace/yb-sanketh-test1 created
dev-server-sanketh-3 12:35 ~/code/charts [master] $
clear
dev-server-sanketh-3 12:35 ~/code/charts [master] $
kubectl delete namespace yb-sanketh-test1
namespace "yb-sanketh-test1" deleted
dev-server-sanketh-3 12:36 ~/code/charts [master] $
cat storageclass.yaml
#ssd-storageclass.yaml
apiVersion: storage.k8s.io/v1
kind: StorageClass
metadata:
name: sanketh-ssd-test
provisioner: kubernetes.io/gce-pd
parameters:
type: pd-ssd
dev-server-sanketh-3 12:36 ~/code/charts [master] $
kubectl apply -f storageclass.yaml -n yb-sanketh-test1
storageclass.storage.k8s.io/sanketh-ssd-test unchanged
dev-server-sanketh-3 12:36 ~/code/charts [master] $
helm3 install yb-sanketh-test1 yugabytedb/yugabyte --version 2.3.0 --namespace yb-sanketh-test1 --set storage.master.storageClass=sanketh-ssd-test --set storage.tserver.storageClass=sanketh-ssd-test --set resource.master.requests.memory=1Gi --set resource.tserver.requests.memory=1Gi --set resource.master.requests.cpu=1 --set resource.master.limits.cpu=1 --set resource.tserver.requests.cpu=1 --set resource.tserver.limits.cpu=1 --wait
Error: create: failed to create: namespaces "yb-sanketh-test1" not found
dev-server-sanketh-3 12:36 ~/code/charts [master] $
kubectl create namespace yb-sanketh-test1
namespace/yb-sanketh-test1 created
dev-server-sanketh-3 12:36 ~/code/charts [master] $
helm3 install yb-sanketh-test1 yugabytedb/yugabyte --version 2.3.0 --namespace yb-sanketh-test1 --set storage.master.storageClass=sanketh-ssd-test --set storage.tserver.storageClass=sanketh-ssd-test --set resource.master.requests.memory=1Gi --set resource.tserver.requests.memory=1Gi --set resource.master.requests.cpu=1 --set resource.master.limits.cpu=1 --set resource.tserver.requests.cpu=1 --set resource.tserver.limits.cpu=1 --wait
NAME: yb-sanketh-test1
LAST DEPLOYED: Sat Sep 26 12:36:44 2020
NAMESPACE: yb-sanketh-test1
STATUS: deployed
REVISION: 1
TEST SUITE: None
NOTES:
1. Get YugabyteDB Pods by running this command:
kubectl --namespace yb-sanketh-test1 get pods
2. Get list of YugabyteDB services that are running:
kubectl --namespace yb-sanketh-test1 get services
3. Get information about the load balancer services:
kubectl get svc --namespace yb-sanketh-test1
4. Connect to one of the tablet server:
kubectl exec --namespace yb-sanketh-test1 -it yb-tserver-0 bash
5. Run YSQL shell from inside of a tablet server:
kubectl exec --namespace yb-sanketh-test1 -it yb-tserver-0 -- /home/yugabyte/bin/ysqlsh -h yb-tserver-0.yb-tservers.yb-sanketh-test1
6. Cleanup YugabyteDB Pods
For helm 2:
helm delete yb-sanketh-test1 --purge
For helm 3:
helm delete yb-sanketh-test1 -n yb-sanketh-test1
NOTE: You need to manually delete the persistent volume
kubectl delete pvc --namespace yb-sanketh-test1 -l app=yb-master
kubectl delete pvc --namespace yb-sanketh-test1 -l app=yb-tserver
dev-server-sanketh-3 12:38 ~/code/charts [master] $
kubectl get pods -n yb-sanketh-test1
NAME READY STATUS RESTARTS AGE
yb-master-0 2/2 Running 0 2m28s
yb-master-1 2/2 Running 0 2m28s
yb-master-2 2/2 Running 0 2m28s
yb-tserver-0 2/2 Running 1 2m28s
yb-tserver-1 2/2 Running 3 2m28s
yb-tserver-2 2/2 Running 3 2m28s
dev-server-sanketh-3 12:39 ~/code/charts [master] $
kubectl exec -it pod/yb-tserver-0 -n yb-sanketh-test1 -- bash
Defaulting container name to yb-tserver.
Use 'kubectl describe pod/yb-tserver-0 -n yb-sanketh-test1' to see all of the containers in this pod.
[root@yb-tserver-0 cores]# hostname -f
yb-tserver-0.yb-tservers.yb-sanketh-test1.svc.cluster.local
[root@yb-tserver-0 cores]# ysqlsh -h yb-tserver-0.yb-tservers.yb-sanketh-test1.svc.cluster.local
ysqlsh (11.2-YB-2.3.0.0-b0)
Type "help" for help.
yugabyte=# create table t(id int primary key);
CREATE TABLE
yugabyte=# insert into t values(1);
INSERT 0 1
yugabyte=# \i /home/yugabyte/share/northwind_ddl.sql
SET
SET
SET
SET
SET
SET
SET
SET
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
yugabyte=# ^D\q
[root@yb-tserver-0 cores]# curl http://yb-master-0.yb-masters.yb-sanketh-test1.svc.cluster.local
curl: (7) Failed connect to yb-master-0.yb-masters.yb-sanketh-test1.svc.cluster.local:80; Connection refused
[root@yb-tserver-0 cores]# ^C
[root@yb-tserver-0 cores]# curl http://yb-master-0.yb-masters.yb-sanketh-test1.svc.cluster.local:7000
<!DOCTYPE html><html> <head> <title>YugabyteDB</title> <link rel='shortcut icon' href='/favicon.ico'> <link href='/bootstrap/css/bootstrap.min.css' rel='stylesheet' media='screen' /> <link href='/bootstrap/css/bootstrap-theme.min.css' rel='stylesheet' media='screen' /> <link href='/font-awesome/css/font-awesome.min.css' rel='stylesheet' media='screen' /> <link href='/yb.css' rel='stylesheet' media='screen' /> </head>
<body>
<nav class="navbar navbar-fixed-top navbar-inverse sidebar-wrapper" role="navigation"> <ul class="nav sidebar-nav"> <li><a href='/'><img src='/logo.png' alt='YugabyteDB' class='nav-logo' /></a></li>
<li class='nav-item'><a href='/'><div><i class='fa fa-home'aria-hidden='true'></i></div>Home</a></li>
<li class='nav-item'><a href='/tables'><div><i class='fa fa-table'aria-hidden='true'></i></div>Tables</a></li>
<li class='nav-item'><a href='/tablet-servers'><div><i class='fa fa-server'aria-hidden='true'></i></div>Tablet Servers</a></li>
<li class='nav-item'><a href='/utilz'><div><i class='fa fa-wrench'aria-hidden='true'></i></div>Utilities</a></li>
</ul> </nav>
<div class='yb-main container-fluid'><h1>YugabyteDB</h1>
<div class='row dashboard-content'>
<div class='col-xs-12 col-md-8 col-lg-6'>
<div class='panel panel-default'>
<div class='panel-heading'><h2 class='panel-title'> Overview</h2></div>
<div class='panel-body table-responsive'><table class='table'>
<tr> <td><i class='fa fa-database yb-dashboard-icon' aria-hidden='true'></i><span class='yb-overview'>Universe UUID </span></td> <td>10cb38f3-0ebe-4e03-bd32-798fabe30f12</td> </tr>
<tr> <td><i class='fa fa-files-o yb-dashboard-icon' aria-hidden='true'></i><span class='yb-overview'>Replication Factor </span></td> <td>3 <a href='/cluster-config' class='btn btn-default pull-right'>See full config &raquo;</a></td> </tr>
<tr> <td><i class='fa fa-server yb-dashboard-icon' aria-hidden='true'></i><span class='yb-overview'>Num Nodes (TServers) </span></td> <td>3 <a href='/tablet-servers' class='btn btn-default pull-right'>See all nodes &raquo;</a></td> </tr>
<tr> <tr><td><i class='fa fa-table yb-dashboard-icon' aria-hidden='true'></i><span class='yb-overview'>Num User Tables </span></td> <td>15 <a href='/tables' class='btn btn-default pull-right'>See all tables &raquo;</a></td> </tr>
<tr><td><i class='fa fa-tasks yb-dashboard-icon' aria-hidden='true'></i><span class='yb-overview'>Is Load Balanced?</span></td><td><i class='fa fa-check' aria-hidden='true'> </i></td></tr>
<tr><td><i class='fa fa-code-fork yb-dashboard-icon' aria-hidden='true'></i><span class='yb-overview'>YugabyteDB Version </span></td><td>2.3.0.0</td></tr>
<tr><td><i class='fa fa-terminal yb-dashboard-icon' aria-hidden='true'></i><span class='yb-overview'>Build Type </span></td><td>RELEASE</td></tr>
</table></div> <!-- panel-body -->
</div> <!-- panel -->
</div> <!-- col-xs-12 col-md-8 col-lg-6 -->
<div class='col-xs-12 col-md-8 col-lg-6'>
<div class='panel panel-default'>
<div class='panel-heading'><h2 class='panel-title'>Masters</h2></div>
<div class='panel-body table-responsive'><table class='table'>
<tr>
<th>Server</th>
<th>RAFT Role</th> <th>Details</th>
</tr>
<tr>
<td><a href="http://yb-master-0.yb-masters.yb-sanketh-test1.svc.cluster.local:7000/">yb-master-0.yb-masters.yb-sanketh-test1.svc.cluster.local:7000</a></td>
<td>FOLLOWER</td>
<td><div><span class='yb-overview'>CLOUD: </span>cloud1</div>
<div><span class='yb-overview'>REGION: </span>datacenter1</div>
<div><span class='yb-overview'>ZONE: </span>rack1</div>
<div><span class='yb-overview'>UUID: </span>19c446c7be6e4923bf6a31a73bedd248</div></td>
</tr>
<tr>
<td><b><a href="http://yb-master-1.yb-masters.yb-sanketh-test1.svc.cluster.local:7000/">yb-master-1.yb-masters.yb-sanketh-test1.svc.cluster.local:7000</a></b></td>
<td>LEADER</td>
<td><div><span class='yb-overview'>CLOUD: </span>cloud1</div>
<div><span class='yb-overview'>REGION: </span>datacenter1</div>
<div><span class='yb-overview'>ZONE: </span>rack1</div>
<div><span class='yb-overview'>UUID: </span>25c0e946c53e4d90a76a26acb6753de2</div></td>
</tr>
<tr>
<td><a href="http://yb-master-2.yb-masters.yb-sanketh-test1.svc.cluster.local:7000/">yb-master-2.yb-masters.yb-sanketh-test1.svc.cluster.local:7000</a></td>
<td>FOLLOWER</td>
<td><div><span class='yb-overview'>CLOUD: </span>cloud1</div>
<div><span class='yb-overview'>REGION: </span>datacenter1</div>
<div><span class='yb-overview'>ZONE: </span>rack1</div>
<div><span class='yb-overview'>UUID: </span>78dd0369a2394f478e81b8615848d7ee</div></td>
</tr>
</table></div> <!-- panel-body -->
</div> <!-- panel -->
</div> <!-- col-xs-12 col-md-8 col-lg-6 -->
<div class='col-md-12 col-lg-12'>
<div class='panel panel-default'>
<div class='panel-heading'><h2 class='panel-title'>User tables</h2></div>
<div class='panel-body table-responsive'><table class='table table-striped' style='table-layout: fixed;'>
<tr><th width='14%'>Keyspace</th>
<th width='21%'>Table Name</th>
<th width='9%'>State</th>
<th width='14%'>Message</th>
<th width='28%'>UUID</th>
<th width='14%'>YSQL OID</th></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a9000030008000000000004000">t</a></td><td>Running</td><td></td><td>000030a9000030008000000000004000</td><td>16384</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a9000030008000000000004005">categories</a></td><td>Running</td><td></td><td>000030a9000030008000000000004005</td><td>16389</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a900003000800000000000400a">customer_demographics</a></td><td>Running</td><td></td><td>000030a900003000800000000000400a</td><td>16394</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a900003000800000000000400f">customers</a></td><td>Running</td><td></td><td>000030a900003000800000000000400f</td><td>16399</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a9000030008000000000004014">customer_customer_demo</a></td><td>Running</td><td></td><td>000030a9000030008000000000004014</td><td>16404</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a9000030008000000000004023">employees</a></td><td>Running</td><td></td><td>000030a9000030008000000000004023</td><td>16419</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a900003000800000000000402d">suppliers</a></td><td>Running</td><td></td><td>000030a900003000800000000000402d</td><td>16429</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a9000030008000000000004032">products</a></td><td>Running</td><td></td><td>000030a9000030008000000000004032</td><td>16434</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a9000030008000000000004041">region</a></td><td>Running</td><td></td><td>000030a9000030008000000000004041</td><td>16449</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a9000030008000000000004046">shippers</a></td><td>Running</td><td></td><td>000030a9000030008000000000004046</td><td>16454</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a900003000800000000000404b">orders</a></td><td>Running</td><td></td><td>000030a900003000800000000000404b</td><td>16459</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a900003000800000000000405f">territories</a></td><td>Running</td><td></td><td>000030a900003000800000000000405f</td><td>16479</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a9000030008000000000004069">employee_territories</a></td><td>Running</td><td></td><td>000030a9000030008000000000004069</td><td>16489</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a9000030008000000000004078">order_details</a></td><td>Running</td><td></td><td>000030a9000030008000000000004078</td><td>16504</td></tr>
<tr><td>yugabyte</td><td><a href="/table?id=000030a9000030008000000000004087">us_states</a></td><td>Running</td><td></td><td>000030a9000030008000000000004087</td><td>16519</td></tr>
</table>
</div> <!-- panel-body -->
</div> <!-- panel -->
<div class='panel panel-default'>
<div class='panel-heading'><h2 class='panel-title'>Index tables</h2></div>
<div class='panel-body table-responsive'>There are no index tables.
</div> <!-- panel-body -->
</div> <!-- panel -->
</div> <!-- col-md-12 col-lg-12 -->
<div class='yb-bottom-spacer'></div></div>
<footer class='footer'><div class='yb-footer container text-muted'><pre class='message'><i class="fa-lg fa fa-gift" aria-hidden="true"></i> Congratulations on installing YugabyteDB. We'd like to welcome you to the community with a free t-shirt and pack of stickers! Please claim your reward here: <a href='https://www.yugabyte.com/community-rewards/'>https://www.yugabyte.com/community-rewards/</a></pre><pre>version 2.3.0.0 build 176 revision ecf9a28370793c532cb50ba64726b6341bdca48b build_type RELEASE built at 05 Sep 2020 10:31:32 UTC
server uuid 19c446c7be6e4923bf6a31a73bedd248</pre></div></footer></body></html>[root@yb-tserver-0 cores]#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment