Hello
Yesterday I have been working on MySQL Replication between two servers. And I think you will need it as a reference article. Because of I also re-search a lot before starting.
Some question:
What is MySQL replication?
How to do?
How is Master? is Slave?
How to configure?
MySQL replication for non-standard port?
How to stop MySQL replication?
How it works?
Ok, let's start!
What is MySQL replication?
MySQL...
[HOW TO] 2015/10/12 15:39:35 [error] 30666#0: *5 open() "/home/www/html/index.html" failed (13: Permission denied), client: 127.0.0.1, server: **.vn, request: "GET /index.html HTTP/1.1", host: "*.**.vn"
I am creating the backup server to prepare in case of disaster. It seems well until I can not get the index.html. I use nginx as web server.
What happened? Afterwards I come to /var/log/nginx/error.log to totally view.
2015/10/12 15:39:35 [error] 30666#0: *5 open() "/home/www/html/index.html" failed (13: Permission denied), client: 127.0.0.1, server: **.vn, request: "GET /index.html HTTP/1.1",...
[HOW TO] Exporting and Importing An Individual MySQL Table
In moving databases from development to production it is sometimes necessary to export individual tables so that they can be imported into another database.
Exporting the Table
To export the table run the following command from the command line:
“mysqldump -p – –user=username dbname tableName > tableName.sql”
This will export the tableName to the file tableName.sql.
[NOTE:...
[HOW TO] What is net.ipv4.conf.default.rp_filter
/usr/share/doc/kernel-doc-2.6.32/Documentation/networking/ip-sysctl.txt
rp_filter - INTEGER
0 - No source validation.
1 - Strict mode as defined in RFC3704 Strict Reverse Path
Each incoming packet is tested against the FIB and if the interface
is not the best reverse path the packet check will fail.
By default failed packets are discarded.
...