It is actually surprising how useful a database can be when used with a website.
In the case of Hardware/Network failure on MASTER, In order to failover to a next available server, we need to manually do the configuration changes for client connections.
In this case, downtime is expected since manual failover will take some times.
Although all the database administrative options can be done through PHP scripts, I strongly suggest installing a copy of PHPMy Admin on your server.
It is an excellent free set of scripts that will provide you with an administrative interface for your My SQL database(s).
You can add, remove, edit, backup and view your databases using this and it is especially useful when troubleshooting your databases.
Throughout this tutorial I will be showing you some of the basics of using PHP and My SQL together.
To do this I will be using an example all the way through.
As you use this tutorial, you will learn how to create a web based contact management program.
For many people, the main reson for learning a scripting language like PHP is because of the interaction with databases it can offer.
In this tutorial I will show you how to use PHP and the My SQL database to store information on the web and include it into your website.
Some examples of PHP and My SQL being used together are: You only really need three things to run PHP scripts which access My SQL databases. This can either be on a computer of your own or on a web host. You can also use most other types of database (SQL, Oracle etc.) but as this is a PHP/My SQL tutorial I will deal just now with the My SQL database (although the commands used here will also work with SQL databases).