Hi Steve,
you haven't said what OS you are installing this on or how you have
installed MySQL. Normally you would use a version avaialable in your
OS distribution as this avoids any overly complicated installation and
will manage security and bug patches for you MySQL binaries. Ie
insta
Quoting william drescher :
I read the manual forwards and backwards but I can't figure out how
to set it up to replicate everything except the in memory table.
Is this what you are after?
http://dev.mysql.com/doc/refman/5.5/en/replication-options-slave.html#option_mysqld_replicate-ignore-tab
Quoting "Brown, Charles" :
Can the mysql replication limited to selected schema or database?
Hi, yes it can. On the master side you control what is written to the
binlog with my.cnf entries for each DB like:
binlog-do-db=DB1
binlog-do-db=DB2
And on the slave side you use entries like:
r
Hi Walter/all,
ok nailed it, the issue is the default hosts.allow installed on
FreeBSD, and specifically the last section that denies everything. By
default it looks like this:
# The rest of the daemons are protected.
ALL : ALL \
: severity auth.info \
: twist /bin/echo "Y
Quoting Reindl Harald :
"You are not welcome to use mysqld from tau" is NOT from mysqld
remove your hosts.allow/hosts.deny crap and replace it with firewall-rules
if the problem goes away make a bugreport on BSD side becahuse this
is NOT a mysqld issue
I've already established that the is
Quoting walter harms :
restart it with the same parameter on the command line and see what happens
the server support a verbos option (never used) perhaps it will tell
you more.
I can start mysqld direct from the command line and reproduce the
problem. I checked and it seems the verbose
Quoting walter harms :
I still do not see why it is restarting ... there must be something
watching is disappear.
Just to be sure, you do from a remote host: mysql -hHOST -ume -e
"show tables" ?
long shot: Do you have LDAP, NIS or so enabled ?
Ok so made a script as you suggested, and it
Quoting Reindl Harald :
Odd that, so I added a mysql specific line to the hosts.allow
who is using hosts.allow for protection instead a firewall in front
of the machine
or iptables (linux) / ipf (bsd)?
Its used for denyhosts as I mentioned.
As I said I can get it to restart just by doing
Quoting walter harms :
What i found odd that your mysqld actualy restarts.
Do you have it in some runlevel ? if yes stop and see
what happens.
If this does not work simple move the mysqld out of he way
and replace it with a script like
#!/bin/sh
echo "mysqld ..." | logger -t TEST
see what ha
Ok, this is pretty odd but I have found the problem.
Today I have repointed all applications to a different DB server, so I
have been free to do any testing on the problem server.
I started by dropping the databases one by one, dropped em all and the
issue persisted.
I stopped crond, even t
This was me restarting MySQL as was requested by Suresh...
Quoting "Singer X.J. Wang" :
This doesn't look like a MySQL issue. Verify that there's no rogue scripts
that shutdowns MySQL...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
No need for that really is there? I posted what was requested.
The part for the shutdown:
110909 17:27:31 InnoDB: Starting shutdown...
110909 17:27:32 InnoDB: Shutdown completed; log sequence number 1589339
110909 17:27:32 [Note] /usr/local/libexec/mysqld: Shutdown complete
110909 17:27:32 mys
Yep, but its basically identical to the info in the logs when its
restarting itself. I have upgraded to MySQL 5.5 as of yesterday, so
the error info differs due to the version now. Here is the log output:
110909 17:27:35 mysqld_safe Starting mysqld daemon with databases from
/var/db/mysql
Hi,
that really is the complete error log, that exact same info gets
repeated over and over, there is zero in the syslog and I get this
behaviour when running with no my.cnf (I do obviously have one but I
tried without and it I still see the prob, so that probably makes
things easier fr
Hi,
as of yesterday the MySQL Daemons keep restarting every 7 mins or
so on one of my FreeBSD servers. The only work carried out recently
related to MySQL on this server was to temporarily disable replication
(its a slave) of one DB, and then re-enable it (via restore of data
and updati
Quoting supr_star :
Is there any way to speed up this process? by disabling indexes or
something? I can't afford to be down for 3 more days...
First stop, the mysql documentation:
http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html
--
MySQL General Mailing List
For list archives
PS and put back the two log files you moved.
PPS if you don't have any space currently to do what I suggested then
at least softlink the log files from /tmp to their original locations.
Quoting a.sm...@ukgrid.net:
Quoting supr_star :
This db is on its own partition, so I can't delete logs o
Quoting supr_star :
This db is on its own partition, so I can't delete logs or anything
else to clear up space. So I moved ib_logfile0 and ib_logfile1
This is a really bad idea as will break all ur InnoDB databases. Do
you have space elsewhere on other partitions on the server? If yes
mo
Quoting Angelo Vargas :
I keep getting this error when we get spikes in traffic.
Even though max connections is set to 4096 and file limits are raised, mysql
still gives this error.
Is there a setting I should be looking for that will allow me to raise
whatever causes this error?
Could be t
Quoting Yoshio :
I found the ibdata and logfiles, but outside from my database dir.
so basically I need copy everything in /var/lib/mysql/* ?
Yeah that's normal, they will be in the top level of your MySQL
datadir. Yep, copy everything. As I said, if you have any MyISAM only
databases t
Quoting Yoshio :
I can use mysqldump but its take many hours to complete a restore. I
can stop the server, so i'm think in a physical copy of the database.
But I have not found the innodb files. Where are that files?
InnoDB is a bit tricky, without going into details (I couldn't
reliably d
Hi,
if you want to copy from one server to another can't you just use
"mysqldump? This is then restored via the "mysql" command using a pipe
or STDIN redirection. If you can shutdown the database for the
duration of the copy then you can do cold backup of all data files.
Both options wi
Quoting Machiel Richards :
We need to be able to delete all data from the 2 tables that is
older than the start of yesterday.
Hi,
I use this ver simple script to purge data from a syslog DB:
#!/usr/local/bin/bash
/usr/local/bin/mysql -u syslog -pmypasswd -e 'DELETE FROM Syst
Hi,
there is a lot of info on different backup methods here:
http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html
For example, for incremental backups see "Making Incremental Backups
by Enabling the Binary Log",
cheers Andy.
--
MySQL General Mailing List
For list archives: http:
Check the manual? Its here under ignore-table
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
Quoting Adarsh Sharma :
Dear all,
I am researching about different parameters provided by the
*mysqldump* utility.
It provides a method to dump databases with all tables.
My problem is I w
Hi,
so yes you can do that, but then I guess you cannot set the server
hosting database A as readonly (from memory this can only be set
server wide, but worht checking it out). Which might leave you a few
options to ensure data integrity, for example simply by user security
either by di
Hi,
I think you are wrong, slaves will always accept writes unless you
set readonly in the mysql config.
Due to this, and if you dont specifically set readonly on the slave
you have to be very careful in order to maintain data integrity on the
slave and also not to break repliacton. Tools
Quoting Machiel Richards :
The question I have however is how do you fail over to the slave
server in the event that the master server is unavailable and then how
to revert back to the master server once the server is available again.
Hi,
to fail over to the slave, you dont need t
Quoting Tompkins Neil :
The problem is I don't have any command line access, just direct MySQL
access to the database tables.
I dont know xtra backup, but if thats not an option you can just use
mysqldump. This can be run from a remote server to your DB server,
just using MySQL network ac
This is in the GA (free) release and has been for many years I believe...
Quoting Machiel Richards :
Hi Guys
Can someone please confirm whether replication / standby
functionality is available on the GA release of MySQL or this an
Enterprise specific functionality?
Regards
Machiel
Quoting Johan De Meersman :
Your raid controller is "lying" to you - you can't have RAID10 with just two
disks :-p Don't worry about that, though - it's a good enough config.
Good enough? If he is genuinely saturating the disk with IO (as he
states the problem is IO) then it isnt good enoug
Quoting vokern :
Two disks with SAS driver, 15K rpm.
Ok so you have fast disks, but with only 2 disks it is normal you will
be quite restricted by DISK IO. By adding more in multiples of 2 and
stripping across all you achieve RAID1+0 and higher max IO...
Andy.
--
MySQL General Mail
Quoting vokern :
The disk is exactly Raid10.
The CPU is two 2.5G*4, totally 16G memory.
And how many disks do you have, and what type (SATA/SAS/FC etc) what
RPM? To improve IO you can add more disks, or upgrade to faster disks.
--
MySQL General Mailing List
For list archives: http://l
If its an IO problem the first and easiest thing to do is (probably)
look at your disk subsystem. You can easily achieve higher disk IO by
increasing the number of disks and implementing something like
RAID1+0. What is your current disk configuration?
Andy.
--
MySQL General Mailing Li
That entirely depends on your requirement, if you need it to be
accessible with the same username and password, then configure it with
the same username and password.
thanks Andy.
Quoting Uwe Brauer :
On Mon, 20 Sep 2010 12:14:06 +0200, Johan De Meersman
wrote:
> He did suggest doin
Why not use the mysql tool, mysqlcheck:
http://dev.mysql.com/doc/refman/5.1/en/mysqlcheck.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Quoting Jangita :
Simply put: I want a solution that ensures that server 2 has all the
data at server 1 at any point in time; say server 1 suddenly fell
into a pond :) . I wouldnt want to open server 2 and find the last
insert/update/delete missing...
Ok so that rules out any asynchro
Clustering is a general term, do you know which one you are comparing
with replication? Clustering most typically refers to high
availability clustering or high performance clustering, which wouldnt
necessarily/normally imply any copy of the actual data.
If you want a copy of your data on a
Quoting jitendra ranjan :
Hi,
The best way to use sync the master and slave is using mk-checksum
tools. just google it and use the the tools for online sync of
master and slave.
Jeetendra Ranjan
MySQL DBA
Yes, data integrity isnt guaranteed with MySQL replication. So if you
want to b
Quoting Ananda Kumar :
Smith,
I never said, this wont work.Some times, there are chances of lossing data.
regards
anandkl
If you have experience of this fair enough. Theres no reason it should
make any difference, as everything is based upon the binlog file and
position...
--
MySQL
Quoting Norman Khine :
i see, so the best is to just stop slave and then check the master
status, and when the master status syncs then i start the slave?
Well Im willing to hear from others experiences, but if you really
shouldnt have to do anything. If you want you can issue a stop slav
That is really bad, you will loose changes.
You shouldnt have to do anything when rebooting either the master or
slave. If the master is down, then the slave recieves no updates. If
the slave is down, when it comes back up it checks the master log pos
and plays thro any changes that are nec
Run something like Solaris zones, or FreeBSD jails? Then u can have
multiple masters...
Quoting Nunzio Daveri :
Hello Gurus, I have a customer who wants to create a reporting server for his
management team. He wants to take server 1,2,3 and move the 3 databases from
all 3 servers to one serv
Quoting Norman Khine :
What is shown from "show master status" and "show slave status" after you
have made a change on the master DB?
this is the output:
http://pastie.org/1100610
it does not seem to have any changes and "show slave status" is just empty.
have i missed to add something to
Quoting Norman Khine :
hello,
i have an issue with the replication here is my procedure:
http://pastie.org/1100368
in the log it shows replication works, but when i update a record this
is not updated on the server.
What is shown from "show master status" and "show slave status" after
you
According to this you must install OpenSSL then compile MySQL from source
http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html
Would be nice if someone on the list with prior experience would comment
Quoting Tompkins Neil :
Hi
I found this documentation. However, I need more in
Google?
http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-ssl.html
This is for MySQL 5.1, I imagine its probably the same in 5.1 but
another little google should be able to confirm that for you
Quoting Tompkins Neil :
Hi,
We are running Ubuntu 10.04 LTS with MySQL 5.1.46 and
this built in command is probably a good start:
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Quoting Johan De Meersman :
On Wed, May 26, 2010 at 10:20 AM, wrote:
If you are trying to restore from backup.sql to a database called soure
then your syntax is wrong. You should be running:
mysql source < backup.sql
You are assuming that the file named "backup.sql" contains a backup of t
Quoting Sydney Puente :
Hello,
I have a mysqldump file created by AutoMySQLBackup.
And it hangs when I do a
mysql > source backup.sql
If you are trying to restore from backup.sql to a database called
soure then your syntax is wrong. You should be running:
mysql source < backup.sql
Assumi
I have been looking at MySQL with the assumption that I could move up to
an enterprise level database from a desktop database without the
prodigious cost normally incurred. I usually work for small business's
and my choice of database has been Paradox. I have been using Delphi as
a front end too
51 matches
Mail list logo