Tech talk

Wanna split the database server and the application server???? Wanna get some more performance with your servers ?? follow these simple steps and feel the difference........

First off never make a server as your windows XP machine if you want to support more than 5 users simultaneously, it will really make a mess of your application. Always use linux(any distro) as your server. I ususally use fedora or ubuntu. So start with making the root user on the database server and then give the root user permissions so that when the application server tries to contact the database server it can easily get through.

Okay now, what you need next is configuring your application server now. If you have used connection pooling, just give the ip of the server you have made as ur database server and never forget to give the exception of the port used in the firewall settings otherwise u will keep trying and u wud never get a response.

So, configured you application server and gave permissions to the root user with the ip of application server. Then you are all set to feel the experience of load distribution.

some command to create user on the database server and giving permission: (MYSQL 5.1 specific commands)

1) update mysql.user set password=password('newpassword') where user='root';
2) create user 'root'@'ipaddress' identified by 'password';
3) grant all on database.table to 'root'@'ipaddress' identified by 'password';
4) configure your application server for your database server's ip address and you are all set to start your application having a database server on the remote system.

happy splitting!!!!