×

Blog

STEP FOR MYSQL MASTER TO MASTER REPLICATION

  • First, install MariaDB on both the centos 7 based servers.

 

  • Command:

#sudo yum install mariadb-server

#sudo systemctl start mariadb

#sudo systemctl enable mariadb

#sudo systemctl status mariadb

#sudo mysql_secure_installation(press enter for the root password for the first time when it asks and then provide your own password to mysql)

  • machines to explain the procedure.

Master1  IP : 192.168.1.25

Master2  IP : 192.168.1.26

  • Configuration Procedure:

 

  • Master1

 

  • In master1 terminal, check the status of MariaDB

#sudo systemctl status mariadb

  • Open my.cnf file and add the following statement to the file. Save and exit from the file. 

#vi /etc/my.cnf

server-id=10

log-bin=mysql-bin

  • Restart the MariaDB service by running the following command.

#sudo systemctl restart mariadb

  • After login to mysql we are going to create user

#mysql –u root –p

#MariaDB [Linux]> create user ‘reply’@’%’ identified by ‘12345’;(here reply is a user and 12345 is password)

#MariaDB [Linux]> grant replication slave on *.* to ‘reply’@’%’ identified by ‘12345’;

#MariaDB [Linux]> flush privileges;

#MariaDB [Linux]> flush tables with read lock;

#MariaDB [Linux]> show master status;   (it will show you the master log file and master position)

#MariaDB [Linux]>exit

  • Take the MySQL dump from master1 terminal and execute the following command

#mysqldump mysql –u root -p> mysql-db.sql

#rsync -Pavzxl mysql-db.sql [email protected]:/root/

 

  • Master2

 

  • In master 2 terminal, check the status of MariaDB

#sudo systemctl status mariadb

  • Open the my.cnf file and add the following statement to the file. Save and exit from the file.

#vi /etc/my.cnf

server-id=20

log-bin=mysql-bin

  • Restart the MariaDB service by running the following command

#systemctl restart mariadb.service

  • Now inject the MySQL dump file into master2 database.

#mysql mysql -u root -p < mysql-db.sql

  • After dumping, open the MySQL shell and do the replication configuration as shown below.

#mysql –u root –p

#MariaDB [Linux]> stop slave;

#MariaDB [Linux]> change master to master_host=’192.168.1.25′, master_user=’reply’, master_password=’12345′, master_log_file=’mysql-bin.000002′, master_log_pos=566;  (check the master log file and master log position of master1)

#MariaDB [Linux]> start slave;

#MariaDB [Linux]> show processlist;

  • Check the slave status by using the command as shown below. 

#MariaDB [Linux]> show slave status;

#MariaDB [Linux]> exit

  • Restart the MariaDB service by running the following command. 

#systemctl restart mariadb.service

  • Go to the master and check the master status using the command as shown below

# mysql –u root –p

#MariaDB [Linux]> show master status;   (it will show you the master log file and master position)

Master1

  • In the master terminal, check the established connection using netstat command.

# netstat -natp | egrep -i established.*mysql

  • Open the MySQL and check the process list and also configure the replication settings

#mysql –u root –p

#MariaDB [Linux]> unlock tables;

#MariaDB [Linux]> show processlist;

#MariaDB [Linux]> stop slave;

#MariaDB [Linux]> change master to master_host=’192.168.1.26′,

master_user=’reply’,master_password=’12345′, master_log_file=’mysql-bin.000004′, master_log_pos=245;

#MariaDB [Linux]> start slave;

#MariaDB [Linux]> show slave status;

  • Replication configuration is done. now Checking the Replication process

Master1

  • I have created one database named as Linux

          #MariaDB [(none)]> create database Linux;

#MariaDB [(none)]> use Linux;

  • Create a table for the newly created database.

# MariaDB [Linux]> create table Distribution(Distro varchar(25) NOT NULL);

  • Insert some values into newly created table.

# MariaDB [Linux]> insert into Distribution values(‘REDHAT’);

  • The table and the database has been created successfully. List the table from the database.

# MariaDB [Linux]> select * from Distribution;

Master2

  • In the master 2, login to MySQL and list the databases. 

# MariaDB [(none)]> show databases;

  • Now the database which is created in master1 is replicated into master2. Use the database and list the table.

# MariaDB [(none)]>  use Linux ;

 # MariaDB [Linux]> show tables;

  • Select and list the table from the selected database. 

# MariaDB [Linux]> select * from Distribution;

  • Insert some values into that table and list the table’s values the updated values is shown. Now the replication between master-master is working successfully. 

# MariaDB [Linux]> insert into Distribution values(‘Ubuntu’);

# MariaDB [Linux]> select * from Distribution;

Master1

  • Again goto master1 terminal, now select and list the tables to check the replication process. If the updated value from the master 2 is shown, then the replication process is done.

#mysql –u root –p

# MariaDB [Linux]> select * from Distribution;

 

 

Benefits of employing Windows VPS services at reasonable rates

Vps Server

VPS servers have gained popularity because of the advantages it is posing for web-hosting needs. VPS refers to the virtual private server which acts as a physical server in a virtual way giving the same features as the physical server would. It works with definite number of resources allowing you to scale up your resources as per your requirements. So with VPS hosting you can actually seek advantages of a physical server in a much more cheaper way.

Vps Hosting

In VPS hosting, Windows VPS is considered to be the most effective because of the added features and performance it offers. Windows VPS runs on the OS of Microsoft developed windows OS which ultimately justifies it quality. It possess some important advantages as follows

  • Microsoft have focused on developing Windows VPS in a newly upgraded, user-friendly way which can give better solutions and compact performance on a cheaper investment.
  • Affordable Windows VPS can also be a beneficial tool for those who need ASP or net technology.
  • Microsoft has been in this market since a very long time and now they have a perfect idea of what their customers really wants. They develop their systems accordingly and make sure to give proper assistance to their buyers regarding their usage. This makes easy for the buyers of Windows VPS to use it with better knowledge and enhance its productivity.
  • Windows VPS at cheaper rates could benefit you with extra features like faster updates, better support services, reliable performance rates etc at just minimal costs.
  • Windows VPS uses only the Windows software and Windows functions which makes your VPS having better quality and assured performance fulfilling all your webhosting needs.
  • Windows VPS is also supportive with the security measure and other security tools posing no risk to your database and ensuring minimal data breaching chances.

Conclusion

Therefore getting Windows VPS at affordable rates can be a big boon to your webhosting needs as you get the assistance Microsoft features which give you an interface being easy to use having the settings and icons which are familiar and simple to understand.

Windows VPS also offers you a flexible option to scale up your operations easily. It also comes with some in-built features which are specially developed to benefit business transactions. It offers a wide array of functions which allows you to carry out in-depth customization effectively.

You should never leave a chance of getting Windows VPS at cheaper rates.  Ideastack is one of those brands offering effective services of Windows VPS at cheaper rates. 

Unblocked Particular ip from WHM/Cpanel

Log in to the main WHM Panel

1.Search for Plugin section

2. Go to ConfigServer Security and Firewall

 

WHM/CPANEl

3.Search for the IP which you want to get unblocked from WHM Panel

Cpanel vps

4. If given IP will be blocked then you’ll find that IP here after clicking on Search for IP button.

To unblock that IP you’ll get the Unblock button below, just simply click on that button and that IP will be unblocked.

 

Whm vps

Now user can open the panel from that IP

The reason why IP got blocked: User might attempt a multiple failed login attempt