General :: Purging Binary Logs In MySQL Replication?

Sep 15, 2010

I had Configured a MySQL Master-Slave replication.It seems that the binary logs steals so much space of My storage.

i.)My Master

show master status;

+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000144 | 475823 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

ii.)My Slave.

mysql> SHOW SLAVE STATUSG;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.277.55.141

[code]....

If i remove all binary files up tp mysql-bin.000144 using "PURGE",will it affect my existing database/any data loss.

View 14 Replies


ADVERTISEMENT

General :: Fail Over Scenario In MySQL Replication?

Sep 12, 2010

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

Replication
(Master Server)----->----(Slave Server)-----------(Additional Server)
DBS 1 DBS 2 DBS 3

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.

View 5 Replies View Related

General :: Mysql Replication Fails After Reading Large Table?

Oct 15, 2010

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

View 11 Replies View Related

General :: Binary - Use Logs To Have Incremental Backup

May 7, 2009

I had full backup in mysql. now i added some tables .i got new binary logs. how i can i use these logs to have incremental backup.

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

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

General :: How To Turn Off All Mysql Logs

Apr 23, 2011

how to turn off all mysql logs because mysql is using too many resources. I turned slow queries log and there is no slow queries here is what I want to turn off the logs maybe this is causing mysql to high load ?

View 2 Replies View Related

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 View Related

Ubuntu Servers :: MySQL Incremental Backup - Binary Log File Names

Mar 15, 2011

I am currently using a script to backup my Ubuntu 10.04.1 system. The mySQL databases are backed up separately from the the system / data.

My problem is with the mySQL incremental / binary log backups.

The problem is that the binary log file(s) are always named xxxx-bin.1.

Up to about a month ago the binary logs were named xxxx-bin.000001, xxxx-bin.000002, etc.

I did make some changes at about the time that this change in file naming ocurred, but I can not identify what, if any, setting I may have changed that has caused all of the binary log files to always have the same name.

My back up script uses both mysqldump and mysqladmin flush-logs to create the binary logs.

All of the setting for mysqldump and mysqladmin are contained in the my.cnf file.

The my.cnf file contents that are relavent are as follows:

Code:

The statements in the backup script that do the backup are:

mysqladmin flush-logs

or

mysqldump | gzip > $DB_BACKUP_DIR/$ARCHIVE_FILE #Note: delete-master-logs in my.cnf

View 3 Replies View Related

Ubuntu Servers :: Rsyslog & Log All Iptable Logs To Mysql Instead Just A Logfile

Apr 5, 2011

I try to log all my iptable logs to mysql instead just a logfile. The setup is as followed:

[Code].....

[red]Problem[/red] rsyslog logs everything correct, except it does not log to db, it logs to /var/log/messages. As I am brand new to the whole Linux experience, I don't get it. My /etc/rsyslog.conf is setup with $ModLoad onmysql.

View 1 Replies View Related

Ubuntu :: Trash Keep Showing Items In It Even After Purging?

Oct 16, 2010

I'm using Ubuntu 10.04.

I recently modified the nautilus to show the trash icon as it didn't come by default on the Desktop.

I have a problem because the trash keeps showing items in it. When I put my mouse over it it keeps saying "6 items", however, when I open the trash it is totally empty.

Code:
sudo find / -name "Trash"
And couldn't find anything that let me fix this.

View 3 Replies View Related

General :: Replication Data Os Level From 1 Pc To Other Pc?

Feb 24, 2010

i do wish to read study learn from linux world. sites to refer always for command, practice,tutorials etc.say like replication data os level from 1 pc to other pc,without using any outside linux software, only os level, linux to linux, linux to windows/macchannel bonding, using 2 network ethernet card, double the speed of network card and failover netowkr card alsosyncronize data 1pc to 2pc

View 1 Replies View Related

General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)

Jun 2, 2010

i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error

