# Notable Features

## Version Control

[Dolt](https://doltdb.com) is a database like no other. There are numerous Dolt version\
control features that you won't find elsewhere. Hosted Dolt gives you all the version\
control features of a running Dolt server without the hassle of running it yourself. For\
example:

* Create branches of your data.
* Merge changes you make with changes made by other people, and resolve conflicts using SQL.
* Look at the state of the data a given commit.
* Diff data between two commits or branches.
* Revert the changes made by a commit.

## Operations

### Logs

While your database is running we collect logging so you can monitor your database. View\
and download logs from any time period from the deployment console.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-c19c614fb9125db02d26a55bdf7e92161f1ff2c1%2Fhosted-logs.png?alt=media\&token=18bd8262-f41b-4e9c-a605-9c1fa6e85875)

### Monitoring

We also collect metrics on your running database and display graphs so you can see\
performance and usage in real time.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-1776c9b544dd61e4609f0e12b3dff47ab790636a%2Fhosted-monitoring.png?alt=media\&token=589b1767-102f-4b70-87c7-197d062be592)

### Custom Configuration

Dolt has a myriad of [configuration options](https://docs.dolthub.com/sql-reference/server/configuration).\
Most of these can be changed on the running server by setting the appropriate [system\
variable](https://docs.dolthub.com/sql-reference/version-control/dolt-sysvars). However, Hosted Dolt\
provides a simple UI for viewing and changing your deployment's custom configuration.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-19112079681ca3b50c8058407e082786180572c1%2Fhosted-custom-config.png?alt=media\&token=c3f3faa8-3944-4f80-901f-9ad12732116d)

### Replication

Scale your deployment read capacity or create hot failover instances by enabling read replication for your deployment. Configure how many replicas you want. You'll get\
logs and metrics for each server.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-875832d08a0f959bdea7de726b2cbdee1aded432%2Fhosted-replica-graphs.png?alt=media\&token=ff315e57-69f9-4e75-b511-ccd3ed823ffe)

### Backups

Full copies of all your databases are backed up nightly. These backups are kept for 14\
days.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-3e3881c451ab84280835ce4e1104dab9b8ba23c5%2Fhosted-backups.png?alt=media\&token=8ffeb297-aad0-4de5-945c-17f3a3f2a1b9)

As a version controlled database, Dolt can handle many of the situations where a backup\
would be needed by other databases. If you drop a table or write a bad delete statement\
you can revert to the previous commit. That said, there are still cases where a backup is\
needed, including dropping a database, hardware issues, data corruption, and destroying\
your history.

You can create a new deployment from any backup. Restoring from a backup currently\
requires you to create a support ticket.

Learn more about backups [here](https://www.dolthub.com/blog/2022-08-31-hosted-backups/).

### Private Networking

Want to use Hosted Dolt, but don't want your database to be reachable through the public internet.\
We support both AWS and GCP private networking.

[Private networking setup instructions](https://docs.dolthub.com/products/hosted/private-networking)

### Dolt Upgrades

We're releasing [new versions of Dolt](https://github.com/dolthub/dolt/releases) at least\
once per week. Set your service window and your deployed Dolt version will automatically\
get upgraded weekly to the latest available version with minimal downtime.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-4a5ad2ac34dde0d5ad8a514f6ba82de00c76f92b%2Fhosted-edit-service-window.png?alt=media\&token=412e1637-e604-413b-ae7b-4045bb104f16)

Or if you want to upgrade Dolt immediately, you can use the "Update Dolt version now"\
button in the Actions dropdown.

### Enterprise Support

Hosted Dolt comes with enterprise support. [Our team](https://www.dolthub.com/team) of\
veteran cloud service engineers will keep your database operating smoothly.

File support tickets directly from your deployment console and our on call team member\
will get back to you within the hour.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-b3002f63aeef6412c089d0f26d02721c4d480678%2Fhosted-support.png?alt=media\&token=6123fac5-0069-4292-bc0c-d7048bf59b51)

Learn more about our support ticket system[here](https://www.dolthub.com/blog/2022-07-13-hosted-dolt-incident-manager/).

### Access Management

Easily manage access to your deployment using the same permissions model as[DoltHub](https://docs.dolthub.com/concepts/dolthub/permissions) and[GitHub](https://docs.github.com/en/repositories/managing-your-repositorys-settings-and-features/managing-repository-settings/managing-teams-and-people-with-access-to-your-repository).

Create a deployment under an organization. All organization members have read access to\
your deployment. Create a team, add members, and give the whole team admin permission to\
your deployment.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-69fa68afaafc479c076568bf3029880f7c95c475%2Fhosted-org-members.png?alt=media\&token=b4cf344e-a053-4095-88bc-d852921fde29)

Need to add a one-off collaborator to a specific deployment? Add that user as a\
collaborator in your deployment's Settings tab.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-23ed4289de8ab23c7ea82259937fc7deed4dca30%2Fhosted-add-collaborator.png?alt=media\&token=e2f1f54e-37ab-4053-a97e-a70aa053b82f)

## Quick Start

### Trial Instance

To lower the cost barrier, Hosted Dolt offers [trial\
instance](https://www.dolthub.com/blog/2022-10-24-hosted-trial-instances/) for $50 a\
month. For $50 you get a t2.medium running in EC2 with 50GB of storage. There is no time\
limit for these instances. This isn't a 30-day trial. It's an instance perfect for\
trialing Dolt.

### Connect Using Any MySQL Client

Dolt is a drop in replacement for MySQL. You can connect to your instance from anywhere\
using your favorite MySQL client using the connectivity information in the Connectivity\
tab of your deployment console.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-2b2f7f68f223ee4d6f177ad1afa626898f033200%2Fhosted-connectivity.png?alt=media\&token=0322c4a6-037a-4464-aa83-620087b8e8a8)

## SQL Workbench

### User Friendly Built-In Web GUI

Each deployment comes with a built-in SQL workbench, inspired by[DoltHub's](https://www.dolthub.com) database page. Browse your data in read-only mode or\
allow writes and make changes to your database from the web. The workbench comes with your\
favorite DoltHub features, including [pull requests](#pull-requests), [diffs](#diffs),[commit logs](#commit-log), [ER diagrams](#er-diagrams), [CSV upload and download](#csv-upload-and-download), and more!

![SQL workbench](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-b3002f63aeef6412c089d0f26d02721c4d480678%2Fhosted-support.png?alt=media\&token=6123fac5-0069-4292-bc0c-d7048bf59b51)

Learn more about the SQL workbench [here](https://docs.dolthub.com/products/hosted/sql-workbench).

### Pull Requests

Create pull requests for human review of changes to your database.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-dbc91b5668c7b3a555dae7d050453b7edf3369d1%2Fhosted-workbench-pr.png?alt=media\&token=7f88302a-b24c-45d8-9ba6-cd27f8e222ea)

### Diffs

Analyze your data and schema changes in a diff and debug issues in specific commits.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-16e16622cfbea3698d6668cff3db34fb06ecd393%2Fhosted-workbench-pr-diff.png?alt=media)

### Commit Log

View an audit log of all changes made to your data.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-c8575fc6580eb14242864add5ab00b33d87b4bc2%2Fhosted-workbench-commit-log.png?alt=media\&token=8226b5ae-373f-496f-849a-bd883b0ecbf1)

### ER Diagrams

Visualize the entities in your database as well as the relationship between tables.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-3e97d6c1d31164da87d2a95fc730dbaf60373056%2Fhosted-workbench-er-diagram.png?alt=media\&token=af5d59e8-64e5-4593-b09e-8769d61c49c4)

### CSV Upload and Download

Update database tables using an uploaded CSV or the built-in spreadsheet editor.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-8ee9531ad8103bde1b2e3cc89810571122d47da0%2Fhosted-upload-csv.png?alt=media\&token=e29d4642-81e6-4ffb-95d5-925c199b7bc1)

And download query results as a CSV.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-3f5192e79353186db73de777ad8d2a3e4a4d5917%2Fhosted-download-results-popup.png?alt=media\&token=2396e730-87e8-4fb8-b4a6-c2ddfbbc4e12)

