[Dev root @ dbversity1host~]# ll -lhtr total 164M -rw-r–r– 1 root root 149M Jul 30 09:59 memsqlbin_amd64.tar -rw-r–r– 1 root root 15M Jul 30 09:59 memsql-ops-4.0.31.tar [Dev root @ dbversity1host~] [Dev root @ dbversity1host~]# mkdir /memsql [Dev root @ dbversity1host~]…
[ root @ dbversity : ~ ] cat Slave_status.sh #!/bin/bash LOGFILE=slavestatus.log mkdir -p /binlogs/cronjobs/Error_Log yum -y -q mail ## ======================================================= **********SLAVE STATUS************* ======================================================================= array=(10.x.xx.xx) for i in “${array[@]}” do #mysql -h$i -umonitor -p’password’ -e”show slave status\G” > /binlogs/cronjobs/Error_Log/$i_Slave_Status.txt 2>/binlogs/cronjobs/Error_Log/$i_Slave_Status.txt mysql…
[ postgres @ dbversity : /YCSB-master ] ls -lhtr total 2.4M -rw-r–r– 1 postgres postgres 479 Aug 18 2014 NOTICE.txt -rw-r–r– 1 postgres postgres 7.9K Aug 18 2014 LICENSE.txt -rw-r–r– 1 postgres postgres 2.6K Aug 18 2014 CHANGELOG drwxrwxrwx 2…
We can calculate the replication lag by comparing the current WAL write location on the primary with the last WAL location received/replayed by the standby. They can be retrieved using pg_current_xlog_location on the primary and the pg_last_xlog_receive_location/pg_last_xlog_replay_location on the standby,…
Postgres installation : [ root @ masterhost : ~ ] yum install postgresql postgresql-server http://guegs3.nam.nsroot.net/SOELinux/repos/prod/soe6gdeproducts-x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 – “The requested URL returned error: 404 Not Found” Trying other mirror. Setting up Install Process Resolving Dependencies –>…
mysql> select * from test; +——+———————+ | id | name | +——+———————+ | 1 | /root/path/to/leaf | | 1 | /var/lib/mysql/data | +——+———————+ 2 rows in set (0.00 sec) mysql> mysql> select id,name, SUBSTRING_INDEX(name, ‘/’, 2) as first_val, SUBSTRING_INDEX(name,…
MemSQL_4.0_Installation_thorough_memsql_ops
[root@ip-10-0-0-67 ycsb-0.1.4]# ll -lhtr total 16M -rw-r–r–. 1 501 games 479 Feb 18 2012 NOTICE.txt -rw-r–r–. 1 501 games 7.9K Feb 18 2012 LICENSE.txt drwxrwxrwx. 2 501 games 102 Feb 22 2012 workloads -rw-r–r–. 1 501 games 2.3K Feb 23…
MySQL General Log : The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. The general…
[root@dbversity ~]$ /opt/mongodb/bin/mongo MongoDB shell version: 2.6.9 connecting to: test > > // To simulate write (inserts) transactions > for(var i = 1; i <= 10000000 ; i++){db.test_collection.insert({“_id” : i , “action” : “write transaction simulations”, ” iteration no:” :…