Amazon EC2 linux web server maintenance & setup for magento website

Currently I have a new magento website hosted with amazon web services. We have been working with a development team putting the website together and building the product catalog for the last 2 months and are looking to launch the website "live." We have 18,000 products right now in the catalog and we plan to take this to over 100,000 products with a good amount of website traffic so we are looking for an experienced freelancer who can work with us to maintain the server with amazon and make the necessary changes when needed. Recently I was using the medium size server with amazon and I just changed this to the large server on the weekend because our website has been going "down" during CPU usage spikes. I believe this is happening when we are trying to mass upload products. Currently we are getting this error

There has been an error processing your request

SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYTpdHkE' (Errcode: 28)


#0 /var/www/lib/Varien/Db/Statement/Pdo/[url removed, login to view](110): Zend_Db_Statement_Pdo->_execute(Array)

#1 /var/www/app/code/core/Zend/Db/[url removed, login to view](291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)

#2 /var/www/lib/Zend/Db/Adapter/[url removed, login to view](480): Zend_Db_Statement->execute(Array)

#3 /var/www/lib/Zend/Db/Adapter/Pdo/[url removed, login to view](238): Zend_Db_Adapter_Abstract->query('SELECT `catalog...', Array)

#4 /var/www/lib/Varien/Db/Adapter/Pdo/[url removed, login to view](428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `catalog...', Array)

#5 /var/www/lib/Zend/Db/Adapter/[url removed, login to view](737): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)

#6 /var/www/lib/Varien/Data/Tree/[url removed, login to view](183): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select))

#7 /var/www/lib/Varien/Data/Tree/[url removed, login to view](192): Varien_Data_Tree_Dbp->load(Object(Varien_Data_Tree_Node), 0)

#8 /var/www/app/code/core/Mage/Catalog/Model/Resource/[url removed, login to view](573): Varien_Data_Tree_Node->loadChildren(0)

#9 /var/www/app/code/core/Mage/Catalog/Model/[url removed, login to view](818): Mage_Catalog_Model_Resource_Category->getCategories('2', 0, false, false, true)

#10 /var/www/app/code/core/Mage/Catalog/Helper/[url removed, login to view](82): Mage_Catalog_Model_Category->getCategories('2', 0, false, false, true)

#11 /var/www/app/design/frontend/xtremo/default/template/catalogsearch/[url removed, login to view](4): Mage_Catalog_Helper_Category->getStoreCategories()

#12 /var/www/app/code/core/Mage/Core/Block/[url removed, login to view](241): include('/var/www/app/de...')

#13 /var/www/app/code/core/Mage/Core/Block/[url removed, login to view](272): Mage_Core_Block_Template->fetchView('frontend/xtremo...')

#14 /var/www/app/code/core/Mage/Core/Block/[url removed, login to view](286): Mage_Core_Block_Template->renderView()

#15 /var/www/app/code/core/Mage/Core/Block/[url removed, login to view](919): Mage_Core_Block_Template->_toHtml()

#16 /var/www/app/code/core/Mage/Core/Block/[url removed, login to view](637): Mage_Core_Block_Abstract->toHtml()

#17 /var/www/app/code/core/Mage/Core/Block/[url removed, login to view](581): Mage_Core_Block_Abstract->_getChildHtml('topSearch', true)

#18 /var/www/app/design/frontend/xtremo/default/template/page/html/[url removed, login to view](52): Mage_Core_Block_Abstract->getChildHtml('topSearch')

#19 /var/www/app/code/core/Mage/Core/Block/[url removed, login to view](241): include('/var/www/app/de...')

#20 /var/www/app/code/core/Mage/Core/Block/[url removed, login to view](272): Mage_Core_Block_Template->fetchView('frontend/xtremo...')

#21 /var/www/app/code/core/Mage/Core/Block/[url removed, login to view](286): Mage_Core_Block_Template->renderView()

#22 /var/www/app/code/core/Mage/Core/Block/[url removed, login to view](919): Mage_Core_Block_Template->_toHtml()

and so forth...

Our previous developer set everything up on one server and amazon has suggested that we switch this to split up the architecture and have the web components separate to the database and to use the load balancing. Send a bid to discuss further.

Beceriler: Amazon İnternet Servisleri, Linux, Microsoft SQL Server, Sistem Yöneticisi, Windows Sunucu

Daha fazlasını görün: www freelancer web page, www freelancer de 3, writing helper, writing a good abstract, who is freelancer web developer, we looking for sql server developer, weekend writing, weekend freelancer, website for getting freelancer services, website design and maintenance services, website architecture freelancer, website and app development services, web services needed for a freelancer, web server development, web frontend developer, web development using html 5, web development helper 0.8 5.1, web developer split, web developer resource, web developer microsoft, web developer helper, web design freelancer needed, web design freelancer database, web design abstract, web app freelancer

