|Version 10 (modified by moorman, 5 years ago)|
SourceForge.net provides MySQL database services on a opt-in basis.
These database services may be used for a variety of things, including:
- Data storage for dynamic project websites.
- Data storage for demos of the project's software residing in project web space.
- In support of project software testing and development needs.
- Data storage for applications deployed by the project to Project web.
- Service is based on MySQL 5.0.x on the x86_64 architecture and supports standard features, with the following caveats:
- We discourage use of pconnect due to the way we distribute load among our server pool. Please use standard connects.
- We discourage use of INSERT DELAYED due server load risks.
- Query runtime is capped at 120 seconds. Queries that exceed the cap will be killed.
- Project databases are accessible from the project web servers.
- Project databases are accessible from the interactive shell servers. The command-line MySQL client is installed on the shell servers.
- A centralized install of phpMyAdmin is provided to ease database management.
- Direct access is provided over the Internet, enabled on a time-limited basis using a self-service interface.
- Three database users are provided for each database, one for each access level: admin, read/write, and read-only.
- Projects may create multiple databases (under the namespace provided to the project) using their admin database account.
Replace LETTTER in the following hostname with the first letter in the project UNIX name.
For example, the project someproject would access use the following hostname to access their Database
Database names are defined by the person who creates the database. A project's database name will be prefixed by the first letter in the project UNIX name, the project Group ID and an underscore (_). This prefix is provided on the project database admin page. For example, if the project filezilla wanted to create a database with the name of "cmsdata", the database would be named f21558_cmsdata.
Each project is provided with three database users, each with a different permissions set. The database usernames are prefixed with the first letter in the project's UNIX name, followed by the project Group ID and end with the permissions identifier. Valid permissions identifiers are: ro, rw and admin. The ro user has SELECT privileges. The rw user has SHOW VIEW privileges. The admin user has SHOW VIEW and CREATE VIEW privileges. As an example, the project filezilla has three users: f21558ro, f21558rw and f21558admin.
Database User Password
Password is specified by the project administrator on the database admin page, must be initially set here and can be changed at any time.
From the Internet
The Internet access offering further extends database access options, and permits users to do things such as remotely make backups, perform data load-in, or use GUI database management tools from their workstation.
Access is provided four hours at a time, for sake of security, and because access to a database over the Internet involves latency we don't want projects running web applications on remote servers talking to the DB over the Internet. Access is provided on-demand after project members request access for their IP address via a self-service management interface. To access the management interface go to replace PROJECT in the URL below with the UNIX name of your project:
You will be prompted to log in with your SourceForge.net username and password.
Once your IP address has been granted access to the MySQL servers, you may connect by following the instructions provided on the management interface regarding hostname and port, and using the MySQL username/password combinations set up for your project.
For example (possible only after you have authorized your IP for access):
mysql -u USERNAME -h mysql-LETTER.sourceforge.net -P 4040 -p
Opt In and Password
The database service is no longer opt-in, a password must be configured for each of the database users to create and access the project databases. There are no preconfigured databases for a project, they must be created using the database admin user by a project member.
Please see our backup documentation for information on the SourceForge.net backup policy and for information on how to perform a backup. FIXME