include 'head.php';
?>
-<strong>Important Notice:</strong><p> This is a beta service and is not yet ready for use in data intensive applications.
-
-<hr />
-
-<br />
-
-<h2>About</h2>
-
-<p>
-This service provides <a href="http://www.mysql.com/">MySQL</a> databases to <a href="http://ca.mit.edu/">Athena account</a> holders.
-You must choose a MySQL password (independent of your Athena account) when you <a href="signup">Signup</a> and then use this interface to create and drop your MySQL databases.
-All subsequent SQL commands can be issued from any host, client, and/or script of your choosing.
-</p>
-
-<h2>Backups</h2>
-
<p>
-As you work with your SQL data, it is automatically saved on an additional secondary SQL server for restoration in the event of a single server failure.
-<strong>We strongly recommend you keep your own backups for your own independent use in all other cases.</strong>
-Although we continually put forth our best efforts, we can make no guarantees on the reliability of the service and access to the data.</p>
-
-<h2>Quotas</h2>
-
-<p>
-By default, new users can create up to <strong>5 databases</strong>, consuming a total of <strong>25 megabytes</strong> of SQL data.
-The system will periodically check your database sizes and suspend creation of new data (INSERT statements) if your total usage exceeds your allotted quota.
+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="do/signup">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>
-This service is not designed to store gratuitous amounts of information in the BLOB or BINARY formats. Extra quota space will not be allotted to users for this type of data.
-Users should instead store these types of data in AFS and use SQL tables only to catalogue it.
+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>
-<h2>Disclaimer</h2>
-
<p>
-We reserve the right to suspend or terminate your MySQL account at any time and for any or no reason.
+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>
-<p>
-We maintain general usage statistics of this service by the MIT community at large.
-</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';
andersk / sql-web.git / blobdiff