Don't advertise /do/signup; it doesn't write a my.cnf

[sql-web.git] / tpl / index.php

diff --git a/tpl/index.php b/tpl/index.php
index 6f454e6107697409be0c84d9147156671e158dec..d48d031220fa0f272539f982c9fe585b0a1ae98e 100644 (file)
--- a/tpl/index.php
+++ b/tpl/index.php
@@ -1,7 +1,49 @@
 <?php
 include 'head.php';
+?>
+
+<p>
+This service provides <a target="_blank" href="http://dev.mysql.com/doc">MySQL</a> databases to <a target="_blank" href="http://ca.mit.edu/">MIT certificate</a> holders.
+You must choose a MySQL password (which should be different from your Athena account password) when you <a href="http://scripts.mit.edu/faq/27">sign up</a>, and
+then use this interface to create and drop databases.  All subsequent SQL commands can be issued from any host, client, and/or script of your choice;
+simply connect to the MySQL server at <b>sql.mit.edu</b> using your username and your new MySQL password.
+You may find it convenient to run scripts using the <a target="_blank" href="http://scripts.mit.edu/web">web script service</a> or
+<a target="_blank" href="http://scripts.mit.edu/cron">shortjobs service</a>.
+</p>
+
+<p>
+All uses of this service must comply with the <a target="_blank" href="http://web.mit.edu/olh/Welcome/rules.html">MITnet rules of use</a>.
+</p>
 
+<p>
+This service has been designed with reliability in mind; we utilize RAID, live server mirroring and periodic offline backups to ensure data reliability.
+However, the SIPB MySQL service should not be used to host critical applications that cannot tolerate downtime.
+One nightly backup is available for your locker at <code>/mit/sql/backup/LOCKER_NAME</code>.  You should perform additional backups of your data using the <a href="http://scripts.mit.edu/cron">shortjobs service</a> or <a href="http://scripts.mit.edu/faq/10/how-can-i-back-up-or-restore-my-sql-data">phpMyAdmin</a>.
+</p>
 
+<div style="text-align:center; font-style: italic;">
+<?php
+if (file_exists('/afs/athena.mit.edu/contrib/sql/stat/questions')) {
+       $x = file_get_contents('/afs/athena.mit.edu/contrib/sql/stat/questions');
+       list($t, $v) = explode("\n", $x);
+       $qavg = $v/$t;
+       $qunits = array('','k','M','G','T','P','E','Z','Y');
+       while (count($qunits) && $v/1000>1) {
+               array_shift($qunits);
+               $v /= 1000;
+       }
+       printf('sql.mit.edu has served %.3f%s queries', $v, array_shift($qunits));
+       $qunits = array('minutes', 'hours', 'days');
+       $qdiv = array(60, 60, 24);
+       while (count($qdiv) && $t/$qdiv[0]>0) {
+               $t /= array_shift($qdiv);
+               $tunits = array_shift($qunits);
+       }
+       printf(' in the last %.2f %s (%.2f qps)', $t, $tunits, $qavg);
+}
+?>
+</div>
 
+<?php
 include 'foot.php';
 ?>