Mysql

Recent in Mysql

How to Backup MySQL databases without interrupting MySQL?

Written on May 11th, 2010 at 23:32 pm by chia

Normally when we create a backup of our MySQL using Mysqldump it creates a Read Lock on the database, so no changes can be made to the database at that time. It may take from a second to few minutes to take up backup of your database. So, sysadmin either prefer to stop MySQL or issue a READ lock on the MySQL table, so that database remains consistent. In this howto, i will demonstrate a method so that you can take up backup of your database without interrupting MySQL.

How to replicate your MySQL database in Fedora, Ubuntu and Opensuse

Written on April 25th, 2010 at 21:44 pm by chia

This tutorial will guide you on how to create MySQL database replication over different servers. All updates on the Master server will be replicated on the slave server. This method may not save you in case of accidental delete operation as that change would have been automatically performed on the slave server as well. This method is best to protect against hardware failures or accidental crashes.

Oracle presents much Faster MySQL Beta 5.5

Written on April 15th, 2010 at 12:58 pm by chia

Oracle announced the release of faster MySQL 5.5 beta which is claimed to be atleast 2 times faster the its previous stable version MySQL 5.1, which debuted a year ago. After all the controversy behind Oracle and MySQL takeover, Oracle proved that they are really serious about the development of  MySQL. This beta release introduces many new features which were originally planned for MySQL 6.0.

MyISAM Or InnoDB MySQL engine?

Written on May 11th, 2010 at 17:00 pm by chia

Most people don't bother about what MySQL engine they are using. Generally, it doesn't even matter, the default MyISAM does the job really well but sometimes switching to some other engine or at least knowing what others are capable of, could speed up a lot of things for you. Managing transactions for a Financial website was how I came across InnoDB engine at first. In this article, we will see the difference between MyISAM and InnoDB MySQL engines.

Backup your MySQL databases automatically using Automysqlbackup

Written on April 17th, 2010 at 00:37 am by chia

When I started managing a server, due to small database I always took manual backups, scarcely though. And because of my laziness in doing so, my fellow author, shredder12 constantly bugged me to do so. So, I started with weird entries in cron until I find this awesome script.

How to install mysql server on fedora

Written on October 6th, 2009 at 06:27 am by chia

This howto will guide you on how to install mysql 5 on your fedora, start the mysql server on reboot, make new mysql users, change root and user's password and add new database, remove anonymous logins and give permissions to different users.

Syndicate content