[Voyage-linux] Running MySQL on memory

[Kim-man 'Punky' TSE]

Hi Michael,

Thanks a lot.  Perhaps you can also post it on the wiki so that other 
can make use of your work 

http://wiki.voyage.hk.

Regards,
Punky


Michael Fung wrote:
> Hello all,
>
> I have an application that updates the data tables heavily. I worked out these and may be someone need it too.
>
> Put backup-mydb.sh in /usr/local/bin
> Edit and run the backup-mydb.sh script (set ROOTPW, ...etc)
>
> Create mount point for new datadir:
> Edit /etc/fstab , add lines:
> # for mysql:
> tmpfs           /var/mysqldata  tmpfs   defaults,size=16M       0 2
>
> run:
> mount /var/mysqldata
> df -h
> You see this line in the output:
> tmpfs                  16M  1.2M   15M   8% /var/mysqldata
>
>
> shutdown mysql, run:
> invoke-rc.d mysql stop
> Edit /etc/mysql/my.cnf, set
> datadir   = /var/mysqldata
>
> replace /etc/init.d/mysql with the attached modified version.
> (the modified one is based on 5.0.51a-24+lenny2)
>
> start mysql, run
> invoke-rc.d mysql start
> The script will automatically restore all data files to /var/mysqldata
>
> You can also run backup-mydb.sh by cron periodically.
>
> Next time when you normally shutdown the system, the data files is auto backed up.
> When the system restart, the data files is auto restored.
>
> Your comments are welcome.
> - Michael
>
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> Voyage-linux mailing list
> Voyage-linux at list.voyage.hk
> http://list.voyage.hk/mailman/listinfo/voyage-linux
>   


-- 
Regards,
Punky

Voyage Solutions (http://solution.voyage.hk)
* Embedded Solutions and Systems
  - Mesh Networking, Captive Portal, IP Surveillance, VoIP/PBX
  - Network Engineering, Development Platform and Consultation