Welcome Guest ( Log In | Register)



 
 Reply to this topicStart new topic
> Question/suggestion Concerning Mysql
lacking_imaginat...
post Feb 25 2006, 03:14 AM
Post #1


Member [Level 3]
******

Group: Members
Posts: 91
Joined: 4-March 05
Member No.: 4,151
Alright...
I'm not one to complain about things, but on the delta server, the MySQL has been down multiple times a week.
I'm getting hosting with a different company soon, on completely unrelated issues that I knew about before coming here and didn't expect to run into quite so fast, but...
I just want to know if the version of MySQL is a stable version. Or is it being over used? Honestly, there have been hours straight when I've been without a forum. Like now for instance. My forums have been down for 2 hours straight on my paid site. My trap17 site is still up.

I'm sorry, but I know I don't rely 100% on the forums, but they are a major part of my site.
And others use the mysql for their main page.

It may only be $3.33 a month, but its almost not worth the hassle. Your free sites are higher quality than the paid ones. I won't miss the hosting here once I purchase my hosting at the new company.

I don't hate this network, in fact, it's my first paid host. But 2 hour+ straight outages multiple times a week? Tuesday mySQL and cpanel crashed.

C'mon guys, we're paying here, please take care of us.

(list)

Go to the top of the page
 
+Quote Post
OpaQue
post Feb 25 2006, 05:23 AM
Post #2


Administrator
Group Icon

Group: Admin
Posts: 1,459
Joined: 11-June 04
From: Somewhere in Time & Space.
Member No.: 1
Hi.

Its not about our Free sites are having a better uptime than our paid site.

Just imagine, Why would we even do this ? Or is there something in our hand that causes mySQL on Paid server to go down ?

I really cannot deny the downtime of MySQL, but when there is even one member who abuses the server, he can bring down the SQL service. We found a member by scanning the logs manually (which takes hours) to track down the spammer.

Tracking down mySQL spammer is really hard. Its because, once the service experiences lot of load, all other sites quering normally affect the server equally. So, it gets hard to determine, who is actually affecting it.

Unlike Free hosting, We cannot simply suspend the suspected sites, because of the very same statement put forth by our customers "We are paying for it, You cannot suspend my site".

I can really understand the value of your money and the service you are expecting, but at this moment, All I can request you is, give it a try. Everyone has their bad day..

I've researched the industry, market and the services provided by our competitors.. As for now, I can still say, the uptime provided till date has been far better than competitors who are charging more than double.

As mentioned in my other post, We have ordered additional equipments of about $3000 for additional monitoring and failture detection.

Also, Please understand that, there is no such software in existence which can give an alarm of any service X mins before it is on the verge of collapsing.

You might have noticed, HTTPD has never been down on DELTA ever. Its been working perfectly since the day it was setup. HTTPD service is monitored as closely as MySQL. However, still we get problems from MYSQL because, we have no where to know, if mySQL is answering your software queries or not.

If the service Dies off, we can fix it within 2 mins. That's my guarantee, but if for some reason, its hogged and ceases to respond to Queries, its literally impossible to find out.

We are working over it hard and be assured, We have a team of programmers who are struggling for giving our members better uptime and quality.

thanks.

(list)

Go to the top of the page
 
+Quote Post
FallenSage
post Jul 1 2006, 08:48 PM
Post #3


Newbie
*

Group: Members
Posts: 7
Joined: 1-July 06
Member No.: 25,911
blink.gif Wow I've never seen a better post in my life. I have only been useing computinghost for a couple weeks now and I haven't had any problems. And like OpaQue said their services are great for their prices and I did my research I must tell you. Searched the web for months no joke. And after reading that post I'm even happier to have them as my host. smile.gif

This post has been edited by FallenSage: Jul 1 2006, 08:48 PM

(list)

Go to the top of the page
 
+Quote Post
OpaQue
post Jul 3 2006, 10:40 AM
Post #4


Administrator
Group Icon

Group: Admin
Posts: 1,459
Joined: 11-June 04
From: Somewhere in Time & Space.
Member No.: 1
The thread was started in Feb and after the installation of those equipments + the change in our monitoring systems, We have not had a SINGLE mySQL related complaint. :-) We are proud of it smile.gif

(list)

Go to the top of the page
 
+Quote Post
ZPGames
post Jul 13 2006, 08:36 PM
Post #5


Advanced Member
*******

Group: Members
Posts: 107
Joined: 4-November 04
Member No.: 2,133
I must say it is true. I have never actually noticed a single problem ever with my site since I have been on ComputingHost, It has been about 7 months going strong. GO COMPUTINGHOST.

(list)

Go to the top of the page
 
+Quote Post
XDelivery
post Aug 2 2006, 11:31 AM
Post #6


Newbie
*

Group: Members
Posts: 0
Joined: 2-August 06
From: A payphone
Member No.: 27,684
QUOTE(OpaQue @ Feb 25 2006, 01:23 AM) *

