Experimental Physics and Industrial Control System
|
Thanks! Yes, I may have a naive assumption that "archiver" is the AA.
> Can we access MySQL directly?
Not per se as in reading any data from arbitrary tables.
If you’re using the RDB archive engine, the one that writes to Oracle, Postgres or MySQL, then yes, we can read that archived data back out by directly
connecting to Ora, PG or MSQL using URLs like jdbc:mysql://192.168.1.230/archive
So we’re assuming to find tables like “channel”, “sample”, … with archived data as used by the RDB archive engine.
It you’re using the archive appliance, then you’ll read data via the AA’s web service, using something like
pbraw://your_host_name…
--
Jeong Han Lee, Dr.rer.nat. Staff Scientist and Engineer Cell: +1 510 384 3868
- References:
- Question about fetching history data from MySQL by using phoebus neu lzf via Tech-talk
- Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
- Re: Question about fetching history data from MySQL by using phoebus Han Lee via Tech-talk
- Re: [EXTERNAL] Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
- Navigate by Date:
- Prev:
Re: [EXTERNAL] Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
- Next:
has anyone used ADPICam in a docker? Lee L. Yang via Tech-talk
- Index:
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
<2023>
2024
- Navigate by Thread:
- Prev:
Re: [EXTERNAL] Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk
- Next:
Re: Question about fetching history data from MySQL by using phoebus neu lzf via Tech-talk
- Index:
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
<2023>
2024
|
ANJ, 28 Jun 2023 |
·
Home
·
News
·
About
·
Base
·
Modules
·
Extensions
·
Distributions
·
Download
·
·
Search
·
EPICS V4
·
IRMIS
·
Talk
·
Bugs
·
Documents
·
Links
·
Licensing
·
|