ensuring a safe database?!?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Obadiah
Forum Regular
Posts: 580
Joined: Mon Jul 31, 2006 9:13 am
Location: Ashland, KY
Contact:

ensuring a safe database?!?

Post 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?
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post by Luke »

mysql is capable of handling millions of records...
User avatar
Obadiah
Forum Regular
Posts: 580
Joined: Mon Jul 31, 2006 9:13 am
Location: Ashland, KY
Contact:

Post by Obadiah »

so why is it at times it crashes...how can i prevent mine from doing that?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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?
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Also, what is your hardware setup, and database server setup? Do you plan on pruning, replicating, etc?
User avatar
Obadiah
Forum Regular
Posts: 580
Joined: Mon Jul 31, 2006 9:13 am
Location: Ashland, KY
Contact:

Post 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?
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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).
User avatar
Obadiah
Forum Regular
Posts: 580
Joined: Mon Jul 31, 2006 9:13 am
Location: Ashland, KY
Contact:

Post 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:
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post 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
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
Post Reply