Need assistance with cre-loaded OSCommerce database going down, optimising and check security

Job ID: 32008281

Budget: $30 – $250 USD

1.Find why database keep failing and showing 500 error.
2.Find a few simple but effective ways to optimise the database and prevent problems.
3.Check security on two server communicating with each other. Need to know it's done in a way that is optimised and secure and not going to endanger our website.
Related categories: PHP Web Security OSCommerce MySQL