List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:August 23 2010 11:11pm
Subject:RE: Creating a dedicated reporting server for management?
View as plain text  
While not elegant, you could setup multiple instances of mysql on different
ports on the same box so each instance is a slave to a different master.

From your web GUI, this is transparent to the end user since your
configuration files and DB wrappers would handle the connections to "4".

We do something similar now where we have DEV 01/02 TEST 03/04 PROD 05/06
and have an 07 slave that runs several instances so each 01,03,05 have a
dedicated slave and the 07 secondary slave. Then we have a script that
takes 07 mysql down, tarballs (7zip) the /var/lib/mysql and /var/log/mysql
dirs (it's WAY faster than a mysql_dump for both import and export), rsyncs
them to a master offsite backup server/tape.

> -----Original Message-----
> From: Travis Ard [mailto:travis_ard@stripped] 
> Sent: Monday, August 23, 2010 3:52 PM
> To: 'Nunzio Daveri'; mysql@stripped
> Subject: RE: Creating a dedicated reporting server for management?
> 
> You could try doing a multi-master configuration by setting 
> up mysql proxy
> to receive changes from 1, 2, and 3 and replicate to 4.
> 
> -Travis
> 
> -----Original Message-----
> From: Nunzio Daveri [mailto:nunziodaveri@stripped] 
> Sent: Monday, August 23, 2010 3:28 PM
> To: mysql@stripped
> Subject: Creating a dedicated reporting server for management?
> 
> Hello Gurus, I have a customer who wants to create a 
> reporting server for
> his 
> management team.  He wants to take server 1,2,3 and move the 
> 3 databases
> from 
> all 3 servers to one server server 4 and then have the 
> management team run
> all 
> the reports from server 4 since there are tons and tons of 
> joins.  How can I
> 
> accomplish this?  I can't do replication since server 4 is 
> going to be a
> slave 
> AND a slave can only have one master so I am sitting here 
> trying to figure
> out 
> how to get this done?  This is an ongoing transfer of data as 
> the reports
> have 
> to be in sync with the 3 master servers so replication would 
> be perfect.
> 
> Any help, docs and directions is most appreciated.
> 
> Thanks In Advance :-)
> 
> Nunzio
> 
> 
> 
>       
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=1
> 

Thread
Creating a dedicated reporting server for management?Nunzio Daveri23 Aug
  • RE: Creating a dedicated reporting server for management?Travis Ard24 Aug
    • RE: Creating a dedicated reporting server for management?Daevid Vincent24 Aug
  • Re: Creating a dedicated reporting server for management?a.smith24 Aug
RE: Creating a dedicated reporting server for management?Daevid Vincent28 Aug