764281 - Setup Datazilla DBs for production

Status: RESOLVED FIXED

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

Description

[Shyam Mani [:fox2mike]]

DBAs, we need to setup the servers in bug 764278 for the datazilla project.

Based on bug 745318 comment 20 it looks like these will run mariadb with the tokuDB OR Aria storage engine.

I'm more than happy to help out with the puppet side of things, if needed.

Comment 1

[Sheeri Cabral [:sheeri]]

Putting a firm date on this and cc'ing Melissa so it WILL GET DONE.

Comment 2

[Shyam Mani [:fox2mike]]

https://inventory.mozilla.org/systems/show/3845/
https://inventory.mozilla.org/systems/show/3847/

are the machines, they have been kicked and puppetized IIRC.

Comment 3

[Sheeri Cabral [:sheeri]]

done on datazilla1:

groupadd mysql
useradd -g mysql mysql
cd /usr/local
tar -zxvf /home/scabral/mariadb-5.5.25-tokudb-6.1.0-45787-linux-x86_64.tar 
ln -s mariadb-5.5.25-tokudb-6.1.0-45787-linux-x86_64/ mysql
cd mysql
chown -R mysql:mysql .
scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data
cp support-files/mysql.server  /etc/init.d/
/etc/init.d/mysql.server start

Comment 4

[Sheeri Cabral [:sheeri]]

also add this to the PATH:

/usr/local/mysql/bin/

and:
mkdir /var/log/mysql
chown -R mysql:mysql /var/log/mysql
mkdir /var/run/mysqld
chown -R mysql:mysql /var/run/mysqld

we're all good!

[[e-mail]3 mysql]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1
Server version: 5.5.25-tokudb-6.1.0-45787-MariaDB-log MariaDB Server

This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]>

Comment 5

[Sheeri Cabral [:sheeri]]

datazilla1 and datazilla2 are now set up.

Can we get VIP's made for rw and ro?

Left to do: VIPs, backups, monitoring.

Comment 6

[Shyam Mani [:fox2mike]]

VIPs are now in place, datazilla-ro-vip.db.scl3.mozilla.com and datazilla-rw-vip.db.scl3.mozilla.com

rw goes to datazilla1.db.scl3 and ro to datazilla2.db.scl3, let me know if this needs to be switched.

Filing bugs for backup and monitoring.

Sheeri, since you're on PTO, I might add ACLs to mysql (if I get to that stage before I leave, will update them here).

Comment 7

[Matt Pressman [:mpressman]]

user datazilla_moz has been created with access to datazilla_mozilla_org

Comment 8

[Melissa O'Connor [:melissa]]

Sheeri: Is there anything more you need to do here?

Comment 9

[Sheeri Cabral [:sheeri]]

Nope, monitoring and backups are set in bug 778197 and bug 778198. It's ready to use now, though.

Comment 10

[Sheeri Cabral [:sheeri]]

closing this bug, as there's nothing left in it (other things are in other bugs, so won't be forgotten).

Comment 11

[Sheeri Cabral [:sheeri]]

Also doc'd - https://mana.mozilla.org/wiki/display/SYSADMIN/Databases#Databases-Datazillaclusterscl3

Comment 12

[Dustin J. Mitchell [:dustin] (he/him)]

These hosts aren't in puppet.

Comment 13

[Sheeri Cabral [:sheeri]]

They're in puppet now!