Dashboard
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
The Dashboard provides a central screen to monitor the overall status of the Ingest instance.
-
Dashboard provides quick access to configure Ingest, including the following:
-
Source Database
-
Destination Database
-
Tables
-
Schedule Tasks
-
-
The Checklist gives the summary of the steps that are needed to complete to start an Ingest job.
-
The graph summary displays the number of records transferred.
-
When Hourly is selected, you can view transfer statistics for the past 24 hours.
-
When Daily is selected, the monthly statistics are shown.
-
The bar graph illustrates the process status:
-
Initial Extract is represented by blue.
-
Inserts are represented by green.
-
Updates are represented by yellow.
-
Deletes are represented by red.
-
-
Hovering over the bar graph shows the exact number of records transferred.
-
-
You can view the log for Source and Destination database at the bottom.
Source Database
You can configure the following databases as a source: Oracle, Microsoft SQL Server, MySQL, PostgreSQL, and Snowflake.
To configure the source database, navigate to Dashboard > Source, and then select the gear icon.
Destination Database
You can configure SingleStore databases as a destination.
-
In the Destination Database dialog, select SingleStore from the Destination Database list.
-
In the SingleStore tab, enter the following configuration details:
-
Host Name: Enter the IP address or hostname of the database server.
-
Port: Enter the port number on which the database server is listening (default port for SingleStore is 3306).
-
Database Name: Enter the name of your database.
-
User ID: Enter a valid SingleStore user ID to be used with Ingest.
-
Password: Enter the password and confirm it by re-entering it in the Confirm Password field.
Note: Passwords are encrypted within Ingest.
-
JDBC Options (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database.
-
-
Select the Advanced Options tab.
Enter the following configuration details: -
Max Updates (Default maximum update is 4)
-
Load Threads
-
Add Database Prefix
-
Truncate table instead of drop
-
Schema for all tables
-
Ignore database name in schema
-
Schema for staging tables
-
Retain staging tables
Refer to Appendix for more information.
-
-
Select Apply to confirm and save the details.
-
Select Test to verify the connectivity.
Multi-Tenant Support
The Schema for all tables field in the Advanced Options controls how source tables are written to the destination, along with support for multi-tenancy.
-
Enter a single database name (e.
g. main_ db) to direct all source tables to that database. -
For multi-tenancy, enter a database name followed by the destination table name in the following format:
<dbname>.
<destination_ table_ name> where
destination_
can include the below symbols, along with other characters, if desired:table_ name -
%d
: Source database name -
%s
: Source schema name -
%t
: Source table name
-
Examples
-
A table called
customer
from source databasetenant1_
is transferred to SingleStore.db Schema for all tables set to:
main_
db. %d_ %t Destination database name will be:
main_
db Destination table will be:
tenant1_
db_ customer -
A table called
supplier
from databaseserver_
, schemadb org_
is transferred to SingleStore.1 Schema for all tables set to:
dest_
db. %s_ %t Destination database name will be:
dest_
db Destination table will be:
org_
1_ supplier
Last modified: January 29, 2025