Symmetricds one way setup
I am a little confused on how to setup a one way 3 tier replication using symmetricds.
What I am trying to setup is something like this:
The company server is not connected to the internet and as you can see it's one way, and basically the final tier is a readonly database used by a web application .
- How to setup this 2 steps replication?
- Do I need to install Symmetric (java . etc) in each server?
Need some guideline here, thanks.
Zack,
It sounds like at a minimum you would want 2 SymmetricDS installations. One for your company server and intermediate server. If these are on the same local network a multi-homed (local node) setup would work. I would make the company server the master node and the intermediate a local node in the same installation. The final installation of SymmetricDS would be close to your DB internet server (you want a reliable JDBC connection here). Then I would setup 3 node groups (ex: server, intermediate, web). I would build group links:
intermediate pulls from server (for your data) intermediate pushes to server (for heartbeats and config) intermediate pushes to web (for your data and allows you to keep a firewall in place from outside connections in). intermediate pulls from web (for heartbeats and config)
From here you can select your tables for replication and should be all set.
- rintrojs only shows first dialog in Safari
- Automatically read a column of lowercases True and False as logical
- How do I add counts to a stacked bar graph?
- Counting the number of rows between each pair of months?
- How to create a conditional panel using a reactive object that is passed from another module?
- Plot multiple normalized stock charts from different dates into a single plot
- Select columns based on string match - dplyr::select
- Looking for a more efficient way to replace matrix elements
- modelsummary modelplot: change linewidth
- custom R function with group argument does not work while using the filter
- ggsurvplot function, risk table alignment problem
- plot running average in ggplot2
- Calling variable in df within function
- How to find position of running minimum (runMin) in a vector in R?
- Using httr2::last_response() in conjunction with purrr::possibly()
- Cropping a raster using terra does not return the expected extent
- Can janitor::clean_names be used on only certain columns in a data frame?
- Efficient way of row binding time series in a data.table, with correctly sorted timestamps
- Defining optional arguments in R when more complex function
- Can I change the cursor in plotly only when hovering over points?
- Issue Loading RStoolbox: "Cannot find proj.db" Error
- Filter CSV files for specific value before importing
- Matching the same lines from 2 different files and 2 columns
- Conditional coloring and outer borders in pdf KableExtra table in R
- How can I use observe
- Posterior predictive check for GAM (mgcv in R)
- Embed images in plotly tick labels
- Product of two beta distributions
- R: how to include a character between two repeted items in R?
- Categorizing data from 7 columns into 2