Creating a dedicated reporting server for management?

Creating a dedicated reporting server for management?

am 23.08.2010 23:28:29 von Nunzio Daveri

--0-717978386-1282598909=:96752
Content-Type: text/plain; charset=us-ascii

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




--0-717978386-1282598909=:96752--

RE: Creating a dedicated reporting server for management?

am 24.08.2010 00:52:16 von Travis Ard

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@yahoo.com]
Sent: Monday, August 23, 2010 3:28 PM
To: mysql@lists.mysql.com
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=gcdmg-mysql-2@m.gmane.org

Re: Creating a dedicated reporting server for management?

am 24.08.2010 01:03:06 von a.smith

Run something like Solaris zones, or FreeBSD jails? Then u can have
multiple masters...

Quoting Nunzio Daveri :

> 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=gcdmg-mysql-2@m.gmane.org

RE: Creating a dedicated reporting server for management?

am 24.08.2010 01:11:47 von Daevid Vincent

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@hotmail.com]
> Sent: Monday, August 23, 2010 3:52 PM
> To: 'Nunzio Daveri'; mysql@lists.mysql.com
> 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@yahoo.com]
> Sent: Monday, August 23, 2010 3:28 PM
> To: mysql@lists.mysql.com
> 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=daevid@daevid.com
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Creating a dedicated reporting server for management?

am 28.08.2010 02:28:06 von Daevid Vincent

You misunderstand.

The slave is LIVE. Every write to the master writes to BOTH slaves. You can
add as many slaves to a master as you want.

My point was IN ADDITION to that benefit, it also affords you the ability
to take down one of the slaves for an offsite archive. So if you need
master/slave for prod, and slave for reports that all have to be up 100%
then setup a 3rd slave then that is a live backup and you can then take it
down at whatever interval you like to make a tarball for offsite backups.
When you start the slave up again, it will re-synch itself to the master
again automatically. Rinse. Repeat.

I don't care how many slaves you have, they don't count as a real backup.

If I say "DROP DATABASE foo" on the master, it will happily replicate to
the slaves and you're whole company is now fsck'd in a way you can't even
begin to comprehend. :) Ala
http://www.geek.com/articles/news/disgruntled-employee-kills -journalspace-w
ith-data-wipe-2009015/


> -----Original Message-----
> From: nunziodaveri@yahoo.com [mailto:nunziodaveri@yahoo.com]
> Sent: Friday, August 27, 2010 5:01 PM
> To: Daevid Vincent
> Subject: Re: Creating a dedicated reporting server for management?
>
> Thanks for the idea. The sales guys want real time access so
> tarballing daily or even several times a day won't work.
>
> Nunzio
> Sent via BlackBerry from T-Mobile
>
> -----Original Message-----
> From: "Daevid Vincent"
> Date: Mon, 23 Aug 2010 16:11:47
> To: 'Travis Ard'; 'Nunzio
> Daveri';
> Subject: RE: Creating a dedicated reporting server for management?
>
> 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@hotmail.com]
> > Sent: Monday, August 23, 2010 3:52 PM
> > To: 'Nunzio Daveri'; mysql@lists.mysql.com
> > 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@yahoo.com]
> > Sent: Monday, August 23, 2010 3:28 PM
> > To: mysql@lists.mysql.com
> > 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=daevid@daevid.com
> >
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org