20.9. FileSystem Metadata¶

The FileSystem data store (FSDS) stores metadata about partitions and data files, to avoid having to repeatedly interrogate the filesystem. When a new data file is added or removed, an associated metadata entry will be created to track the operation.

20.9.1. File System Persistence¶

By default, metadata information is stored as a change log in the metadata folder under the root path for the FSDS. This is the simplest solution, as it does not require any additional infrastructure. However, the initial time required to read the metadata may be a limitation when dealing with a large number of partitions.

If the number of metadata files grows too large, they may be reduced by using the compact or manage-metadata command-line functions, and/or manually moved into sub-folders.

20.9.2. Relational Database Persistence¶

Alternatively, metadata may be stored in a relational database through JDBC. See Configuring Metadata Persistence for information on how to configure the metadata. A relational database may be specified by using the name jdbc, and supports the following configuration options (required options are marked with *):

Key	Description
`jdbc.url *`	The JDBC connection URL, e.g. `jdbc:postgresql://localhost/geomesa`
`jdbc.driver`	The fully-qualified name of a JDBC driver class, e.g. `org.postgresql.Driver`
`jdbc.user`	The database user used to create connections
`jdbc.password`	The password for the database user
`jdbc.pool.min-idle`	The minimum number of connections to keep idle in the database connection pool
`jdbc.pool.max-idle`	The maximum number of connections to keep idle in the database connection pool
`jdbc.pool.max-size`	The maximum size of the database connection pool
`jdbc.pool.fairness`	Enable fairness when retrieving from the database connection pool (`true` or `false`)
`jdbc.pool.test-on-borrow`	Test connections when retrieving them from the database connection pool (`true` or `false`)
`jdbc.pool.test-on-create`	Test connections when initially creating them (`true` or `false`)
`jdbc.pool.test-while-idle`	Test idle connections in the database connection pool (`true` or `false`)

Currently, Postgres and H2 are officially supported. Other databases may work, but have not been tested.