Need Some suggestion over MySQL Database.
1 MySQL Server at One Location -- need Replication of the MySQL Server 1 to different location and need Clustering second location.
Is it possible in MySQL Database to Replicate the database from 1 location and another and clustering there , if yes what will be the minimum resources we need for about 500GB Database .
Please suggest me in brief.
Thanks in Advance