725696 - Add Database Support to De Todos Para Todos

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Christie Koehler [:ckoehler]]

The second iteration of the Facebook tab for DTPT requires a database.

Please:

1. Create database and user.
2. Update db name and credentials in tab/db.config.php (copied from db.config.php.sample).
3. Run tab/mysql/feb012012.sql
4. Block web access to tab/mysql/feb012012.sql via apache conf (or less us know if it should be done via htaccess).

Thanks!

Comment 1

[Sheeri Cabral [:sheeri]]

In order to best place the database, can you give us some information about the database?  How big do you expect it to grow?  Do you have any anticipation of purging data that's older?  What's the usage you expect to see from this?  

Obviously estimates and reality are different, but we should at the very least start with a good idea of what we should be doing here.

Comment 2

[Antonio Rodriguez]

Greetings,

The database won't grow at all. We are using a database because we were saving user information, but based on our last meeting we scratched that functionality.

At the moment, the database will hold 1 table and that 1 table will hold 1 row/entry/value that will auto-increment as users participate/share. Right now this database will work as a simple click-counter.

Comment 3

[Christie Koehler [:ckoehler]]

Antonio - Do you have an idea what the db requirements will be for the main part of the website? We should take that into consideration at this time.

Comment 4

[Sheeri Cabral [:sheeri]]

BTW, I'm very happy to join one of your meetings to discuss how the database might grow if you'd like....

Comment 5

[Christie Koehler [:ckoehler]]

I spoke with Sheeri this afternoon about the requirements and she'll be able to set up databases for dev, stage and prod on Monday.

Comment 6

[Sheeri Cabral [:sheeri]]

Databases:

Dev:
read/write server: dev1.db.phx1.mozilla.com
read-only server: dev2.db.phx1.mozilla.com
db name: dtpt_dev_allizom_org
users:
dtpt_dev
dtpt_dev_ro

Stage:
read/write server: dev1.db.phx1.mozilla.com
read-only server: dev2.db.phx1.mozilla.com
db name: dtpt_allizom_org
users: 
dtpt_stage
dtpt_stage_ro

Production:
read/write server: db-generic-rw
read-only server: db-generic-ro
db name: dtpt_mozilla_org
users:
dtpt
dtpt_ro

I will work out a way to get the passwords to you.

Comment 7

[Sheeri Cabral [:sheeri]]

Correction (stage/dev db's are not as I wrote them before):

Databases:

Dev:
read/write server: db-dev-rw
read-only server: db-dev-ro
db name: dtpt_dev_allizom_org
users:
dtpt_dev
dtpt_dev_ro

Stage:
read/write server: db-dev-rw
read-only server: db-dev-ro
db name: dtpt_allizom_org
users: 
dtpt_stage
dtpt_stage_ro

Production:
read/write server: db-generic-rw
read-only server: db-generic-ro
db name: dtpt_mozilla_org
users:
dtpt
dtpt_ro

I will work out a way to get the passwords to you.

Comment 8

[Sheeri Cabral [:sheeri]]

Resolving, please reopen if there are issues.