839075 - New Graphite Databases

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Eric Ziegenhorn :ericz]

When clustered, Graphite requires a MySQL database for coordinating Django settings, user logins, saved graphs and the like.  It's neither big nor intensive.  Can we get such a database for our Graphite cluster in SCL3 and another for PHX1?

Comment 1

[Sheeri Cabral [:sheeri]]

Sure! We have a generic cluster in phx and a generic cluster in scl3, that do not talk to each other.

Should the database be called "graphite"?

What kind of users will you need? read/write + read_only?

Comment 2

[Eric Ziegenhorn :ericz]

I think just a read/write user would work.  "graphite" works for me!

Comment 3

[Sheeri Cabral [:sheeri]]

OK, it being read-only Friday, I'll do this on Monday.

Comment 4

[Shyam Mani [:fox2mike]]

graphite_mozilla_org will probably be easier to track and consistent with the site name :D

Comment 5

[Sheeri Cabral [:sheeri]]

only production, no dev? :D

Comment 6

[Sheeri Cabral [:sheeri]]

OK, created the db and the host:

MariaDB [(none)]> create database if not exists graphite_mozilla_org;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> grant all on graphite_mozilla_org.* to graphite@10.22.70.20_ identified by 'ELIDED';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> grant all on graphite_mozilla_org.* to graphite@10.22.70.21_ identified by 'ELIDED';
Query OK, 0 rows affected (0.00 sec)

This will allow the graphite user from the load balancers.

The password is on rocky aka admin1a.private.scl3.mozilla.com in /home/eziegenhorn/graphite_pass

If it looks good, please close.

Comment 7

[Eric Ziegenhorn :ericz]

Tested in scl3, thanks!

Comment 8

[Matt Pressman [:mpressman]]

I created the db on the generic cluster in phx1 using the new hashed password that was altered from the default given.

mysql> create database if not exists graphite_mozilla_org;
Query OK, 1 row affected (0.24 sec)

mysql> grant all on graphite_mozilla_org.* to graphite@10.8.70.20_ identified by *PASSWORD;
Query OK, 0 rows affected (0.06 sec)

mysql> grant all on graphite_mozilla_org.* to graphite@10.8.70.21_ identified by *PASSWORD;
Query OK, 0 rows affected (0.06 sec)