Solved

One or two databases?

Posted on 2014-11-12
4
136 Views
Last Modified: 2014-11-19
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
0
Comment
Question by:burnedfaceless
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 5

Expert Comment

by:meb_santoso
ID: 40437042
Let's put all the technical stuffs aside for a minute:
-. 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....
0
 
LVL 110

Accepted Solution

by:
Ray Paseur earned 500 total points
ID: 40437048
You probably need to get professional help from a web development company.  There are (at least) a couple of years of college between these questions and the best-practices answers.  With all the storage businesses that exists today, you may be able to find software that is already built; you can license something and get started immediately.  But you may find that this is PC software and not web enabled.

To handle the login portion, you can follow the design patterns here:
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_2391-PHP-login-logout-and-easy-access-control.html

You probably want to use ONE database.  More databases for something like this means more headaches.  Just learn about the "normalization" process and have a DBA help you organize your tables before you start.

SSL will help keep data secure during internet transmission, but the more likely security exposure will occur when a careless employee leaves a logged-in computer or accidentally loses a laptop.  Or when a programming error exposes data inappropriately.  Security is a full-time, four year college major at the University of Maryland.  You may want to join OWASP to learn more.

Automatic and secure backups can be arranged by your hosting provider. Consider cloud-based hosting or a highly professional host like Blackmesh.

The MySQL manual is all online, as is the PHP manual.  
http://dev.mysql.com/
http://php.net/docs.php
0
 

Author Closing Comment

by:burnedfaceless
ID: 40453575
Thanks
0
 
LVL 110

Expert Comment

by:Ray Paseur
ID: 40454026
Thanks for the points and thanks for using E-E, and best of luck with your project. ~Ray
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question