1. Summary
  2. Files
  3. Support
  4. Report Spam
  5. Create account
  6. Log in
Version 10 (modified by moorman, 5 years ago)

--

Project Database

SourceForge.net provides MySQL database services on a opt-in basis.

These database services may be used for a variety of things, including:

We encourage developers new to MySQL to familiarize themselves with the MySQL manual. Projects developing applications on MySQL should check out the book, "High Performance MySQL".

Features

  • 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.

Access

FIXME

Database Host

Replace LETTTER in the following hostname with the first letter in the project UNIX name.

mysql-LETTER.sourceforge.net

For example, the project someproject would access use the following hostname to access their Database

mysql-s.sourceforge.net

Database Name

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.

Database Users

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:

https://apps.sourceforge.net/admin/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

Management

FIXME

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.

Backups

Please see our backup documentation for information on the SourceForge.net backup policy and for information on how to perform a backup. FIXME

Getting Help