Adoptable Cookbooks List

Looking for a cookbook to adopt? You can now see a list of cookbooks available for adoption!
List of Adoptable Cookbooks

Supermarket Belongs to the Community

Supermarket belongs to the community. While Chef has the responsibility to keep it running and be stewards of its functionality, what it does and how it works is driven by the community. The chef/supermarket repository will continue to be where development of the Supermarket application takes place. Come be part of shaping the direction of Supermarket by opening issues and pull requests or by joining us on the Chef Mailing List.

Select Badges

Select Supported Platforms

Select Status

RSS

maxdb (2) Versions 0.1.14

Installs/Configures maxdb

Policyfile
Berkshelf
Knife
cookbook 'maxdb', '~> 0.1.14', :supermarket
cookbook 'maxdb', '~> 0.1.14'
knife supermarket install maxdb
knife supermarket download maxdb
README
Dependencies
Changelog
Quality 33%

maxdb Cookbook

This cookbook provides recipes for installing SAP MAXDB Server Tested with Vagrant & AWS Provider
For more information, other SAP Cookbooks, questions and feedback please go to: http://sapcc.github.io/sap-cookbook-docs/

This cookbook
- creates a volume for the data
- installs the MaxDB binaries
- creates a default database instance
- starts the MaxDB including x-server

Requirements

Installation binary

The installation bin is taken from service market of sap, you should login and take it from there
link: https://support.sap.com/software/databases.html

Platform

  • AWS Image - Suse SLES 11 SP3 (checked on this AMI: ami-f1f5acc1 from region: us-west-2)
  • approx. 80GB in the rootfs directory
  • AWS EC2 Instance Type: m4.large (Minimum requirements - tested on this type)

Dependencies (recepies)

Please ensure that you have accessibility to the following:
- ark
- lvm

Attributes

All attributes have sane default values (See attributes/default.rb). You can install any supported component in this cookbook, without overriding any attributes. In case you need to override an attribute(s), use either a role or a wrapper cookbook. See examples in the examples section.

maxdb::default

<table>
<tr>
<th>Key</th>
<th>Type</th>
<th>Description</th>
<th>Default</th>
</tr>
<tr>
<td><tt>['maxdb']['tmpDir']</tt></td>
<td>String</td>
<td>tmp dir to put zip files and setup scripts</td>
<td><tt>/tmp</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['sapdbDir']</tt></td>
<td>String</td>
<td>base directory for installation</td>
<td><tt>/sapdb</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['programDir']</tt></td>
<td>String</td>
<td>global programs directory</td>
<td><tt>/sapdb/programs</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['SID']</tt></td>
<td>String</td>
<td>instance id</td>
<td><tt>SID</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['volDataDir']</tt></td>
<td>String</td>
<td>path to the data volume</td>
<td><tt>/sapdb/['maxdb']['SID']/sapdata1</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['volLogDir']</tt></td>
<td>String</td>
<td>path to the log volume</td>
<td><tt>/sapdb/['maxdb']['SID']/saplog1</tt></td>
</tr>
</table>

maxdb::installdb

<table>
<tr>
<th>Key</th>
<th>Type</th>
<th>Description</th>
<th>Default</th>
</tr>
<tr>
<td><tt>['maxdb']['repoUrl']</tt></td>
<td>String</td>
<td>Repository url pointing to the maxdb installation files</td>
<td><tt>http://example-server.org:8080/location-of-binary/</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['version']</tt></td>
<td>String</td>
<td>MaxDB version</td>
<td><tt>7.8</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['globalDataDir']</tt></td>
<td>String</td>
<td>global data directory</td>
<td><tt>/sapdb/data</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['instDbDir']</tt></td>
<td>String</td>
<td>instance data directory</td>
<td><tt>/sapdb/<SID>/db</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['zipFile']</tt></td>
<td>String</td>
<td>Name of the installation zip file</td>
<td><tt>filename.tgz</tt></td>
</tr>
</table>

maxdb::dbsettings

