Server :: Setup LAMP With MySQL Master/slave Replication And Apache Rsync?

Aug 12, 2010

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.

View 1 Replies


ADVERTISEMENT

Software :: Master And Slave OpenLDAP Setup Using Replication Method

May 13, 2011

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...

View 5 Replies View Related

General :: Master And Slave DNS Server Replication

Nov 29, 2010

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.

View 4 Replies View Related

Ubuntu Servers :: Live / Instant Rsync For Master Slave Setup

Feb 8, 2011

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.

View 3 Replies View Related

General :: LAMP Server Setup - MySQL - PHP - Apache - FTP

Mar 16, 2010

Good tutorial, using images for a lamp server that has, MySQL,PHP, Apache, FTP with all the fruit for running a server that will host a Gallery, forum and main site

I know there's heaps around for Ubuntu 9.10, but its not quiet what I'm looking for as in Gd, ImageMagick and some extras for Apache mods

View 1 Replies View Related

Server :: Setup Master / Master Mysql In HA Setup Without Use Of Load Balancer Provided By Host?

Mar 31, 2010

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?

View 2 Replies View Related

OpenSUSE Network :: Setup LAMP On An Old Pc Installed Apache, MySQL?

Jan 16, 2011

i am trying to set up LAMP on an old pc i have installed linux, apache, mySQL and PHP following this guide Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 11.3 (LAMP) | HowtoForge - Linux Howtos and Tutorials. i have installed phpMyAdmin but when i try and acess it i get this error

Error
MySQL said:
Cannot connect: invalid settings.

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

[Code]...

View 1 Replies View Related

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

PC <====> Server <====> Laptop

View 1 Replies View Related

Server :: Unable To Setup Replication In MySQL 5.0.77 On CentOS 5.5

Jun 21, 2010

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'

[Code]....

View 3 Replies View Related

Server :: Bind Views With Master And Slave

Apr 12, 2011

I have bind configured with Internal and External views, but the slave server is transferring only the Internal zone files for both Internal and External - a diff shows no difference, and the log shows the same serial number.What am I missing in the config so the slave server properly receives updates from the master for both views?

View 2 Replies View Related

CentOS 5 Server :: DNS Not Replicating From Master To Slave?

Jan 27, 2010

I have set up a master BIND DNS server with 2 slaves. All the services start up fine on all 3 servers, but zones and named.conf info is not being replicated. The 3 servers are tentatively installed on a Xen virtual server for testing purposes. All 3 servers are 64bit and installed with: -> CentOS release 5.4 (Final) - 2.6.18-164.10.1.el5xen -> BIND 9.3.6-P1-RedHat-9.3.6-4.P1.el5_4.2

All 3 servers are fully updated. All 3 servers have static IP addresses. The services on all 3 servers start up without any apparent issues. Master server: # /etc/init.d/named restart ; tail -f /var/log/messages

[Code]...

View 10 Replies View Related

Server :: Distribute Securenets File From NIS Master To Slave?

Jan 25, 2011

I have a large environment with many VLANs and NIS slaves serving the VLANs. Previously we have not used a securenets file (don't worry; we don't use NIS for passwords, just NFS maps), but I'd like to start. The number of NIS slaves makes it annoying to update a securenets file on each when we add a new VLAN. Is there a way to propagate the securenets file to each slave when I update it on the master?If not, I guess I can live with propagating the file once and only visiting new slaves when I build them, because in 99% of cases a NIS slave only serves its own subnet.

View 1 Replies View Related

Server :: New Zone Entry In Master Not Getting Updated At Slave

Feb 19, 2011

I have configured master and slave Bind servers. Everything works fine. But whenever I add a new zone entry at master server it is not getting updated at slave server in logs I see this error:
client 192.168.1.1#43428: view external: received notify for zone 'yourdomainname.com': not authoritative

At master server I do not see any error or warning message. This error clearly indicates that named.conf file does not have zone entry in it or domain name is wrong. While checking the named.conf file I see that the zone entry has not been updated at slave server. If I update it manually and reload named on slave then zone files (db files) are getting created without any issue and any modification at master server for the zone records are also getting updated. My concern is why zone record is not getting appended at slave server in named.conf file.

Is there anything I am missing in the configuration. I am pasting the steps which I have followed to configure my master and slave server:
Configure Bind as master and slave server
Install Bind on your server
yum install bind
OR
sudu apt-get install bind9
Generate RNDC Key using the command
rndc-confgen -a -k rndc-key
it will stored in /etc/rndc-key file
Master Server IP 192.168.0.1
Slave Server IP 192.168.1.1
Master Server Configuration
options .....

View 8 Replies View Related

Server :: Configure Master / Slave Dns Using SSL Authentication While Transferring The Zone Files

Jul 11, 2011

In our Server they configure Master / Slave Dns using SSL authentication while tranfering the zone files, i dont have much idea about ssl authentication for Dns, how it will works

View 3 Replies View Related

Server :: 2 Mysql Replication To 1 Machine?

Apr 5, 2010

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

View 5 Replies View Related

Server :: User Privileges In Mysql Replication

Sep 27, 2010

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?

View 2 Replies View Related

Server :: Email Notification - Heartbeat To Send Email When The Slave Server Becomes The Master?

May 3, 2010

Have someone used Linux heartbeat to send email when the Slave server becomes the Master? I've read I can configure the MailTo under.

But I really don't know how to do it. I basically need my primary server to send an email when it becomes inactive and all the activities are manage by the secondary node.

View 7 Replies View Related

Server :: MySQL 5.1 Not Replicating Properly With Slave

Jul 31, 2010

