by Aromal Rajagopal | Nov 17, 2010 | Articles and tutorials, Technical |
There are various solutions available for achieving high availability and scalability of MySQL data/service. ‘MySQL Replication’ and ‘MySQL Cluster’ the solutions offered and supported by MySQL. Third-party solutions such as DRBD (Distributed...
by Aromal Rajagopal | Sep 28, 2010 | Articles and tutorials, Technical |
There are a various solutions available for achieving high availability and scalability of MySQL data/service. ‘MySQL Replication’ and ‘MySQL Cluster’ the solutions offered and supported by MySQL. Third-party solutions such as DRBD (Distributed...
by Aromal Rajagopal | Feb 5, 2010 | Quick fixes, Technical |
Issue : A MySQL database was created and still does exist but it is not being listed in the Plesk interface. Solution : This usually happens when the database is not created via Plesk. Instead, it might have been created via SSH. To get around this, there are two ways...
by Aromal Rajagopal | Dec 9, 2009 | Quick fixes, Technical |
Issue : How to reset MySQL ‘root’ password ? Solution : -> Stop the mysql daemon. /etc/init.d/mysqld stop -> Run the following commands : mysqld_safe –skip-grant-tables & mysql -u root mysql> use mysql; mysql> update user set...
by Aromal Rajagopal | Nov 11, 2009 | Quick fixes, Technical |
Issue : While trying to restore a database through phpmyadmin, following error occurs: #1153 – Got a packet bigger than ‘max_allowed_packet’ bytes Solution : This error occurs if the packet size is more than the default value OR the value defined in...