<table>
<tr>
<th>Key</th>
<th>Type</th>
<th>Description</th>
<th>Default</th>
</tr>
<tr>
<td><tt>['maxdb']['scriptName']</tt></td>
<td>String</td>
<td>Name of the MaxDB setup script to be found in the templates</td>
<td><tt>createdb</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['dbName']</tt></td>
<td>String</td>
<td>Name of the Database to be created</td>
<td><tt>DEFAULT</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['dbmOperator']['name']</tt></td>
<td>String</td>
<td>name of the DBM operator</td>
<td><tt>dbm</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['dbmOperator']['password']</tt></td>
<td>String</td>
<td>password of the DBM operator</td>
<td><tt>dbm</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['dbUser']['name']</tt></td>
<td>String</td>
<td>name of the DB User</td>
<td><tt>DBADMIN</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['dbUser']['password']</tt></td>
<td>String</td>
<td>password of the DB User</td>
<td><tt>admin</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['dbUser']['xuser']</tt></td>
<td>String</td>
<td>key of the DB User in the XUSERS list (of root)</td>
<td><tt>dba</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['sessionTimeout']</tt></td>
<td>String</td>
<td>DB parameter sessionTimeout</td>
<td><tt>0 (unlimited Sessions)</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['CacheMemorySize']</tt></td>
<td>String</td>
<td>DB parameter CacheMemorySize</td>
<td><tt>1000</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['MaxDataVolumes']</tt></td>
<td>String</td>
<td>DB parameter MaxDataVolumes</td>
<td><tt>64</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['MaxUserTasks']</tt></td>
<td>String</td>
<td>DB parameter MaxUserTasks</td>
<td><tt>120</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['DefaultCodePage']</tt></td>
<td>String</td>
<td>DB parameter DefaultCodePage</td>
<td><tt>UNICODE</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['autoUpdateStatistics']</tt></td>
<td>String</td>
<td>DB parameter autoUpdateStatistics</td>
<td><tt>ON</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['autoExtend']</tt></td>
<td>String</td>
<td>DB parameter autoExtend</td>
<td><tt>ON</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['autoExtendPercentage']</tt></td>
<td>String</td>
<td>DB parameter autoExtend on percentage</td>
<td><tt>90</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['logOverwrite']</tt></td>
<td>String</td>
<td>DB parameter logOverwrite</td>
<td><tt>ON</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['maxSQLLocks']</tt></td>
<td>String</td>
<td>DB parameter MaxSQLLocks</td>
<td><tt>900000</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['maxServerTasks']</tt></td>
<td>String</td>
<td>DB parameter MaxServerTasks</td>
<td><tt>4096</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['joinTableBufferSize']</tt></td>
<td>String</td>
<td>DB parameter JoinTableBufferSize</td>
<td><tt>16384</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['joinSearchLevel']</tt></td>
<td>String</td>
<td>DB parameter JoinSearchLevel</td>
<td><tt>4</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['maxTransactions']</tt></td>
<td>String</td>
<td>DB parameter MaxTransactions</td>
<td><tt>32767</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['maxCPUs']</tt></td>
<td>String</td>
<td>DB parameter MaxCPUs</td>
<td><tt>3</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['maxLogVolumes']</tt></td>
<td>String</td>
<td>DB parameter MaxLogVolumes</td>
<td><tt>4</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['autoRecreateBadIndex']</tt></td>
<td>String</td>
<td>DB parameter AutoRecreateBadIndex. Can be ALL, UNIQUE or OFF</td>
<td><tt>ALL</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['db']['parameter']['autoLogBackup']</tt></td>
<td>String</td>
<td>DB parameter AutoLogBackup. Can be on or off (must be lower case). Do not turn on, when ['maxdb']['db']['parameter']['logOverwrite'] is activated.</td>
<td><tt>off</tt></td>
</tr>
</table>

maxdb::createdb

