]>
Commit | Line | Data |
---|---|---|
e4fd5e1b JP |
1 | #extends templates.common.shell |
2 | ||
3 | #def title: MySQL Services | |
4 | ||
5 | #block body | |
6 | <p> | |
7 | 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. | |
8 | 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 | |
9 | 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; | |
10 | simply connect to the MySQL server at <b>sql.mit.edu</b> using your username and your new MySQL password. | |
11 | You may find it convenient to run scripts using the <a target="_blank" href="http://scripts.mit.edu/web">web script service</a> or | |
12 | <a target="_blank" href="http://scripts.mit.edu/cron">shortjobs service</a>. | |
13 | </p> | |
14 | ||
15 | <p> | |
16 | 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>. | |
17 | </p> | |
18 | ||
19 | <p> | |
20 | This service has been designed with reliability in mind; we utilize RAID, live server mirroring and periodic offline backups to ensure data reliability. | |
21 | However, the SIPB MySQL service should not be used to host critical applications that cannot tolerate downtime. | |
22 | 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>. | |
23 | </p> | |
24 | ||
25 | <div style="text-align:center; font-style: italic;"> | |
26 | <!-- /afs/athena.mit.edu/contrib/sql/stat/questions --> | |
27 | </div> | |
28 | #end block body |