Database Redundancy

[Mars12343]

I was trying to set up my vbulletin so that my database was on 2 servers at once both with the same data if someone could tell me how to do this i would be very grateful. Thanks!

--------------- Added 1215492400 at 1215492400 ---------------

Help please!

[Dismounted]

MySQL replication?

[Mars12343]

Yes.

[Dismounted]

I just told you the answer. My post was more "have you tried MySQL replication?".

[Mars12343]

I really dont know what that is. How would i do mysql replication?

[Dismounted]

Google "MySQL Replication". The first few results will help you.

[Mars12343]

Ok it says slave db Could i just turn my forums off import the db to another host then Set the second host as slave db info in my config.php?

[R1lover]

Here you go... enjoy the read :)

http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html

[Mars12343]

Im really trying to do it the easiest way possible... See above post with my question.

--------------- Added 1215509040 at 1215509040 ---------------

And lets say that my host cut my service... if im using mysql replication would it clear the database on the slave?

[R1lover]

now the truth comes out lol

[Mars12343]

Anyone have an answer for me?

[R1lover]

Anyone have an answer for me?

Yes we both posted the info above, you will need to be able to read the links in order to see.

[Mars12343]

I did read it and i didnt see an answer in there...

And with the built in slave function is that the same as mysql replication just built into vb?

[R1lover]

The answer is this...

You can use replication in mysql, mysql is the database software. In order to do what you are asking that is the answer, you need to learn about mysql and use the replication feature of it. The link above gives you a full how too on it.

--------------- Added 1215845564 at 1215845564 ---------------

Here are the links again in case you missed it.

18.1.1. How to Set Up Replication

[+/-]

18.1.1.1. Creating a User for Replication
18.1.1.2. Setting the Replication Master Configuration
18.1.1.3. Setting the Replication Slave Configuration
18.1.1.4. Obtaining the Master Replication Information
18.1.1.5. Creating a Data Snapshot Using mysqldump
18.1.1.6. Creating a Data Snapshot Using Raw Data Files
18.1.1.7. Setting Up Replication with New Master and Slaves
18.1.1.8. Setting Up Replication with Existing Data
18.1.1.9. Introducing Additional Slaves to an Existing Replication Environment
18.1.1.10. Setting the Master Configuration on the Slave

[Mars12343]

I was referring to the slave database option in the config.php is it basically the same thing as a mysql replication?

[Dismounted]

You need to setup MySQL replication (or rather, have synchronised MySQL servers), to use the slave database function.

[Mars12343]

So i just turn my forum offline do a sql dump import it to the new server and add the slave db info to my config.php then turn my forum back on and im done?

[R1lover]

It seems you are in way over your head with this idea, I would recommend you hiring someone to take care of this for you.

[Mars12343]

So i just turn my forum offline do a sql dump import it to the new server and add the slave db info to my config.php then turn my forum back on and im done?

Anyone?

[Dismounted]

No, you cannot simply do that - your data will eventually be out-of-date.

[ssslippy]

You need to use both MySQL data replication and the slave database system. However it sounds like you are trying to do this on 2 different web hosts. Do NOT do this. Your forums will suffer dramatically.

[Videx]

Forget it. These guys are experts and when you ask them how to do something, no matter how ridiculous it is, they'll answer you.

You don't want any fancy replication at all. All you want is regular db backups. These can be done manually via Cpanel. There are also methods to set up automatic daily backups; do a search here.