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

--

Project Database

SourceForge.net provides MySQL database services to all SourceForge.net projects.

Features

*Three preconfigured database users provide for admin, read-write, and read-only access.

*A centralized installation of phpMyAdmin? is available for projects to use.

Management

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.

phpMyAdmin? is a web-based MySQL administration tool and client. It can be accessed at https://mysql-LETTER.sourceforge.net/, where LETTTER is the first letter in the project UNIX name (i.e. the project 'filezilla' would access https://mysql-f.sourceforge.net/). The username and password for the !phpMyAdmin installation matches that of the database usernames and passw

We strongly recommend against using persistent connections (pconnects) and INSERT DELAYED. In a shared environment, neither of these solutions will significantly improve your database performance, and due to technical limitations, may actually have negative impact on your application performance.

We have implemented a MySQL query runtime cap of 120 seconds. All queries that run longer than that will be stopped when detected. You should optimize your query to make it run faster. This cap has been implemented to preserve service performance (this service is shared by many projects).

Currently, SourceForge.net provides only MySQL database services to SourceForge.net-hosted projects. There are no plans at this time to provide other database services at this time.

The MySQL database service is only accessible from the SourceForge.net project web servers.

The project database service is only available to projects hosted on SourceForge.net.

SourceForge.net only provides the preconfigured database users.

Access

Database Host

mysql-LETTER (LETTER is the first letter in your project's UNIX name, the project filezilla would use mysql-f, for example)

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.

Backups

Getting Help

The MySQL Documentation is an excellent source of information on MySQL.

EXPANDME

READYTOEDIT

Pull content from http://alexandria.wiki.sourceforge.net/Project+Web%2C+Shell%2C+VHOST+and+Database+Services