Ubuntu Servers :: MySQL - Multi-Master Replication?
Aug 8, 2011
I have two computers (one tower, one laptop). On both the computers, I have apache & PHP & mysql running, so i can program/script anywhere I like. With a simple sync'ing program, the PHP scripts are synced between the PC's, thought the databases arent. Therefor I'm looking for a method to sync (replicate) the databases between the PC's. thought after setting up some configuration, i'm stuck... now with how to, but what to
Option 1) Multi-master replication between the PC and the laptop. With this setup, the database can ONLY sync once both the devices are turned on. Also it can only sync if they are turned on on my LAN, since they do not have an external static IP address. if I turn on both PC's on my LAN, with static IP's (from the DHCP server), this option will work. Thought, I basically never have both pc's turned on in my own home... cuz i can use only one at the time anyway.So I was thinking of another setup
Option 2) Multi-master replication with: online Server, PC and Laptop. The server basically contains the most up to date database. for example, the laptop updates the server and the server can update the PC later, once the PC is turned on. Also the other way around, the PC can update the server which can than update the Laptop.
There is, if i'm correct, only one problem: the only multi master replications setups I found, use a circulair setup... (1 updates 2, 2 updates 3, 3 updates 1) What I need is to have the PC update the server, but ALSO have the server update the PC (same for the laptop)
than there is another (little) problem: the PC and laptop cannot be reached from behind the modem, nor do they have a static IP. My question: Is it possible to sync the server with the laptop (that has no static IP), the laptop with the server (that has a static IP), and the same for the PC
I started over combining the first parts of this guide: [URL]..ubuntu8.04 (Only the first few parts in terms of configuration and naming). Then I used this guide: [URL]..Surprisingly enough all steps worked.
1. Now I need to set up LAMP servers with MySQL master/slave replication and Apache rsync.
2. Next i need to add BIND to both my Load Balancers with master/slave backup and replication...
Are there any guides to look at to follow on these? Can tou point me to the right direction for BIND with replication.
I configured a master DNS server 192.168.2.10 working OK. After that I configure a DNS Slave Server (92.168.2.11)the initial replication worked fine. This is test environment for my certification. I see how the zones from my master are transferred zones in Master training.com.db transferred zone to my slave when I started named service sec.training.com.db
That's Ok but I added some IPs to resolve to my master zone webserver IN A 192.168.2.30 fileserver IN A 192.168.2.31
I restart/reload named on master and after that I go to slave and restart/reload but zones wuth the new values are not replicated. How long does it take for slave to take the changes from master? how is the procedure manual or automatic? I see If I go to slave and delete sec.training.com and restart named the zone with the changes is transferred but that is very manual... I am including my DNS Configuration so you can take a look.
I'm setting up a Master and Slave OpenLDAP (ver. 2.4.25) use Replication method following {URL]. When I used slapdcat (slapdcat -l master_dump.ldif), I got a message:
root@ldap:/usr/local/openldap/sbin# ./slapcat -l master_dump.ldif /usr/local/openldap/etc/openldap/slapd.conf: line 89: <replogfile> keyword is obsolete (ignored) /usr/local/openldap/etc/openldap/slapd.conf: line 91: <replica> keyword is obsolete (ignored) bdb_db_open: warning - no DB_CONFIG file found in directory /usr/local/openldap/var/openldap-data: (2). Expect poor performance for suffix "dc=abc,dc=com". bdb_monitor_db_open: monitoring disabled; configure monitor database to enable
My Master slapd.conf is: # Require 112-bit (3DES or better) encryption for updates # Require 63-bit encryption for simple bind # security ssf=1 update_ssf=112 simple_bind=64
# Sample access control policy: # Root DSE: allow anyone to read it # Subschema (sub)entry DSE: allow anyone to read it # Other DSEs: # Allow self write access # Allow authenticated users read access # Allow anonymous users to authenticate
# Directives needed to implement policy: # access to dn.base="" by * read # access to dn.base="cn=Subschema" by * read # access to * # by self write # by users read # by anonymous auth # if no access controls are present, the default policy allows anyone and everyone to read anything but restricts updates to rootdn. (e.g., "access to * by * read") .....
My Slave slapd.conf is similar configuration to the Master Server...
I have a load balancer with 2 web servers behind it. The web servers rsync with cloud storage to update their apache directories 1 time every hour. Apache is just running php pages that pull/push data to a DB so they dont need to be updated that often. However I need to figure out how to implement a Master/Master MySQL setup to have my web servers point to for the PHP stuff. I need to implement it without having a single point of failure. The Load balancers are useless for failover as they only detect availability based on Ping request. So putting a master/master setup behind a Load Balancer is out. what is the best way to setup the master/master mysql in a HA setup without the use of a load balancer provided by the host?
If I have 2 MySQL server and I want to replicate their database to only 1 server, is it possible? I cannot afford to have master-to-master only because I still need to replicate one more machine but I do not have anymore more machine for replication so I'm thinking if these 2 MySQL server can be replicate to only 1 machine. If this is not possible, I guess I've no choice but to have two mysql daemon on that machine
i had configured a MySQl Replication Server with 2 DB Servers.Now we are planning to implement a failover Scenario.If Master fails The slave should act as a Master and we have a addition server.It will be going to act as slve.i had mentioned the points below..
1.Replication is made between Master (DBS 1) and Slave (DBS 2) (successfully done)
2.If Master (DBS 1) failed Slave (DBS 2) should act as a Master and Additional Server (DBS 3) needs to be Slave
3.Whenever Orginal Master (DBS 1) became online the current Master ie ..Slave (DBS 2) should go back to Slave position and all lost data will be replicated to Master DBS 1.
Might this is silly question but I am not much familiar to database.I am doing master slave Mysql replication for load balancing. On master server different database has different user privileges. I create backup using mysqldump command and restore on slave server instead of using load data from master; command.When i replicate database from master to slave will i require to set user privileges same as master ?One more question: How to lock all database in mysql?
I am looking into setting up replication in a production environment but currently this is on two test machines. I am following the documentation at [URL] but I am unable to get past "16.1.1.10 Setting the Master Configuration on the Slave". When I do the CHANGE MASTER TO I am getting a syntax error for some reason. What am I doing wrong? These servers run "CentOS release 5.5 (Final)" and "MySQL 5.0.77-log Source distribution" installed via yum. The only changes from default are that I created a single database on the master before doing the table lock and dump, then everything else has been done exactly to what the documentation states, but is still failing.
The option skip-networking is not in the config file on either server and neither one runs SELinux or any firewall.
mysql> CHANGE MASTER TO -> MASTER_HOST='192.168.1.220' -> MASTER_USER='repl' -> MASTER_PASSWORD='removed'
My MySQL replication slave failed,while reading a large size table from master.Thhe information from error.logError 'Unknown table engine 'InnoDB'' on query. Default database: 'test'. Query: I am sure that table is a Big size table..
I am using Debian as mail server and proxy server. I need to configure one backup server for the same. Mainly I need to replicate/sync the files on both machines. So I can avoid the failure time.
I have successfully installed Openldap and am able to authenticate to it, but I can not get the replication server operating correctly. I have followed all of the steps in doing so from this guide, [URL], but there are a few things i don't understand. when creating the consumer_sync.ldif file on the consumer server it says to replace ldap01.example.com to your server's hostname.
would this be the provider or consumer? My porvider is ldap@tech.local and my consumer is ldap-backup@tech.local.... so what one are they refurring to with the ldap01? And is there a way to push, or sync the two server manually? How do I know if they are backing up properly? How do I test?
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ] * Starting MySQL database server mysqld [ OK ] * Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
I have installed OpenSuse 11.3 32 Bit in a virtual machine on an older computer on a Windows XP host and on a new computer with AMD Phenom II X4 965 processor.
With sysbench I tested the performance of mutex and on the new computer it is 3 - 4 times slower than on the virtual machine. Other performance tests with sysbench for CPU, memory and threads are faster on new computer like expected. I tested this, because I have a slower performance of table creation in MySql tested with sql-bench, where creation of 10000 tables lasts 45 seconds on the virtual machine but over 400 seconds on the new computer.
I have tested with kernel-desktop and kernel-default but there are not large differences. File creation was tested with bonnie++ and is on newer computer faster as expected.
My questions are: - Why is the mutex handling on the multi core CPU slower than in the virtual machine and how to speed up this? - Or is there another reason why table creation of MySql is so much slower on multi core CPU?
I am using ubuntu server 9.04 version and trying to configure a primary master DNS on my server as followed the ubuntu official documentation [URL]. The files named.conf.local, db.example.com & db.192 are almost same as the documentation. And I can restart DNS. But when I followed the troublshooting page to ping example.com
thomas@UServer:~$ ping -c 4 example.com PING example.com (127.0.0.1) 56(84) bytes of data. 64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.047 ms 64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.067 ms 64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.058 ms 64 bytes from localhost (127.0.0.1): icmp_seq=4 ttl=64 time=0.061 ms
I had a dedicated HTPC box running Mythbuntu 11.04 (MythTV 0.24.1, I believe) that was both a master backend and frontend. I was also running a separate box (server 10.04) as a file server, print server, etc. Very recently I decided to try to migrate the backend duties and database from the HTPC box to the server so that I only need to have one machine running 24/7. So, on the server, I installed mythtv-backend-master from the repository, which for 10.04 is version 0.23.0+fixes. You might have seen this one coming... when I try to import the database from the Mythbuntu box into the server's MythTV installation, I get an error message saying the database schema (1264) is newer than expected (1254).
So, I'm wondering about my options at this point. Is it reasonable to install the same version of MythTV on the server? What would be the best way of going about that?
Is there a way to easily revert the database schema to the earlier version that's required?
Will I just need to start over with a new database? (Hopefully not this one.)
I'm managing a residential network. Each flat is its own subnet, and can only communicate with the other flats through a router (i.e. no broadcast). 95% of these 300 subnets only contains windows computers (from lambda users).
My final goal is to be able to browse the entire network from any computer.
I set up a samba server acting as a wins server, and every computer is aware of it because it is registered in the dhcp. So name resolution is working fine for everyone.
The same samba server is set to be the "Domain master browser":
workgroup = WORKGROUP wins support = yes prefered master = yes local master = yes domain master = yes os level = 65
When I browse the network (using "net view" or "browstat view"), I can only see the servers which are in the same subnet as the domain master browser.
Now, when in a subnet the computers arrange themselves to find a "local master browser", the only visible computers are the one in that subnet.
What I don't understand is why all the local masters don't synchronize their lists with the domain master.
So, to sum up, every subnet get the following behaviour:
-if a local master is elected, the only visible computers are the one in the same subnet.
-if no local master is elected, the only visible computers are the one in the subnet of the domain master.
-if I add another samba, configured as a local master winning all elections, then the magic is working and the lists are synchronized.
What is expected: -every computer can see all the computer from all the subnets.
I am attempting to setup an Ubuntu server as a secondary DNS server. It seems whenever it tries to dump the master file the system log shows Permission denied.let me know if more information is needed.NOTE: where it says example.com I have simply removed my actual Domain name.
Mar 21 21:49:24 ulinux named[14418]: zone example.com/IN: Transfer started. Mar 21 21:49:24 ulinux named[14418]: transfer of 'example.com/IN' from 192.168.0.15#53: connecte$
I need to perform instant filecopy between a pair of servers. Its loosely based on a master slave setup as we have ucarp floating a virtual IP between the two. services are on both boxes (tftp, apache). I'm happy with that, I now need a way to instantly sync files from set directories, as we could see problems if files have changed should the system fail over without being in sync
I know I could cron *1 but I don't want it running EVERY minute, in any case, if the change was within the last minute, then it wouldn't have the change anyway. I think it can be done with rsync daemons on box boxes, but I can't find a guide to to this. ATM the slave has been setup to accept rsync from the master, so I just need the config to have all changes on the master instantly replicated.
Faced with disk-bound issues on a FTP server with high traffic. Would like to set up multiple FTP server nodes with dedicated storage for each node where all FTP access is managed by a master FTP server. So, a user would FTP to a single externally visible IP address for the master FTP server and then get routed to the appropriate FTP node. Are the mutiple FTP nodes required or is there a better way of doing this? Perhaps only one FTP server is required and then each node would serve as a separate file server
I have 2 partitions, 1 for OS and 1 for data. The OS 1 is going to be imaged with every Ubuntu OS update so that this image can be taken from the testing server to the live server. However, the data must stay on the live server, so the imaging it will not erase the data. Therefore, I divided the live server into 2 partitions: OS and data.
I want to be able to save all of my customizations and data on the live server to the data partition. This includes (but is definitely not limited to) MySQL databases, Apache configurations, my /var/www/ folder, etc. How would I go about doing this? As in how do I set MySQL/Apache/etc. to save their configuration files on the data partition? Or is there a totally better way to achieve what I want?
I rent a server with 7 ip given. And i also want to host 7 website with 7 domain name in itI wish to assign each website with an ip address. is it possible to do that ?When I do
I am looking to create a multi-user LAMP server. For example the domain name behind my curent server is [URL] I would like user1 to have [URL] and user2 [URL]
Using Ubuntu server 10.04.2 64-bit all up to date.
I am running multi-threaded processes. These use OpenMP in my own code and the multi-threaded ACML maths library. When run in the foreground, everything is fine i.e. if I have set
export OMP_NUM_THREADS=8
then when I start all 8 cores are in use and things whizz along. However, when running overnight and logged out using e.g. 'at now + 1 minute' then the command, I am only getting about 130% CPU and it slows down accordingly. I have tried renice'ing and calling from within a bash script in case sh is doing something odd but nothing seems to solve it. I am sure that in the recent past this wasn't the case.
The libraries being used are shared versions in case that might have any bearing.
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ] Starting cups: [ OK ] STOPPING server from pid file /var/run/mysqld/mysqld.pid starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho sts/denyhosts.cfg 090727 04:35:47 mysqld ended
I have an ATI Radeon HD 3300 on-board video chipset, and an ATI Radeon HD 4350 PCI card. What I want is to have both displays available from one mouse/keyboard. I want to play media on one and have the other as my main desktop.The problem is that with Xinerama enabled, KDE desktop effects do not work (KDE says XComposite and XDamage are not available, even though I explicitly enabled them as extensions in the xorg.conf file), and performance is quite bad. Without Xinerama enabled, performance is great, desktop effects work great, but there's a lot of trouble with full-screen video, and the KWin window manager does not apply in the second display (although I can run a second instance of KWin on :0.1).
Now that Ubuntu 10.04 has multi-touch capabilities built-in, if I do not have a multi-touch screen or surface device, can I get 2 USB mice and get 2 pointers on the screen? One for the right hand and one for the left hand as I am ambidextrous, and would find it very convenient to have 2 mice.
