Beyond the Hype: What Retailers Really Want from Tech in 2025 Europe’s biggest retail conference …
Cloud-native POS platform for seamless omnichannel customer experience.
A single hub for all promotions campaigns.
The most advanced synchronization solution for databases and file systems.
Data configuration and batch automation across different disparate systems and vendors.
Beyond the Hype: What Retailers Really Want from Tech in 2025 Europe’s biggest retail conference …
What a fun week it was for women from across the country who came together …
It’s a wrap for the Jumpmind Team at Shoptalk Spring and we could not have …
The new release of SymmetricDS Pro 3.16 data replication software simplifies setup, improves performance, and …
Sybase ASE (more recently known as SAP Adaptive Server Enterprise), announced its end of mainstream …
Azure Blob Storage has become a popular option for storing files in the cloud. And …
Jumpmind Powers Point of Sale and Promotions Execution for Landmark Retail, One of the Largest …
Retail Technology Leader Jumpmind to Enable Mobile Point of Sale and Inventory Management for DTLR/VILLA …
The retailer is charting its next chapter with retail technology modernization to power inspired omnichannel …
After nearly a century in business, the legendary Canadian fashion retailer is retooling to streamline …
The Solution Addresses Modern Retail Challenges with Innovative Promotions to Captivate Inflation-Weary Shoppers NRF 2024, …
New research by RSR, sponsored by Jumpmind, finds 65% of retailers say their current store …
Cloud-native POS platform for seamless omnichannel customer experience.
A single hub for all promotions campaigns.
The most advanced synchronization solution for databases and file systems.
Data configuration and batch automation across different disparate systems and vendors.
SingleStoreDB is an up-and-coming database for real-time analytics that can now be replicated with the variety of other databases that SymmetricDS supports.
Just like the other databases replicated with the SymmetricDS the SingleStore database is not any different with full support for loading data, capturing changes, live transformations, and initial loads. This blog will walk through the basics of configuring this replication use case.
– SymmetricDS is installed and running.
– SingleStore is installed and running.
– If you intend to capture changes on SingleStore for replication you will need a different user setup than the user id provided to applications and users making the changes (ex. SymmetricDS as a user).
– The following variables will need to be set in SingleStore again if you plan to capture changes on SingleStore for replication.
sdb-admin update-config --key auditlog_level --value ALL-QUERIES-PLAINTEXT --all
sdb-admin update-config --key auditlog_disk_sync --value ON --all
sdb-admin update-config --key auditlog_retention_period --value 7 --all
Connecting to a SingleStore database and setting it up as a SymmetricDS node is similar to all the other databases supported. Select SingleStore from the database dropdown and provide the credentials and URL needed to make a JDBC connection to your SingleStore database.
After making a successful connection to your SingleStore database the next step will be to identify where the audit logs are located. These will be used by SymmetricDS to capture changes on the SingleStore database to replicated to a target system.
The final check is to verify the variables are set up properly for replication. If the permission check fails be sure to verify all the variables in the prerequisites section have been properly set up.
Once you have completed the setup wizard your SingleStore node is ready for change capture. You will be able to see it on the design table as a log-based node and can continue with loading data as needed to or from SingleStore.