Database Server Nodes

Database server nodes are servers that provide access to a number of databases. There are two main scenarios of registering a database server in the system:

Learn how to perform these operations next in this section.

Important: Database servers do not require a license key. You can register any number of database servers in the system without any limitations.

Adding a New Database Server Node

Before registering a new database server node, make sure that it meets the following requirements.

OS

MySQL and PostgreSQL:
RHEL 5.10, 6.4 (32-bit or 64-bit)
CentOS 5.10, 6.4 (32-bit or 64-bit)

CloudLinux 6 (32-bit or 64-bit)

 

MS SQL Server 2008:
Windows 2008 SP1 (32-bit or 64-bit)*
Windows 2008 R2 (64-bit)*
* - with installed .NET Framework 3.5 SP1 and Windows Installer 4.5

 

MS SQL Server 2012:
Windows 2008 R2 (64-bit) SP1

Windows 2012 (64-bit)

CPU

MySQL and PostgreSQL:
2 GHz or higher

MS SQL Server:
3.2 GHz or higher

RAM

MySQL and PostgreSQL:
1 GB

MS SQL Server:
2 GB

Disk space

At least 10 GB free

Open TCP ports

Communication between a service node and PPA panels: TCP ports 8352-8999

MySQL: TCP port 3306

PostgreSQL: TCP port 5432

To register a new database server node in PPA:

  1. Add a database server node to PPA by starting the Add New Node wizard in Administration Panel > Infrastructure > Service Nodes. The wizard will ask you to provide the following information:
  2. Normally, when the installation is complete, the node is marked as Ready to provide its services. If this does not happen, resolve the issue and mark it manually on the node properties page (Infrastructure > Service Nodes).

Once the registration is completed, the node will be added to the list of service nodes in Infrastructure > Service Nodes and in Infrastructure > Database Servers.
When registering a database server node, the system automatically assigns the MySQL, PostgreSQL, or Microsoft SQL provisioning attribute to the node.  

Registering an Existing Database Server

Supported database servers

MySQL 4.1, 5.0, 5.1, 5.5

PostgreSQL 7.4 – 8.4

Microsoft SQL Server 2000, 2005, 2008, 2008 R2, 2012

To register an existing database server in PPA:

  1. Start the Add Database Server wizard in Administration Panel > Infrastructure > Database Servers.
  2. Provide the following information to the wizard:

When registering an existing database server, the system does not add it to the list of available service nodes and does not automatically assign any provisioning attributes to this server. This server will be shown only in the list in Infrastructure > Database Servers.

Note that these database servers cannot be configured for automatic service provisioning. To use such a server for providing database services, you should assign its IP address to the corresponding MySQL database or PostgreSQL database resource type of a certain service template. This should be done in Products > Service Templates > select a template > Resources tab > select the MySQL database, PostgreSQL, or Microsoft SQL database resource type > Activation Parameters > Edit.

Integrating the myLittleAdmin Tool for Microsoft SQL Server Management

To enable your Windows hosting users to manage databases with a web-based tool called myLittleAdmin, you need to set up an IIS-based webspace on which myLittleAdmin will be deployed. That deployed instance will be used for serving all Windows-based hosting subscriptions. So, you will need to perform the following steps only once:

  1. Create an IIS-based webspace with enabled ASP.NET support.
  2. Obtain a distribution package from http://mylittleadmin.com/en/download.aspx.
  3. Upload the package into the /httpdocs directory of the webspace and extract its contents.
  4. Create a virtual directory linked to the directory with the extracted package, for example, mssqladmin.

    Now myLittleAdmin can be accessed via http://<webspace_name>/mssqladmin.

  5. Configure a connection to MS SQL Server as described in Installation Guide.pdf, which is available in the root directory of the extracted package.
  6. On the management node, issue the following command in the console:

    /usr/local/psa/bin/custombutton -c -place domain -text 'MS SQL ADMIN' -public true -url 'http://<webspace_name>/mssqladmin'

After that a button with the name 'MS SQL ADMIN' will appear in Hosting Panel > Websites tab, and will lead to http://<webspace_name>/mssqladmin.

 

Leave your comments on this page