SQL08x Appliance

[BeckyHester]

This topic is dedicated to questions and comments related to the SQL08X_03, SQL08WG_03, SQL08D_03, SQL08W_03, SQL08S_03, SQL08E_03: Microsoft SQL Server Database Appliances.

These appliance will be included in the AppLogic 2.7 Production release.

The SQL08 data sheet can be found at http://doc.3tera.net/AppLogic27/CatDatabaseAppliancesSQL.html. (page will be published concurrently with 2.7 release)

Please post any questions and/or comments here.

[danielsonchris]

Is there a recommended way of managing this sort of appliance and the actual SQL Server data? I'm scratching my head wondering how I'm going to get my SQL script onto the already mounted drive. Do I need to branch the class and then add a NET port on it so that I can patch my SQL database when the time is right?

Kind Regards,
Chris

[PeterNic]

Chris,

The easiest way to get something onto the data volume is to use the live appliance scp access method.

Essentially, you can scp anything to a running appliance's file system; for example:

scp myscript root@mygrid.mydomain.com:/app/myapp/main.mycomp/mypath

(everything that starts with 'my' are replacement variables -- your grid's controller host name, your app, the name of the SQL server appliance (instance name) and the path within it you want to store the file to)

Another way, if you prefer to access the volume while the appliance is not running is to use the filer; either use the "vol manage" command or the GUI method (open the app in the editor, select Application | Manage Volumes, select a volume, and choose Manage).


Let me know if any of the above helps,

-- Peter

[danielsonchris]

Peter,
This is a wonderful technique! Thanks for the pointer here.
Regards,
Chris