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)
- DNS (2)
- FTP (2)
- General (4)
- Kernel (2)
- Mail (10)
- Monitoring (5)
- MySQL (10)
- PostgreSQL (1)
- Release (49)
- Security (9)
- Virtualization (3)
- Web (13)
- X (1)
Ubuntu Tutorials – Latest
- Installing ionCube
- Installing Zend Optimizer
- Disable root login to SSH
- Installing PowerDNS on Karmic Koala
- Add a sudoer (user allowed to use sudo)