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:As noted elsewhere, Micro Focus recommends using an existing SQL database if one is available.

If you need to use a MySQL appliance, prepare that now by completing the instructions in Section C.0, MySQL Appliance—Configuring (Alternate Practice) and then continue with Setting Up the Filr Appliances.

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

8.1.1 Configuring a MySQL or MariaDB Server

IMPORTANT:Do not create the Filr database on your MySQL or MariaDB server manually.

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

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	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. Uncomment the InnoDB tables section. 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 Identify or create a user account with sufficient rights to create and manage the Filr database.
Worksheet 23	Record the username and password on Worksheet 23. Continue with Setting Up Two Filr Search Appliances.

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	Enable remote access to the Microsoft SQL database server. Open port 1433 on the Windows firewall where the database server is running. 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.
Worksheet 23	Record the username and password on Worksheet 23.
Server management console	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 Continue with Setting Up Two Filr Search Appliances.