Get Latitude/Longitude from an address (or Geocoding ) using PHP

$geocode=file_get_contents('http://maps.google.com/maps/api/

geocode/json?address=573/1,+Jangli+Maharaj+Road,

+Deccan+Gymkhana,+Pune,+Maharashtra,+India&sensor=false');

$output= json_decode($geocode);

$lat = $output->results[0]->geometry->location->lat;
$long = $output->results[0]->geometry->location->lng;

Create Virtual Host on Ubuntu

Install
1. cd /etc/apache2/sites-available
2. sudo vim yourdomain.com.conf and enter your VirtualHost directive. Below I've put
the most basic example, see Apache docs for details and additional features:
3. <VirtualHost *>
4. ServerName yourdomain.com
5. DocumentRoot /home/youruser/public_html
6. </VirtualHost>
7. Save & exit.
8. sudo vim /etc/hosts and add your new domain to the 127.0.0.1 localhost line so it looks
like this:
9. 127.0.0.1 localhost yourdomain.com
10. Save & exit.
11. Enable your new virtualhost:
12. sudo a2ensite yourdomain.com.conf
13. Reload the Apache configuration:
14. sudo /etc/init.d/apache2 reload

Remove

Code:
sudo a2dissite sitename
Restart apache2
Code:
sudo /etc/init.d/apache2 reload
Again to remove (delete)it completely from the system,
Code:
sudo rm /etc/apache2/sites-available/sitename
I would also disable it first before deleting the file.

Backup script + User in mysql

backup script
***************************
su d=$(date +%Y_%m_%d_%H_%M)
project="project_data"
path="/backup/databases/$project-$d.gz"
mysqldump --opt --routines --single-transaction -uroot -ppassword $project | gzip > $path
**************************************

restore
****************************************
gunzip < project_data.gz | mysql -uroot -p -h192.168.1.1
project_data
****************************************

User
#####Create user
create user 'developer'@'localhost' identified by 'password';

######grant user
grant all on *.* to 'developer'@'localhost';
FLUSH PRIVILEGES;
#
######revoke user
REVOKE INSERT ON *.* FROM 'jeffrey'@'localhost';
FLUSH PRIVILEGES;
#
######Drop user
DROP USER 'jeffrey'@'localhost';

######Update user password
update user set password=PASSWORD("123456") where user='root' and
host='localhost';
flush privileges;

######Show grant of user
SHOW GRANTS FOR 'developer'@'%';

MySQL Replication

MySQL Replication

Two years ago, I had to learn MySQL replication because we had to transfer our databases to a new server with minimal downtime. If it's performed correctly, the downtime could be under 60 seconds. In my case, the downtime was about 5 minutes because of my carelessness. Nonetheless, MySQL replication can be used for many purposes including:

1. Scalability - if most of your queries are read.
2. Data security
3. Analytics - there are cases when you have complex queries and you do not want to put the stress on the production server.
4. Long-distance data distribution

Whatever your reason for coming here. Let's cut it short and start configuring.

Configuring the master server

1. Master server must have binary log enabled
2. Unique server-id must be configured

Edit my.cnf, for

• Red Hat based server: /etc/my.cnf
• Debian based server: /etc/mysql/my.cnf

Insert the following lines under [mysqld]:

[mysqld]
log-bin   = mysql-bin
server-id = 1

Make sure the following lines must be commented out. Otherwise, slave servers won't be able to access the master:

#skip-networking
#bind-address    = 127.0.0.1

Now, restart MySQL service:

Debian based:  service mysql restart
Red Hat based: /etc/init.d/mysqld restart

Create replication user on master server

1. Log into MySQL server as root
   

   mysql -uroot -p

2. Now, on MySQL shell create the replication user
   

   mysql> GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY 'password';

   mysql> FLUSH PRIVILEGES;

Configuring the slave server

1. Unique server-id must be configured. Remember, none of the slave/master servers can have the same server-id. Server-id enabled communication between the master and slave servers.
2. Enabling binary log is not compulsory but it recommended for data backup and crash recovery. There might be a case when you want this slave server to be the master server for other slaves.
3. The following configurations can be set/changed whilst MySQL service is running:
   
   • master-host: master IP address or hostname.
   • master-user: MySQL user account with replication privilege.
   • master-password: replication user password.
   • master-connect-retry: seconds to retry to connect after network failure.

Edit my.cnf and insert the following lines under [mysqld]:

[mysqld]
log-bin               = mysql-bin
server-id             = 2
master-host           = 192.168.0.1
master-user           = slave_user
master-password       = password
master-connect-retry  = 60

Now, restart MySQL service.

Preparing to replicate
Most of the cases, we have our master database running long before the slave. Hence, the master database should have a lot of data. We must import data from master to slave before replicating. There are two ways:

1. LOAD DATA FROM MASTER:
   use this if you are willing to have the master server being locked during the importing operation.
   
   1. Log into MySQL server as root:
      

      mysql -uroot -p

   2. Now, importing and replicating from MySQL shell:
      

      mysql> LOAD DATA FROM MASTER;

   Done! Life cannot be simpler than this!
   
   
2. Common procedure:
   
   Tasks on master server
   
   1. Enabling READ LOCK from master server for mysqldump later. We want to make sure that data will not be changed while we dumping the databases:
      

      mysql> FLUSH TABLES WITH READ LOCK;

   2. Now, get the log sequence number:
      

      mysql> SHOW MASTER STATUS;

      If we see something like this, then we are on the right track:

      +------------------+----------+--------------+------------------+
      | File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
      +------------------+----------+--------------+------------------+
      | mysql-bin.000001 |      106 |              |                  |
      +------------------+----------+--------------+------------------+
      1 row in set (0.00 sec)

      Please take note of the position (106)! This is the log position where we start backing up the data.
   3. Backup up the database from Linux shell:
      

      mysqldump --routines --triggers --single-transaction --quick -uroot -p --all-databases > all-dbs.sql

   4. Unlock the master database so data can be written:
      

      mysql> UNLOCK TABLES;

   5. Now, transfer SQL file (all-dbs.sql) to slave server.
   
   Tasks on slave server
   
   1. Import data to slave server:
      

      mysql -uroot -ppassword mysql < /path/to/all-dbs.sql
      Note: -ppassword: no space between -p & password

   2. Stop slave from replicating:
      

      mysql> SLAVE STOP;

   3. Now, we have to manually set the log sequence position:
      

      mysql> CHANGE MASTER TO
      MASTER_HOST='192.168.0.1',
      MASTER_USER='slave_user',
      MASTER_PASSWORD='password',
      MASTER_LOG_FILE='mysql-bin.001',
      MASTER_LOG_POS=106;

   4. Finally, start replicating:
      

      mysql> SLAVE START;

By now, our slave server should be replicating from the master server.