Hello Peter, It sounds like splitting the servers for both MySQL and web, will require external help either experienced developer or assistance from hosting server to split the servers. Not something easy to do even for the good-known forum owner ?
Post: Site was down today, support and web hosting.
August 31, 2007 By 27 Comments
… and serial console, backup etc. Plus we had one server hosted with them in Europe for couple of months for tracking… to match my timing so I went ahead and returned web site back to old server which happily was still available… this move did not work I’m looking for other hosting location in US I would either rent 2-3 servers…
Post: Traffic Tricks by Hosting Providers.
October 17, 2007 By 13 Comments
… my experience (which is at large extent focused on inexpensive hosting) I found it much better to work with Co-Location… 95% Commit + Overcharge payment is also fair pricing which means hosting provider is interested for me to use more traffic, not… power buy another rack. Going forward we plan to host our consulting business web sites MySQLPerformanceBlog, Percona high quality dedicated server, mainly…
Comment: Opening Tables scalability
December 22, 2006 By 27 Comments
Yes, I was speaking about web hosting case. Companies that sell shared web hosting services often place all of their customers’ DBs to a… ‘show databases’ – you have to care about it in a web hosting case. phpMyAdmin calls it twice when you open it’s…
Comment: About This Blog
October 7, 2008 By 48 Comments
… thoughts are welcome — more details below: I work at a Web Hosting company and we were frustrated by our inability to account…, Questions, Com_update FROM conuser WHERE Questions > 10000; +—————————-+————-+———–+————+ | conuser (user@host) | Com_select | Questions | Com_update | +——— ——————+————-+———–+————+ | bandala@db2.adomain.com | 8306726…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
Working with number of hosting providers I always wonder how do they manage to keep …) Hosting Providers and remember this exactly where a lot of kids start to develop their first sites and play with web technologies. So how do the hosting providers manage to host hundreds of users on single server…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… the patch features will surely be a great help for hosting providers to produce detailed reports on how each customer utillizes… his own application, completely ignoring the fact they chose shared hosting. Of course this alone is not a problem and theoretically… resulting database load may not be directly related to the web traffic some customer has. The load can also be changing…
Comment: An argument for not using mysqldump
November 8, 2010 By 24 Comments
… in parallel Example : I have a client at my DB/Web hosting company with 650+ databases (450+ GB) in one mysql instance… individual tables (which I have also scripted for other DB Hosting clients) Option 2 (not using mysqldump) MAATKIT’s very own…
Comment: Wishes for new "Pure PHP" MySQL driver
September 15, 2010 By 17 Comments
… for people using shared web hosting! I managed to compile a local php5.3 cgi on a shared host recently and got it…
Comment: MySQL for Hosting Providers - how do they manage ?
February 12, 2009 By 15 Comments
I was with host monster but they kicked us off because our mysql queries were too long. Do you know of a web hosting place where we can have longer queries
