Re: Federated servers
Hi! Ok, but is it possible to have the same table on booth servers and split the data by rows? Like you can with ms-sql and the federated servers technique? Can you be more specific and maybe guide me to some documentation? Thanks! andy thomas writes: On Tue, 29 Jun 2004 [EMAIL PROTECTED] wrote: Hello! We are currently running with one big ms sql-server. Is it possible to do federated servers on mysql? What I want to do is to purchase one more server and split the work load on the two servers. Yes, you can use master/slave replication in MySQL to share the load across multiple serevrs. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Federated servers
Have you looked at MySQL Cluster as a solution? Does this meet your definition of federated? http://www.mysql.com/products/cluster/ Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine [EMAIL PROTECTED] To: [EMAIL PROTECTED] 06/30/2004 03:19 cc: [EMAIL PROTECTED] AM Fax to: Subject: Re: Federated servers Hi! Ok, but is it possible to have the same table on booth servers and split the data by rows? Like you can with ms-sql and the federated servers technique? Can you be more specific and maybe guide me to some documentation? Thanks! andy thomas writes: On Tue, 29 Jun 2004 [EMAIL PROTECTED] wrote: Hello! We are currently running with one big ms sql-server. Is it possible to do federated servers on mysql? What I want to do is to purchase one more server and split the work load on the two servers. Yes, you can use master/slave replication in MySQL to share the load across multiple serevrs. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Federated servers
Hello! We are currently running with one big ms sql-server. Is it possible to do federated servers on mysql? What I want to do is to purchase one more server and split the work load on the two servers. Any ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Federated servers
On Tue, 29 Jun 2004 [EMAIL PROTECTED] wrote: Hello! We are currently running with one big ms sql-server. Is it possible to do federated servers on mysql? What I want to do is to purchase one more server and split the work load on the two servers. Yes, you can use master/slave replication in MySQL to share the load across multiple serevrs. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Federated servers
[EMAIL PROTECTED] wrote: We are currently running with one big ms sql-server. Is it possible to do federated servers on mysql? What I want to do is to purchase one more server and split the work load on the two servers. Any ideas? On a quick note: What about MySQL replication? http://dev.mysql.com/doc/mysql/en/Replication.html A tutorial discussing what you can use replication for can be found here (chapter 7 of Jeremy Zawodny's High Performance MySQL): http://dev.mysql.com/books/hpmysql-excerpts/ch07.html Regards, Stefan Hinz -- Stefan Hinz [EMAIL PROTECTED] MySQL AB, Documentation Team Taunusstr. 27, 12161 Berlin, Germany Desk: +49 30 82702940 Fax: +49 30 82702941 Mobile: +49 177 7841069 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]