Mysql Cluster Host
Nov 16, 2008I there any good shared or reseller host that has clustered mysql servers facility?
View 1 RepliesI there any good shared or reseller host that has clustered mysql servers facility?
View 1 Replieswe are planing to build a 5 system mysql cluster for our website. i have few questions regarding this. As per our provider, we need mod_ndb for apache to connect database cluster. (SQL API). we have 5 system apache cluster.
Mod_ndb configuration, we need to add all table structure in http configuration. Is there any other way to connect database? or any other way to configure mod_ndb without adding table structure inside http configuration.
any other better way to connect database
All my sites that depend on MySQL at iMountain have been down all day. I was in the process of converting some of them to Joomla/Drupal but I'm having second thoughts now.
My question is - shouldn't "clustering" prevent this sort of thing happening? I thought it implied some level of redundancy.
I have a total DB in size of 800MB... Recently I had to make a few configurations in the management tool and had to do an intialize restart... Not sure what's taking so long, but it's been nearly 8 hours and I have not seen any of my tables that used to be there.
When I do du -sh /var/lib/mysql-cluster, it shows that I have 800M /var/lib/mysql-cluster...
I'd like to create cluster of 2-3 web hosting servers. Data shared on NAS, infront load balancer. But I have problem what to do with Mysql server. First I wanted create cluster. But it requires my customers create cluster databases, not Myisam or Innodb.
Second solution is replication But I can see problem with creating multiple master servers. There is suggestion to create master for writing , and slaves for reading, but I can not imagine how do it transparent for users. I'd like to know how other people solve this problem.
My current web host (SectorLink) has been acting flaky lately so I'm in the market for a My requirements are at least 6GB of space, the ability to run multiple websites on the same account (I'm currently at 7) and ASP, PHP, and mySQL capabilities. I'd also like the price to be competitive with what I'm currently paying ($11/month) though I'm willing to go up a bit.
I'm currently looking at 3 hosts, but I'm open to any suggestions. My short list right now includes:
HostGator - Not a Windows host, I know (though they're working on Windows plans), but they do offer ChiliSoft ASP capabilities. This host would give me unlimited space and domains for $14.95 per month.
AllReseller - This host would give me 50GB of space and unlimited domains for $11.95 a month.
Aspnix - This host would give me 10GB of space and 7 domains for $7.77 a month.
Has anyone used any of these hosts? What were your experiences with them? Could you recommend any other hosts? Side Question to any classic ASP developers out there: Have you used ChiliSoft ASP and, if so, how good is it at running scripts originally written for IIS?
host with PHP 5.2.x & MySQL 5.x.
- under 10$/month (monthly payment)
- at least 15 multi sites allowed.
my site is mainly based upon mysql ...mean I need to insert 25-30 mb data everyday .I saw several webhost saying 5 gb space ...does it mean i can store 4.5 gb data in mysql ? lets take that i will use only 0.5gb to store file&codes.
View 6 Replies View RelatedI am trying to find a reliable host that can provide both mysql and ms sql for the same site. I know this is not how the site should be designed, and a complete redesign is in the works to streamline everything to mysql, but for now I need a host that can provide both. Our current host is absolutely horrible (seekdotnet.com) as there is an excessive amount of downtime (typically a few times/day for various periods of time). Thus far the only one I have been able to find is Mosso, but it seems a lot of people on here are anti-mosso, or have had problems with mosso.
View 7 Replies View RelatedLooking for linux and the above, on shared or virtual plan. A number of sites will be on the account and can run sites without 'www' .
phpmyadmin, real FTP's (non anonymous), SSH/SFTP access, decent uptime, spam filters and support in place. No outsourcing of support, and they house their own servers.
but first, is it a good idea to have mysql on a remote server? let's say my app makes about 400 reqs per second.
View 2 Replies View RelatedI am reading the BYO Database Driven Website Using PHP and MySQL and I am ready to play around a bit. I was wondering if anyone could recommend a quality provider with this language. I have had problems with some in the past when using Joomla so I am trying eleviate that problem from the get-go.
View 6 Replies View RelatedI've been with CystalTech for a while now. They're descent, but expensive.
I've been hearing a lot of good things about HostNexus.
A friend is recommending intermedia, but they don't offer MySQL.
This is for mission critical stuff, but I can't afford dedicated. The stats don't justify it to the powers that be.
What is the standard number on maximum mysql connection on most shared host providers and which one give the highest number.
View 11 Replies View RelatedI need to get the h3ll away from Godaddy, fast!
However, my site has a large MySQL database (200 megabytes) and it's impossible to backup or restore via phpMyadmin. Godaddy has a feature on their control panel, where you can restore/backup your MySQL database to a special diretory on your web http file space, which you can upload/download vis FTP. I use this alot.
Is there any other web hosting company that offers such a feature? I haven't seen this anywhere except on Godaddy.
As to why I need to get away from Godaddy:
Basically what they did was, my site was getting too much traffic (even though it's still well under Godaddy's advertised limits for that plan)... so they sent me an email that says:
"Your site is using too much server resources. We have moved you to a new server to protect our other customers. Please identify steps to reduce your site traffic and contact us."
They moved my site to what is, apparently, a punishment area (Godaddy Hell) where all the high volume sites go. It is so extremely slow, my site might as well not exist... it is inaccessible to my visitors for all intents and purposes.
I know there are a million "looking for cheap shared hosting" threads. Hopefully my particular values/interests justify a new one.
I'm a (mostly PHP/MySQL/CMS) web developer, using Dreamhost for years (perhaps DH was better back then) to host staging/development sites for clients (once I've developed a client site, I usually make them get their own host somewhere more reliable), as well as for low-traffic sites, transferring files, etc.
What I don't like about Dreamhost:
a) SLOW. my guess is this is 25% web server overselling, and 75% MySQL server overselling. My simple sites are tolerably slow - including lightweight php/mysql sites (textpattern CMS, etc.) - BUT my Drupal and Silverstripe and ZenCart experiments are intollerable (5+ second page loads).
b) funny ownership policies - I can't (easily) create a client FTP user that is restricted to one of my subfolders. Each user = exclusive file/folder ownership.
c) not much else. I seem to get a-little-too-frequent DNS problems/outages, and used to get a-little-too-frequent server lock-ups... but I don't expect perfection from a cheap host. And of course I send my mail through google apps, I wouldn't trust a cheap host with my mail.
What I like about Dreamhost:
a) the control panel functionality. Yes, it's ugly, but god it does a lot of nice stuff that cPanel doesn't (and frankly, cPanel is usually ugly too).
b) the usual: a very low price for unlimited domains, unlimited mySQL, and huge storage.
So, who is my next low-cost host?
a) Interested in MySQL performance/protection - perhaps hosts that put MySQL [and mail] on separate servers, like DH, but don't overload them!?! Do I need to worry about this?
b) I wouldn't mind moving to a reseller account
c) I'd like a progressive control panel; I have clients on medialayer - who use directadmin (nice) - but their pricing structure is a bit tight on domains/db/storage. [As an aside, medialayer provides excellent shared hosting performance/value/support, if you don't need a lot of domains/db/storage]
d) I'd like to stay in the $10-20ish a month range
I have the hatchling plan on HostGator. Is there a PHP and MySQL open-source application where I can put up there to test its performance on running PHP and MySql applications? I want to see if there is any performance issue on this host before migrating a large ZenCart app to it.
What are people's experience on HostGator running PHP and MySQL?
I am getting the error "max_user_connections exceeded" for database user "xxxx". So every time this happens I have to feed a new database admin login to my script.
There is nothing wrong with the script since it is very popular membership script. I think my host just allows low number of "max_user_connections". please advice me on a host that allows higher number of "max_user_connections"
have just had a website created for me where I can store my photos on. It uses JSP + MySQL for the databse which stores the photo IDs, photo location etc. I want to get it up and running on the net but have no idea how to do this!
View 14 Replies View RelatedI have developed a desktop system that uses MySQL data.
I want to use a host to access the data but my current provider only allows access to MySQL data via a web server.
Can anyone suggest a host that would provide direct connection to a MySQL database?
I currently run a website which is hosted with storminternet.co.uk and, while I can't fault their reliability, the (lack of) performance is undermining the usefulnes of the website.
Key features of the website are:
- completely MySQL/PHP driven so the host needs MySQL support and processor power . Some of the MySQL queries are fairly complex and call upon multiple tables of large datasets.
- monthly bandwidth is much less of an issue than speed (if that's not an oxymoron) as the number of visitors is currently <250/day.
- most if not all of the visitors are from the UK
In terms of budget I would be willing to go £150+/year if the service was top quality.
for a linux web host that has extremely fast mysql connections, 100GB of bandwidth, and the amount of space has to be at least 1GB. Price doesn't really matter.
View 8 Replies View RelatedBy default, mysql will create user with host as 'localhost'. Now, if I want the host is '1.2.3.4' by default, how to configure it?
View 3 Replies View RelatedI'm desperately trying to find a hosting service that offers Linux hosting with latest versions of php (5.2.x), mySQL (5.1) and maybe CVS or SVN?
Space or bandwidth are not an issue (500mb space will be more than I'll ever need)
This will mainly will be a development/testing place.
I really need a host that actually updates to latest versions of php/mysql/apache.
(not the next day the upgrade is out but some time soon at least >_<)
Things like CVS / SVN, SSH access and access to change your own php.ini settings are more than welcome but I could live without.
how to add a mysql access host by command line? or or how to add a mysql access host through an sql query?
View 3 Replies View RelatedI switched to HostGator because they had PDO drivers enabled on shared hosting plans with PHP 5 & MySql 5. The problem is that every time they update PHP (4 times in 8 months now) they don’t include PDO in the build and its takes day to get past level 1 support and get it fixed.
So I’m looking for a “Reliable” host. I had a hard time when I switched to HG finding shared hosting plans with PDO enabled.
any hosts that can provide the following:
PHP5.3 +
MySQL
CRON (to run daily/weekly scripts at a certain time)
Mass Email. The scripts will send emails to a number of users(between 10-100 at first, but may grow) and this will be done daily and weekly.
In the past, I've tended to go with SupaNames or FastHosts but looking at their solutions for this, it's not quite right for my requirements.
I have a moderately successful site, which makes enough money to cover my current hosting costs of 7 per month. I know, millionaire row it ain't, but it's popular. But my database is getting big and my current host wont allow the user of EXECUTE and SUPER privileges which I need to run triggers and stored procedures to keep the page load times sensible.
So, I need another UK host with:
- 2Gb of space (the site serves up big PDF documents)
- 70Gb of bandwidth (I said they were big)
- mysql privs available as above
Customer service with my current host, uk web solutions, is great (apart from refusal to countenance the privileges) so I need my new host to be as good. Budget? well, you can see what I'm paying now, and I have a psychological Ă‚Â£10/month barrier which I don't want to cross.