Results 1 to 20 of 20
-
10-23-2006, 09:38 AM #1New Member
- Join Date
- Oct 2006
- Posts
- 4
need hosting which support innodb of mysql
Hi,
my site needs innodb of mysql.
I found nearly no hosting comppany support it.
Can you help me out?
Thank you!
-
10-23-2006, 09:41 AM #2.
- Join Date
- Jun 2006
- Location
- East Coast // NYC
- Posts
- 1,698
Not sure why you need INNODB since this is mostly used as a backup solution.
-
10-23-2006, 09:47 AM #3New Member
- Join Date
- Oct 2006
- Posts
- 4
two scripts
Because my applicatinon needs the following script to be run on the mysql server:
CREATE TABLE `active_sessions` ( `id` int(11) NOT NULL default '0', `user_id` int(11) default NULL, `session_id` char(255) default NULL, `lastused` datetime default NULL, `ip` char(30) default NULL, UNIQUE KEY `id` (`id`), KEY `session_id_idx` (`session_id`) ) TYPE=InnoDB;
_________________
CREATE TABLE `zseq_help` ( `id` int(10) unsigned NOT NULL auto_increment, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=99
-
10-23-2006, 09:49 AM #4.
- Join Date
- Jun 2006
- Location
- East Coast // NYC
- Posts
- 1,698
Won't it work just the same without the TYPE=InnoDB?
-
10-23-2006, 09:49 AM #5Disabled
- Join Date
- Oct 2006
- Posts
- 149
Have you asked ane tech support?
-
10-23-2006, 09:52 AM #6WHT Addict
- Join Date
- Mar 2004
- Location
- Belgium
- Posts
- 101
Do you really need to work with Innodb ? The most common type on mysql servers is MyISAM. But Innodb should work on all mysql server.
BPowers.com: Eu Web Hosting Solutions
Shared hosting with Cpanel/Fantastico
Live Help: http://www.bpowers.com
-
10-23-2006, 09:54 AM #7New Member
- Join Date
- Oct 2006
- Posts
- 4
I do need innodb to run my application.
I have bought space from cirtexhosting.com and i found that these script can't be run on their server.
The default intallation of mysql on my windows xp box can run these scripts.
I don't know why many companies turn off this feature.
My budget is $5 per month I only need about 1.5G space and my site is low traffic site.If any company can fulfill my requirement,I will buy your space.Last edited by wangwangwang; 10-23-2006 at 09:59 AM.
-
10-23-2006, 09:59 AM #8WHT Addict
- Join Date
- Mar 2004
- Location
- Belgium
- Posts
- 101
Just ask your host to enable it via its /etc/my.cnf file or change host. Your budget is too low for us.
BPowers.com: Eu Web Hosting Solutions
Shared hosting with Cpanel/Fantastico
Live Help: http://www.bpowers.com
-
10-23-2006, 10:00 AM #9Web Hosting Master
- Join Date
- Apr 2001
- Location
- Paradise
- Posts
- 12,052
Ask to your host why they can't set INNODB , because is something pretty easy to do
█ Shared Web Hosting - Reseller Hosting - Semi-Dedicated Servers - SolusVM/XEN VPS
█ LiteSpeed Powered - R1Soft Continuous Data Protection - 24/7 Chat/Email/Helpdesk Support
█ Cpanel/WHM - Softaculous - R1soft Backup - Litespeed - Cloudlinux -Site Builder- SSH support - Account Migration
█ DowntownHost LLC - In Business since 2001- West/Center/East USA - Netherlands - Singapore
-
10-23-2006, 10:01 AM #10Disabled
- Join Date
- Oct 2006
- Posts
- 149
I've already asked tech support at random. And they said YES.
-
10-23-2006, 10:03 AM #11Hey, whats your uptime ?
- Join Date
- Mar 2004
- Location
- Tokyo / Japan
- Posts
- 492
Originally Posted by MrRadic
To the original topic poster:
2) Are you aware that the company giving support for InnoDB and created the InnoDB was bought last year from Oracle ? (so you might want to reconsider)
3) I am sure there are many hosting companies with InnoDB support, but the price range might not be within the budget hosting packages.
I hope this helps.
Best regards__--- Nils Valentin ---
☆★☆ Speedtest One: Tokyo / Japan ☆★☆ / Feedback
☆★☆ Speedtest Two: Tokyo / Japan ☆★☆ / Feedback
-
10-23-2006, 12:36 PM #12Junior Guru Wannabe
- Join Date
- Aug 2006
- Posts
- 49
I'm sure lots of webhosts support it.... it's just not enabled by default. just ask if they would enable it while shopping around.
www.griffinhosting.com
WHMCS Email Plus+ - Email integration with Sendgrid, Mailgun, Postmark, Amazon, Mandrill, Sparkpost, Sendinblue and others...
-
10-23-2006, 02:01 PM #13Junior Guru Wannabe
- Join Date
- Sep 2006
- Posts
- 33
InnoDB tables are available at Dreamhost, that should fit in your budget
-
10-23-2006, 04:39 PM #14WebHostingTalk Lover
- Join Date
- Mar 2003
- Location
- New York City
- Posts
- 7,406
Originally Posted by wangwangwang
We do support innodb, if you're having any issues please let us know via helpdesk and we'll take care of ya.
Cheers█• Taskade - To-Do List & Tasks • All-in-One To-Do List & Mind Map App for Remote Teams
█• Simple and shareable to-do lists for web, mobile, and desktop
█• To-Do List Templates • 300+ shareable templates and productivity workflows
█• Get things done, faster and smarter! • I eat penguins for breakfast ...
-
10-23-2006, 05:04 PM #15Web Hosting Master
- Join Date
- Nov 2005
- Location
- USA
- Posts
- 884
Always a good idea to open a ticket and check with your host before hand.
GS RichCopy 360 Enterprise - Voted #1 for data migration and replication in terms of performance and features. Replicate data across between servers in the same network, WAN, or even across the internet - Many customer call it RSync for Windows
-
10-23-2006, 05:15 PM #16Disabled
- Join Date
- Oct 2006
- Location
- England, UK
- Posts
- 9
Personally, I would of thought most hosts would support InnoDB.
ITAhmed has the idea, open a pre-sales ticket with any prospective host and outline your requirements before hand!
-
10-23-2006, 05:18 PM #17Web Hosting Master
- Join Date
- Nov 2005
- Location
- USA
- Posts
- 884
Originally Posted by KeiGDPGS RichCopy 360 Enterprise - Voted #1 for data migration and replication in terms of performance and features. Replicate data across between servers in the same network, WAN, or even across the internet - Many customer call it RSync for Windows
-
10-23-2006, 05:20 PM #18WebHostingTalk Lover
- Join Date
- Mar 2003
- Location
- New York City
- Posts
- 7,406
Originally Posted by ITAhmed
Cheers█• Taskade - To-Do List & Tasks • All-in-One To-Do List & Mind Map App for Remote Teams
█• Simple and shareable to-do lists for web, mobile, and desktop
█• To-Do List Templates • 300+ shareable templates and productivity workflows
█• Get things done, faster and smarter! • I eat penguins for breakfast ...
-
10-23-2006, 06:19 PM #19Disabled
- Join Date
- Oct 2006
- Location
- England, UK
- Posts
- 9
Why don't you recommend users to use it?
If they've got a script that requires transactional support, recommending them not to use it would be a bit of a stupid thing to do.
If they have an "inkling" to use InnoDB, chances are that they've got a damn good reason to do so.
-
10-23-2006, 06:34 PM #20WebHostingTalk Lover
- Join Date
- Mar 2003
- Location
- New York City
- Posts
- 7,406
Originally Posted by KeiGDP
We only recommend myisam over innodb in certain cases as a suggestion, we in no way discourage our users from using innodb. If they wish to use innodb, they're free to do so, and of course if a user runs into any problems they can contact us.
Cheers█• Taskade - To-Do List & Tasks • All-in-One To-Do List & Mind Map App for Remote Teams
█• Simple and shareable to-do lists for web, mobile, and desktop
█• To-Do List Templates • 300+ shareable templates and productivity workflows
█• Get things done, faster and smarter! • I eat penguins for breakfast ...