How to set up MySQL replication
How to set up MySQL replication. And for debugging purpose, it will be great if I can run multiple MySQL instances on a single host.
To set up MySQL replication, check these tutorials:
Similar Posts
How to install WordPress on Fedora 19
ByQ A
How to install the latest WordPress on a newly installed Fedora 19? Thanks! First, install the LAMP (you already have ‘L’) stack: # yum install httpd php php-mysql mysql-server php-gd and start these services: # systemctl start mysqld.service httpd.service Then, install WordPress on the LAMP stack following the tutorials on the Web. Two good ones…
How to write a SQL to replace strings in a column in a MySQL database table?
ByEric Ma
How to replace strings in a column in a MySQL database table? For example, I would like to replace http://www.systutorials.com with https://www.systutorials.com in a content column of a table post. You may use a SQL statement as follows. update post set content = replace(content, ‘http://www.systutorials.com’, ‘https://www.systutorials.com’) where content like ‘%http://www.systutorials.com%’ Read more: HTML form generation…
How to exclude directories with certain names from rsync on Linux?
ByEric Ma
How to exclude directories with certain names like “cache” from rsync on Linux during backup? The “cache” directory may in many different paths, such as file1/cache/ or file2/cache/, and adding all “cache” directories to rsync command is not a doable way. You can use rsync with –exclude=cache/ like rsync -avxP –exclude=cache/ /path/to/src/directory/ /path/to/dst/dir/ Read more:…
Proxy using SSH Tunnel on Windows
ByEric Ma
This article is an instruction of how to use https://www.systutorials.com/proxy-using-ssh-tunnel/ on a Windows machine. The mechanism is similar as the one in https://www.systutorials.com/proxy-using-ssh-tunnel/ with “Proxy listening to localhost port only”. Download PuTTY PuTTY is the software we use here for port forwarding. Please download it following the links in https://www.systutorials.com/open-source-and-portable-ssh-scp-sftp-and-vnc-clients-for-windows-to-remote-control-linux/. Configure PuTTY and create a…
How to add two static IPs for a Xen VM?
ByEric Ma
Hello, I have installed Xen4Centos on Centos7, having single NIC card with bridge network and have two VMs on that. In one VM, I want to add two static IP one for webserver and one for mail server. So I have created IP alias in guest VM, it was created but it was not pinging…
Bash comparison operators
ByEric Ma
What are all the bash supported comparison operators? The man 1 test contains all the operators supported in bash. An omitted EXPRESSION defaults to false. Otherwise, EXPRESSION is true or false and sets exit status. It is one of: ( EXPRESSION ) EXPRESSION is true ! EXPRESSION EXPRESSION is false EXPRESSION1 -a EXPRESSION2 both EXPRESSION1…