İşveren Hakkında:
( 10 değerlendirme ) Corona, United States

Proje NO: #6491777

24 freelancers are bidding on average $249 for this job


Hello, I have over 9 years experience as an linux admin and strong experience with AWS services and magento. Please feel free to ask if you have any questions. Thank you

1 gün içinde 157$ USD
(362 Değerlendirme)

Hi, Highly experienced sysadmin here. Yes, separating the web server from the db server is a good idea. Using varnish for caching would help as well. I can set everything up for you Please let me know if you a Daha fazlası

in 3 gün içinde244$ USD
(335 Değerlendirme)

Looking at the logs seems you run out of disk space. Have you checked how much free space do you have on your disk? Are you using the instance ssd storage or ebs? Regards, Sergio.

in 5 gün içinde200$ USD
(99 Değerlendirme)

Hi, This is only a placeholder bid. I am an experienced server admin with excellent exposure to AWS. I have already setup and worked on magento sites optimizing them for performance. Check [url removed, login to view] for an examp Daha fazlası

in 7 gün içinde263$ USD
(28 Değerlendirme)

Do you have .pem key for the EC2?. Have you ever thought about database cluster as 100.000 products require powerful server/cluster?. ANyway I'm looking forwards to your response. Thank you.

in 3 gün içinde200$ USD
(98 Değerlendirme)

Hello, I am an experience system admin and i can help you in this project. You can view my profile for similar projects i have completed. I am ready to start on it and if you have any query please feel free to ask Daha fazlası

1 gün içinde 120$ USD
(117 Değerlendirme)

Ainda não foi fornecida uma proposta

in 3 gün içinde66$ USD
(13 Değerlendirme)

Hi, Magento guru is here, i work and bid only in Magento within 4years. Please have a fair compare on reviews number, looking for long term work with Magento, I can start work immediately, daily report working progr Daha fazlası

in 2 gün içinde263$ USD
(2 Değerlendirme)

Hello sir, I have an experience of 3 year in Linux filed.I will setup Solve server issue related to magento and Mysql, This Particular problem is realated to mysql, I'm ready to solve this My resume - http://resu Daha fazlası

in 3 gün içinde50$ USD
(17 Değerlendirme)

Hello, I have huge experience in Linux server Also about LAMP architecture, I have atleast 10 years experience in LAMP. I can help you transfer hosting , help you backup your data reliably or restore your Daha fazlası

in 3 gün içinde222$ USD
(3 Değerlendirme)

Hi there, i was setup many systems on ec2 and currently i am setup the architect for my company on ec2. so i can setup the architect for your site with load balance, caching server(we can use apache traffic server or v Daha fazlası

in 4 gün içinde144$ USD
(3 Değerlendirme)

Hi There, What is your current specification in medium tire ? What operating system you are using ? What control panel you are using ? How many bulk products you try importing and how ? You can contact us on S Daha fazlası

in 3 gün içinde155$ USD
(4 Değerlendirme)

A proposal has not yet been provided

1 gün içinde 39$ USD
(7 Değerlendirme)

Hello! Ready to discuss cooperation - do you fully optimized secure server fortress! For the safety and optimization of scripts sites are responsible programmers Look my portfolio

in 3 gün içinde155$ USD
(1 Değerlendirme)

Hi, I have 14 years of Linux and web server management experience. Though I am new here. You can check my linkedin profile at [url removed, login to view] Right now I am managing cloud deployments for Daha fazlası

in 3 gün içinde246$ USD
(1 Değerlendirme)

Hi, what options we could use: mysql on separate host\instance. What about Amazon RDS? How big is mysql database? Per mine expirince CPU power on Amazon is not so good:( Per provided error log: issue w/ mys Daha fazlası

in 3 gün içinde111$ USD
(2 Değerlendirme)

Hello, This error message tell you that you have a problem with /tmp directory. I can resolve it after detailed investigate this issue. At for first look this issue have two way to resolve. Also I can suggest shoul Daha fazlası

in 3 gün içinde155$ USD
(1 Değerlendirme)

Hello, We have been already hosting and managing more than 100 clients e-commerce websites and we have experience and expertise of 4 years. I can fix the error message mentioned by you in the project details as I kn Daha fazlası

in 0 gün içinde111$ USD
(0 Değerlendirme)

A proposal has not yet been provided

in 2 gün içinde111$ USD
(0 Değerlendirme)

Hello, I've been working with Magento and Amazon Web Services in the last 3 years. I'm not a programmer, I'm infrastructure specialist and I can evaluate and suggest modifications in order to obtain best performance Daha fazlası

in 7 gün içinde244$ USD
(0 Değerlendirme)