Browsing articles from "September, 2011"
Sep
16
2011

Install and setup replication MySQL on Fedora Rackspace Cloud

I assume for this you have already got a database setup with data in it. Install Slave Start up a new Fedora 15 instance in Rackspace Open SSH using Putty and do the following: yum install mysql mysql-server /etc/init.d/mysqld start /usr/bin/mysql_secure_installation When asked for current password just press enter. Then set a root password (make it secure), remove anonymous users, disallow root login remotely and remove the test database. Finally reload the privilege tables. To [...]

Sep
12
2011

Recopy Master Database to Slave on Fedora 14 Rackspace Cloud when out of Sync

MySQL

Sometimes when the slave gets out of sync with the Master, the best thing is to just start again with a fresh copy from the Master.