ensuring a safe database?!?
Moderator: General Moderators
ensuring a safe database?!?
i was wondering if there was a couple of positive ways(or measures) i can take to ensure that my database doesent crash...what im needing to do is build another table but the values would be being updated everyday and new values added maybe up to 500 records daily...is this something i should do with mySQL? is it capable of handling the workload? what are some of the things i should watch for or do to make sure it doesnt crash?
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
@feyd=no error codes yet thank goodness...i was just asking just in case there was something i could do to ensure that it wouldent happen
@everah=i have mysql and php all installed in the xampp package...when i first installed it i was curious on how to get the two of them to work together and i didnt really(still a bit rough on it)know how to go about setting it up so i got the xampp package...it seems to work pretty great...its all setup on a windows 2003 web server...as far as all the technicalities like hd size and processor speed im not too sure on it...but will ask my supervisor about it....what did you mean by pruning, and replicating?
@everah=i have mysql and php all installed in the xampp package...when i first installed it i was curious on how to get the two of them to work together and i didnt really(still a bit rough on it)know how to go about setting it up so i got the xampp package...it seems to work pretty great...its all setup on a windows 2003 web server...as far as all the technicalities like hd size and processor speed im not too sure on it...but will ask my supervisor about it....what did you mean by pruning, and replicating?
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Pruning is the act of degrading stale data (essentially deleting what is no longer needed from the production database). Replication is the active copying of data from one source to another source so as to maintain active, available data for use as backups in case of catastrophic system failure.
Remeber too, that PHP and MySQL are completely independent of each other. You do not need one to use the other. Installing them then is merely a matter of setting up each application, the making them talk to one another (usually done behind the scenes in the form of a client API).
Remeber too, that PHP and MySQL are completely independent of each other. You do not need one to use the other. Installing them then is merely a matter of setting up each application, the making them talk to one another (usually done behind the scenes in the form of a client API).
aah i getcha now...as of now...i only have a small amount of data in the users table...ive also been watching forEverah wrote:Pruning is the act of degrading stale data (essentially deleting what is no longer needed from the production database). Replication is the active copying of data from one source to another source so as to maintain active, available data for use as backups in case of catastrophic system failure.
bots and such to make sure there isnt a name in there that doesnt belong and deleted all test accounts/records...now as far as replication...would you recommend that i create another database and store the same values in it as the one im actively using?
this is why i got the xampp package because when i installed them before they worked fine seperately but getting then to work together was a whole other ballgame....it was hell...lolEverah wrote:Remeber too, that PHP and MySQL are completely independent of each other. You do not need one to use the other. Installing them then is merely a matter of setting up each application, the making them talk to one another (usually done behind the scenes in the form of a client API).
edited
lol rhymes with hell
Sounds like you need to pick up a mysql book...
http://www.amazon.com/s/103-1506527-131 ... lla-search
I read this one... it was pretty good:
http://www.amazon.com/High-Performance- ... F8&s=books
http://www.amazon.com/s/103-1506527-131 ... lla-search
I read this one... it was pretty good:
http://www.amazon.com/High-Performance- ... F8&s=books
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA