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
Ástþór IP
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.
Ástþór IP
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
admin