search

archiver-appliance / epicsarchiverap

This is an implementation of an archiver for EPICS control systems that aims to archive millions of PVs.
Other
38 stars 38 forks source link

Performance difference between JDBM2Persitence and MySQL #85

Closed psh-yonsei closed 5 years ago

psh-yonsei commented 5 years ago

I'm now using JDBM2Persistence due to easy file backup. Is it better to move MySQL especially for performance? Expected number of PV is ~100K (or more). Also, if MySQL is better than JDBM, is there any specific action to move persistence?

Thanks,

slacmshankar commented 5 years ago

JDBM2Persistence is not really thread-safe; that is, it is possible to get into deadlocks and such on a multi-user environment. It was mainly meant for personal archivers and so on where traffic is very low.

Is it better to move MySQL

Yes; for production environments, MySQL is the better choice.

is there any specific action to move persistence?

You can probably use an export/import step but there is nothing out of the box for this; a custom script is probably needed.