Posts Tagged ‘mysql

Any reliable web hosts that support Ruby on Rails and hopefully PostgreSql? Looking for clients who have had experience in these web hosts to provide feedback. Much appreciated MikeDVB replied: Generally I’d avoid cPanel hosting for Ruby on Rails… While it *can* do it, it tends to be more of a pain than it’s worth. [...]

I have an unmanaged server that I’ve been using to run some software on, and I’d now like to use it to host some of my websites as well, with a PHP/MySQL platform. But I’ve always hosted using Linux/cPanel WHM and am very confused on what to do. I tried to google information but couldn’t [...]

Hi, I run mysql in a master-slave setup. You know if mysql slave fails to work properly, it writes the error to the mysqld.log. Anyone have any idea how do I setup it so that it can send me an email when the slave fails to copy from the master? Thanks all! rankris replied: you [...]

I’ve have been working with mostly VPS and shared hosting accounts. Im looking to move to a dedicated. Im seeing that SQL is an extra costs with most dedicated plans. Is this correct, or is this something different. I do, of course need a SQL for my forum. thanks guys. Hybridsoft replied: Ive never actually [...]

how to limit cpu use memory use mysql use in cpanel i am using vps with CENTOS 5.5 i686 virtuozzo on server2 onel0ve replied: how to limit mysql concurrent connection mail sending cpu use memory use in my cpanel ?? add in main post For more information click here.

is this the correct way to go? Code: mysql> GRANT SELECT, INSERT ON *.* TO ‘mysql_opt_db’@’localhost’ identified by ‘hard password’; mysql> flush privileges; mysql> exit; > crontab -e # MySQL weekly optimisation 0 0 * * 0 /usr/bin/mysqlcheck -Aos -u mysql_opt_db -phard password > /dev/null 2>&1 For more information click here.

Ok so after some bad experiences on the grid I’d like an alternative. I recently tried out a shared cpanel server and had frequent downtime with it too so am really despairing. I am looking for a server with at least 6GB space, 200GB traffic with HIGH reliability. I really can’t stand the constant problems [...]

in cpanel where the database stored, can i locate the database via file manager? tws replied: /var/lib/mysql Normal cpanel/ftp users won’t have access to that via file manager. mudassirjaved replied: i found it, thanks tws, For more information click here.