How to Configure Replication and High Availability in MySQL

Setting up replication 1. Configure master server parameters. This can be done by assigning an id for the master server and enabling binary logging. Add the following lines under [mysqld] section of your option file [mysqld] server-id=1 log-bin 2. Next step is to create a user with replication privileges on the master server, which can(…)

Difference between bytes and bits

Bits are 1s or 0s representing the state of a switch, in binary form. A byte is a binary word, consisting of 8 bits. 8 bits equals one Byte. 1024 bytes equals one KiloByte (KB) 1024 KiloBytes equals one MegaByte (MB) 1024 MegaBytes equals one GigaByte (GB) Sometimes people use 1000 instead of 1024, so(…)

Installing MySQL on Linux

Become the superuser if you are working in your account. (Type “su” and the prompt and give the root password). 1. Change to the directory that has the RPM download. 2. Type the following command at the prompt: 3. rpm -ivh “mysql_file_name.rpm” Similarly you can also install the MySQL client and MySQL development RPMs if(…)

How to Install MySQL on Windows

1. Create a temporary directory called mysqltem. 2. Unzip the file to this directory. 3. After unzipping is over, you’ll find a file called “setup.exe”. 4. Close all programs 5. Click on Start – Run and browse to the setup file in mysqltem. 6. Click “OK” to proceed 7. The setup program loads and guides(…)

How to Configure PIX Firewall.

Please find below a step by step process to configure the PIX Firewall from scratch. A simple scenario is given here where you have a corporate network with a PIX Firewall connected to the Internet through the Outside Interface, Internal Network through the Inside interface and DMZ through the DMZ Network. This paper would assist(…)

Basic PIX Troubleshooting

The “show interfaces” Command The show interfaces command will show you the basic status of the PIX’s interfaces. I’ve included some sample output below: pixfw# show interface interface ethernet0 “outside” is up, line protocol is up Hardware is i82559 ethernet, address is 0009.e89c.fdaa IP address 97.158.253.25, subnet mask 255.255.255.248 MTU 1500 bytes, BW 10000 Kbit(…)

How To Make Your PIX A DHCP Server

Enabling your PIX to be a DHCP server for your home network requires very few statements. First you have to enable the feature on the desired interface, which is usually the “inside” interface. The next step is to set the range of IP addresses the PIX’s “inside” interface will manage, and finally, you need to(…)

How To Configure Your PIX To Accept Telnet

The telnet command can be used to configure your PIX to accept telnet sessions. By default, it allows connections on the inside interface from the 192.168.1.0 network, as seen below: telnet 192.168.2.0 255.255.255.0 inside Of course, if you change the IP address of the inside interface, you may have to change the statement above. You(…)

HOW TO CONFIGURE SENDMAIL

With the growth of the Internet, e-mail has quickly become the main vehicle to spread information through the public at large. As the demand for fast, cheap and reliable e-mail grows, more individuals are turning to Linux to provide a fast, cheap and reliable solution. sendmail was originally developed by Eric Allman, in 1979, as(…)

How to Install and Configure VMWare Server virtualization in openSUSE

VMware Server is a free virtualization product for Windows and Linux servers. VMware Server is a robust yet easy to use server virtualization product and is based on proven virtualization technology. VMware can run on any standard x86 hardware and can support 64-bit guest operating systems including Windows Linux and Sun Solaris. VMware server can(…)

How to Configure Redhat-Win2k Dualboot

• Redhat/Win2k Dualboot • This How-To will assume that you have installed Redhat linux once before, you have installed win2k once before, and that all your data has been backed up. If your data is not backed up, do NOT follow this How-To. Update: I’ve found a similar but better method of doing this. The(…)

How to Recover MySQL root password

You can recover MySQL database server password with following five easy steps. Step # 1: Stop the MySQL server process. Step # 2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password Step # 3: Connect to mysql server as the root user Step # 4:(…)