In /etc/my.cnf
server-id=2
replicate-same-server-id = 0
auto-increment-increment = 2
auto-increment-offset = 2
replicate-do-db = databasename
Thursday, December 1, 2011
Setting for MYSQL replication in my.cnf
Subscribe to:
Post Comments (Atom)
Like Technology? Stay tuned.
Blog Archive
-
▼
2011
(57)
-
▼
December
(28)
- How to check Centos Version.
- How to change SSH port on Centos,Ubuntu,Debian
- Asterisk as a SIP client
- Asterisk configuration templates
- Change the Linux User Root Password
- How to Reset forgotten root password on Centos/Red...
- Repairing a Corrupted Database in MYSQL
- HOW TO CHANGE NAME OF AUTHOR in Blogger
- Dialplan that will act as a plug-in replacement fo...
- Multiple Logins In Windows Live Messenger
- Adding User Accounts in MYSQL
- Exporting Table Data in a File
- Remote UNIX connection
- SHOW CREATE TABLE displays the CREATE TABLE statem...
- check directory/dir/file size in linux
- Send Mail from CLI (LINUX)
- Change the system date in Linux
- Asterisk updating from 1.6.1.8 to 1.6.2.19
- How to Compile Asterisk module like (app_Voicemail.c)
- Run Wireshark in asterisk
- MYSQL Packet too large
- LoopProtection in OTRS
- [otrs] State change New to Open
- Check Size of Database [in MB]
- Setting for MYSQL replication in my.cnf
- Trouble Shooting MySQL Replication.
- Maintenance of Replicated Mysql Server
- Complete Master to Slave MySQL DB Replicate
-
▼
December
(28)
Social Profiles
-
If you are getting this error " Can't create PID PostMasterMailbox, because it's already running" in SYSconfig in OTRS ADM...
-
1. Download and extract Web-MeetMe gui in the root direcotry of your Web Server (usually /var/www/). The actual version of the package is ...
-
Example for Asterisk IVR ;*****************************START context1*********************************** [context1] ;ext...
-
Asterisk standard channel variables There are a number of variables that are defined or read by Asterisk. Here is a list of them. More infor...
-
Only work with asterisk 1.6 or above CLI> core show application GotoIfTime [Syntax] GotoIfTime(times,weekdays,mdays,months[,timezo...
-
<?php mysql_connect('localhost', 'root', 'admin'); mysql_select_db('xml'); $sql = "SELECT udid, coun...
-
If getting an error in asterisk cli (1.6.1.8) -- Remote UNIX connection -- Remote UNIX connection disconnected -- Remote UNIX connecti...
-
To RUN this install PHP 5.2 or later as it wont work on earlier version because of filter_var() issue as in 5.2 it is already installed as a...
-
CREATE DATABASE asterisk; GRANT INSERT ON asterisk.* TO asterisk@localhost IDENTIFIED BY 'yourpassword'; USE asterisk; CREAT...
-
SPY CALL by channel exten => 209,1,Dial(DAHDI/09r5,20,tT) exten => 209,n,Hangup() exten => 210,1,ChanSpy(DAHDI/${EXTEN:09}...
Blog Archive
-
▼
2011
(57)
-
▼
December
(28)
- How to check Centos Version.
- How to change SSH port on Centos,Ubuntu,Debian
- Asterisk as a SIP client
- Asterisk configuration templates
- Change the Linux User Root Password
- How to Reset forgotten root password on Centos/Red...
- Repairing a Corrupted Database in MYSQL
- HOW TO CHANGE NAME OF AUTHOR in Blogger
- Dialplan that will act as a plug-in replacement fo...
- Multiple Logins In Windows Live Messenger
- Adding User Accounts in MYSQL
- Exporting Table Data in a File
- Remote UNIX connection
- SHOW CREATE TABLE displays the CREATE TABLE statem...
- check directory/dir/file size in linux
- Send Mail from CLI (LINUX)
- Change the system date in Linux
- Asterisk updating from 1.6.1.8 to 1.6.2.19
- How to Compile Asterisk module like (app_Voicemail.c)
- Run Wireshark in asterisk
- MYSQL Packet too large
- LoopProtection in OTRS
- [otrs] State change New to Open
- Check Size of Database [in MB]
- Setting for MYSQL replication in my.cnf
- Trouble Shooting MySQL Replication.
- Maintenance of Replicated Mysql Server
- Complete Master to Slave MySQL DB Replicate
-
▼
December
(28)
0 comments:
Post a Comment