Closed

Setup MySQL server to handle thousands of connections in simultaneous

Hello,

I need someone with experience setting up mysql servers under unix distributions, in this case centOS 6.

The server has 32GB RAM and should be able to handle as many connections in simultaneous as possible.

The database itself is very small, and each table doesn't have more than a thousand rows, the key here is really to be able to keep as many connections open as possible.

Right now we have this setting:

max_connections=20000

But sometimes we still get some weird errors like:

Can't connect to DB: Lost connection to MySQL server at 'reading initial communication packet', system error: 111

If you could provide with the right [url removed, login to view] file to handle such requirements would be lovely and a very straight forward project.

Skills: Database Administration, Database Development, Database Programming, MySQL, UNIX

See more: rackspace mysql server setup, debian mysql server setup configure, configuring asterisk server setup sip trunk connection, lost connection mysql server oscommerce, rss 2013 lost connection mysql server query, paypal 2013 lost connection mysql server query, 2013 lost connection mysql server query cre loaded, 2013 lost connection mysql server query php, insert table lost connection mysql server query, lost connection mysql server query, 2013 lost connection mysql server query

About the Employer:
( 3 reviews ) Sykesville, United States

Project ID: #13716962

27 freelancers are bidding on average $174 for this job

A2Design

Hi, Nice project you have there, let us help you with it! Our team is Russian-Canadian. We code in PHP. Check our recent projects here [url removed, login to view] Here’s a little video about our team too! ht More

$250 USD in 2 days
(17 Reviews)
7.1
scriptphp87

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [url removed, login to view] More

$222 USD in 3 days
(104 Reviews)
7.3
amcorreia

Hi there, I can help you right away. .

$111 USD in 1 day
(43 Reviews)
5.8
codetrance

Do you have root access to your server?. I'm looking forwards to your response. Thank you.

$110 USD in 1 day
(71 Reviews)
5.8
$155 USD in 3 days
(4 Reviews)
5.5
ranganathp

FREELANCER RECOMMENDED ------------------------------------------------------ Can help... I am an Expert... Lets Start! Please start a Discussion with me and we can get started from there... Please check the past p More

$155 USD in 3 days
(13 Reviews)
4.8
vinaysinghh

i am mysql dba having more then 10 yrs of experience. please check y review for mysql projects ..................................................................................

$111 USD in 3 days
(38 Reviews)
5.1
yasithab

Hello mate, A senior systems engineer with 8+ years of industry experiences. Holding RedHat certified Architect license including server hardening and performance tuning as well. Please note that, you can not get these More

$200 USD in 5 days
(33 Reviews)
5.1
m7slabs

Hi There, I have been Through Your description, we have a specialized team for this particular task. You will not regret trying us. Many Thanks

$277 USD in 3 days
(41 Reviews)
4.9
acronymsolutions

Hi, I am 18+ years experienced Database Programmer at CMMI-5 level company. I have 20 member team of different Technology. We are working on : RDBMS :Oracle,MySQL,PostgreSQL, MSSQL Server 7.0/2000/2008R2 and On More

$200 USD in 3 days
(36 Reviews)
5.4
tanujchugh

Hi, I will optimise the mysql with mysql tuner for maximum performance for high availablilty we can set mysql cluster and replication too. I Have been active in hosting and cloud field from last 7 years workin More

$155 USD in 1 day
(26 Reviews)
5.0
Codomotive

Hello Sir, We thank you to give us the opportunity to bid on your project. We are really interested to work on your project. I had a look on your requirement and I think we have exact skill set to effectively complete More

$200 USD in 3 days
(4 Reviews)
4.1
nizamec2012

Hello, I can help you with your MySQL configuration but i need to know more information about the parameters so that I can provide you the best possible MySQL configuration for the server. Thank you

$55 USD in 3 days
(18 Reviews)
3.7
redssr

Can we have chat in detail. I would like to work on your project.. About myself, 6+ yrs of relevant exp in Linux with followings 1) OS: Redhat,CentOS,Fedora Debian and Ubuntu with Server Management, User managemen More

$80 USD in 3 days
(10 Reviews)
3.3
vladimirumnov

Hi, if you have really small amount of tables i suggest to move to memsql, its protocol compatible with mysql but very-very fast. memsql not support as much as mysql in compex queries but for most users requiring fast More

$155 USD in 10 days
(10 Reviews)
3.4
thms00

Hi there. I am Linux system engineer in France, working for an ISP after I got my master degree. (I am 25). Scaling mySQL is a tedious task. If I could give my advice I'd look into a more performant solution than O More

$250 USD in 3 days
(10 Reviews)
2.9
$155 USD in 3 days
(7 Reviews)
3.0
akmshasan

Hi, I have 13+ years of experience on Windows and Linux servers especially built on VMware and Microsoft Hyper-V environments. I have working knowledge on various cloud services such as AWS, Azure and OpenStack. I a More

$250 USD in 0 days
(5 Reviews)
2.8
$155 USD in 3 days
(1 Review)
1.4
jaydeep06

System Administrator having experience 3+ years in Servers (Linux/Windows), Database (MYSQL/MSSQL), Cloud (AWS/AZURE), Installation and Configuration.

$155 USD in 0 days
(1 Review)
1.0