If the service Dies off, we can fix it within 2 mins. That's my guarantee, but if for some reason, its hogged and ceases to respond to Queries, its literally impossible to find out.


Lemme help you out then! smile.gif

Here's a VERY quick and dirty script, to monitor your MySQL db's.

All you have to do, is change the settings, and, crontab it to run every 5-30 mins or so (By the way, you run it, like this: php -q scriptname.php )

I'd say, run one copy on each machine, edit the machine name, and you should get nice, concice emails, from each box, when mysql either dies, or stops responding to queries.

(I wrote it, from scratch, so, if you have any questions, let me know smile.gif )

CODE

<?php

function testfailed($reason_for_failure) {
    # Settings:
    $boxname = "Alpha"; //Set this to the machine's name
    $errorto = "support@computinghost.com"; //Set this to whom you want to receive the warning email
    $errorfrom = "support@computinghost.com"; //Set this to whom you want the error mail to come FROM

    $subject = 'WARNING -- MySQL Failure on ' . $boxname;
    $message = 'Hello, MySQL has failed on' . $boxname . 'The reason given by MySQL was: \r\n' . $reason_for_failure;
    $headers = 'From: ' . $errorfrom . "\r\n" . 'X-Mailer: PHP/' . phpversion();
    mail($errorto, $subject, $message, $headers);
}

#More settings
$mysql_host = "Host.Of.The.MySQL.Machine";  //IP or ohstname of the MySQL machine being tested
$mysql_user = "MySQL_Username";        //MySQL Username
$mysql_password = "MySQL_Password";  //MySQL User password
$test_database = "Database name";   //The DB Name
$tablename = "An_Example_Table";   //Must have at least one table, with one entry....

$link = mysql_connect($mysql_host, $mysql_user, $mysql_password) or testfailed('Could not connect: ' . mysql_error());
mysql_select_db($test_database) or testfailed('Could not select database' . mysql_error());
$query = 'SELECT * FROM' . $tablename;
$result = mysql_query($query) or testfailed('Query failed: ' . mysql_error());
mysql_free_result($result);
mysql_close($link);
?>


QUOTE(OpaQue @ Jul 3 2006, 06:40 AM) *

The thread was started in Feb and after the installation of those equipments + the change in our monitoring systems, We have not had a SINGLE mySQL related complaint. :-) We are proud of it smile.gif



D'oh! It pays to read the dates on posts! smile.gif

(list)

Go to the top of the page
 
+Quote Post
FallenSage
post Aug 6 2006, 02:05 AM
Post #7


Newbie
*

Group: Members
Posts: 7
Joined: 1-July 06
Member No.: 25,911
Well your posting here tongue.gif . But that sounds like a good idea too.

(list)

Go to the top of the page
 
+Quote Post
XDelivery
post Aug 9 2006, 09:41 AM
Post #8


Newbie
*

Group: Members
Posts: 0
Joined: 2-August 06
From: A payphone
Member No.: 27,684
QUOTE(FallenSage @ Aug 5 2006, 10:05 PM) *

Well your posting here tongue.gif . But that sounds like a good idea too.


Heh, I was referring to my own inability to read posting dates smile.gif

(list)

Go to the top of the page
 
+Quote Post
OpaQue
post May 9 2007, 10:34 AM
Post #9


Administrator
Group Icon

Group: Admin
Posts: 1,459
Joined: 11-June 04
From: Somewhere in Time & Space.
Member No.: 1
QUOTE(XDelivery @ Aug 2 2006, 05:01 PM) *
Lemme help you out then! smile.gif

Here's a VERY quick and dirty script, to monitor your MySQL db's.

All you have to do, is change the settings, and, crontab it to run every 5-30 mins or so (By the way, you run it, like this: php -q scriptname.php )

I'd say, run one copy on each machine, edit the machine name, and you should get nice, concice emails, from each box, when mysql either dies, or stops responding to queries.

(I wrote it, from scratch, so, if you have any questions, let me know smile.gif )

CODE
<?php

function testfailed($reason_for_failure) {
    # Settings:
    $boxname = "Alpha"; //Set this to the machine's name
    $errorto = "support@computinghost.com"; //Set this to whom you want to receive the warning email
    $errorfrom = "support@computinghost.com"; //Set this to whom you want the error mail to come FROM

    $subject = 'WARNING -- MySQL Failure on ' . $boxname;
    $message = 'Hello, MySQL has failed on' . $boxname . 'The reason given by MySQL was: \r\n' . $reason_for_failure;
    $headers = 'From: ' . $errorfrom . "\r\n" . 'X-Mailer: PHP/' . phpversion();
    mail($errorto, $subject, $message, $headers);
}

#More settings
$mysql_host = "Host.Of.The.MySQL.Machine";  //IP or ohstname of the MySQL machine being tested
$mysql_user = "MySQL_Username";        //MySQL Username
$mysql_password = "MySQL_Password";  //MySQL User password
$test_database =