mark2012 Posted February 6, 2013 Posted February 6, 2013 How do deal with large datebase to help with performance? Mine have about 1.2 GB and today my hosting company just sent to me this email Hi, Your script running on x account continues to have problems with the MySQL DB so we are going to convert it for you to INNODB to help with performance. The DB on the site is fairly large and you will probably need to upgrade the RAM if it continues to grow and eat up the RAM. Regards What do you think about this option ?
AlexJ Posted February 6, 2013 Posted February 6, 2013 Without seeing Machine/VPS specs, your database engine tables and your MySQL specs it's hard to suggest or to provide any feedback.
GreenLinks Posted February 6, 2013 Posted February 6, 2013 Alex is right however the response you received makes me think that you are highly possible on a vPS or low level Dedicated server. On top of what Alex asked , you should supply following information so we can supply our suggestions : Phpinfo page link Server specs Online user + guest average with 15 min cookie time out Slow query log output My.conf output
mark2012 Posted February 6, 2013 Author Posted February 6, 2013 Alex is right however the response you received makes me think that you are highly possible on a vPS or low level Dedicated server. No, not low level dedicated server but low level hosting support. Right now i cannot post any info because the server is dead, as usually. waiting for my check on 10th, did found a germany datacenter where to buy an unmanaged server where to move. Will be back with info when the server is going back online.
AlexJ Posted February 6, 2013 Posted February 6, 2013 Just a personal advice: If you are going to buy the dedicated server offshore check the HD health first and see if they give you new hard drive or not. HD I/O is critical on busy boards. You can use SMART data from HD to check hard drive health and how much old hard drive is.
mark2012 Posted February 6, 2013 Author Posted February 6, 2013 These are the server specs: System FreeBSD 8.2-STABLE FreeBSD 8.2-STABLE #0: Mon Sep 19 20:47:28 UTC 2011 root@backup5.website.com:/usr/obj/usr/src/sys/GENERIC amd64 Build Date Feb 5 2013 10:30:15 Configure Command './configure' '--with-apxs2' '--with-curl=/usr/local/lib' '--with-gd' '--with-ttf' '--with-gettext' '--with-jpeg-dir=/usr/local/lib' '--with-freetype-dir=/usr/local/lib' '--with-kerberos' '--with-openssl' '--with-mcrypt' '--with-mhash' '--with-mysql=/usr/local/mysql' '--with-mysqli=/usr/local/mysql/bin/mysql_config' '--with-pdo-mysql=/usr/local/mysql' '--with-pcre-regex=/usr/local' '--with-pear' '--with-png-dir=/usr/local/lib' '--with-xsl' '--with-zlib' '--with-zlib-dir=/usr/local/lib' '--with-iconv=/usr/local' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-magic-quotes' '--enable-safe-mode' '--enable-soap' '--enable-sockets' '--enable-mbstring' '--enable-zip' '--enable-wddx' Server API Apache 2.0 Handler Virtual Directory Support disabled Configuration File (php.ini) Path /usr/local/lib Loaded Configuration File /usr/local/lib/php.ini Scan this dir for additional .ini files (none) Additional .ini files parsed (none) PHP API 20090626 PHP Extension 20090626 Zend Extension 220090626 Zend Extension Build API220090626,NTS PHP Extension Build API20090626,NTS Debug Build no Thread Safety disabled Zend Memory Manager enabled Zend Multibyte Support disabled IPv6 Support enabled Registered PHP Streams https, ftps, compress.zlib, php, file, glob, data, http, ftp, phar, zip Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls Registered Stream Filters zlib.*, convert.iconv.*, mcrypt.*, mdecrypt.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk PHP Credits Configuration apache2handler Apache Version Apache Apache API Version 20051115 Server Administrator my email address Hostname:Port www.mywebsite.com:0 User/Group apache(1005)/1004 Max Requests Per Child: 4000 - Keep Alive: on - Max Per Connection: 4096 Timeouts Connection: 30 - Keep-Alive: 5 Virtual Server Yes Server Root /etc/httpd Loaded Modules core mod_authn_file mod_authn_default mod_authz_host mod_authz_groupfile mod_authz_user mod_authz_default mod_auth_basic mod_reqtimeout mod_include mod_filter mod_deflate mod_log_config mod_logio mod_env mod_expires mod_headers mod_unique_id mod_setenvif mod_version mod_proxy mod_proxy_connect mod_proxy_ftp mod_proxy_http mod_proxy_scgi mod_proxy_ajp mod_proxy_balancer mod_ssl prefork http_core mod_mime mod_dav mod_status mod_autoindex mod_asis mod_suexec mod_cgi mod_dav_fs mod_dav_lock mod_negotiation mod_dir mod_actions mod_userdir mod_alias mod_rewrite mod_so mod_php5 Apache Environment Variable Value UNIQUE_ID URKzxEAGZL4AAAdaEq4AAACI SCRIPT_URL /forum/angel/index.php SCRIPT_URI mywebsite URL HTTP_HOST mywebsite.com HTTP_USER_AGENT Mozilla/5.0 (Windows NT 5.1; rv:18.0) Gecko/20100101 Firefox/18.0 HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_ACCEPT_LANGUAGE en-US,en;q=0.5 HTTP_ACCEPT_ENCODING gzip, deflate HTTP_REFERER mywebsite.com HTTP_COOKIE rteStatus=rte; member_id=2; pass_hash=2ec0736a20ebdb444cfe839cbeb2bcdb; ipsconnect_177789ba6eaf63eaf3a7df3ec03a0bd7=0; member_id=0; pass_hash=0; coppa=0; ticketselectid=19; ticketselect=; PHPSESSID=7d641d5e79f033dc31d0ea26d3422f4b; session_id=6856519ab91dc3005e5aeeba8c1954c1; mqtids=%2C HTTP_CONNECTION keep-alive PATH /sbin :/bin :/usr/sbin :/usr/bin SERVER_SIGNATURE no value SERVER_SOFTWARE Apache Cookie rteStatus=rte; member_id=2; pass_hash=2ec0736a20ebdb444cfe839cbeb2bcdb; ipsconnect_177789ba6eaf63eaf3a7df3ec03a0bd7=0; member_id=0; pass_hash=0; coppa=0; ticketselectid=19; ticketselect=; PHPSESSID=7d641d5e79f033dc31d0ea26d3422f4b; session_id=6856519ab91dc3005e5aeeba8c1954c1; mqtids=%2C ; modtids=%2C Authorization Basic cGlzaWN1dHM6c3VqaXB1bGFtdWll Connection keep-alive HTTP Response Headers X-Powered-By PHP/5.3.21 bcmath BCMath support enabled Directive Local Value Master Value bcmath.scale 0 0 calendar Calendar support enabled Core PHP Version 5.3.21 Directive Local Value Master Value allow_call_time_pass_reference On On allow_url_fopen On On allow_url_include Off Off always_populate_raw_post_data Off Off arg_separator.input & & arg_separator.output & & asp_tags Off Off auto_append_file no value no value auto_globals_jit On On auto_prepend_file no value no value browscap no value no value default_charset no value no value default_mimetype text/html text/html define_syslog_variables Off Off disable_classes no value no value disable_functions no value no value display_errors Off Off display_startup_errors Off Off doc_root no value no value docref_ext no value no value docref_root no value no value enable_dl On On error_append_string no value no value error_log no value no value error_prepend_string no value no value error_reporting 6983 30711 exit_on_timeout Off Off expose_php On On extension_dir ./ ./ file_uploads On On highlight.bg #FFFFFF #FFFFFF highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors On On ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off log_errors On On log_errors_max_len 1024 1024 magic_quotes_gpc On On magic_quotes_runtime Off Off magic_quotes_sybase Off Off mail.add_x_header Off Off mail.force_extra_parameters no value no value mail.log no value no value max_execution_time 0 30 max_file_uploads 20 20 max_input_nesting_level 64 64 max_input_time 60 60 max_input_vars 1000 1000 memory_limit 128M 128M open_basedir no value no value output_buffering no value no value output_handler no value no value post_max_size 200M 200M precision 12 12 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv On On register_globals Off Off register_long_arrays On On report_memleaks On On report_zend_debug On On request_order no value no value safe_mode Off Off safe_mode_exec_dir no value no value safe_mode_gid Off Off safe_mode_include_dir no value serialize_precision 100 100 short_open_tag On On SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off track_errors Off Off unserialize_callback_func no value no value upload_max_filesize 200M 200M upload_tmp_dir /var/tmp /var/tmp user_dir no value no value user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order EGPCS EGPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off y2k_compliance On On zend.enable_gc On On cURL support enabled cURL Information 7.24.0 Age 3 Features AsynchDNS No Debug No GSS-Negotiate No IDN No IPv6 Yes Largefile Yes NTLM Yes SPNEGO No SSL Yes SSPI No krb4 No libz Yes CharConv No Protocols dict, file, ftp, ftps, gopher, http, https, imap, imaps, pop3, pop3s, rtsp, smtp, smtps, telnet, tftp Host x86_64-unknown-freebsd8.2 SSL Version OpenSSL/0.9.8q ZLib Version 1.2.3 date/time support enabled "Olson" Timezone Database Version 2012.10 Timezone Database internal Default timezone UTC Directive Local Value Master Value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenith 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone UTC UTC dom DOM/XML enabled DOM/XML API Version 20031129 libxml Version 2.7.6 HTML Support enabled XPath Support enabled XPointer Support enabled Schema Support enabled RelaxNG Support enabled EXIF Support enabled EXIF Version 1.4 $Id$ Supported EXIF Version 0220 Supported filetypes JPEG,TIFF Directive Local Value Master Value exif.decode_jis_intel JIS JIS exif.decode_jis_motorola JIS JIS exif.decode_unicode_intel UCS-2LE UCS-2LE exif.decode_unicode_motorola UCS-2BE UCS-2BE exif.encode_jis no value no value exif.encode_unicode ISO-8859-15 ISO-8859-15 GD Support enabled GD Version bundled (2.0.34 compatible) FreeType Support enabled FreeType Linkage with freetype FreeType Version 2.4.7 GIF Read Support enabled GIF Create Support enabled JPEG Support enabled libJPEG Version 8 PNG Support enabled libPNG Version 1.4.8 WBMP Support enabled XBM Support enabled Directive Local Value Master Value gd.jpeg_ignore_warning 0 0 gettext GetText Support enabled hash hash support enabled Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost adler32 crc32 crc32b salsa10 salsa20 haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 iconv iconv support enabled iconv implementation libiconv iconv library version 1.14 Directive Local Value Master Value iconv.input_encoding ISO-8859-1 ISO-8859-1 iconv.internal_encoding ISO-8859-1 ISO-8859-1 iconv.output_encoding ISO-8859-1 ISO-8859-1 json json support enabled json version 1.2.1 libxml libXML support active libXML Compiled Version 2.7.6 libXML Loaded Version 20706 libXML streams enabled mbstring Multibyte Support enabled Multibyte string engine libmbfl HTTP input encoding translation disabled mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1. Multibyte (japanese) regex support enabled Multibyte regex (oniguruma) backtrack check On Multibyte regex (oniguruma) version 4.7.1 Directive Local Value Master Value mbstring.detect_order no value no value mbstring.encoding_translation Off Off mbstring.func_overload 0 0 mbstring.http_input pass pass mbstring.http_output pass pass mbstring.http_output_conv_mimetypes ^(text/|application/xhtml+xml) ^(text/|application/xhtml+xml) mbstring.internal_encoding no value no value mbstring.language neutral neutral mbstring.strict_detection Off Off mbstring.substitute_character no value no value mcrypt mcrypt support enabled mcrypt_filter support enabled Version 2.5.8 Api No 20021217 Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes Supported modes cbc cfb ctr ecb ncfb nofb ofb stream Directive Local Value Master Value mcrypt.algorithms_dir no value no value mcrypt.modes_dir no value no value MHASH support Enabled MHASH API Version Emulated Support mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 5.5.30 MYSQL_MODULE_TYPE external MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/usr/local/mysql/include MYSQL_LIBS -L/usr/local/mysql/lib -lmysqlclient Directive Local Value Master Value mysql.allow_local_infile On On mysql.allow_persistent On On mysql.connect_timeout 60 60 mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket /tmp/mysql.sock /tmp/mysql.sock mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited mysql.trace_mode Off Off mysqli MysqlI Support enabled Client API library version 5.5.30 Active Persistent Links 0 Inactive Persistent Links 0 Active Links 1 Client API header version 5.5.30 MYSQLI_SOCKET /tmp/mysql.sock Directive Local Value Master Value mysqli.allow_local_infile On On mysqli.allow_persistent On On mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket no value no value mysqli.default_user no value no value mysqli.max_links Unlimited Unlimited mysqli.max_persistent Unlimited Unlimited mysqli.reconnect Off Off openssl OpenSSL support enabled OpenSSL Library Version OpenSSL 0.9.8q 2 Dec 2010 OpenSSL Header Version OpenSSL 0.9.8q 2 Dec 2010 pcre PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 8.20 2011-10-21 Directive Local Value Master Value pcre.backtrack_limit 1000000 1000000 pcre.recursion_limit 100000 100000 Phar Phar: PHP Archive support enabled Phar EXT version 2.0.1 Phar API version 1.1.1 SVN revision $Id: 7b7d559811a842dc9e7d33777a8f993aa2b9933d $ Phar-based phar archives enabled Tar-based phar archives enabled ZIP-based phar archives enabled gzip compression enabled bzip2 compression disabled (install pecl/bz2) Native OpenSSL support enabled Phar based on pear/PHP_Archive, original concept by Davey Shafik. Phar fully realized by Gregory Beaver and Marcus Boerger. Portions of tar implementation Copyright © 2003-2009 Tim Kientzle. Directive Local Value Master Value phar.cache_list no value no value phar.readonly On On phar.require_hash On On Directive Local Value Master Value session.auto_start Off Off session.bug_compat_42 On On session.bug_compat_warn On On session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_httponly Off Off session.cookie_lifetime 0 0 session.cookie_path / / session.cookie_secure Off Off session.entropy_file no value no value session.entropy_length 0 0 session.gc_divisor 100 100 session.gc_maxlifetime 1440 1440 session.gc_probability 1 1 session.hash_bits_per_character 4 4 session.hash_function 0 0 session.name PHPSESSID PHPSESSID session.referer_check no value no value session.save_handler files files session.save_path /var/tmp /var/tmp session.serialize_handler php php session.use_cookies On On session.use_only_cookies On On session.use_trans_sid 0 0 Directive Local Value Master Value soap.wsdl_cache 1 1 soap.wsdl_cache_dir /tmp /tmp soap.wsdl_cache_enabled 1 1 soap.wsdl_cache_limit 5 5 soap.wsdl_cache_ttl 86400 86400 SPL SPL support enabled Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException SQLite SQLite support enabled PECL Module version 2.0-dev $Id$ SQLite Library 2.8.17 SQLite Encoding iso8859 Directive Local Value Master Value sqlite.assoc_case 0 0 sqlite3 SQLite3 support enabled SQLite3 module version 0.7-dev SQLite Library 3.7.7.1 Directive Local Value Master Value sqlite3.extension_dir no value no value standard Dynamic Library Support enabled Path to sendmail dont have ssh access so dont know where to get the info from My.conf. Took the bellow details from the hosting page: ZFS ZMIRROR 500 gb 8 gb ram 100 Mbps Transfer cpu 3.3 GHz I3-2120 DC
mark2012 Posted February 6, 2013 Author Posted February 6, 2013 Just a personal advice: If you are going to buy the dedicated server offshore check the HD health first and see if they give you new hard drive or not. HD I/O is critical on busy boards. You can use SMART data from HD to check hard drive health and how much old hard drive is. Thanks for tip ! I have to decide between this one and this one from oVH Also planning to install Nginx instead apache and maybe varnish cache too
IveLeft... Posted February 6, 2013 Posted February 6, 2013 We run Apache and Unixy Varnish - works really well
mark2012 Posted February 6, 2013 Author Posted February 6, 2013 We run Apache and Unixy Varnish - works really well Using nginx instead of apache with unixy varnish would do better? I`ve read many good things about nginx this is why im asking.
IveLeft... Posted February 6, 2013 Posted February 6, 2013 You could use both nginx and apache with varnish :thumbsup:
AlexJ Posted February 7, 2013 Posted February 7, 2013 OVH is over sold network lately so be careful. Also their support is in French most of the time so for me it was hard to get support from them when I needed one. With 20% VAT it would be around same price... to other good providers in US. If you are not going to use all 32GB RAM then I would opt for RAID 1 and SSD for DB. That would be screaming fast I/O. But I don't know your load, users and all so I can't say much. But stay away from OVH if you find some nice deal with other good host provider.
GreenLinks Posted February 7, 2013 Posted February 7, 2013 The server you have is basically a personal pc which is converted to a server. i3 is not designed to run on servers. Server and regular PC cpu's differ a lot and servers always need more horsepower. Without seeing your My.cnf it is hard to say anything. If you are looking for unmanaged servers , i highly suggest checking Germany. Their prices are way lower compared to US companies.
mark2012 Posted February 7, 2013 Author Posted February 7, 2013 Thank you very Alex and Sjv! Yeah i`ve noticed the VTA from OHV it`s kinda sucks, the price per server is much bigger now. Also OVH took 8 days to answer to my email and wandering if something wrong it happens 8 day without an an ticket response will be truly pain. Webtropia answered to my email in decent time, around 24 hours.
AlexJ Posted February 7, 2013 Posted February 7, 2013 Their are many good host in US in terms of 100-150$/month. E3/16GB/RAID 1 is easily doable for 120-130$ in US and might even get 32GB with SSD + RAID 1 (HD's) for 150$ on Tier 1 or 2 networks. What's your budget?
mark2012 Posted February 7, 2013 Author Posted February 7, 2013 Their are many good host in US in terms of 100-150$/month. E3/16GB/RAID 1 is easily doable for 120-130$ in US and might even get 32GB with SSD + RAID 1 (HD's) for 150$ on Tier 1 or 2 networks. What's your budget? My budget for this one is not more than 200 bucks and since my main target is europe i have decided to find an european provider.
IveLeft... Posted February 7, 2013 Posted February 7, 2013 Mark What spec are you looking for VPS or Dedi ? Ram ? HDD ? Cpanel ?etc
mark2012 Posted February 7, 2013 Author Posted February 7, 2013 Mark What spec are you looking for VPS or Dedi ? Ram ? HDD ? Cpanel ?etc Well i`m looking for a server with more performance than the actual server (soon ex). A server who can handle easly 500-600 online members simultaneously with not more than 250 gb disk space which is more than enough for me and with 16 gb ram preferably 32 gb ram. And not managed due to my last horible experience. These are my specs located in EU would like.
GreenLinks Posted February 7, 2013 Posted February 7, 2013 Well i`m looking for a server with more performance than the actual server (soon ex). A server who can handle easly 500-600 online members simultaneously with not more than 250 gb disk space which is more than enough for me and with 16 gb ram preferably 32 gb ram. And not managed due to my last horible experience. These are my specs located in EU would like. Check hetzner.de , they have latest i7 series with high memory and ssd
mark2012 Posted February 7, 2013 Author Posted February 7, 2013 thanks Sjv , just sent them an email now. Waiting for their answer.
Grumpy Posted February 8, 2013 Posted February 8, 2013 The server you have is basically a personal pc which is converted to a server. i3 is not designed to run on servers. Server and regular PC cpu's differ a lot and servers always need more horsepower. Without seeing your My.cnf it is hard to say anything. If you are looking for unmanaged servers , i highly suggest checking Germany. Their prices are way lower compared to US companies. Yes, i3 is not targeted at businesses to run as servers, but desktop CPUs aren't that far from server, "enterprise", CPUs. The L series and extreme aside, the mainstream for both desktop and server are identical except that the server carry few additional features. These includes things like ECC and virtualization. In turn, the enterprise CPUs lower clocked in turn for lower voltage, because they need to be low powered as power consumption and it's resulting outcomes is #1 upkeep cost for datacenters (other than humans). L series (low power series) are great examples of these, and that's why L series are supported for longer because it's more cost efficient to do so. The architecture are actually exactly the same. It's perfectly fine to run a server with a desktop cpu if you do not value these added feature. In most cases, ECC is likely the only valued item if you are running a mission critical application. There's a chance (like one in trillion) that a bit will be misread by a computer. 0 when it should be a 1 for example. an ECC module will correct that if it happens. Though, chance ^2 that ecc fails too. :tongue: And the funny part is, if you opt with cheap hosts *cough* OVH *cough* they often actually skip the ECC module on the lower end so they can get cheaper components -- which completely nullifies the point of getting the enterprise CPU. and desktop cpu's usually come with integrated graphic card, but no one cares about that... ^^; I also somewhat disagree on the statement that Germany/EU is cheaper than USA. It's a bit of a niche issue. EU is full of staple server providers like OVH, Hetzner, PlusServer (has many names)... meh I'll stick leaseweb in there too... that focus on automation to delivery of servers. Awesome part about staple server is that if your needs fit within one of their pre-configured server with pre-configured images, it allows automation to take place very easily, they get to buy in huge bulks -- saving money, and ultimately you get it for cheap. But the moment you need something else, it becomes really expensive. By the words of the Hetzer PR guy, they aim for 95 percentile, aim to fit most needs, not all needs (bit paraphrased). I could get something like E3, 16GB ram, with 4 bays, 2x SSD, 2x HDD (something I'd recommend the OP) for $200 (in budget) if it were USA. But, it's hard to get the same in europe because this kind of half mix and match of disks won't fit into their prebuilt servers. Actually, OVH has one. Oh and yeah... Mark, if you can, get a E3-XXXX (frankly doesn't matter that much, v2 if possible. Just not 1220 [has no HT]). You don't really need 32GB ram, and the 8GB modules for the CPU with ECC are oddly more pricy than the 4GB (typically the mobo have 4x ram slots). So, just stick with 16GB. 2x SSD for OS + MySQL would be awesome. 300GB SSDs tend to be kind of expensive and not really sure if a 2 bay 300GB SSD will be cheaper or 4 bay with 2x 80GB SSD and 2x 500GB HDD for everything be cheaper. Personally, given your # of online, I would find SSD mandatory. It's better and cheaper than 15k drives anyway... Though, after all this typing, I don't really have a recommendation for you. I feel like all the ones I know in EU are going to be out of budget. You might be able to check swiftway's sales for one and be within budget... but feel like not... probably doesn't hurt to ask. Don't even look at their website... just go straight to sales email. Good luck searching. If searching fails... well. Pick your poison among the 4 mentioned. xD But don't expect like <15min response from support for emergencies...
GreenLinks Posted February 8, 2013 Posted February 8, 2013 I disagree nearly everything you said grumpy There is a reason why desktop and server products differ. It is not only CPU speed but stability and the life span of the product is critical. However i am not going to type tons of things like you , feel free to believe and order what ever you need dude.
mark2012 Posted February 8, 2013 Author Posted February 8, 2013 Thank you very much for explanation Grumpy ! Yep instead of chosing 32 gb ram and i3/i5 i can find a server with E3/E5 and less ram instead. Hetzner is not on my list anymore, they replied to me couple of moments ago, didn`t decided myself yet still searching and reading on webtalkhosting. I will be back here these days after will purchase the machine :mellow:
Grumpy Posted February 8, 2013 Posted February 8, 2013 I disagree nearly everything you said grumpy There is a reason why desktop and server products differ. It is not only CPU speed but stability and the life span of the product is critical. However i am not going to type tons of things like you , feel free to believe and order what ever you need dude. Not even really sure what you disagree with considering most I said are stuff said by the manufacturers and suppliers. Though yes, I did miss out on the CPU "life span". While the manufacturer promotes the enterprise cpu with longer life span... but this has to be a joke. CPUs don't fail. Okay... it's extremely rare. Doesn't matter if it's consumer or enterprise. The statistical likelihood of a CPU failing is so low that you'll likely go through like 100 other replacements before you need to replace a CPU. The rare occasions where CPU fail is almost always due to bad power supply or overclocking. But these days, with great mobos, it's virtually impossible to break cpu's with OC. Stability go hand in hand with ECC. It's how the enterprise CPUs have greater stability and I covered that already. If the enterprise cpus are indeed much superior to the desktop counterpart, the pricing point doesn't make sense. An e3-1270 and i7-2600k are similar pricing point, same architecture and similar performance. Majority of increase in price by choosing "enterprise" is the rest of the components like chassis, motherboard, ram, etc. Though, some getting custom desktop usually gets MUCH superior power supply for desktop. You can quite frankly take the 1270 and put it on desktop mobo and run fine, and same vice versa. Again, this is what OVH actually does with their low end. Again, I'm not talking about low or high ends like atoms, mobile, or E7 line. I'm not talking about CPUs from pre-"core" series when they really were completely separately designed. I'm talking about the mainstream line of today: sandy/ivy bridge, namely the E3s vs newer i5~i7. They carry the same chipset. Same architecture. Same sockets. They are NOT designed differently, just different features. Choosing the "cream of the crop" aside, they are same.
AlexJ Posted February 9, 2013 Posted February 9, 2013 With desktop grade CPU's you get desktop grade mobo's and HD's most of the time and you run into issues sooner or later with desktop grade hard drives. Learned the lesson hard way :) http://www.webhostingtalk.com/showthread.php?t=1200617 Irony, I am using Hetzner but if I can change IP's then I would leave them in heartbeat!
mark2012 Posted February 17, 2013 Author Posted February 17, 2013 ok, just bought tuesday my new server from webtropia.de and it was ready thursday. It have this configuration: i7 32 gb ram 2x1000 sata 2 hdd 100mps with centOS6 , didn`t installed any control panel and not planning soon. It took me more than 70 hours to read how to configure the server and make the initial setup. Mess up the whole server yesterday and i had to re-install the centos in order to make the iredmail to work properly. I`ve dealt with so many errors when was trying to re-import a backup starting with blank white page (really pain in the ass) from the board but now it`s all good. Waiting to propagate the dns to make the final change today or maybe tomorrow.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.