RE: Creating a dedicated reporting server for management?

2010-08-23 Thread 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 so

Re: Creating a dedicated reporting server for management?

2010-08-23 Thread 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 serv

RE: Creating a dedicated reporting server for management?

2010-08-23 Thread 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:nunziodav...@yahoo.com] Sent: Monday, August 23, 2010 3:28 PM To: mysql@lists.mysql.com Subject: Creat

Creating a dedicated reporting server for management?

2010-08-23 Thread 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 jo

Re: How to unstall MySQL 5.1 on Ubuntu 8.04 LTS

2010-08-23 Thread Jaime Crespo Rincón
2010/8/23 Manasi Save : > Dear All, > > I need to install MySQL 5.1.42 on ubuntu. MySQL site does not have installer > packages for ubuntu(.deb). > If I need to use tar.gz is there any document available which will help me > do this specific changes. Follow the official guide: http://dev.mysql.com

How to unstall MySQL 5.1 on Ubuntu 8.04 LTS

2010-08-23 Thread Manasi Save
Dear All,   I need to install MySQL 5.1.42 on ubuntu. MySQL site does not have installer packages for ubuntu(.deb).  If I need to use tar.gz is there any document available which will help me do this specific changes.   Any input will be great help. As I need to set it up urgently.   Thanks in adva