706206 - mm setup

Status: RESOLVED FIXED

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

Description

[Sheeri Cabral [:sheeri]]

mm setup between generic101.webapp.phx1 and whatever host gets setup in sjc

Comment 1

[Sheeri Cabral [:sheeri]]

Not sure if LDAP is set up for this just yet:

[scabral@natasha ~]$ ssh generic101.webapp.phx1
Permission denied (publickey,gssapi-keyex,gssapi-with-mic).
[scabral@natasha ~]$ ssh root@!$
ssh [e-mail]1
Last login: Tue Nov 29 11:18:41 2011 from 10.8.81.5
[[e-mail]1 ~]# 

That might be OK or not.....just noting it here.

Comment 2

[Sheeri Cabral [:sheeri]]

MySQL and db's are already on the machine, so I'm just waiting for whatever sjc host is setup to be able to setup master/master.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
| wos                |
+--------------------+
4 rows in set (0.00 sec)

mysql> show variables like 'version';
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| version       | 5.1.52 |
+---------------+--------+
1 row in set (0.00 sec)

Comment 3

[Sheeri Cabral [:sheeri]]

pipe isn't completely clear between the 2 servers -- wostest1.webapp.sjc1 and generic101.webapp.phx1, updated bus 706954 with the details.

Comment 4

[Sheeri Cabral [:sheeri]]

Set up, I had to enable binary logging and put server id's, so I used the last 2 octets of the IPs (so they're unique) and set expire_logs_days to 30.