I know i'm a newbie at this, but i don't wan't to mess this up so i am asking for advices and tips and tricks on this...
I have put up on a server a large (500 Mo) database that is smoothly running, and responding to our demand.
This database will be called from a software that requires data updated regurlaly for an external source.
We are wondering, how in the future, the migration of servers will be as transparent as possible and how we can code in hard in the software an adress to point on the database (the risk with an ip adress, is when we will change of ip... It will then require that we provide a new software version with new ip in it...)
I was thinking of putting up a ns (probably not the appropriate term though) so that rather than pointing on an ip, the software points on a domain name which points then on mysql : IP / Port (3306 i.e, but this has changed already for other port)
Yet i am wondering several questions i'm too newbie to answer by myself :
- How do i put up such a thing (do i just have to create domain name, and declare it at registry as a ns ???)
- How do i configure the server so that this domain points specifically to the mysql database and on nothing else ???
- Is there compatibility problems with APF firewall ???
- Should there be any spécific precautions to be taken when using this method ???
Thks for your help and advices ...
Tdldp
I have put up on a server a large (500 Mo) database that is smoothly running, and responding to our demand.
This database will be called from a software that requires data updated regurlaly for an external source.
We are wondering, how in the future, the migration of servers will be as transparent as possible and how we can code in hard in the software an adress to point on the database (the risk with an ip adress, is when we will change of ip... It will then require that we provide a new software version with new ip in it...)
I was thinking of putting up a ns (probably not the appropriate term though) so that rather than pointing on an ip, the software points on a domain name which points then on mysql : IP / Port (3306 i.e, but this has changed already for other port)
Yet i am wondering several questions i'm too newbie to answer by myself :
- How do i put up such a thing (do i just have to create domain name, and declare it at registry as a ns ???)
- How do i configure the server so that this domain points specifically to the mysql database and on nothing else ???
- Is there compatibility problems with APF firewall ???
- Should there be any spécific precautions to be taken when using this method ???
Thks for your help and advices ...
Tdldp