Add federated to Mysql

I know the post is a little old, but it seems that many people are having issues with federated engines. When the mysql binaries are installed via yum, you already have the HA (High Availability) plugins. You simply need to load the plugins within the mysql CLI. Here is the basic process: Start mysqld if it is not already started.…

Remove SSL default Cert on Plesk 11.0.9

Log into mysql. mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql> select dom_id,certificate_id from hosting where dom_id=13; +--------+----------------+ | dom_id | certificate_id | +--------+----------------+ | 13 | 0 | +--------+----------------+ 1 row in set (0.00 sec) mysql> SELECT * FROM IP_Addresses; +----+---------------+-------------+---------------+-------+--------------------+-------------------+-------+------+--------+ | id | serviceNodeId | ip_address | mask | iface | ssl_certificate_id | default_domain_id | ftps | main | status |…

MySQL’s wait_timeout and interactive_timeout Variables

Ever get these errors? Mysql reporting error when accessing plesk. Zend_Db_Adapter_Exception: SQLSTATE[08004] [1040] Too many connections. You can set-variable=max_connections=250 to /etc/my.cnf and restart and use mysql close statements for php code. Or, set up mysql to close sleeping processes. Mysql Config. (/etc/my.cnf) wait_timeout variable represents the amount of time that MySQL will wait before killing an idle connection. The default…

MySQL InnoDB Recovery

Mysql Recovery. Error logs shows: InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 7. InnoDB: You may have to recover from a backup. 080703 23:46:16 InnoDB: Page dump in ascii and hex (16384 bytes): … A LOT OF HEX AND BINARY DATA… 080703 23:46:16 InnoDB: Page checksum 587461377, prior-to-4.0.14-form checksum 772331632 InnoDB: stored checksum…

Optimize Mysql

Did you know that mysql comes with configuration files for better optimization? These files are located at: /usr/share/doc/mysql-server-5.1.71/my-huge.cnf /usr/share/doc/mysql-server-5.1.71/my-innodb-heavy-4G.cnf /usr/share/doc/mysql-server-5.1.71/my-large.cnf /usr/share/doc/mysql-server-5.1.71/my-medium.cnf /usr/share/doc/mysql-server-5.1.71/my-small.cnf /usr/share/man/man5/openssl.cnf.5ssl.gz Or /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf Stop mysql # service mysqld stop Stopping mysqld: [ OK ] backup the original my.cnf file. # mv /etc/my.cnf /etc/my.cnf.original Move the new config file to /etc based on your needs:…

Mytop

Install the repository CentOS 5.x rpm -Uhv http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm CentOS 6.x 64 bit rpm -Uhv http://apt.sw.be/redhat/el6/en/i386/rpmforge/RPMS/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm Install mytop yum -y install mytop Configuration Odds are, you will get an error initially running this program unless you configure it first. whereis mytop Example: /usr/bin/mytop or /usr/local/bin/mytop nano /usr/bin/mytop or nano /usr/local/bin/mytop Locate the following lines: my %config = ( delay => 5,…