Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

A Question about OSC and database.


PGelsman

Recommended Posts

My OSC store has about 20,000 products currently. My sql database seems to get corrupted now and then. Currently its totally fubarred because of my soon to be former host Godaddy.com but that's another story.

So anyhow, I was wondering if OSC can run with 2 databases? One for my products, and another one for everyting else. Is this possible?

 

Thank you in advance,

[email protected]

Link to comment
Share on other sites

Hi Paul,

I am not aware this can be done due to the fact there is the one entry in your configure file for one database.

I would assume that you are moving hosts and would expect this problem to sure itself once complete, DB problems can be anything from being attacked to poor server, but its unusual for this to happen ofter to the extent that it kills it.

What things are corrupted?

Nic

Sometimes you're the dog and sometimes the lamp post

[/url]

My Contributions

Link to comment
Share on other sites

While it's certainly possible, it won't solve your problem. First, you'd have to find every place in the code that performs a database action, and add in a parameter to specify which database to use ("overhead" or "products"). I'm assuming that "products" DB usage can be cleanly separated from "overhead" such as categories -- I won't even swear that's possible. Second, the "products" would probably be more than 99% of your database size and activity anyway, so you wouldn't save anything by splitting databases.

 

It would be a whole 'nuther matter to split up the products into multiple smaller databases, and handle them separately, but why bother? You'd be better off going to a host who can handle such a large database, and possibly moving to industrial strength databases such as Oracle (and another store, as osC is MySQL-only), if you had enough products. I've heard of far larger stores running on a single MySQL database, so it's probably a hosting problem rather than a database-is-overtaxed problem.

Link to comment
Share on other sites

Hi Paul,

I am not aware this can be done due to the fact there is the one entry in your configure file for one database.

I would assume that you are moving hosts and would expect this problem to sure itself once complete, DB problems can be anything from being attacked to poor server, but its unusual for this to happen ofter to the extent that it kills it.

What things are corrupted?

Nic

 

Fim.......Thanx for the reply. I don't know what exactly is corrupted in my DB, but I've had tons of problems lately with Godaddy. I'm currently moving to Bluehost as suggested here. Currently only 25% of my customers are getting download links and I can't access my control panel. I've had numerous support calls to Godaddy and those knuckleheads don't know their ass from a hole in the ground. I posted a review of Godaddy at this link:

 

http://www.myhostingpicks.com/godaddy-hosting-reviews.html#reviews

 

My review is #96 I also have multiple threads here on my problem in the last 10 days or so.

 

Paul

Link to comment
Share on other sites

Paul

When you say "Control Panel" do you mean the admin for oSC or the godaddy account cpanel?

I do not remember who you use as a payment gateway but could it be something interrupting the return token? Security Pro can do this if it was not set to ignore certain files (not a problem with the add on either), can be a cause of your 25% return problem

If its your admin you cannot get into and its something like a 500 serve error it can be due to htaccess permissions problems, or calling for an htpassword that does not exist any longer (the actual file itself).

 

I think with hosting especially the larger companies you are in a que with hundreds of others, and as they want their service levels they will throw you an half answer. They are great with the small problems but when it get more involved they will stop answering!

Never used them but i believeBlue Host are pretty good, though for your business i would have though a dedicated server would be better.

Nic

Sometimes you're the dog and sometimes the lamp post

[/url]

My Contributions

Link to comment
Share on other sites

Fimble - Thank you for the reply. When I was looking for a new host, all of the DS and VPS plans only offer low disk space.Also they are pretty pricey. I need at the very least 500GB to start.

 

PGelsman

Link to comment
Share on other sites

Hi Paul

It can be more in monetary terms however the extra security and full use of system resources for your sites IMHO far outweigh that.

As with everything you would need to do your reasearch into this and decide for yourself if you feel its in your businesses best interests, all i can say is that i would not want to go back to shared hosting now.

Nic

Sometimes you're the dog and sometimes the lamp post

[/url]

My Contributions

Link to comment
Share on other sites

MySql is robust enough to handle far, far larger lists, and the programming in OSC is pretty efficient.

 

If you can't access your control panel, but you can access your database via phpMyAdmin in your Godaddy control panel, and you can access your files via a web editor (Dreamweaver, netbeans, ftp, etc) then try this simple to use contribution, authored by Fimble above. It has saved my rear end a couple of times.

 

http://addons.oscommerce.com/info/5857

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...