MySQL database facilities

Maths has two dedicated MySQL servers available to all users:

For research

Following a request from a research group, a generally accessible MySQL database server was set up in May 2015 for those who wish to host SQL databases for research purposes. Accessible from any DNS-registered computer at Imperial College, this server will allow you to have your own database account and be able to create tables, etc yourself.

For web-related purposes

An additional MySQL server is available on the collaboration and sharing server intended mainly for supporting web-based projects hosted on this server. This essentially re-instates the MySQL server facility the department had up until 2007 when the departmental webpages moved to College central hosting and the Maths webservers, which also hosted a MySQL server, were closed down.

If you would like to use either of these database servers just mail Andy Thomas with your choice of database name, the host server (macomp00 or share2) and your College username and an account will be set up for you.

MySQL is a high performance SQL relational database with speeds on a par with Oracle 12 and IBM's DB2 heavyweight mainframe databases - it is perhaps no surprise that MySQL is very popular with commercial web sites.

Andy Thomas

Research Computing Officer
Department of Mathematics

last updated: 06.10.15