SingleStore | MemSQL

SingleStoreDB, formerly known as MemSQL, is a high-performance distributed relational database management system renowned for its real-time analytics capabilities. It offers unparalleled speed and scalability, allowing users to process and analyze massive volumes of data with low latency. SingleStoreDB's distributed architecture ensures high availability and fault tolerance, making it suitable for mission-critical applications requiring rapid data processing and analytics. With its support for both transactions and analytics in a single platform, SingleStoreDB empowers organizations to derive actionable insights and make data-driven decisions with ease.

SingleStore Integration with ADOC

ADOC extends its data reliability capabilities to data visualized through SingleStore. Integrating SingleStore as a data source into ADOC allows users to monitor and ensure the dependability and integrity of their visualized data, facilitating real-time data processing and analytics.

Steps to Integrate SingleStore as a Data Source

To add SingleStore as a data source:

1. Click the Register icon from the left pane.
2. Click Add Data Source button.
3. Select the SingleStore (MemSQL) data source. The Data Source Details page is displayed.

4. Enter a name for the data source in the Data Source name field.
5. (Optional) Enter a description for the Data Source in the Description field.
6. Enable the Data Reliability capability by switching on the toggle switch.
7. Select a Data Plane from the Select Data Plane drop-down menu. To create a new Data Plane, click Setup Dataplane.

8. Click Next. The Enter Connection Details page is displayed.
9. Enter the Host, Port, JDBC Username, and JDBC Password to establish a connection.
10. Click Test Connection. If your credentials are valid, you receive a Connected message. If you get an error message, validate the SingleStore credentials you entered.

11. Click Next. The Observability Setup page is displayed.
12. Provide the required information and enable the Crawler Execution Schedule: Turn on this toggle switch to select a time tag and time zone to schedule the execution of crawlers for Data Reliability.
13. Click Submit.

ADOC V3.1.0's integration with SingleStore represents a significant advancement in data observability. By leveraging SingleStore's powerful visualization tools within the ADOC platform, businesses can achieve deeper insights, improved data reliability, and more informed decision-making processes.