Redundant OTRS web servers at differnet data centers?

[drn76]

Anyone have any experience setting up redundant OTRS web servers? Maybe this question isn't even specific to OTRS. I'm no web administrator and I don't know much about this stuff at all. I managed to set up OTRS on top of Fedora, Apache and MySQL. Now I need to figure out how to set up another one at our backup data center. The idea is to have one be the backup and for the primary to replicate data from its MySQL db to the MySQL db at the BDC and that in the event of a failover scenario, the BDC OTRS web server will pick up where the PDC server left off. Any advice would be much appreciated, even just pointing me in the right direction. I'm certainly not expecting anyone to give me step by step instructions or anything like that. I found one post in German on this site but it didn't provide any answers I don't think.

Thanks in advance.

[crythias]

http://www.mysql.com/why-mysql/drbd/
http://www.osscube.com/technology/mysql ... ailability

Google search: MySQL High Availability

[drn76]

Thanks for the reply, much appreciated!

I did some additional Googling the past few days and I'll go ahead and post what I found out in case someone else is in my shoes sometime in the future. Hello future person, good luck to you ; )

....................................

http://www.clockwatchers.com/mysql_dump.html:

MySQL Tutorial - Import or Export A Database

This tutorial section deals with mysqldump which is a tool to import and export MySQL databases.

It can be used to back up a database or to move database information from one server to another.

1. Export A MySQL Database

This example shows you how to export a database. It is a good idea to export your data often as a backup.

# mysqldump -u username -ppassword database_name > FILE.sql

Replace username, password and database_name with your MySQL username, password and database name.

File FILE.sql now holds a backup of your database, download it to your computer.

2. Import A MySQL Database

Here, we import a database. Use this to restore data from a backup or to import from another MySQL server.

Start by uploading the FILE.sql file to the server where you will be running this command.

# mysql -u username -ppassword database_name < FILE.sql

Replace the parts in red with your own information.

This powerful, easy to use command has many uses. Let's say you wanted to switch web hosting providers.

Simply export your data on the old provider's server and import it on your account with the new host.


And to move the file from master to slave: http://www.hypexr.org/linux_scp_help.php

One way to get around a cron job is to use replication: http://www.howtoforge.com/mysql_database_replication, http://onlamp.com/pub/a/onlamp/2005/06/16/MySQLian.html


: )