One of the most important procedure in setting up master-slave replication on Mysql database successfully is to have a consistent dump or backup of database(s) from the master server by locking all tables during mysqldump so...
Category - Quick Tips & Tricks
linux tips and tricks
I’ve been working with the servers most of the time, and few days ago, i had free time to test ubuntu on one of my laptop, it’s not new but not too old either, it’s dual core MSI VR320 and guess what it’s...
1. Wonder why you can’t send email from your linux server? 2. Is your mail server or 3rd party email hosting provider requires authentication for your outgoing server to send out emails successfully? 3. Are you using a...
Assuming you already have mysql server installed on your machine, the reason you are installing phpmyadmin is to ease your administration of your MySQL like database creation and deletion, create/alter/drop/view tables and...
There are ways to sync two MySQL tables in a non-GUI method such as mysql triggers or by Maatkit’s MySQL Table Sync, but it’s not that user-friendly. Of course, if you want the GUI-type, there’s always the...
I had the chance to work as a systems administrator in an e-commerce company and they have Linux dedicated servers leased/purchase from a hosting provider. Dedicated servers compared to a shared hosting is you have full control...
In this tutorial, we will be cloning PC desktop machines using an opensource tool called “G4U”. g4u (“ghosting for unix”) is a NetBSD-based bootfloppy/CD-ROM that allows easy cloning of PC harddisks to...
Here’s one trick to do that: Step 1. Install FreeTDS FreeTDS Website: choose FreeTDS source distribution Compile parameter: –prefix=/usr/local/freetds –enable-msdblib Then, copy /etc/ld.so.conf, to...
Want to test your Asterisk PBX system if it can sustain load and large traffic? Then you can use this tool. Sipp is a performance testing tool for the SIP protocol. Its main features are basic SIPStone scenarios, TCP/UDP...
These are the steps on adding additional hard drives on a pre-installed Linux server. Drives will be detected and can be checked thru the “dmesg” command. [root@localhost ~]#fdisk /dev/cciss/c0d1 press n to create...