Page 1 of 1

ensuring a safe database?!?

Posted: Mon Nov 13, 2006 4:33 pm
by Obadiah
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?

Posted: Mon Nov 13, 2006 4:36 pm
by Luke
mysql is capable of handling millions of records...

Posted: Mon Nov 13, 2006 4:38 pm
by Obadiah
so why is it at times it crashes...how can i prevent mine from doing that?

Posted: Mon Nov 13, 2006 4:41 pm
by feyd
500 records a day is extremely small.

Without knowing FAR more detail about your configuration, it's quite difficult for us to advise on crashing issues. Do you have error codes, log information, anything specific that may help us diagnose your problem?

Posted: Mon Nov 13, 2006 5:11 pm
by RobertGonzalez
Also, what is your hardware setup, and database server setup? Do you plan on pruning, replicating, etc?

Posted: Tue Nov 14, 2006 8:58 am
by Obadiah
@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?

Posted: Tue Nov 14, 2006 10:08 am
by RobertGonzalez
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).

Posted: Tue Nov 14, 2006 11:06 am
by Obadiah
Everah 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.
aah i getcha now...as of now...i only have a small amount of data in the users table...ive also been watching for
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?
Everah 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).
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...lol

edited
lol rhymes with hell 8O that was not intentional :lol:

Posted: Tue Nov 14, 2006 11:13 am
by Luke
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

Posted: Tue Nov 14, 2006 11:36 am
by RobertGonzalez
There is really nothing to do to make them talk to one another other than making sure you have the right client on your system (which is usually installed when the database gets installed).

Typically as long as the PHP extensions are loaded you should be able to hit the database.