nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Distributed polling ?

christianvo

Hi all,

I'm looking into implementing multiple polling engines
with a centralized web/database for a few different geographic regions. Ideally I'd like to assign one polling engine per region (x number of devices per region) and have the polled information sent to the database server...

Based on my search result within this forum, this seems possible...
Can anyone point me to the documentation to set this up?
Any known issues with this type of setup?

As well, would it be possible to have region-specific web/database servers at the same time? i.e. polling engine writes to local region database and also sends to HQ's database? trying to limit the loss of data in the case that the wan links between each region fail for some reason or another, and also provide region-specific view as well as the BIG picture

Thanks

Chris

Find more posts tagged with

Accepted answers

All comments

Cygnuz

I think that vpn for transmitting traffic between the remote poller and the central db is a must. Multiple poller over 1 central db is easy to implement. The configuration for the local/central databse management is someting i'm looking for too. Probably replication or clustering, but still I don't know.
Hope this can help

Network_Guru

Depends on the bandwidth & latency of your WAN link.
Generally it is not a good idea:

www2.solarwinds.net/.../topic.asp

Having a WAN link between a polling engine and the SQL server is not a good idea.
But, many SolarWinds customers place remote Orion servers, each with its own SQL server across a WAN link.

In this situation, the remote polling engine has its own SQL server. Customers then will remotely roll-up the data they need via queries to the remote SQL server.

SolarWinds also has a few customers that create their own master web site that drills down into each remote server.

-=Cheers=-
NG

Cygnuz

quote:Originally posted by Network_Guru
In this situation, the remote polling engine has its own SQL server. Customers then will remotely roll-up the data they need via queries to the remote SQL server.

First of all, thank for your answer, but still I don't understand something.
When you say "Customers then will remotely roll-up the data" it means that customers have developed theirs own sql application for merging 2 (or more) database versus one remote big db? isn't this dangerous and easily prone to node/interface/alert (etc) id or data collision?
should this be considered a scalability limitation for Orion?
Or there is something i'm probably missing?

Network_Guru

quote:
When you say "Customers then will remotely roll-up the data"

I guess you did not follow the link? I'm sorry for mis-leading you Cygnuz.

You will have to ask Don Yonce, as I was only quoting his reply - hence the italics. In the future I will use quotes, so there is no mis-understanding of who said what.

-=Cheers=-
NG

Cygnuz

ok, i'm sorry too for my wrong quoting. hope Don Yonce, or someone else, can answer to this giving us light on how to better setup multiple db. I followed ALL the post about cluster, redundancy, polling etc. but I didn't find any clear solution.

Network_Guru

I'd suggest calling the Sales or Support line to find out more on if/how this can be done.

We are a one poller/db shop, so I really can't provide any additional feedback on this.

-=Cheers=-
NG

mreitz

quote:Originally posted by Network_Guru

Depends on the bandwidth & latency of your WAN link.
Generally it is not a good idea:

I'd agree. We had a lot of issues (missed polls, in particular) when we tried seperating our pollers via a fairly robust WAN link. Eventually, SW told us "that's not a supported configuration" and we moved the pollers back to the same site as the db server.

Malcolm

Network_Guru

Well it appears I am in this exact situation now.
The DB will be separated from the secondary poller via an OC12 WAN link with 40ms latency.

Does anyone have any experience with this?
What is the performance like ?
Any issues with the DB or other services timing out?

jonchill

Our secondary poller is across a WAN link and before we upgraded our WAN we had a latency of 40 - 50ms and didn't have a single problem with any timeouts.

It will also depend on how frequently your polling and gathering stats.

Jon

Network_Guru

Hi Jon,

Ever since moving the DB to another site with the Primary polling engine/web server, my secondary polling engine has 1 - 2 hour gaps in any SNMP collected data.
ICMP stats are fine & are collected & written to the DB every 5 minutes.
Of course Solarwinds Tier 3 support was no help & used the standard disclaimer - "we do not support remote polling engines separated from the DB".

I'm sure there is a problem with the install, or perhaps something else I have missed.
Documentation on setting up a secondary polling engine is sparse, to say the least...

Any words of advice would be greatly appreciated.

njoylif

My GUESS at what Don? was saying was that your DB and poller would be at the remote location and do everything locally to that site. You would then use some type of reporting tool or SQL Query to gather the data you need from the remote sites (and merge them with local data queries) to populate your reports. You would have to be pretty fluent in SQL querying to accomplish this. This is what I will be doing within the next 6 months and will try to post on successes/issues.

Larry

dbatten

Hi Larry:

I think many of us will be interested in your successes/issues. In our environment all data collection is centralize, so do not see any need for us to use distributed polling.

However, our concern is a disaster recovery perspective--losing the building that have our SQL cluster and production Orion poller.

G'luck

Dale