109 lines
3.4 KiB
Markdown
109 lines
3.4 KiB
Markdown
|
|
Use the [`influxdb3 create database` command](/influxdb3/version/reference/cli/influxdb3/create/database/)
|
|
to create a database in {{< product-name >}}.
|
|
Provide the following:
|
|
|
|
- Database name _(see [Database naming restrictions](#database-naming-restrictions))_
|
|
- {{< product-name >}} authorization token
|
|
|
|
> [!Note]
|
|
> While in beta, {{< product-name >}} does not require an authorization token.
|
|
|
|
<!--Allow fail for database create and delete: namespaces aren't reusable-->
|
|
<!--pytest.mark.skip-->
|
|
|
|
{{% code-placeholders "DATABASE_NAME" %}}
|
|
|
|
```sh
|
|
influxdb3 create database DATABASE_NAME
|
|
```
|
|
|
|
{{% /code-placeholders %}}
|
|
|
|
- [Database naming restrictions](#database-naming-restrictions)
|
|
- [InfluxQL DBRP naming convention](#influxql-dbrp-naming-convention)
|
|
- [Database limit](#database-limit)
|
|
|
|
<!--
|
|
## Retention period syntax
|
|
|
|
Use the `--retention-period` flag to define a specific
|
|
[retention period](/influxdb3/version/admin/databases/#retention-periods)
|
|
for the database.
|
|
The retention period value is a time duration value made up of a numeric value
|
|
plus a duration unit.
|
|
For example, `30d` means 30 days.
|
|
A zero duration (`0d`) retention period is infinite and data won't expire.
|
|
The retention period value cannot be negative or contain whitespace.
|
|
|
|
{{< flex >}}
|
|
{{% flex-content "half" %}}
|
|
|
|
##### Valid durations units include
|
|
|
|
- **m**: minute
|
|
- **h**: hour
|
|
- **d**: day
|
|
- **w**: week
|
|
- **mo**: month
|
|
- **y**: year
|
|
|
|
{{% /flex-content %}}
|
|
{{% flex-content "half" %}}
|
|
|
|
##### Example retention period values
|
|
|
|
- `0d`: infinite/none
|
|
- `3d`: 3 days
|
|
- `6w`: 6 weeks
|
|
- `1mo`: 1 month (30 days)
|
|
- `1y`: 1 year
|
|
- `30d30d`: 60 days
|
|
- `2.5d`: 60 hours
|
|
|
|
{{% /flex-content %}}
|
|
{{< /flex >}}
|
|
-->
|
|
|
|
## Database naming restrictions
|
|
|
|
Database names must adhere to the following naming restrictions:
|
|
|
|
- Alphanumeric characters
|
|
- Dashes (`-`), underscores (`_`), and forward slashes (`/`) are allowed
|
|
- Must start with a letter or number
|
|
- Maximum length of 64 characters
|
|
|
|
## InfluxQL DBRP naming convention
|
|
|
|
In InfluxDB 1.x, data is stored in [databases](/influxdb/v1/concepts/glossary/#database)
|
|
and [retention policies](/influxdb/v1/concepts/glossary/#retention-policy-rp).
|
|
In {{% product-name %}}, databases and retention policies have been merged into
|
|
_databases_; retention policies are no longer part of the data model.
|
|
Because InfluxQL uses the 1.x data model, to support InfluxQL queries the use
|
|
databases and retention policies, an {{< product-name >}} database must
|
|
be mapped to a v1 database and retention policy (DBRP) to be queryable with InfluxQL.
|
|
|
|
**When naming a database that you want to query with InfluxQL**, use the
|
|
following naming convention to automatically map v1 DBRP combinations to an
|
|
{{% product-name %}} database:
|
|
|
|
```text
|
|
database_name/retention_policy_name
|
|
```
|
|
|
|
##### Database naming examples
|
|
|
|
| v1 Database name | v1 Retention Policy name | New database name |
|
|
| :--------------- | :----------------------- | :------------------------ |
|
|
| db | rp | db/rp |
|
|
| telegraf | autogen | telegraf/autogen |
|
|
| webmetrics | 1w-downsampled | webmetrics/1w-downsampled |
|
|
|
|
## Database limit
|
|
|
|
**Maximum number of databases**: {{% influxdb3/limit "database" %}}
|
|
|
|
_For more information about {{< product-name >}} database, table, and column limits,
|
|
see [Database, table, and column limits](/influxdb3/version/admin/databases/#database-table-and-column-limits)._
|