I recently set up replication on a production server and some rows are not making it to the tables on the slave. After 3 days I can see 200+ entries (of 161,000~) that are on the master and not the slave. Logs under /var/log including mysqld.log, mysql.status, messages do not show any problem.I have already tried dropping the DB on the slave and setting up the replication again by doing a stop slave, set slave options such as were in the logging to start, drop table, restore the dump previously made by the master, start slave, but the issue persists.

I following the documentation on the MySQL site for setting up replication so I'm not sure why this is having issues.What can I do to investigate and fix this?

View 2 Replies View Related

Ubuntu :: Slave Or Master Drive. Does It Matter?

Aug 14, 2010

i'm about to perform a fresh ubuntu install, and i was wondering if anyone knew whether installing on the slave or master drive mattered. i know if you're installing on the same drives it's slightly faster for ubuntu to be installed first, but that doesn't seem to be the case since i have two separate drives

View 9 Replies View Related

General :: How To Transfer All Zone From Master To Slave

Mar 15, 2010

I installed bind 9 sucessfully, and create many zones on its.

I want to biuld 1 slave server but i have problem :

How to transfer all zone from master to slave server ?

View 1 Replies View Related

Ubuntu Installation :: HDD Config - Secondary Master / Slave

May 1, 2011

I have an EeePC 901, with a 4gb SSD and a 16gb SSD installed. Trying to get Natty installed and hit a few problems not least of which, that it won't fit on the 4gb drive! However in my BIOS setup under HDD config it says:
Secondary Master=4gb
Secondary Slave=16gb
I have no other devices attached. Why aren't they Primary? And I can't seem to switch them round.

View 5 Replies View Related

Red Hat / Fedora :: Convert Slave To Master And Enable Writing To Db?

Jan 27, 2010

Is there any possible to convert slave to master, and enable writing to db?

View 4 Replies View Related

Hardware :: Configure The Master And Slave On 5 Sata Disks?

May 13, 2010

How to configure the master and slave on 5 Sata disks? Is there that or it is automatic.I install Debian, ok, master boot ok, on the first sataAnd at reboot, just after install, the boot hangs and no grub appears.

View 3 Replies View Related

Debian :: MySQL Server Can't Start In Lamp

Jun 24, 2015

I installed LaMp 2 days ago. First everything works; But until yesterday, I can't start anymore mysql server : it failed each time.

When I look at the status :

Code: Select allsystemctl status mysql
Failed to get D-Bus connection: Erreur inconnue -1

It's like it can't generate mysqld.sock

Code: Select all/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

I keep reading man and trying to find something I didn't configure correctly, but I can't find nothing.

View 1 Replies View Related

OpenSUSE :: Setup PHP / Apache / MySQL For Development?

Mar 16, 2011

On Windows and Mac it's as simple as downloading some WAMP and XAMP stack and clicking "install".

On OpenSUSE I'm trying to do it myself. I went into YaST and installed the "Web and LAMP Server" pattern.

Then I edited the default-server.conf file to point towards my website by changing the DocumentRoot and <Directory "blah blah"> lines.

Then I tried to start apache, but got the following error:

Code:
# apache2ctl restart
httpd2: Syntax error on line 188 of /etc/apache2/httpd.conf: Could not open configuration file /etc/apache2/sysconfig.d/include.conf: No such file or directory
So I just went into httpd.conf and commented out that line.

[Code].....

View 7 Replies View Related

Debian :: Create A Sandbox Environment On LAMP Server For PHP/MySql Development?

Mar 5, 2011

I need to create a sandbox environment on my LAMP server for PHP/MySql development. Anyone who could point me in the right direction or share their insight?

View 1 Replies View Related

CentOS 5 :: Setup A Box With Apache, PHP, MySQL And IRedMail (Postfix/Dovecot)?

Jul 26, 2010

For 3 days now I've been trying to setup a CentOS box with Apache, PHP, MySQL and iRedMail (Postfix/Dovecot) Everything is great apart from Apache, which is returning 403 errors: "You don't have permission to access / on this server.". The apache error_log file says: "[Mon Jul 26 14:02:32 2010] [error] [client x.x.x.x] (13)Permission denied: access to / denied" (I've blanked out my IP). I have no idea what's happening here. Apache works fine until I add my VirtualHost which is:

<VirtualHost mydomainname.com>
DocumentRoot "/home/myuser/public_html"
<Directory "/home/myuser/public_html">
allow from all
Options +Indexes
RewriteEngine On

[Code]...

View 5 Replies View Related

Ubuntu :: Re Setup Mail/LAMP Server?

Oct 14, 2010

Ubuntu 10.10point me the URL of Howto re setup a mail/LAMP server Google brought me the howto from howtoforge. I need the howto from Ubuntu documentation/Greek.

View 2 Replies View Related

OpenSUSE Network :: Port Forwarding & Samba Access For An Apache Lamp Server?

May 23, 2010

How do you configure the firewall to allow external web access (it's a LAMP server) and internal access for samba shares ?

View 6 Replies View Related

Ubuntu Installation :: Setup A LAMP Server On An Old Desktop Machine?

Jan 27, 2010

I am a total noob with regards Linux so will undoubtedly frequent this board asking some lame questions in the coming weeks. At present I am trying to setup a LAMP Server on an old desktop machine I have lying about, however there is not going to be a keyboard, monitor or mouse attached beyond the installation process. My question simply is am I best installing the server or desktop version of Ubuntu for this requirement?

I have been playing with Desktop 9.04 and found it tough to use headlessly, however understand that Server 9.04 fully supports headless access. Being a newbie I do prefer to use the GUI to make changes and generally play around, so a UI such as GNOME would be essential. Having read about I understand the best way to access remotely is to install SSHServer and VNCServer and then login over SSH and VNC into the box.My remote machine I will use to connect to Ubuntu is a Windoze 7/XP machine.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved