[PostgreSQL]: Replication setup
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]: How to split a string into multiple columns in a SQL statement
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,…
YCSB Benchmarks on Amazon RDS Oracle
[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/Error log as a solution for user audit log
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…
[Oracle]: SQL*Plus Client installation (sqlplus)
[root@ip-10-0-0-67 ~]# cd /home/ec2-user/ [root@ip-10-0-0-67 ec2-user]# ll -lhtr total 100M -rw-r–r–. 1 root root 95M Feb 24 2012 ycsb-0.1.4.tar.gz -rw-rw-r–. 1 ec2-user ec2-user 809K Jul 7 03:57 oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]#…
mysqlfabric commands
[ root @ vm-5cc5-bad6 : ~ ] mysqlfabric group lookup_servers mysql-ha-group Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e Time-To-Live: 1 server_uuid address status mode weight ———————————— ——————- ——- ———- —— 4a914fd4-1eec-11e5-972b-005056bb627d 10.116.175.107:3306 PRIMARY READ_WRITE 1.0 [ root @ vm-5cc5-bad6 : ~ ] [ root…
MySQLFabric Q&A
MySQL Fabric is built around an extensible and open source framework for managing farms of MySQL Servers. Currently two features have been implemented – High Availability (built on top of MySQL Replication) and scaling out using data sharding. These features…
MySQL: fresh startup script
[ root @ dbversity : /tmp ] cat mysql_fresh_start.sh service mysql stop & sleep 10; cd /var/lib/mysql rm -rf /var/lib/mysql/* mysql_install_db & sleep 10; chown mysql:mysql /var/lib/mysql/ -R echo -e “\n” service mysql start & sleep 5; echo -e “\n”…
MySQL Fabric setup document
MySQL Fabric is a framework for managing groups of MySQL Servers and using those servers to provide services. It is designed to be extensible so that over time many different services can be added. In the current version the services…
[MySQL]: Master-slave replication for a new-setup
Master: 1. Install MySQL as per the standard procedure 2. Edit my.cnf of Master server with below parameters server-id = 8 # Should be unique id between 2 and 2^32 – 1 log-bin = /home/mysql5/mysql-binlogs/’hostname’binlog # required for replication log-bin-index…