8.1 Setting Up the SQL Database

Figure 8-3 illustrates that an SQL database is the second component deployed (after shared storage) when creating an expandable Filr deployment.

Figure 8-2 Set Up an SQL Database

IMPORTANT:Micro Focus recommends using an existing SQL database if one is available.

Prepare your in-house SQL server by completing the steps in one of the following sections:

8.1.1 Configuring a PostgreSQL Appliance

Deploying a PostgreSQL Appliance

  1. Deploy the PostgreSQL Appliance similar to the Filr Appliance. The binary is available on the sld.microfocus.com location.

  2. Specify <postgresqlappliance_IP or hostname>:9443 to access the PostgreSQL Appliance as the vaadmin user.

  3. Under PostgreSQL Appliance Tools, click Configure PostgreSQL.

  4. Specify a password for the “postgres” user, then click OK.

Creating User Roles for Accessing PostgreSQL Appliance

This user is used when connecting Filr to PostgreSQL in 9443 console.

  1. Under PostgreSQL Appliance Tools, click phpPgAdmin.

  2. Click PostgreSQL, then specify the Username as “postgres” and password that you specified in Step 4.

  3. Click Roles > Create role.

  4. Specify all the required details to create a user. Ensure to select the options: Create DB? and Can login? and click Create.

Creating Database for Connecting to Filr

This database is used to connect to Filr.

  1. Click Databases > Create database.

  2. The Name should be same as the user you created in Step 4.

  3. In the Template field, select template0, then continue with defaults and click Create.

  4. (Optional) Create one more database, if you want to connect to Filr with a database with a different name than the user.

8.1.2 Configuring a MySQL or MariaDB Server

This section describes configuring MySQL or MariaDB server by using the Filr configuration wizard. It is recommended not to manually create the Filr database on your MySQL or MariaDB server.

The MySQL database mentioned in this section is an existing database and not a Filr default database. From Filr 4, the default database is PostgreSQL.

Table 8-1 Configuring MySQL or MariaDB for Filr

File

Do This

 

1 - Edit the configuration file.

MySQL or MariaDB server > /etc/my.cnf file

  1. Edit the file as follows:

    [client] 
default-character-set = utf8
    [mysqld]
character-set-server = utf8
max_connections = 900
transaction-isolation = READ-COMMITTED
expire_logs_days = 7

    The expire_logs_days setting is optional, but is recommended because it cleans up mysql-bin-* files.

    Unless this is done regularly, the files will consume significant disk space in the vastorage directory.

  2. Uncomment the InnoDB tables section.

  3. Increase the buffer pool size to approximately 60 percent of the amount of RAM that has been allocated to the dedicated server.

    For example, a dedicated server with 4 GB of RAM should have a buffer pool size of 2560 MB, as follows:

    innodb_buffer_pool_size = 2560M

  4. Identify or create a user account with sufficient rights to create and manage the Filr database.

Continue with Setting Up Two Filr Search Appliances.

8.1.3 Configuring a Microsoft SQL Server

IMPORTANT:Do not create the Filr database on your MS SQL server manually.

Let the Filr configuration wizard create the database to ensure the correct configuration.

Table 8-2 Configuring Microsoft SQL Server for Filr

File

Do This

 

1 - Configure the server.

Server management console

  1. Enable remote access to the Microsoft SQL database server.

  2. Open port 1433 on the Windows firewall where the database server is running.

  3. Identify or create a user account that is configured with SQL Server Authentication and has sufficient rights to create and manage the Filr database.

    IMPORTANT:Filr supports only SQL Server Authentication. Windows Authentication and Windows Domain User Authentication to Microsoft SQL are not supported.

Server management console

  1. Run the following queries against the database:

    ALTER DATABASE database-name SET READ_COMMITTED_SNAPSHOT ON         
ALTER DATABASE database-name COLLATE Latin1_General_CI_AS_KS_WS

  2. Continue with Setting Up Two Filr Search Appliances.