hi, you didn't speakabout your tuning work on the databases with only one machine. Have you done such work with the indexation part for best performance ?
I can tell you that several databases with about 40 Go for all is not huge. but if you want look at some linux clustering solutions like openmosix. It's not a mysql load-balancing solutionn but a linux software one. personnaly, i advice you to begin by indexation and maybe denormalization, sumarry tables, ... tunig :o) Mathias Selon El Bunzo <[EMAIL PROTECTED]>: > Hi, > > I use MySQL for years with very much respect of it's stability and > performance. > But in these years one of my servers has grown to several hundreds of > databases with approximately 50 tables in each of the databases. > > Some of these database have tables containing more than a million > records, which will still grow. Actually I expect them to grow even to > more than 10 million records. Storing these records is no problem, but > querying them becomes more and more difficult within a reasonable time. > The total size of all databases is about 40 GB and will grow constantly. > So, the MySQL-cluster seems no solutions since all data must be kept > into memory. > > I am looking for a scalable solution where I can put more hardware, if > necessary, for more performance. > Is there some way to "loadbalance" select-queries over multiple servers? > When I look at the "google-technology", they have a lot of machines, > each of them storing some chunks of data. So each server handles just a > little piece of the request. It would be great if there is such > technique for MySQL, splitting up the databases in chunks over several > machines. Firing a query should result in a query to all machines, which > return their results. The "master-process" collects all chunks of data > from the machines and returns the total results to my application. > > If I run into performance trouble in the future, it should be a matter > of placing some more hardware to solve the problem. > > Any ideas, suggestions or solutions? > > Thanx. > > El. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
