Setup MySQL server to handle thousands of connections in simultaneous


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:


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, mysql, website managament, linux, 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


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 [login to view URL] Here’s a little video about our team too! ht More

$250 USD in 2 days
(17 Reviews)

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 [login to view URL] More

$222 USD in 3 days
(104 Reviews)

Hi there, I can help you right away. .

$111 USD in 1 day
(43 Reviews)

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

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

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)
$155 USD in 3 days
(7 Reviews)

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)
$155 USD in 3 days
(1 Review)

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)