PGelsman Posted October 2, 2011 Posted October 2, 2011 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]
FIMBLE Posted October 2, 2011 Posted October 2, 2011 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
MrPhil Posted October 2, 2011 Posted October 2, 2011 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.
PGelsman Posted October 2, 2011 Author Posted October 2, 2011 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
FIMBLE Posted October 3, 2011 Posted October 3, 2011 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
PGelsman Posted October 6, 2011 Author Posted October 6, 2011 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
FIMBLE Posted October 6, 2011 Posted October 6, 2011 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
npn2531 Posted October 6, 2011 Posted October 6, 2011 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
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.