# danog\MadelineProto\Settings\Database\Mysql: MySQL backend settings. > MariaDb 10.2+ or Mysql 5.6+ required. [Back to index](../../../../index.html) > Author: Daniil Gentili MySQL backend settings. MariaDb 10.2+ or Mysql 5.6+ required. ## Method list: * [`getOrmSettings(): \danog\AsyncOrm\Settings`](#getOrmSettings) * [`getMaxConnections(): positive-int`](#getMaxConnections) * [`setMaxConnections(positive-int $maxConnections): static`](#setMaxConnections) * [`getIdleTimeout(): positive-int`](#getIdleTimeout) * [`setIdleTimeout(positive-int $idleTimeout): static`](#setIdleTimeout) * [`getDatabase(): string`](#getDatabase) * [`setDatabase(string $database): static`](#setDatabase) * [`getUsername(): string`](#getUsername) * [`setUsername(string $username): static`](#setUsername) * [`getUri(): string`](#getUri) * [`setUri(string $uri): static`](#setUri) * [`getEphemeralFilesystemPrefix(): ?string`](#getEphemeralFilesystemPrefix) * [`setEphemeralFilesystemPrefix(?string $ephemeralFilesystemPrefix): static`](#setEphemeralFilesystemPrefix) * [`getCacheTtl(): int`](#getCacheTtl) * [`setCacheTtl((int|string) $cacheTtl): static`](#setCacheTtl) * [`getPassword(): string`](#getPassword) * [`setPassword(string $password): static`](#setPassword) * [`getSerializer(): ?\danog\MadelineProto\Settings\Database\SerializerType`](#getSerializer) * [`setSerializer(?\danog\MadelineProto\Settings\Database\SerializerType $serializer): static`](#setSerializer) * [`getEnableFileReferenceDb(): bool`](#getEnableFileReferenceDb) * [`setEnableFileReferenceDb(bool $enableFileReferenceDb): static`](#setEnableFileReferenceDb) * [`getEnableMinDb(): bool`](#getEnableMinDb) * [`setEnableMinDb(bool $enableMinDb): static`](#setEnableMinDb) * [`getEnableUsernameDb(): bool`](#getEnableUsernameDb) * [`setEnableUsernameDb(bool $enableUsernameDb): static`](#setEnableUsernameDb) * [`getEnableFullPeerDb(): bool`](#getEnableFullPeerDb) * [`setEnableFullPeerDb(bool $enableFullPeerDb): static`](#setEnableFullPeerDb) * [`getEnablePeerInfoDb(): bool`](#getEnablePeerInfoDb) * [`setEnablePeerInfoDb(bool $enablePeerInfoDb): static`](#setEnablePeerInfoDb) ## Methods: ### `getOrmSettings(): \danog\AsyncOrm\Settings` #### See also: * `\danog\AsyncOrm\Settings` ### `getMaxConnections(): positive-int` Get maximum connection limit. #### See also: * `positive-int` ### `setMaxConnections(positive-int $maxConnections): static` Set maximum connection limit. Parameters: * `$maxConnections`: `positive-int` Maximum connection limit. #### See also: * `positive-int` ### `getIdleTimeout(): positive-int` Get idle timeout. #### See also: * `positive-int` ### `setIdleTimeout(positive-int $idleTimeout): static` Set idle timeout. Parameters: * `$idleTimeout`: `positive-int` Idle timeout. #### See also: * `positive-int` ### `getDatabase(): string` Get database name. ### `setDatabase(string $database): static` Set database name. Parameters: * `$database`: `string` Database name. ### `getUsername(): string` Get username. ### `setUsername(string $username): static` Set username. Parameters: * `$username`: `string` Username. ### `getUri(): string` Get database URI. ### `setUri(string $uri): static` Set database URI. Parameters: * `$uri`: `string` Database URI. ### `getEphemeralFilesystemPrefix(): ?string` If set, indicates that the filesystem is ephemeral, and thus session files will not be used to store persistent data. Must contain a unique string, used as prefix for database tables, different for every session. The prefix may be the same if different databases are used. This is useful when running MadelineProto inside docker containers without volumes, using just a database. Note that the session folder must still NEVER be deleted *if* MadelineProto is running, or else the session will be dropped from the database due to AUTH_KEY_DUPLICATED errors. Stopping the container and then deleting the session folder is 100% OK though. ### `setEphemeralFilesystemPrefix(?string $ephemeralFilesystemPrefix): static` If set, indicates that the filesystem is ephemeral, and thus session files will not be used to store persistent data. Must contain a unique string, used as prefix for database tables, different for every session. The prefix may be the same if different databases are used. This is useful when running MadelineProto inside docker containers without volumes, using just a database. Note that the session folder must still NEVER be deleted *if* MadelineProto is running, or else the session will be dropped from the database due to AUTH_KEY_DUPLICATED errors. Stopping the container and then deleting the session folder is 100% OK though. Parameters: * `$ephemeralFilesystemPrefix`: `?string` The database prefix ### `getCacheTtl(): int` Get for how long to keep records in memory after last read, for cached backends. ### `setCacheTtl((int|string) $cacheTtl): static` Set for how long to keep records in memory after last read, for cached backends. The cache TTL identifier can be a string like '+5 minutes'. When data is retrieved from a database it is stored in memory. This helps to reduce latency, improve speed and reduce mysql/postgres/redis load. Data will be removed from the cache if last access was more than this amount of time. Clean up is done once per minute. Parameters: * `$cacheTtl`: `(int|string)` For how long to keep records in memory after last read, for cached backends. ### `getPassword(): string` Get password. ### `setPassword(string $password): static` Set password. Parameters: * `$password`: `string` Password. ### `getSerializer(): ?\danog\MadelineProto\Settings\Database\SerializerType` #### See also: * [\danog\MadelineProto\Settings\Database\SerializerType](../../../../danog/MadelineProto/Settings/Database/SerializerType.html) ### `setSerializer(?\danog\MadelineProto\Settings\Database\SerializerType $serializer): static` Which serializer to use by default. If null, the best serializer is chosen. Parameters: * `$serializer`: `?\danog\MadelineProto\Settings\Database\SerializerType` #### See also: * [\danog\MadelineProto\Settings\Database\SerializerType](../../../../danog/MadelineProto/Settings/Database/SerializerType.html) ### `getEnableFileReferenceDb(): bool` Get whether to enable the file reference database. If disabled, will break file downloads. ### `setEnableFileReferenceDb(bool $enableFileReferenceDb): static` Set whether to enable the file reference database. If disabled, will break file downloads. Parameters: * `$enableFileReferenceDb`: `bool` Whether to enable the file reference database. If disabled, will break file downloads. ### `getEnableMinDb(): bool` Get whether to enable the min database. If disabled, will break sendMessage (and other methods) in certain conditions. ### `setEnableMinDb(bool $enableMinDb): static` Set whether to enable the min database. If disabled, will break sendMessage (and other methods) in certain conditions. Parameters: * `$enableMinDb`: `bool` Whether to enable the min database. If disabled, will break sendMessage (and other methods) in certain conditions. ### `getEnableUsernameDb(): bool` Get whether to enable the username database. If disabled, will break sendMessage (and other methods) with usernames. ### `setEnableUsernameDb(bool $enableUsernameDb): static` Set whether to enable the username database. If disabled, will break sendMessage (and other methods) with usernames. Parameters: * `$enableUsernameDb`: `bool` Whether to enable the username database. If disabled, will break sendMessage (and other methods) with usernames. ### `getEnableFullPeerDb(): bool` Get whether to enable the full peer info database. If disabled, will break getFullInfo. ### `setEnableFullPeerDb(bool $enableFullPeerDb): static` Set whether to enable the full peer info database. If disabled, will break getFullInfo. Parameters: * `$enableFullPeerDb`: `bool` Whether to enable the full peer info database. If disabled, will break getFullInfo. ### `getEnablePeerInfoDb(): bool` Get whether to enable the peer info database. If disabled, will break getInfo. ### `setEnablePeerInfoDb(bool $enablePeerInfoDb): static` Set whether to enable the peer info database. If disabled, will break getInfo. Parameters: * `$enablePeerInfoDb`: `bool` Whether to enable the peer info database. If disabled, will break getInfo. --- Generated by [danog/phpdoc](https://phpdoc.daniil.it)