|
Hello everyone out there on the Mailinglist
I hope this could be informative to all who using now an lvs mysql ha
solution. This subject is discussed here in many ways and many times. I know
there are some people who are very interested in that topic.
I saw now some interesting thing on the mysql website. First of all, I think
everybody knows how the mysql cluster works. If not so go to the mysql.com
website and have a look there.
A Fact is, that every data is stored in Memory in a Mysql cluster setup and
this is not realy great for very large databases. If you store about 100 GB
in your databaes you need about 100 GB of Memory (ram + swap). This is a lot
and normal i386 machines has a limit of 16 GB of Ram (if you take a dual
xeon board. I haven't seen until know a board that supports more Ram).
Now it looks that there will be a solution for that. I found a thread in the
myslq-cluster mailing list and a link in the manual. Mysql 5.1 will be able
to handle disk-based records in the cluster (see link and thread) ... and I
think this will be a very nice solution (furthermore the mysql cluster code
is more stable and more tested).
Thread:
http://forums.mysql.com/read.php?25,20801,20801#msg-20801
Link:
http://dev.mysql.com/doc/mysql/en/mysql-5-1-cluster-roadmap.html
regards
Matthias
--
+++ GMX - Die erste Adresse für Mail, Message, More +++
1 GB Mailbox bereits in GMX FreeMail http://www.gmx.net/de/go/mail
|
