Microsoft has released several security updates that address newly discovered issues in Microsoft Windows. Information about these updates and which software is affected is available on the Microsoft.com Security Web site:
HOW TO VERIFY THE AUTHENTICITY OF A MICROSOFT SECURITY E-MAIL MESSAGE
Before you take any advice on downloading software or updating your computer, make sure you can trust the source. Learn the warning signs for spotting a fraudulent security bulletin, as well as how to check the security certificate for any Web site:
The Microsoft Security Update is an e-mail alert service designed for home users and small businesses that provides information about Microsoft security updates and virus alerts. Microsoft also uses this service to make subscribers aware that they might need to take action to guard against a circulating security threat.
You have received this update because you are a subscriber. If you would like to unsubscribe, follow the instructions at the bottom of this page.
To cancel your subscription to this newsletter, reply to this message with the word UNSUBSCRIBE in the Subject line. You can also unsubscribe at the Microsoft.com web site <http://www.microsoft.com/misc/unsubscribe.htm>. You can manage all your Microsoft.com communication preferences at this site.
So I did this once before but then my webserver sort of died.. ok I just left it at my old office cause it was on a p2 and I didn't want to move it, so i'll redo this.
This little tutorial thinks you have a basic mysql setup and have never tried to setup replication. If you have you generally have to remove all the binary logs and the settings in the my.cnf
Master Server
So these are the settings on the master server you need. For me I edit the /etc/my.cnf
Now log into the mysql client and you need to setup a replication user.
Code:
GRANT REPLICATION SLAVE ON *.* TO slaveuser@'10.10.10.10' IDENTIFIED BY 'slavePass';
When creating users I always like to use ip's you can use hostnames and wildcards and such.. for more information on that visit the mysql doc page for the new user section.
Ok now the next step requires you to stop your mysql server for a bit cause you want to make sure the db is locked when you do a dump and no hidden data gets inserted or such.
Code:
FLUSH TABLES WITH READ LOCK;
Now that its locked you can run the following command
now move the /tmp/backup.sql file to the slave server
You can now unlock the db's now
Code:
unlock tables
Slave Server
Now on to the slave server. So this takes into account that it is a new install or such of mysql and you have no tables.. so lets import the backup from the master server
Code:
mysql < backup.sql
You want to add -u root -p if you setup a root password already on your slave
Now we want to add the following into /etc/my.cnf. The server id muse be unique
Code:
server-id=2
log-slave-updates
log-warnings
now restart the mysql server
Now login to the mysql client and issue the following query
Code:
CHANGE MASTER TO MASTER_HOST='<master host name>',
MASTER_USER='slaveUser',
MASTER_PASSWORD='slavePass',
MASTER_LOG_FILE='mysql_binary_log.000004',
MASTER_LOG_POS=79;
So you can see the last 2 lines are where i told you to note the filename and position and the others are from the grant.. now if everything worked you should be able to issue the following command in the mysql client
Code:
start slave
and replication should be working.. you can test this by creating a new DB on the master and it should appear on the slave.. if it doesn't work remember to check those logs
D:\>smbios
Microsoft (R) Systems Management BIOS Dump Utility 1.1 (01/03/2002)
Copyright (C) Microsoft Corporation 2001. All rights reserved.
SMBIOS [/?] [/t] [/d|/dx|/r|/rx] [/v]
/t - Display SMBios and DMI Table Entry Point information.
/d - Display all tables and their data.
/dx - Display information from tables of the specified type.
/r - Display all tables and their data in raw format.
/rx - Display information from tables of the specified type in raw.
/v - Verbose mode (debug information)
How do you like the events in <snip>? I'm <snip> and of course I can't leave it without attention all these <snip> :)) The reason is that I gave up <snip> ten years ago and recently following all these <snip>. But that's not all. Imagine my surprise when I <snip> , my motherland. Thus, there can be such paradoxes in our lives. Now I <snip>.
