Re: Spreading the load across multiple servers (was: Server Stats)
>I don't have any real answers - just a suggestion. What is wrong with the >classic RDBMS architecture of RAID 1 on multiple drives with MySQL - surely >it will be able to do that transparently? Yes, RAID is very helpful with MySQL. I spoke with Monty, the developer of MySQL at the open source conference in Monterey and he said that they are currently working on replication and mirroring features. It might be worth inquiring directly with them. Ed
RE: Spreading the load across multiple servers (was: Server Stats)
On Thu, 21 Oct 1999, William R. Lorenz wrote: > Has anyone considered writing a proxy to allow the client > and/or server software to connect to a single data source, > or would this defeat the purpose by having the software use > a single server as a proxy? :) > > In addition, what are the issues involved with mirroring > a MySQL database between database servers? I don't have any real answers - just a suggestion. What is wrong with the classic RDBMS architecture of RAID 1 on multiple drives with MySQL - surely it will be able to do that transparently? And as for MySQL falling over - if it doesn't corrupt the DB when it falls over (I hope it doesn't?) then can't you just put it in init.d (I know that's not the best solution, but it's _a_ solution)? -- Details: FastNet Software Ltd - XML, Perl, Databases. Tagline: High Performance Web Solutions Web Sites: http://come.to/fastnet http://sergeant.org Available for Consultancy, Contracts and Training.
RE: Spreading the load across multiple servers (was: Server Stats)
Has anyone considered writing a proxy to allow the client and/or server software to connect to a single data source, or would this defeat the purpose by having the software use a single server as a proxy? :) In addition, what are the issues involved with mirroring a MySQL database between database servers? I apologize to the list if this is considered off-topic and non-beneficial, but I though I would try my luck, as well. ;) Thanks, in advance, for replies and comments. > > MySQL is quick, it's by far the fastest you can get at > > most operations. On the other hand, you can't easily > > spread the load over multiple servers > > possible to run MySQL across multiple servers? Should > > we be looking at a solution with multiple database > > servers instead of one machine? At the hardware level, > There's a DBD::Multiplex in development (by Thomas Kishel > and myself) that's designed to allow you to spread the > load across multiple database servers and/or add > resilience in case one goes down. %% "The will to win is important, but the will to prepare is vital." -- Joe Paterno
