WARNING: This web is not used anymore. Please use PDBService.CurrentStatus instead!
 

Status of the MySQL integration service

Date Task
Domain Duration Administrator
09/04/2008 MySQL 5.0 server configuration update in order to enable logging of the slow queries (e.g. longer then 10s):

mkdir /var/log/mysql
touch /var/log/mysql/log-slow-queries.log
chown mysql.mysql -R /var/log/mysql

In /var/lib/mysql/my.cnf:
set-variable=long_query_time=1
log-slow-queries=/var/log/mysql/log-slow-queries.log
DB configuration 1h
+
2h
tuning
task
Radovan
16/01/2008 Added RBASSET schema nad rbasset account:

CREATE DATABASE IF NOT EXISTS RBASSET;
GRANT ALL PRIVILEGES ON RBASSET.* TO 'rbasset'@'137.138.%' IDENTIFIED BY '*****' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON RBASSET.* TO 'rbasset'@'128.141.%' IDENTIFIED BY '*****' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON RBASSET.* TO 'rbasset'@'128.142.%' IDENTIFIED BY '*****' WITH GRANT OPTION;
Users, Security   Radovan
17/12/2007 Added LCG_COOL_NIGHTLY database and account:

CREATE DATABASE IF NOT EXISTS LCG_COOL_NIGHTLY;
GRANT ALL PRIVILEGES ON LCG_COOL_NIGHTLY.* TO 'AVALASSI'@'137.138.%' IDENTIFIED BY '*****' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON LCG_COOL_NIGHTLY.* TO 'AVALASSI'@'128.141.%' IDENTIFIED BY '*****' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON LCG_COOL_NIGHTLY.* TO 'AVALASSI'@'128.142.%' IDENTIFIED BY '*****' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON LCG_COOL_NIGHTLY.* TO 'LCG_COOL_NIGHTLY'@'137.138.%' IDENTIFIED BY '*****' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON LCG_COOL_NIGHTLY.* TO 'LCG_COOL_NIGHTLY'@'128.141.%' IDENTIFIED BY '*****' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON LCG_COOL_NIGHTLY.* TO 'LCG_COOL_NIGHTLY'@'128.142.%' IDENTIFIED BY '*****' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON LCG_COOL_NIGHTLY.* TO 'LCG_COOL'@'137.138.%' IDENTIFIED BY '*****' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON LCG_COOL_NIGHTLY.* TO 'LCG_COOL'@'128.141.%' IDENTIFIED BY '*****' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON LCG_COOL_NIGHTLY.* TO 'LCG_COOL'@'128.142.%' IDENTIFIED BY '*****' WITH GRANT OPTION;
Users, Security   Radovan
03/04/2007 Updated /etc/sysconfig/iptables by adding:

-A INPUT -s 128.142.0.0/16 -p all -j ACCEPT

and followed by:

service iptables restart

Updated Persistency and POOL writer accounts to allow nightly builds succeed from build servers:
GRANT ALL PRIVILEGES ON Persistency_WRITER.* TO 'Persistency_WRITER'@'128.142.%' IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON CORAL_TEST_WRITER.* TO 'CORAL_TST_WRITER'@'128.142.%' IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON RAL_TEST_WRITER.* TO 'RAL_TEST_WRITER'@'128.142.%' IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON RAL_WRITER.* TO 'RAL_WRITER'@'128.142.%' IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;
Security   Radovan
18/03/2007 Updated COOL accounts access for additional network 128.142.x.x by:
GRANT ALL PRIVILEGES ON LCG_COOL.* TO 'LCG_COOL'@'128.142.%' IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON AVALASSI.* TO 'AVALASSI'@'128.142.%' IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON SAS.* TO 'SAS'@'128.142.%' IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON MARCOCLE.* TO 'MARCOCLE'@'128.142.%' IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;
Security   Radovan
16/03/2007 Reconfigured MySQL 5.0.37 server to use InnoDB engine as the default one + ANSI syntax.
Reconfigured physical data storage for InnoDB tablespaces and logs.
The server specific config file has been put in place: ln -s /data/service/server_config/mysql5.0.x.my.cnf /var/lib/mysql/my.cnf, see it attached as well.
DB configuration   Radovan
15/03/2007 The LCG COOL, POOL and Persistency projects required schemas and users have been created, see the attached scripts.
The notification e-mails have been sent to the responsibles and asking them to change the passwords after their first database interactive connection
Schemas & Users   Radovan
13/03/2007 Upgrade of MySQL software to the community version 5.0.37
$ mkdir -p /data/sw/5.0.37
$ cd /data/sw/5.0.37
$ wget ftp://ftp.solnet.ch/mirror/mysql/Downloads/MySQL-5.0/MySQL\*5.0.37-0.glibc23.i386.rpm
$ rpm -e MySQL -standard-debuginfo-5.0.27
$ rpm -e MySQL -shared-standard-5.0.27
$ rpm -Uvh MySQL -server-5.0.37-0.glibc23.i386.rpm MySQL -shared-5.0.37-0.glibc23.i386.rpm MySQL -devel-5.0.37-0.glibc23.i386.rpm MySQL -client-5.0.37-0.glibc23.i386.rpm MySQL -debuginfo-5.0.37-0.glibc23.i386.rpm
$ service mysql restart
DB software   Radovan
09/03/2007 Changing IPTABLES configuration to allow connections on ports 3306 (MySQL default), 3307, 3308 as we plan to run multiple MySQL server versions updating /etc/sysconfig/iptables file by adding the following:

-A INPUT -m tcp -p tcp --dport 3306 -j ACCEPT
-A INPUT -m tcp -p tcp --dport 3307 -j ACCEPT
-A INPUT -m tcp -p tcp --dport 3308 -j ACCEPT
-A INPUT -s 128.141.0.0/16 -p all -j ACCEPT
Security   Radovan
09/03/2007 Configuring SPMA to allow user defined RPMs by setting in /etc/spma.conf:userpkgs = yes CERN legacy   Radovan
09/03/2007 Setting MySQL server root password right after RPMs were installed Security   Radovan
09/03/2007 Installation of the MySQL 5.0.27 software using RHEL 4 RPMs from MySQL DB software   Radovan

Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatsql create_integration_users.sql r1 manage 3.4 K 2007-03-15 - 16:39 RadovanChytracek user creation script
Unknown file formatsql drop_integration_users.sql r1 manage 2.2 K 2007-03-15 - 16:40 RadovanChytracek user cleanup script
Unknown file formatcnf my.cnf r1 manage 4.9 K 2007-03-16 - 16:40 RadovanChytracek Mysql 5.0.x server configration file
Edit | Attach | Watch | Print version | History: r11 < r10 < r9 < r8 < r7 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r11 - 2010-06-11 - PeterJones
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback