MySql database replication (master/slave)
In this tutorial we'll create a simple one-way master/slave database replication. You must have at least one master and one slave but you can use multiple slaves.
Master
1. Configure master to listen on all ip addresses (pico /etc/mysql/my.cnf)
#bind-address = 127.0.0.1
Moving databases from one MySql server to another
1. On the source database server run the following command to export all databases:
mysqldump -h localhost -u {username} -p --all-databases > database_dump.sql
Replace {username} with your MySql username.
Setup PostgreSQL database system
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.
1. Install packages
apt-get install postgresql postgresql-client
Hosting sponsor
Debian Tutorials
Tag Cloud
Categories
- Backup (2)
- Control Panel (1)
- DNS (3)
- FTP (2)
- General (4)
- Kernel (2)
- Mail (16)
- Monitoring (8)
- MySQL (13)
- Networking (4)
- PostgreSQL (1)
- Release (66)
- Security (13)
- Virtualization (4)
- Web (19)
- X (1)
Popular Tutorials
- Installing Zend Optimizer
- Installing ionCube
- Installing Zenoss monitoring system
- Installing and configuring PPTP VPN server on lenny
- Pure-FTPd with MySQL backend
- Installing Postfix with MySql backend and SASL for SMTP authentication
- Loading iptables rules on startup
- Installing DSPAM with ClamAV for Postfix on lenny
Ubuntu Tutorials – Latest
- Installing PEAR framework and packages
- Install mod_spamhaus Apache module to fight comment spam
- Installing ionCube
- Installing Zend Optimizer
- Disable root login to SSH