Solved

Need Server Set Up Advice

Posted on 2008-06-19
2
155 Views
Last Modified: 2010-04-21
My application uses PHP and MySQL

Although I've been careful to set up my database and PHP code to be normalized and efficient yada yada, I'm well aware that code/DB tuning can end up being meaningless as your user base grows if your server infrastructure is not set up well. Since I am hoping my site will one day be very big, I've been particularly interested in using MySQL Cluster.

I recently asked the host that I've been working with if they would let me run MySQLCluster on their machines, and they said no. I've looked around a bit and haven't found one, so I thought I'd ask here.

My main question is: Do you know of any server hosts out there that allow one to run MySQL Cluster on their machines?

My follow up question, is if you have any general advice on setting up a scalable server. I see running my own servers as a bad idea for a few reasons, but if you have any advice to the contrary, please let me know.

Thanks!
0
Comment
Question by:iSac1984
2 Comments
 
LVL 20

Accepted Solution

by:
virmaior earned 300 total points
ID: 21831060
By the time you need a MySQL cluster, you don't use a host.  You use rackspace from a company.  A MySQL cluster means that you have multiple different machines operating as MySQL servers for your application.

So if you can still be handled by a hosting company, then you don't needa MySQL cluster.  If your performance is slow, then either your current host just stinks or your DB design is suboptimal.
0
 

Author Closing Comment

by:iSac1984
ID: 31469059
Thanks.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question