Information
Good afternoon, cann`t write very well in English, but I would that I could take out a doubt.
We have a MySQL base of nearly 1.5 billion rows.
Tables ranging from 175 million to 330 million records. We use Enginne MyISAM. This database, rarely receives instructions Insert. However we have on average 50-280 queries per second. We use CentOS 6.4 and MySQL 5.7.
We have two machines. The first works as a web service (apache + php) and the second DBMS + Sphinx.
The first has 32GB of memory, 4 processors and disks SATA3.
The second offers 192 GB of memory, 24 processors and 15K SAS drives.
The first of which is a slave of the second machine.
So having explained this, what is my doubt?
I was reading about MySQL Cluster. In my case with machines "so different" worth I invest in cluster? OR more worth keeping the Master and Slave, as it is today?
Thank you for your help, will be of great value.
Subject
Written By
Posted
Information
June 13, 2013 12:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.