Learn more in [our blog](https://www.dolthub.com/blog/2023-06-30-hosted-workbench-csv-support/).

## Dolt Ecosystem

### Clone a Hosted Instance

In some cases you might want to clone your database from Hosted Dolt so that you can\
access Dolt's [command line interface](https://docs.dolthub.com/cli-reference/cli). Hosted provides an option\
to expose your instance's remotesapi endpoint to allow clone, fetch, and pull from your\
Hosted.

![](https://1372377717-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO3iUAEaFtCYE0joxfA%2Fuploads%2Fgit-blob-29648f2c86b1c7524cb83a129a0acb3d1c34fd60%2Fhosted-clone-commands.png?alt=media\&token=240a57b2-6700-41bb-8d0e-ad0f24fc4648)

Learn more in our [cloning guide](https://docs.dolthub.com/products/hosted/cloning).

### Use DoltHub as a Remote

To interact with DoltHub from your Hosted instance, you can use DoltHub as a[remote](https://docs.dolthub.com/concepts/dolt/git/remotes). We have [SQL\
remote](https://www.dolthub.com/blog/2021-09-22-sql-remotes) operations such as`dolt_clone`, `dolt_pull`, and `dolt_push` that let you interact with remotes using SQL.\
You can add Dolt credentials to your Hosted instance to authenticate certain operations,\
like cloning a private database from DoltHub or pushing changes to a DoltHub database you\
have write permissions to.

```sql
mysql> call dolt_clone('dolthub/user_metrics');
+--------+
| status |
+--------+
|      0 |
+--------+
1 row in set (0.71 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| user_metrics       |
+--------------------+
3 rows in set (0.05 sec)
```

Learn more in our [DoltHub as a remote guide](https://docs.dolthub.com/products/hosted/dolthub-as-remote).