[racktables-users] Re: Installing DR racktables server

  • From: Edward Sandberg <Edward_Sandberg@xxxxxxxx>
  • To: "racktables-users@xxxxxxxxxxxxx" <racktables-users@xxxxxxxxxxxxx>
  • Date: Thu, 3 Jul 2014 20:24:48 +0000

Thanks everyone for the input.  I copied the directory to the backup server and 
everything is working fine.

As for the possibility of corrupting the backup database that Oliver mentioned 
I already have a user with read only privileges to use so no changes will be 
made from that server.

Edward Sandberg
Copilot Foundry Senior Analyst
Certifications: LPIC-1,  SNIA Certified Storage Engineer, SNIA Certified 
Storage Architect
Dell | Compellent
Hours: Monday - Friday, 7am-4pm CST
Desk +1.952.562.3046
Edward_Sandberg@xxxxxxxx<mailto:Edward_Sandberg@xxxxxxxx>
Copilot Support | 866 EZSTORE | 
dell_online_storage@xxxxxxxx<mailto:dell_online_storage@xxxxxxxx>
Please consider the environment before you print this email.

From: racktables-users-bounce@xxxxxxxxxxxxx 
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Olivier Contant
Sent: Thursday, July 03, 2014 1:32 PM
To: racktables-users@xxxxxxxxxxxxx
Subject: [racktables-users] Re: Installing DR racktables server

I think I forgot one important information.

Racktable is just php code that fetch all its data from the database.  You 
could just copy the webapp from server1 to server2 and change the configuration 
file to set the slave database as its database.  *no need to run the install or 
anything.  Copy paste folder and update configuration file.

But by doing that, you are risking to have split brain issue...   The 
application racktable wasn't developed to work in that type of environment and 
won't do any sanity check to prevent corruption.  Racktable is not cluster 
aware.

When you work in clustering at the infra level, it is important to have an 
application that is aware of the cluster or do abstraction *like in 
virtualization* to avoid corruption of data.


Regards,

Olivier Contant
System Administrator, Triton Digital

1440 Ste-Catherine W., Suite 1200 | Montreal, Qc, H3G 1R8
Tel.: +1.514.448.4037 #2771 | Toll-Free: +1.866.448.4037 #2771
olivier.contant@xxxxxxxxxxxxxxxxx<mailto:olivier.contant@xxxxxxxxxxxxxxxxx>


From: 
racktables-users-bounce@xxxxxxxxxxxxx<mailto:racktables-users-bounce@xxxxxxxxxxxxx>
 [mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Haleem, Mohamed
Sent: Thursday, July 03, 2014 2:19 PM
To: racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>
Subject: [racktables-users] Re: Installing DR racktables server

We are using http://galeracluster.com/ for our mysql replication ...

From: Edward Sandberg 
<Edward_Sandberg@xxxxxxxx<mailto:Edward_Sandberg@xxxxxxxx>>
Reply-To: 
"racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>" 
<racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>>
Date: Thursday, July 3, 2014 at 2:07 PM
To: "racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>" 
<racktables-users@xxxxxxxxxxxxx<mailto:racktables-users@xxxxxxxxxxxxx>>
Subject: [racktables-users] Installing DR racktables server

I have setup mysql to replicate the racktables database to another server.  I 
am now trying to install racktables butI get to step 5 of 7 and the installer 
says:

Your database is already holding 65 tables, so I will stop here and let you 
check it yourself.
There is some important data there probably.

Is there a way around this?  I suppose I could install to a new db and then 
import all the tables but then I would need to set up the replication all over 
again.

Edward Sandberg
Copilot Foundry Senior Analyst
Certifications: LPIC-1,  SNIA Certified Storage Engineer, SNIA Certified 
Storage Architect
Dell| Compellent
Hours: Monday - Friday, 7am-4pm CST
Desk +1.952.562.3046
Edward_Sandberg@xxxxxxxx<mailto:Edward_Sandberg@xxxxxxxx>
Copilot Support | 866 EZSTORE | 
dell_online_storage@xxxxxxxx<mailto:dell_online_storage@xxxxxxxx>
Please consider the environment before you print this email.

Other related posts: