Solved

Need Server Set Up Advice

Posted on 2008-06-19
2
154 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

813 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now