Free cookie consent management tool by TermsFeed Policy Generator

Changes between Version 17 and Version 18 of Documentation/Howto/SetupHiveServer


Ignore:
Timestamp:
06/17/13 14:05:21 (11 years ago)
Author:
pfleck
Comment:

Replaced old Hive Server Setup Wiki page with the new one after performance improvements.

Legend:

Unmodified
Added
Removed
Modified

  • Documentation/Howto/SetupHiveServer

    v17 v18  
    11= How to ... setup a Hive server =
     2
    23This page gives you instructions about how to setup and run a Hive server.
    34
    … …  
    1213
    1314== Setup IIS ==
     15 * In the Server Manager add `Non-HTTP Activation` in the Add Features Wizard under `.NET Framework 3.5.1 Features`
     16 * Go to Windows Services and start `NetTcpActivator` and `NetTcpPortSharing` services
    1417 * Open IIS Manager
    1518 * Create an application pool (Hive-3.3, .net 4.x, integrated)
    … …  
    1922 * Go to bindings of the website.
    2023  * Add a http-binding with port 80.
     24  * Add a net.tcp-binding with port 808 (Binding information: `808:*`)
    2125 * Create a new application within the website and call it Hive-3.3 and use the already created appPool Hive-3.3
    22  * Open advanced settings of the application and enter `http` as enabled protocols
     26 * Open advanced settings of the application and enter `http, net.tcp` as enabled protocols
    2327 * Grant the usergroup `IIS_IUSRS` read-permissions on the application directory
    2428 * Grant the `NETWORK SERVICE` group read access to the certificate you created in UsersHowtosDevelopServices
    2529 * For the charting to work in the Status.aspx page, a folder for caching the images has to be created. The default, as configured in the `Web.config`, is `C:\TempImageFiles\`. Note that `Network Service` must have read and write permissions to this folder.
     30 * Allow port 808 in Firewall
     31  * For Windows Firewall enable `Windows Communication Foundation Net.TCP Listener Adapter (TCP-In)` Rule in `Inbound Rules`
    2632
    2733
    … …  
    4349
    4450== Setup Hive database ==
     51 * Open the SQL Server Configuration Manager.
     52   * If the Configuration Manager displays `Remote Procedure call failed`, install SQL Service Pack 1 (http://www.microsoft.com/en-us/download/details.aspx?id=26727).
     53 * Right click the `SQL Server (MSSQLSERVER)` and select properties.
     54 * In the Filestream Tab enable `Filestream for Transact-SQL access` and `Filestream for file I/O streaming access`.
     55 * Restart the service.
    4556 * Open the SQL Server Management Studio and create a new database called `HeuristicLab.Hive-3.3`
     57 * Go to the Properties of the new Database.
     58   * Select the `Filegroup` page and add a new Filestream called `FileStream` and use it as `default`.
     59   * Go to the `Files` page and add a new file `HeuristicLab.Hive-3.3_FileStream` with type `Filestream` and the Filegroup `FileStream` you created in the previous step. Set the Path where `HeuristicLab.Hive-3.3` database is located.
     60   * In the `Options` page set `Recovery model`(at the top) to `Simple` and `Auto Shrink` to `True`.
    4661 * Use the SQL Server Management Studio to open and execute the following two scripts in this order:
    4762   * `Initialize Hive Database.sql`
    4863   * `Prepare Hive Database.sql`
    49  * Both scripts can be found in `HeuristicLab.Services.Hive.DataAccess\3.3\SQL Scripts\`
     64   * If you have already installed an older Hive-Server version (< 3.3.x) and want to keep your data while updating to a newer version, execute `Migrate to Filestream.sql` instead. You have to execute the previous steps to enable the Filestream before executing the migration script.
     65 * All scripts can be found in `HeuristicLab.Services.Hive.DataAccess\3.3\SQL Scripts\`
    5066 * Use the SQL Server Management Studio to create a new login for the `NETWORK SERVICE` group (or the identity you defined when creating the application pool): In Object Explorer: Security -> Logins -> right click (New Login...). Next you have to add the login to the two created `HeuristicLab` databases (`HeuristicLab.Hive-3.3`, `HeuristicLab.Authentication`) in the `Users` section (in Object Explorer: Databases -> !HeuristicLab.* -> Security -> Users -> right click (New User...)).
    5167
    … …  
    8399
    84100After this change you have to recompile everything. The slave as well as the Job Manager and Administrator should now connect to your Hive server.
    85 
    86 
    87