If you need a mySQL database for your research or project, the BSOE hosts a shared mySQL database server that is backed up nightly. As a rule of thumb, we allow databases on this shared server up to 20GB, a maximum of 5,000 queries per hour, and a maximum of 10 concurrent database connections.
These mySQL databases may be used for senior projects, instructional projects, graduate projects or general research efforts.
If you would like to request a mySQL database for your research or project, please submit a request using the web form. Upon approval of the sponsoring faculty or staff member, mySQL connection information will be e-mailed to you.
If you plan on using this service, it would be a good idea to subscribe to the BSOE mySQL e-mail list to be notified about system updates and planned downtime.
Our mySQL server is backed up nightly and databases can be restored from those backups. Generally, 5 days worth of mySQL backup data are retained. Additionally, we maintain a multi-master replication set-up with a second mySQL server that is located in the San Diego Supercomputing Center, which acts as a more-or-less up-to-the-minute backup server in the event of hardware failure of the primary server.
If you need additional backup capacity, you can run your own mySQL dumps from a cron job on an interactive server and dump the results to a projects disk.