jBase5 Virtualized!
Goal: To prove that jBase5 online backup restored to Delphix can be run as virtualized database.Result: Done! Restored files are working just fine.
 |
| Delphix Express ingested jBase database. |
Nuts & Bolts
Testbed Components- Delphix Express 4.2.3.1
- jBase 5.2.13
- CentOS release 6.6 (Final) - VM
- jbaseadm user created
- jBase installed in /opt/jbase5/5.2.13 from jbaseadm user
- /home/jbase5 - database files folder
- System dictionary created in /home/jbase5 { CREATE-FILE DICT SYSTEM 11 }
- Account created in /home/jbase5/PLAY { CREATE-FILE DICT MD 29 }
- Account added to System file { JED SYSTEM PLAY }
001 D
002 /home/jbase5/PLAY
03 - 19 lines are null
020 ESYSTEM_START
021 jbase
022 /home/jbase5/PLAY
23 - 27 lines are null
028 /home/jbase5/PLAY/MD]D
29 - 36 lines are null
037 ESYSTEM_END
- Some test files taken from /opt/jbase5/5.2/samples/SQL and moved to PLAY account folder
- Environment variables configured
Scala Test Program
I have decided to test if database is working fine using simple Scala program. Program is connecting to jBase instance using JDBC interface and selecting some data from MYCUSTS database file.Test Program Source
#!/bin/sh
exec scala -Dorg.slf4j.simpleLogger.logFile=../logs/jbase_jdbc_test_$(date "+%Y.%m.%d-%H.%M.%S").log -Dorg.slf4j.simpleLogger.showDateTime=true -Dorg.slf4j.simpleLogger.dateTimeFormat="yyyy-MM-dd HH:mm:ss.S" -classpath "/opt/jbase5/5.2.13/java/lib/jbasejdbc.jar:../lib/slf4j-api-1.7.12.jar:../lib/slf4j-simple-1.7.12.jar:../lib/scala-logging_2.11-3.1.0.jar" "$0" "$@"
!#
println("jbase5 jdbc test")
println("Args: ")
args.foreach(println)
println("--")
import java.sql.{Connection, DriverManager, ResultSet, Date};
import java.util.{Calendar, Properties};
import com.typesafe.scalalogging.{Logger};
import org.slf4j.{LoggerFactory};
val logger = Logger(LoggerFactory.getLogger("jbase5_jdbc_test"))
val conn_str = "jdbc:jbase:thin:@localhost:20002/PLAY"
Class.forName("com.jbase.jdbc.driver.JBaseJDBCDriver")
val conn = DriverManager.getConnection(conn_str)
try {
val queryBv = "select * from MYCUSTS";
val statement = conn.prepareStatement(queryBv);
val rs = statement.executeQuery();
val rsMetaData = rs.getMetaData();
println("Qry: "+queryBv)
println("Number of columns: " + rsMetaData.getColumnCount());
for (i <- 1 to rsMetaData.getColumnCount()) println("Col"+i+": "+rsMetaData.getColumnName(i))
var i = 0
while(rs.next() && i<5) {
println(rs.getString(1) + ", " + rs.getString(2) + ", " + rs.getString(3) + ", " + rs.getString(4) + ", " + rs.getString(5) + ", " + rs.getString(6) + ", " + rs.getString(7) + ", " + rs.getString(8) + ", " + rs.getString(9));
i +=1
}
}
finally {
conn.close
}
Virtualization Test Plan
- Execute jBase background processes.
- Execute test program to see if we get data selected.
- Execute jbackup on /home/jbase5 folder
- Stop jBase background processes.
- Move original /home/jbase5 to backup location.
- Provision from Delphix empty vFiles folder and mount it in /home/jbase5
- Restore backup executing jrestore. After restore we have our jBase files inside Delphix Engine.
- Start jBase backgroud processes.
- Execute test program to see if we get data selected. If we get out test output we are successful!
Test Steps - Details
- Execute jBase background processes.
$ jbase_agent -p 20002 -F -A account &Execute test program to see if we get data selected.
# cd /opt/jbase5/5.2
# . jbase_env.sh
# jlogadmin -a On
# jRLA -ib
# sh jbase_jdbc_test.shExecute jbackup on /home/jbase5 folder
jbase5 jdbc test
Args:
--
Qry: select * from MYCUSTS
Number of columns: 15
Col1: RECID
Col2: FIRSTNAME
Col3: LASTNAME
Col4: ADDR1
Col5: ADDR2
Col6: CITY
Col7: STATE
Col8: ZIP
Col9: HOMETEL
Col10: WORKTEL
Col11: EMAIL
Col12: HARDWARE
Col13: OS
Col14: SYSTEMTYPE
Col15: NUMUSERS
0000041, ALAN, COOPER, 10260 SW GREENBURG RD, #1020, SEATTLE, WA, 24358, (124) 555-1337
0000041, ALAN, COOPER, 10260 SW GREENBURG RD, #1020, SEATTLE, WA, 24358, (124) 555-1337
0000041, ALAN, COOPER, 10260 SW GREENBURG RD, #1020, SEATTLE, WA, 24358, (124) 555-1337
0000041, ALAN, COOPER, 10260 SW GREENBURG RD, #1020, SEATTLE, WA, 24358, (124) 555-1337
0000041, ALAN, COOPER, 10260 SW GREENBURG RD, #1020, SEATTLE, WA, 24358, (124) 555-1337
# find /home/jbase5 -print | sort | jbackup -W -v > /tmp/jbase5_w.bakStop jBase background processes.
Move original /home/jbase5 to backup location.
# mv /home/jbase5 /home/jbase5_savProvision from Delphix empty vFiles folder and mount it in /home/jbase5
Restore backup executing jrestore. After restore we have our jBase files inside Delphix Engine.
cat /tmp/jbase5_w.bak | jrestore -vStart jBase backgroud processes.
$ jbase_agent -p 20002 -F -A account &Execute test program to see if we get data selected.
# cd /opt/jbase5/5.2
# . jbase_env.sh
# jlogadmin -a On
# jRLA -ib
# sh jbase_jdbc_test.shWorking!!!
jbase5 jdbc test
Args:
--
Qry: select * from MYCUSTS
Number of columns: 15
Col1: RECID
Col2: FIRSTNAME
Col3: LASTNAME
Col4: ADDR1
Col5: ADDR2
Col6: CITY
Col7: STATE
Col8: ZIP
Col9: HOMETEL
Col10: WORKTEL
Col11: EMAIL
Col12: HARDWARE
Col13: OS
Col14: SYSTEMTYPE
Col15: NUMUSERS
0000041, ALAN, COOPER, 10260 SW GREENBURG RD, #1020, SEATTLE, WA, 24358, (124) 555-1337
0000041, ALAN, COOPER, 10260 SW GREENBURG RD, #1020, SEATTLE, WA, 24358, (124) 555-1337
0000041, ALAN, COOPER, 10260 SW GREENBURG RD, #1020, SEATTLE, WA, 24358, (124) 555-1337
0000041, ALAN, COOPER, 10260 SW GREENBURG RD, #1020, SEATTLE, WA, 24358, (124) 555-1337
0000041, ALAN, COOPER, 10260 SW GREENBURG RD, #1020, SEATTLE, WA, 24358, (124) 555-1337
Starting from this point we can make snapshots of our virtualized jBase files and use all Delphix vFiles functionality to enjoy DaaS.
Conclusion
- Virtualizing jBase files seems to be straightforward and works very well.
- We can enjoy jBase DaaS with Delphix Engine.
