Phoenix - Your AI AssistantAdvanced MySQL Cluster Setup and Implementation
- Posted:
- Proposals: 4
- Remote
- #265602
- Awarded
have already sent a proposal. Description
Experience Level: Expert
We currently host 16 database-driven websites via a series of 5 individual, independent web servers. All these sites are linked via our central forums which contains our membership database of some 5.6 million members along with all our commenting and social interaction functionality via the forums database. It presents a nasty single-point of failure; if the forum server/database goes down then all sites become practically functionless.
We want a MySQL Cluster solution to not only increase our redundancy but also to provide scalability for our future network expansion.
Each site on the network has their own MySQL database, so 15 databases for the sites and 1 database for the forums. Some of these databases are large with tables that contain millions of rows. For example, our members table (naturally) contains 5.6 million rows. Our “posts” table (for forum posts) contains 8 million rows. The total file size of our forum database alone is 18.6GB with ~42million rows.
Our database usage is heavy on read rather than write, with very few writes being performed compared to reads on the database.
We have attempted to setup a cluster ourselves with 3 new servers that we already have ordered and setup. Unfortunately we've run into numerous issues, some due to the size of our database and some for reasons we just can’t work out ourselves that have left us with an extremely unstable MySQL cluster (that usually crashes within 10 minutes of coming up) and extremely slow to restart nodes (over 2 hours).
We are looking for someone to provide us with a completely stable and redundant MySQL Cluster setup on our current hardware with at least our forum database imported in to the cluster and working under load.
This is more advanced than setting up a standard "cookie-cutter" MySQL cluster and is going to require some advanced and in-depth knowledge of tweaking MySQL Cluster for best performance and importing large tables.
We are looking for someone to begin working on this project immediately.
We want a MySQL Cluster solution to not only increase our redundancy but also to provide scalability for our future network expansion.
Each site on the network has their own MySQL database, so 15 databases for the sites and 1 database for the forums. Some of these databases are large with tables that contain millions of rows. For example, our members table (naturally) contains 5.6 million rows. Our “posts” table (for forum posts) contains 8 million rows. The total file size of our forum database alone is 18.6GB with ~42million rows.
Our database usage is heavy on read rather than write, with very few writes being performed compared to reads on the database.
We have attempted to setup a cluster ourselves with 3 new servers that we already have ordered and setup. Unfortunately we've run into numerous issues, some due to the size of our database and some for reasons we just can’t work out ourselves that have left us with an extremely unstable MySQL cluster (that usually crashes within 10 minutes of coming up) and extremely slow to restart nodes (over 2 hours).
We are looking for someone to provide us with a completely stable and redundant MySQL Cluster setup on our current hardware with at least our forum database imported in to the cluster and working under load.
This is more advanced than setting up a standard "cookie-cutter" MySQL cluster and is going to require some advanced and in-depth knowledge of tweaking MySQL Cluster for best performance and importing large tables.
We are looking for someone to begin working on this project immediately.
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.