burnedfaceless
asked on
One or two databases?
The business I am designing a website we are considering making use of php and MySQL to automate some functions.
This business is unit storage and is divided into two departments in two different physical locations a considerable distance away.
We were considering moving from our manual system to one where the storage department can access a html page, login, view available units, and when one is rented send an invoice or a bill depending on how they have it set up.
Regardless I thinking of having two separate databases, one for invoices and bills, and granting both departments read access to both databases, but the ability to write only to their own database.
I had some questions
1. Have I provided enough information to let me know if I'm on the right track with two databases
2. I need some hefty reading on how to securely login to MySQL database from php. Ebooks are preferred. Would SSL affect this situation? I've worked through some books but I feel like I need something dense for it to be secure.
3. What is the best way to automatically and securely backup your databases? I'm guessing you can write some scripts?
4. I never learned SQL commands and I have to build these with that so I need a book to read on that too thanks
This business is unit storage and is divided into two departments in two different physical locations a considerable distance away.
We were considering moving from our manual system to one where the storage department can access a html page, login, view available units, and when one is rented send an invoice or a bill depending on how they have it set up.
Regardless I thinking of having two separate databases, one for invoices and bills, and granting both departments read access to both databases, but the ability to write only to their own database.
I had some questions
1. Have I provided enough information to let me know if I'm on the right track with two databases
2. I need some hefty reading on how to securely login to MySQL database from php. Ebooks are preferred. Would SSL affect this situation? I've worked through some books but I feel like I need something dense for it to be secure.
3. What is the best way to automatically and securely backup your databases? I'm guessing you can write some scripts?
4. I never learned SQL commands and I have to build these with that so I need a book to read on that too thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Thanks for the points and thanks for using E-E, and best of luck with your project. ~Ray
-. have you considered to just place the whole system online so that the two departments can work on single db (or single set of db)?
-. It will save you development and deployment time, costs --and maintenance.
On your questions:
1. See above
2. Depends on your setup and/or deploment scenario. SSL will secure the transaction / data interchange between the client(s) and the server; i think it should also secure server to server connection.
3. Depends on your setup (again); on a *nux based server, you can make use of the cron command (google it, it's easy!). The easiest would be a daily backup of the whole database and/or system (html / php files as well) and let it transferred to some off-site location. Yes, scripts are available, but if you use cPanel for your web control panel, it's easier :-) *your mileage and preferences may vary*
4. Oh boy....