<table>
<tr>
<th>Key</th>
<th>Type</th>
<th>Description</th>
<th>Default</th>
</tr>
<tr>
<td><tt>['maxdb']['scriptName']</tt></td>
<td>String</td>
<td>Name of the MaxDB setup script to be found in the templates</td>
<td><tt>createdb</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['dbName']</tt></td>
<td>String</td>
<td>Name of the Database to be created</td>
<td><tt>DEFAULT</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['dbmOperator']['name']</tt></td>
<td>String</td>
<td>name of the DBM operator</td>
<td><tt>dbm</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['dbmOperator']['password']</tt></td>
<td>String</td>
<td>password of the DBM operator</td>
<td><tt>dbm</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['dbUser']['name']</tt></td>
<td>String</td>
<td>name of the DB User</td>
<td><tt>DBADMIN</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['dbUser']['password']</tt></td>
<td>String</td>
<td>password of the DB User</td>
<td><tt>admin</tt></td>
</tr>
<tr>
<td><tt>['maxdb']['dbUser']['xuser']</tt></td>
<td>String</td>
<td>key of the DB User in the XUSERS list (of root)</td>
<td><tt>dba</tt></td>
</tr>
</table>

Usage

maxdb::default

All-in-one to get a running DB.

First, create four volumes with device path '/dev/sapdb_pv_data, /dev/sapdb_pv_log, /dev/sapdb_pv_global, /dev/sapdb_pv_instance' and attach it to your node.
Then include maxdb in your node's run_list:

{
  "name":"my_node",
  "run_list": [
    "recipe[maxdb]"
  ]
}

and set at least the following attributes:

[maxdb][SID]
[maxdb][dbName]
[maxdb][dbmOperator][password]
[maxdb][dbUser][password]

maxdb::lvm

creates several ext3 lvm volume groups 'sapdb_vg_instance', 'sapdb_vg_global', 'sapdb_vg_data', 'sapdb_vg_log' and corresponding volumes from devices '/dev/sapdb_pv_instance', '/dev/sapdb_pv_global', '/dev/sapdb_pv_data', '/dev/sapdb_pv_log' and mounts it to '[maxdb][volDataDir]' (and subsequent)

maxdb::installdb

Downloads the installation zip file (tgz) from moo-repo and runs 'sdbinst' with the specified parameters.

maxdb::createdb

Processes the 'createdb' template and puts it to '/tmp'. Then it runs 'dbmcli -i /tmp/createdb' to setup a database named [:maxdb][:dbName].

maxdb::dbsettings

Processes the 'dbsettings' template and puts it to '/tmp'. Then it runs 'dbmcli -i /tmp/dbsettings' to configure the database named [:maxdb][:dbName].

maxdb::startdb

Starts the x_server and the database

Contributing

  1. Fork the repository on Github
  2. Create a named feature branch (like add_component_x)
  3. Write you change
  4. Write tests for your change (if applicable)
  5. Run the tests, ensuring they all pass
  6. Submit a Pull Request using Github

License and Authors

License: SAP AG
Authors: Stefan Weidemüller-Schmidt (stefan.weidemueller-schmidt@sap.com), Haggai Philip Zaggury, Dirk Lehmann (dirk.lehmann@sap.com)

Dependent cookbooks

ark = 0.4.0
lvm >= 0.0.0

Contingent cookbooks

There are no cookbooks that are contingent upon this one.

maxdb CHANGELOG

This file is used to list changes made in each version of the maxdb cookbook.

0.1.0

  • [your_name] - Initial release of maxdb

Check the Markdown Syntax Guide for help with Markdown.

The Github Flavored Markdown page describes the differences between markdown on github and standard markdown.

Collaborator Number Metric
            

0.1.14 passed this metric

Contributing File Metric
            

0.1.14 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a CONTRIBUTING.md file

Foodcritic Metric
            

0.1.14 failed this metric

FC064: Ensure issues_url is set in metadata: maxdb/metadata.rb:1
FC065: Ensure source_url is set in metadata: maxdb/metadata.rb:1
FC066: Ensure chef_version is set in metadata: maxdb/metadata.rb:1
FC069: Ensure standardized license defined in metadata: maxdb/metadata.rb:1
Run with Foodcritic Version 16.3.0 with tags metadata,correctness ~FC031 ~FC045 and failure tags any

No Binaries Metric
            

0.1.14 passed this metric

Testing File Metric
            

0.1.14 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a TESTING.md file

Version Tag Metric
            

0.1.14 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number