Sanity check of multi-node deployment


#1

Hi folks,

I think I successfully deployed SciDB on two nodes (dfz-scidb-0, dfz-scidb-1) but I want to make sure it’s running on two nodes. Is there any simple way to verify this? How about the following command/output?:

ubuntu@dfz-scidb-0:~$ scidb.py dbginfo mydb
scidb.py: INFO: collect logs, cores, install files (srv 1 (dfz-scidb-1) local instance 1)
scidb.py: INFO: Running sftp remote: /home/ubuntu/mydb-DB/1/1/20160729-210135/srv-1-1-20160729-210135.tgz -> local: /home/ubuntu/mydb-DB/0/0/srv-1-1-20160729-210135.tgz
scidb.py: INFO: collect logs, cores, install files (srv 1 (dfz-scidb-1) local instance 0)
scidb.py: INFO: Running sftp remote: /home/ubuntu/mydb-DB/1/0/20160729-210135/srv-1-0-20160729-210135.tgz -> local: /home/ubuntu/mydb-DB/0/0/srv-1-0-20160729-210135.tgz
scidb.py: INFO: Running sftp remote: /home/ubuntu/mydb-DB/1/0/20160729-210135/install-srv-1-0-20160729-210135.tgz -> local: /home/ubuntu/mydb-DB/0/0/install-srv-1-0-20160729-210135.tgz
scidb.py: INFO: collect logs, cores, install files (srv 0 (dfz-scidb-0) local instance 1)
scidb.py: INFO: Running sftp remote: /home/ubuntu/mydb-DB/0/1/20160729-210135/srv-0-1-20160729-210135.tgz -> local: /home/ubuntu/mydb-DB/0/0/srv-0-1-20160729-210135.tgz
scidb.py: INFO: Running sftp remote: /home/ubuntu/mydb-DB/0/1/20160729-210135/install-srv-0-1-20160729-210135.tgz -> local: /home/ubuntu/mydb-DB/0/0/install-srv-0-1-20160729-210135.tgz
scidb.py: INFO: collect logs, cores, install files (srv 0 (dfz-scidb-0) local instance 0)
ubuntu@dfz-scidb-0:~$

Does this mean it’s working fine? Or, is there any query I can run under iquery to list all the running servers in my deployment?

Thanks!
Dongfang


#2

alright, it’s actually pretty simple, for example on 2 nodes (2 instances per node):

AFL% list(‘instances’);
{No} name,port,instance_id,online_since,instance_path
{0} ‘ip-172-31-0-201’,1239,0,‘2016-07-30 04:23:53’,’/home/ubuntu/mydb-DB/0/0’
{1} ‘ip-172-31-0-201’,1240,1,‘2016-07-30 04:23:53’,’/home/ubuntu/mydb-DB/0/1’
{2} ‘ip-172-31-0-202’,1239,4294967298,‘2016-07-30 04:23:54’,’/home/ubuntu/mydb-DB/1/0’
{3} ‘ip-172-31-0-202’,1240,4294967299,‘2016-07-30 04:23:54’,’/home/ubuntu/mydb-DB/1/1’
AFL%