[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.

[code]....

i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.

View 9 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

Networking :: Ubuntu (lucid) - Clearing/flushing/purging Slapd?

Aug 4, 2010

I'd like to clear the slapd DB so that I could reinstall it from scratch, however, when I remove the package and reinstall it, I still get some items in there.How can I purge/flush/remove everything from slapd?Instructions I follow to do the set up?https://help.ubuntu.com/10.04/server...ap-server.html

View 3 Replies View Related

General :: Open Source File Replication - Backup ?

Jun 5, 2010

I am IT Manager. Currently I am responsible for a mostly IBM shop, running a mix of AIX, OS/400. VMware, and Windows.

My P-series running AIX and Oracle and my AS/400 both back up to tape drives daily.
But my VMware system is not being backed up, the virtual machines are, but my tape drive just broke down.

I just ordered a server grade machine with an i5 CPU, running 3 2TB SATA drives in RAID5, this is going to be my new backup server.

I am hoping I can put Linux on it, and some sort of open source file replications, real time backup software that will back up my Windows servers, and my Windows desktops in real time.... any sort of animal exist?

View 5 Replies View Related

Programming :: Finding A Utility To Combine Two Or More Binary Files Into A Single Binary File?

May 5, 2011

Is there any Linux utility to combine two or more binary files into a single binary file ?

View 7 Replies View Related

Programming :: Version Info Coded Into ELF Binary / Author And Company Name Into ELF Binary?

Nov 30, 2010

How to coded version info and other information likes author and company name into the ELF binary?

I prefer the put the version info during build step.

View 5 Replies View Related

General :: Create A New Mysql User And A Mysql Database At The Shell Prompt?

Aug 7, 2010

How do I create a new mysql user and a mysql database at the shell prompt?

View 1 Replies View Related

General :: Mysql Not Starting After Changing Mysql Admin Password In Fedora?

Feb 19, 2010

Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.

View 1 Replies View Related

General :: Access Remote Mysql Db With Mysql-administrator Command?

May 13, 2011

I have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.

now a these days i am connect through ssh and excuting below command

#mytop mysql -u root -p <passwd>

In my mysql db i have added the userip & passwd (allowed the privileages for that ip)

If i use mysql-administrator i am getting below error

MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)

View 6 Replies View Related

General :: Interact With The Mysql To Reset The Root Mysql Pass?

Jun 14, 2011

I have tried many different ways to interact with the mysql to reset the root mysql pass. This is what I got to right now

Code:
#!/bin/sh
newpass=$1
service mysqld stop
mysqld_safe --skip-grant-tables --skip-networking &
echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD("$newpass") where User="root";" >> /tmp/mysql_pass_reset.txt

[Code]...

View 6 Replies View Related

Server :: Mysql "flush Logs" Or "flush Tables With Read Lock?

Jan 15, 2010

policy is to backup mysql with mysql-zrm.However at a certain stage it hangs forever. This is at the "flush logs". I tried this manually and it gave the same result. Even after restarting mysql and the host. After some googling and trying I found out "flush tables with read lock" gives the same result. The tables seem to be MyIsam. I tried with a mysqldump on one server and restore it on a test vm. I used the same config and flush logs still hangs. ALso I tried to change some configuration directives... but with the same result

Edit: btw, I checked the logfile and didn't found anything (/var/log/mysqld.log)

Edit2: I also did myisamchk -s *.MYI (in all direcoties with db files;actually did it with find command) and it did not return anything so datafiles seem ok.

View 4 Replies View Related

Fedora :: FC12 Logs In And Then Logs Out?

Apr 19, 2010

When I try to login as me - it gets pretty far but then something happens and automatically logs out. This happens in Gnome, Kde too. Now - I have no problem logging in a Root. Is there a way I can try to stop the login process before it kicks me out, or is there a way to look at some files to tell me what's going on?

View 3 Replies View Related

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:

Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory

[Code]...

View 6 Replies View Related

CentOS 5 :: Different Replication Using DRBD 8.3.2?

Apr 13, 2010

I'm running RHEL 5.5 on two workstation for test DRBD and I get something that sound strange ...[URL] Quote:Protocol C. Synchronous replication protocol. Local write operations on the primary node are considered completed only after both the local and the remote disk write have been confirmed. As a result, loss of a single node is guaranteed not to lead to any data loss. Data loss is, of course, inevitable even with this replication protocol if both nodes (or their storage subsystems) are irreversibly destroyed at the same time. By far, the most commonly used replication protocol in DRBD setups is protocol C.

View 15 Replies View Related

CentOS 5 :: Logs In Goes To Check The Logs And Gets "/var/log" Permission Denied

Jan 29, 2010

On our app server the logs from the Sybase Mobilink service get logged to /var/log because of that I did a chmod a+rx /var/log and all is well until.... the next day QA logs in goes to check the logs and gets:

Quote:
qa@dwdb [~]$ ls /var/log
ls: /var/log: Permission denied
qa@dwdb [~]$

View 18 Replies View Related

Hardware :: Unable To Check The Replication?

Jan 18, 2011

I have a fedora 8 server and I just wanted to install fedora directory server I got it install and running, but I'm unable to check the replication and also it seems that I has no database when I user fedora-console-idm.[URL].. Also the same thing happens at the web tool. Any ideas? I think there is no db set, but I have no idea how to do this on fedora-ds. I'm new to it.

View 1 Replies View Related







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