Unix Services

Enterprise MySQL

MySQL is an open-source SQL database server that supports multiple applications and websites across the laboratory. MySQL supports various languages for data queries and manipulation, including PHP, Perl, Python, Java, Ruby, ASP, and .NET.

ITD Unix Services maintains a highly-available MySQL 5.1 installation. This service is only available to the internal BNL network.

Data from ITD's MySQL service is backed up regularly in multiple ways, allowing full point-in-time recovery for enterprise-level applications that require it.

Various command-line and graphical tools are available for interaction with, and administration of, MySQL servers.  There are many open source, shareware and commercial products on the market.

To request an account and/or database on ITD's MySQL service or for assistance in setting up a separate MySQL installation specific to your needs, contact the ITD Helpdesk at x5522 or via email to itdhelp@bnl.gov.

For additional resources and information about MySQL please examine the following resources available from MySQL:

• MySQL Website: http://www.mysql.com/
• MySQL Reference Manual: http://dev.mysql.com/doc/refman/5.1/en/
• MySQL Workbench GUI: http://dev.mysql.com/downloads/workbench/5.2.html

Last Modified: February 14, 2011

To reach ITD Unix Services for any support issues, please contact the ITD Helpdesk via email (itdhelp@bnl.gov) or call x5522.  In any communications, please include the name of the machine(s) in question, as well as their operating system, software package and other relevant information which will allow ITD to help you more effectively.

One of ten national laboratories overseen and primarily funded by the Office of Science of the U.S. Department of Energy (DOE), Brookhaven National Laboratory conducts research in the physical, biomedical, and environmental sciences, as well as in energy technologies and national security. Brookhaven Lab also builds and operates major scientific facilities available to university, industry and government researchers. Brookhaven is operated and managed for DOE's Office of Science by Brookhaven Science Associates, a limited-liability company founded by the Research Foundation for the State University of New York on behalf of Stony Brook University, the largest academic user of Laboratory facilities, and Battelle, a nonprofit, applied science and technology organization.

Privacy and Security Notice  | Contact Web Services for help