[racktables-users] Re: Installing DR racktables server
- From: Michał Sochoń <kaszpir@xxxxxxxxx>
- To: racktables-users@xxxxxxxxxxxxx
- Date: Fri, 4 Jul 2014 09:20:33 +0200
Better have mysql read only access. But this may be the problem in certain
situations.
Concernin galera cluster - you will need at least 3 mysql instances.
Michał Sochoń /mobile/
On 3 Jul 2014 21:26, "Edward Sandberg" <Edward_Sandberg@xxxxxxxx> wrote:
> 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
>
> Copilot Support | 866 EZSTORE | 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
>
>
>
>
>
> *From:* racktables-users-bounce@xxxxxxxxxxxxx [
> mailto:racktables-users-bounce@xxxxxxxxxxxxx
> <racktables-users-bounce@xxxxxxxxxxxxx>] *On Behalf Of *Haleem, Mohamed
> *Sent:* Thursday, July 03, 2014 2:19 PM
> *To:* 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>
> *Reply-To: *"racktables-users@xxxxxxxxxxxxx" <
> racktables-users@xxxxxxxxxxxxx>
> *Date: *Thursday, July 3, 2014 at 2:07 PM
> *To: *"racktables-users@xxxxxxxxxxxxx" <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
>
> Copilot Support | 866 EZSTORE | dell_online_storage@xxxxxxxx
>
> Please consider the environment before you print this email.
>
>
>
Other related posts:
