Innodb Database Server Setup (for Dummies)
Jun 12, 2008
I'm getting ready to setup a dedicated server for a site that is database intensive that mostly uses mysql innodb databases.
What is the best setup for me that would allow regular database backups of my innodb databases the easiest way possible. I basically want to be able to backup my database at a regular interval (probably weekly) without having to think too much (and without having to shut down my server each time or stop my database).
I'm not too tech savvy with database management so am after tips on:
- Best server setup (second drive just for bakups?)
- I Don't fully understand RAID 1 setups and how they would benefit me
- Explain to me the backup process for any solution you suggest
View 9 Replies
ADVERTISEMENT
Jun 29, 2007
I have an HA network with 2-web servers sitting under and F5 load balancer.
I pointed the domain to the load balanced IP through it's A Name record.
How can I configure one of the web servers as an email server also?
The web servers are using the plesk control panel.
View 0 Replies
View Related
Sep 30, 2009
I'm investigating quick and easy web hosts for our neighborhood web site. We don't need anything fancy, but the most important feature would be where (once I set up the site) simpletons like the board members can upload new documents, articles, contact info, etc.
Kind of like a SharePoint site where you don't need a web master to make changes (I have better things to do...).
View 14 Replies
View Related
Jul 9, 2008
We are currently looking into getting a new setup to serve our online store, and I would be thankful for feedback as to which servers to choose.
Today almost the entire store is on a single three year old dual proc/dual core server (4 gb ram, RAID5) that is beginning to get overloaded. (There is also a simpler secondary server that serves some static content and does some cron jobs.)
The system is a in-house developed LAMP (where the P is mod_perl/Mason). The database is rather large, two tables with 2-6 million rows are hit multiple times on most public pages - these grow with ~10% per year. Several other often-used tables are in the few-hundred thousand to a million rows, also continuously growing.
We anticipate rapid sales/visit growth over the next couple of years (a good day today is 6000-8000 visits), so I'm thinking of separating the database and web server. The most likely hosting candidate right now is Softlayer's WDC data center (we are located in Europe).
With that background, does this sound like an adequate setup:
Database server
Dual Xeon 5430 - 2.66GHz
8GB ram
RAIDed 3x73GB (or possibly 147GB) (15k rpm). I'm thinking RAID1? The big tables are not written to too much during the day, so read performance is more important than writing.
Web server
This (these) would be serving the Apache/mod_perl part of the system. Some static content (images and some PDFs) unless we put them on a separate server (all static content are placed in a single folder so it would be easy to do a mod_rewrite to an image server).
Dual Xeon 5050 or 7320
4GB ram
2x73GB (SCSI 10k rpm) RAID1
I don't think we need to load balance between two web servers from the beginning but that is something we will keep in mind (and hopefully have to do at some point). Are the two configurations sane (or is one overkill compared to the other)? Generally, how many web servers can a single database server serve? Email is handled separately (Google Apps). I estimate our budget to not more than $1000-1500 a month (if we go with Softlayer we will most likely use some other services such as firewalls, SAN and so on).
We currently use Suse, I have previously used RedHat on personal servers at ThePlanet. Is RedHat 4 32-bit a sensible choice? I have some experience with CPanel so we would most likely use that.
View 2 Replies
View Related
Jun 29, 2009
how to enable innodb
use this command in mysql ....
View 4 Replies
View Related
Sep 27, 2008
I finally found a shopping cart that I think will fit my needs. I registered a hosting account with Hostgator a couple months ago so that I'm now out of the refund period. It's great for my Wordpress site, but I got an error when I tried to install LiveCart. It said that I need InnoDB. I contacted Hostgator's support, and they said that they don't support InnoDB. Is that true? I don't want to have to move hosts and be out my year of hosting fees.
View 6 Replies
View Related
Feb 11, 2008
What is more suitable for shared web hosting?
View 8 Replies
View Related
Jun 5, 2007
Question for people who have moved to InnoDB: I wonder if it is worthwhile?
I don't care about ACID compliance, my only interest is in the row level locking which I do not get with large MYISAM tables which do table locking and clog up everything. I have a huge database that needs frequent updates, like 50,000 per hour. I also don't care about InnoDB's large size of indexes and such, I have lots of hard disk to throw at it.
My fear is with the backup of InnoDB tables, and the fact that it is not as simple to "fire up" the tables when I restart the database. MySQL manual suggests something like a query to "Warm up" the tables.
Any thoughts would be great, and if possible, any help with what settings you use. FYI, I am on a 4GB RAM machine with dual Core2Duo procs. When I tried the following in my.cnf for the InnoDB stuff ---
Code:
#skip-innodb
innodb_buffer_pool_size=1G
# Set the log file size to about 25% of the buffer pool size
innodb_log_file_size=250M
innodb_log_buffer_size=8M
innodb_data_file_path=/idbdata1:200M:autoextend
innodb_additional_mem_pool_size=20M
innodb_log_group_home_dir = /iblogs
innodb_log_files_in_group = 2
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=10
--- the MySQLD wouldn't start! Question about the stuff in red: what're those paths for?
Do I need to create those paths?
View 6 Replies
View Related
Feb 25, 2008
It was recommended by my software vendor that I use MyISAM and stay away from InnoDB.
InnoDB is the default storage engine on my box, but I have no InnoDB's at this time.
Everything says MyISAM (in phpMyAdmin). Could I just reinstall SQL (with MyISAM) from scratch? Or will I need to backup and reload from dump?
View 6 Replies
View Related
Jan 6, 2007
MySQL didn't work well on my server so I had a look at the err file. It indicates that MySQL is getting started and stopped all the time. After it has started it will stop and then start again etc:
070106 14:40:25 InnoDB: Started; log sequence number 5 959534492
/usr/sbin/mysqld: ready for connections.
Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Communi$
A mysqld process already exists at Sat Jan 6 14:40:28 CST 2007
070106 14:40:38 [Note] /usr/sbin/mysqld: Normal shutdown
070106 14:40:38 [ERROR] /usr/sbin/mysqld: Sort aborted
070106 14:40:40 InnoDB: Starting shutdown...
070106 14:40:41 InnoDB: Shutdown completed; log sequence number 5 959534492
070106 14:40:41 [Note] /usr/sbin/mysqld: Shutdown complete
070106 14:40:42 mysqld ended
070106 14:40:42 mysqld started
070106 14:40:42 InnoDB: Started; log sequence number 5 959534492
View 4 Replies
View Related
Sep 18, 2014
I've been with my Strato VServer and it installed Plesk on Linux a big problem.
I coming no longer in the Plesk Dashboard and the following code appears:
Syntax error or access violation: 1286 Unknown table engine 'InnoDB'
Here are the contents of my my.cnf
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
[Code] .....
View 8 Replies
View Related
Nov 2, 2014
I am using Parallels Plesk Panel v. 11.0.9 on a V-Server provided by Strato (Germany), the OS is Ubuntu 10.04 LTS. Established and running under Plesk is a MySQL-Database, administered via Plesk by PHPMyAdmin 3.5.8.1. PHPMyAdmin offers the following information:
Datenbank-Server
Server: Localhost via UNIX socket
Software: MySQL
Software-Version: 5.1.41-3ubuntu12.10 - (Ubuntu)
Protokoll-Version: 10
Benutzer: admin@localhost
Server Zeichensatz: UTF-8 Unicode (utf8)
Webserver
sw-cp-server
Datenbank-Client Version: libmysql - mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $
PHP-Erweiterung: mysql
Click to expand...
View 3 Replies
View Related
Apr 22, 2009
I just want to use a server for file sharing, it will have nginx and that's it. I'm looking at centos, or freebsd, but I been using centos forever now and I'm not sure how to use freebsd, should I just stay with centos?
Do I tell my hosting provider to just install the OS and give me ssh action and that's it? Don't install any control panels or any other stuff? I want one domain and one subdomain on it though and ftp action.
View 8 Replies
View Related
Jan 1, 2008
for setup and configuration instructions for setting up mail server on a Fedora Core 6 server. I googled it and most of the links are described with steps while installing OS, but i need to configure a mail server on a server where my site is already running.
View 1 Replies
View Related
Jul 31, 2008
As my clients' needs expand, they're asking for chroot ssh/sftp setup. I'm currently on a dedicated Linux setup but don't really have the time to set up a whole new box with full virtualization or investigate a full chroot solution (baby on the way), and to be honest it would be less hassle to move to a new provider than worry about down time with sites.
What I'm looking for:
- linux hosting
- hosting for 30+ accounts, some with several domains
- at least 6 IP addresses for SSL certs
- each account in a full chroot environment (ssh/sftp/ftp) so they can't poke around each others' files, or each account set up in a virtual machine setup (ie: openvz)
- maildir
- spamassassin
- php 5, mysql, perl 5.8.8
- suexec apache would be nice
View 3 Replies
View Related
Sep 16, 2006
I have 1 server so I setup dns as ns1.mydomain.com, ns2.mydomain.com ip address pointed to server1. So, now I just bought another server. Can I setup ns2.mydomain.com pointed to 2nd server. Also how to setup more servers ie. 10, 20 server because I can only set up to 6 dns in one domain name.
View 8 Replies
View Related
Jun 12, 2008
to setup a OpenVPN server on a Trixbox Server I'm running and tell us how to setup a Linksys router running DD-WRT Firmware to connect as a client. We need to make it so remote Cisco IP phones can connect to Trixbox.
View 0 Replies
View Related
