Forum

Discussions specific to version 8.1
Contributor
Offline
User avatar
Posts: 14
Joined: Wed Feb 11, 2015 3:57 pm

Restore on v8

by jagan.kumar » Mon Feb 23, 2015 8:33 am

Hi

We are trying to restore v7 backup on v8
Database size:4.5 TB
Backup size :1.5 TB

To improve the overall restore process, following options are set as part of wxrestore command.
-i to skip restore of table and view images
-T to restore required schema

Apart from these, are there any best practices/methods to improve overall restore process?

Thanks,
Jagan
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: Restore on v8

by markc » Mon Feb 23, 2015 9:26 am

You should probably disable SSL for the restore if you are running it from a trusted connection (e.g. from a dedicated AP), as that will speed things up.

http://www.kognitio.com/forums/ODBC%20Attributes.pdf mentions the SSLEnabled ODBC attribute that you can set to N to disable SSL for a DSN.
Reply with quote Top
Contributor
Offline
User avatar
Posts: 14
Joined: Wed Feb 11, 2015 3:57 pm

Re: Restore on v8

by jagan.kumar » Tue Feb 24, 2015 8:48 am

Hi Mark

I guess, the change has to be made on odbc.ini file in $WCS location in AP node.

Following is the new entries made in odbc.ini.
ServerAddress1=<DB IP addess>
ServerPort1=6550
Timeout=30
ForceConnect=N
SslEnabled=N

Thanks,
Jagan
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: Restore on v8

by markc » Tue Feb 24, 2015 4:41 pm

That looks fine. You can also check the NET_PROTOCOL field for connections in SYS.IPE_ALLCURSESSIONS - this will be "TCP/IP with SSL" for SSL connections and "TCP/IP" for non-SSL connections.
Reply with quote Top
Contributor
Offline
User avatar
Posts: 14
Joined: Wed Feb 11, 2015 3:57 pm

Re: Restore on v8

by jagan.kumar » Wed Feb 25, 2015 8:32 am

Thank you Mark.
BTW, just curious to know, in case of TBs of restore,
what can be the probable performance difference range based on your experience please -
with SSL vs without SSL?
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: Restore on v8

by markc » Wed Feb 25, 2015 9:21 am

I don't have a performance figure to hand for restore, but do have one for 7.2.1 backup which ran in 76% of the time with SSLEnabled=N compared to SSLEnabled=Y. From memory, we've seen bigger discrepancies than that with restore.
Reply with quote Top
Contributor
Offline
User avatar
Posts: 386
Joined: Thu May 23, 2013 4:48 pm

Re: Restore on v8

by markc » Wed Feb 25, 2015 9:39 am

I've found an old email from July 2011 indicating restore with SSLEnabled=N went 4 x faster on a system than the same restore with SSLEnabled=Y.

SSLEnabled=Y is the default as SSL should only be disabled when the connection is over a trusted network. The network between the AP and server can typically be trusted.
Reply with quote Top
Contributor
Offline
User avatar
Posts: 14
Joined: Wed Feb 11, 2015 3:57 pm

Re: Restore on v8

by jagan.kumar » Wed Feb 25, 2015 10:10 am

Thank you Mark
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 2 guests

cron