Database Tab in MySQL
In the Database tab, once you set the 'Database Provider' property to 'MySQL', the following configurations become available.
Database Section
This section contains general configurations for the MySQL Server database.
| Configuration | Description | Default value |
|---|---|---|
| Server | The hostname or IP address to the database server. | |
| Schema | The database schema to be used by OutSystems. |
For advanced settings, click on the Advanced Settings link.
| Configuration | Description | Default value |
|---|---|---|
| Advanced Connection Settings | ||
| Runtime Applications | Allows you to use a specific connection string for OutSystems applications. | |
| OutSystems Services | Allows you to use a specific connection string for OutSystems services. | |
| Default Query Timeout | Sets the default time for database queries to complete. The value can be overridden in the development environment, for each query. | 30 |
| 1-Click Publish | ||
| Database Update Query Timeout | Sets the default time for database updates to run when 1-Click publishing an application. | 600 |
Administrator Section
The 'Administrator' section allows you to configure the database user that manages the platform. This user owns the OutSystems metamodel tables, views, and indexes.
| Configuration | Description | Default value |
|---|---|---|
| User | Name of the user that is the owner of OutSystems metamodel tables. | OSADMIN |
| Password | Password for the user. |
Runtime Section
The 'Runtime' section allows you to configure the database user used by the applications at runtime. This user owns the tables created by developers in the development environment.
| Configuration | Description | Default value |
|---|---|---|
| User | Name of the user that is the owner of tables created in the development environment. | OSRUNTIME |
| Password | Password for the user. |
Log Section
In this section you specify the login of the user that owns logging tables, used by the OutSystems Log Service to write logs and rotate them whenever necessary.
| Configuration | Description | Default value |
|---|---|---|
| User | Name of the user that is the owner of logging tables. | OSLOG |
| Password | Password for the user. |
Create/Upgrade Database Button
To create all the database objects (tables, indexes, views, etc) the platform requires, click the 'Create/Upgrade Database'.
This button creates all necessary database objects (tables, indexes, views, stored procedures, etc) to run the OutSystems version you are installing.
To install or upgrade OutSystems, you should follow the installation checklist.