Python Buzz Forum - MySQL - keeping a local hot backup

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

Sponsored Link •

Python Buzz Forum
MySQL - keeping a local hot backup

0 replies on 1 page.

Welcome Guest
Sign In

Back to Topic List

Reply to this Topic

Search Forum

Threaded View


Previous Topic		Next Topic

Flat View: This topic has 0 replies on 1 page

Phillip Pearson

Posts: 1083
Nickname: myelin
Registered: Aug, 2003

Phillip Pearson is a Python hacker from New Zealand

MySQL - keeping a local hot backup

Posted: Dec 18, 2006 2:50 AM

This post originated from an RSS feed registered with Python Buzz by Phillip Pearson.
Original Post: MySQL - keeping a local hot backup Feed Title: Second p0st Feed URL: http://www.myelin.co.nz/post/rss.xml Feed Description: Tech notes and web hackery from the guy that brought you bzero, Python Community Server, the Blogging Ecosystem and the Internet Topic Exchange	Latest Python Buzz Posts Latest Python Buzz Posts by Phillip Pearson Latest Posts From Second p0st

Here's a clever idea: run two copies of MySQL (a master and a slave) on one machine so you can shut down the slave to populate another database.

I'm planning out PeopleAggregator's MySQL replication code at the moment, and am doing the initial testing by running multiple MySQL servers on my laptop. It's not as hard as it sounds:

mkdir -p /home/phil/mysqlroot/data /home/phil/mysqlroot/log

mysql_install_db --basedir=/usr --datadir=/home/phil/mysqlroot/data --pid-file=/home/phil/mysqlroot/mysqld.pid --skip-locking --port=3307 --socket=mysqld.sock --log=/home/phil/mysqlroot/log/mysql.log --log-slow-queries=/home/phil/mysqlroot/log/mysql-slow.log

/usr/sbin/mysqld --basedir=/usr --datadir=/home/phil/mysqlroot/data --pid-file=/home/phil/mysqlroot/mysqld.pid --skip-locking --port=3307 --socket=mysqld.sock --log=/home/phil/mysqlroot/log/mysql.log --log-slow-queries=/home/phil/mysqlroot/log/mysql-slow.log

Comment

Read: MySQL - keeping a local hot backup

Previous Topic

Next Topic


	Web Artima.com