Is there oracle to mysql replication software?
Greetings, We have an oracle database that we would like to explore using it as a "master" database in order to replicate it's data into, in real or near real time (like MySQL's replication), a set of MySQL servers. We need only one way replication (oracle -> MySQL), but the replication needs to happen "continously", and automatically i.e. no batch load's. We're especially concerned about replicationg any deletes that occur on the oracle side. Free (libre) software is always preferred, but we are willing to look at everything at this point. Thanks, Jeff Adams Webmaster Hoover's Online - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slow replication question/problem
Jeremy Zawodny wrote: < snip > > > Are subsequent inserts just as slow to replicate? > > Can you show us the output of SHOW SLAVE STATUS and maybe the my.cnf > files of the master and a slow slave? > > Jeremy > Thanks for the response. Below is the info you requested. If there's anything else that might be of help, please let me know and I'll do my best to provide it. I'm pretty sure most, if not all subsequent inserts are slow, although it might be true that if we did a number of inserts at the same time that they may inserted on the slaves together. We have not tried this at this point in time. The slave status looks like: --- | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos| Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | | p23.hoovers.com | repl | 3306 | 60 | p23-bin.004 | 931831 | Yes | portlets | hoovers | 0 | | 0 | --- The Master status gives: --- | File| Position | Binlog_do_db | Binlog_ignore_db | +-+--+--+--+ | p23-bin.004 | 1004808 | portlets | hoovers | --- The Master my.cnf (comments removed): ---[mysqld] skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=16M set-variable= table_cache=512 set-variable= sort_buffer=6M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=128M set-variable= thread_cache_size=4 set-variable= thread_concurrency=4 # Try number of CPU's*2 set-variable= tmp_table_size=4M set-variable= net_read_timeout=300 set-variable= net_write_timeout=300 # Replication log-bin server-id=1 binlog-do-db=portlets binlog-ignore-db=hoovers [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M --- Slave my.cnf (comments removed): --- [mysqld] skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=16M set-variable= table_cache=512 set-variable= sort_buffer=5M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=128M set-variable= thread_cache_size=4 set-variable= thread_concurrency=4 # Try number of CPU's*2 set-variable= tmp_table_size=3M set-variable= net_read_timeout=300 set-variable= net_write_timeout=300 set-variable= max_connections=500 log-update # Replication master-host=p23.hoovers.com master-user=repl master-password= master-port=3306 server-id=2 replicate-do-db=portlets replicate-ignore-db=hoovers log-slave-updates log-bin [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M --- Thanks again, - Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Missing libmysqlclient.so.6
Try updating your /etc/ld.so.conf file to include the path to the libmysqlclient.so.6 library, and re-run ldconfig. - Jeff Webmaster wrote: > Hi: > > How I can install or copy mysqlclient.so.6 without reinstall?? > > I'm trying to execute PHP script (Phorummail) from shell, but I receive that > this lib is > missing. > > [root@corotu docs]# ./phorummail > >>>php: error in loading shared libraries: libmysqlclient.so.6: cannot open >>> > shared > >>>object file: No such file or directory >>> > > > I have MySQL 3.27.23, PHP 4.0.6 and Red Hat Linux 6.0 > > Thanks for your help. > > Peter Brumvig > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slow replication question/problem
Greetings, This morning we sucessfully inserted a new record on our master MySQL machine. 4 1/2 hours later, the change showed up on the slaves. I was under the impression that MySQl replication would occur in a more timely fashion. We have a single master with 4 slaves replicating only one of our databases using MySQL v. 3.23.41 compiled from source on both the master and the slaves. There are no obvious (to me) errors in the error log or the binlog. The master is a dual 1Ghz PIII w/ 2GB RAM. The slaves consist of both dual 800Mhz PIII's w/ 2GB of RAM and quad 450MHZ Ultrasparc II's w/ 4GB RAM. Everything resides on a 100Mbit switched LAN. (Since we're still working the bugs out of the setup these systems have no real load). I'm not really sure where to start looking, so please let me know if there's anything I can provide that would shed some light on this. Thanks, Jeff Adams Webmaster Hoover's Online - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication stalls
Greetings,
We're having some problems with our one way replication "stalling".
There are no errors in the errors logs, and the status reports seem to
indicate things are still running, however, changes to the master are
not being received by our slaves.
We're running a farm of 4 slave mysql machines (MySQL version 3.23.41)
that talk to a single master (also version 3.23.41) machine. We're
running two databases on the machines (I'll call them db1 and db2), but
I only wish to replicate one of them (db2).
I've sync'd the databases, and turned on replication, and everything
works great until we load data into _db1_ via the 'load data infile'
command.
At that point, any further changes to db2 are not replicated to the
slave machines.
Running 'show processlist' at that point, on any of the slaves, gives
the following:
| 1294 | system user | none | NULL | Connect | 5233 | Reading master
update | NULL
Running 'show slave status' gives:
| master | user | 3306 | 60 | p23-bin.004 | 380 | Yes | db2 | db1
| 0 | | 0 |
Running 'show processlist' on the master reveals:
| 4 | repl | 10.1.1.108 | NULL | Binlog Dump | 2666 | Reading from net
| NULL
Running 'show master status' on the master gives:
| p23-bin.004 | 11283 | db2 | db1 |
If I run 'mysqlbinlog -j 380 p23-bin.004 |head' on master I get:
# at 380
#010830 15:39:21 server id 1 Query thread_id=32exec_time=0
error_code=0
use db1;
SET TIMESTAMP=999203961;replace into time_last_updated (time,table_name)
values ('2001-08-30 15:24:16','person_function');
If I issue 'slave stop' and 'slave start' on a slave, it syncs up to the
master, and will continue replicating until db1 is updated. Restarting
the master will also allow all of the slaves to sync up.
Here's the mysqld section of my.cnf from the master:
[mysqld]
#port= 3306
#socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=384M
set-variable= max_allowed_packet=16M
set-variable= table_cache=512
set-variable= sort_buffer=6M
set-variable= record_buffer=1M
set-variable= myisam_sort_buffer_size=128M
set-variable= thread_cache_size=4
set-variable= thread_concurrency=4 # Try number of CPU's*2
set-variable= tmp_table_size=4M
set-variable= net_read_timeout=300
set-variable= net_write_timeout=300
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=64M
# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
# Replication
log-bin
server-id=1
binlog-do-db=db2
binlog-ignore-db=db1
And from the slaves:
[mysqld]
#port= 3306
#socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=384M
set-variable= max_allowed_packet=16M
set-variable= table_cache=512
set-variable= sort_buffer=5M
set-variable= record_buffer=1M
set-variable= myisam_sort_buffer_size=128M
set-variable= thread_cache_size=4
set-variable= thread_concurrency=4 # Try number of CPU's*2
set-variable= tmp_table_size=3M
set-variable= net_read_timeout=300
set-variable= net_write_timeout=300
set-variable= max_connections=500
log-update
# Replication
master-host=master
master-user=user
master-password=password
master-port=3306
server-id=3
replicate-do-db=db2
replicate-ignore-db=db1
log-slave-updates
#log-bin
If anyone could shed some light on this is happening, and more
importantly, how we can keep the replication going, or if you need any
other information, please let me know.
Thanks,
Jeff Adams
Webmaster
Hoover's Online
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
