• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Planning on setting up a virtualized DB

Joined
Mar 24, 2007
Messages
7
EDIT: Don't know how to delete thread so I removed original text. Responses were basically just telling me to read the best practices for the DB I want to use.
 
Last edited:
As long as you understand that virtually no database software provider supports their database software being virtualized and you accept that risk, then there are a few things to consider. What I'm saying is, if you have a problem with Access running on a virtualized VM, and you have some odd issue.. Microsoft will give you the finger until you move it to a physical box to replicate the problem. With that said..

What virtualization software are you using?
How is your storage connected? San, Iscsi, nfs, cifs, infiband?
What kind of storage solution do you plan to use?
Have you ever exported data from MS Access and dumped it into a MySQL database?
What is your budget?

it'll be hard to answer your questions with out a little more back ground.
 
In short, you should be able to virtualize it, but that is a very blanket statement. We need to know more about what DB platform you are going to, not considering. The software you are looking at moving to should have specifications on what hardware they recommend for X users. Y modules in the application, etc. Also, in your research for your POS application make sure you look into if they can handle database replication (for multi-sites) or if the application will work over Terminal Services/RDP (or some other remote connection method).

P.S. - I actually work at a POS VAR for ~18 years now, so if I can help direct you in any way possible, please let me know. I really dislike seeing someone, or company, have a solution in place that really isn't a solution.
 
EDIT: Don't know how to delete thread so I removed original text. Responses were basically just telling me to read the best practices for the DB I want to use.
 
Last edited:
EDIT: Don't know how to delete thread so I removed original text. Responses were basically just telling me to read the best practices for the DB I want to use.
 
Last edited:
Depending on how this works out, you may have a different definition of POS than now :)
 
I have been dealing with high performance mysql and MSSQL virtual infrastructures for years now and wouldnt think twice about staying that way. There are plenty of best practices out there, follow them and you will be fine. Of course if you want specific advice, as others have said here, we need to know exactly what type of data you will be dealing with ultimately.

You will find no shortage of vendor support for virtualizing DB applications. At this point, I am not sure why someone would think otherwise.
 
EDIT: Don't know how to delete thread so I removed original text. Responses were basically just telling me to read the best practices for the DB I want to use.
 
Last edited:
Back
Top