Posts

Showing posts from April, 2009

Running manual NTP (network time protocol) In Ubuntu Linux

If your Ubuntu is out of time sync you can run a manual comand to syncronize the clock. command is: ntpdate Running ntpdate with no options / switches will couse it to try to sync with default servers. If none are set you will get an error similar to: ntpdate[15110]: no servers can be used, exiting then run it with servers address. for example: ntpdate europe.pool.ntp.org north-america.pool.ntp.org you might need to run sudo if you are not system root: sudo ntpdate europe.pool.ntp.org north-america.pool.ntp.org P.S. Server pool for Israel is: il.pool.ntp.org Provided by: SiQ systems, Cloud experts

Fix (repair) MySQL replication in case of duplicate items

If you as i am using MySQL replication mechanism, master-slave or master-master replication you sometimes loose replication due to duplicate entries. You can fix it by simply skipping the record: 1. log into MySQL: mysql -u root -p 2. in MySQL shell stop slave replication mysql> STOP SLAVE; 3. skip the affected record mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; 4. start slave replication process mysql> START SLAVE; 5. verify that replication is working: mysql> SHOW SLAVE STATUS \G 6. exit MySQL shell: mysql> quit; Provided by: SiQ systems, Cloud experts