Thursday, April 23, 2015

Mysql Master-Master Replication

This site[1] though me how to do the replication.

[1]
https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication

Steps
MasterA (192.168.56.110)
MasterB (192.168.56.111)
1
# yum install mysql-server mysql-client vim ntpdate
# yum install mysql-server mysql-client vim ntpdate
2
# ntpdate ntp.org
# ntpdate ntp.org
3
# service mysqld restart
# service mysqld restart
4
# /usr/bin/mysqladmin -u root password 'mapass'
# /usr/bin/mysqladmin -u root password 'mbpass'
5
# vim /etc/my.cnf
#--------------------------------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

server-id              = 1
log_bin                = /var/log/mysql/mysql-bin.log
binlog_do_db           = example
bind-address           = 192.168.56.110

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#--------------------------------------
# mkdir -p /var/log/mysql/
# chown mysql /var/log/mysql/
# service mysqld restart
# vim /etc/my.cnf
#--------------------------------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

server-id              = 2
log_bin                = /var/log/mysql/mysql-bin.log
binlog_do_db           = example
bind-address           = 192.168.56.111

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#--------------------------------------
# mkdir -p /var/log/mysql/
# chown mysql /var/log/mysql/
# service mysqld restart
6
# netstat -antlp | grep 3306
tcp 0 0 192.168.56.110:3306 0.0.0.0:* LISTEN      1655/mysqld
# netstat -antlp | grep 3306
tcp 0 0 192.168.56.111:3306 0.0.0.0:* LISTEN      1558/mysqld
7
# mysql -u root –p
Mapass

8
mysql> show databases;

mysql> create user 'replicator'@'%' identified by 'rapass';
Query OK, 0 rows affected (0.00 sec)

mysql> grant replication slave on *.* to 'replicator'@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> show master status \G;
            File: mysql-bin.000001
        Position: 341
mysql>

9
We have to use the mysql-bin.000001 and position of 341 over there in masterB server.
mysql> show databases;

mysql> create user 'replicator'@'%' identified by 'rbpass';
Query OK, 0 rows affected (0.00 sec)

mysql> grant replication slave on *.* to 'replicator'@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> show master status \G;
            File: mysql-bin.000001
        Position: 341

mysql> slave stop;

mysql> CHANGE MASTER TO MASTER_HOST = '192.168.56.110', MASTER_USER = 'replicator', MASTER_PASSWORD = 'rapass', MASTER_LOG_FILE = 'mysql-bin.000001', MASTER_LOG_POS = 341;

mysql > slave start;
10
mysql> slave stop;

mysql> CHANGE MASTER TO MASTER_HOST = '192.168.56.111', MASTER_USER = 'replicator', MASTER_PASSWORD = 'rbpass', MASTER_LOG_FILE = 'mysql-bin.000001', MASTER_LOG_POS = 341;

mysql > slave start;

11
Mysql > \! iptables -I INPUT 1 -p tcp --dport 3306 -j ACCEPT
Mysql > \! /sbin/service iptables save
Mysql > \! iptables -I INPUT 1 -p tcp --dport 3306 -j ACCEPT
Mysql > \! /sbin/service iptables save
12
Mysql > create database example;


13

This should create a DB called example here too.
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| example            |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.00 sec)
14
mysql> create table example.Bala (`id` varchar(10));

15
mysql> show tables in example;
+-------------------+
| Tables_in_example |
+-------------------+
| Bala              |
+-------------------+
1 row in set (0.00 sec)
mysql> show tables in example;
+-------------------+
| Tables_in_example |
+-------------------+
| Bala              |
+-------------------+
1 row in set (0.00 sec)
16
The following command will takeout Bala table from example DB on both the servers.
mysql> DROP tables example.Bala;
Query OK, 0 rows affected (0.00 sec)

Monday, October 20, 2014

Changing Timezone in Wireshark

Hi

I don't think there is an outright method in wireshark to do it.  However you can set you TZ to some other value as described in this link  http://seclists.org/wireshark/2011/Oct/402


Get the list of TZ from here http://en.wikipedia.org/wiki/List_of_tz_database_time_zones


Now start wireshark like so to start displaying Time in EST.  Note this works in GNU/Linux OS.  Not sure about other OS.

$ TZ='America/New_York' wireshark &



Friday, October 3, 2014

Ubuntu not discovering other OS on my friends computer

I got burned by Ubuntu not discovering other OS on my friends computer.  I found the answer in the link shown below.


http://askubuntu.com/questions/11916/how-to-restore-windows-xp-menu-entry-in-grub




All we need to do is include the following five lines under /boot/grub/grub.cfg #40 custom OS detections......





As always try to take backup before you screw up something real bad.

menuentry "Some Operating System (on /dev/sda1)" {
    insmod ntfs
    set root='(hd0,1)'
    chainloader +1
}

Saturday, August 2, 2014

PhotoRec looks promising for recovering files



http://www.cgsecurity.org/wiki/PhotoRec

Starting with GIT


Initializing giti init To initialize a Git repository
Checking the Status git status git status command to see what the current state of our project is
Adding git status
Git add octocat.txt
To check and add a file to git tracking mechanism.
Committing git commit -m “Add cute octocat story”
Adding All Changes git add '*.txt' Adding all *.txt files alone
Committing all git commit -m “Add all the octocat files” Now committing them.
History git log
Remote Repositories git remote add origin https://github.com/try-git/try_git.git To push the changes of local repo to the server
Pushing Remotely git push -u origin master The -u is to remember origin and master, next time we can just do git push
Pulling Remotely git pull origin master
Difference git diff HEAD
Difference git add octocat/octodot.txt
Staged Difference git diff –staged
Resetting the Stage git reset ocotfamily/octodog.txt

git checkout – octodog.txt
Branching Out git branch clean_up

git checkout clean_up
Removing All The Things git rm '*.txt'

git commit -m “Remove all the cats”

git checkout master

git merge clean_up
Keeping things clean git branch -d clean_up Deleting the branch clean_up

git push

Monday, July 21, 2014

Strange words



3-21
flabbergast :surprise (someone) greatly; astonish.
Jibber Jabber: useless words, beating around the bush,

3-22
my chair my rules -> sella mea et praecepta mea(Latin)


4.3
Beaver - Rodent
wee-wee - a child's word for urine.
potty - a bowl used by small children as a toilet.
buck up - Be strong
intimidate - frighten or overawe (someone), especially in order to make them do what one wants.
obnoxious - extremely unpleasant.
caterwauling - (of a cat) make a shrill howling or wailing noise.
bitchy pills -
condescension - an attitude of patronizing superiority
subtle - making use of clever and indirect methods to achieve something.
defecate - discharge faeces from the body.
outright - wholly and completely.
cognitive - cognition - the mental action or process of acquiring knowledge and understanding through thought, experience, and the senses.
ipso facto - by that very fact or act.
subsume - include or absorb (something) in something else.
rankest - having a foul or offensive smell.
hogwash - nonsense.
preposterous - contrary to reason or common sense; utterly absurd or ridiculous.
pining - suffer a mental and physical decline, especially because of a broken heart.
 

Monday, June 16, 2014

Cesiumjs 3D Globe, 2.5D and 2D map

Here is the piece of html code which I have used download.

This is the video which I recorded after writing that piece of code.