can i replicating innodb table?

2005-10-20 Thread Hiu Yen Onn
can i replicating innoble tables? does the master db and the slave db will having the same of information when they are doing replication? thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql on raid 1 or raid 5?

2005-10-20 Thread Hiu Yen Onn
hi all, currently, i have a machine with raid 1 and raid 5 (backplane). in order to boost up the mysql performance, does it advise install /var/ (mysql data directory) into raid 1 or raid 5? please advise. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: default table type = innodb is stable??

2005-10-16 Thread Hiu Yen Onn
Is that stable if i started mysql server by defining default_table_type = INNODB at the my.cnf file? from which by default my.cnf is defining MYISAM table to be the defaulted. Richard Dale wrote: this is my error log file. InnoDB: Error: log file ./ib_logfile0 is of different size

mysql connectivity error

2005-10-16 Thread Hiu Yen Onn
hi all, i have a mysql which only localhost can be logged in. if i have created an account [EMAIL PROTECTED], then, i cant login in as that host. mysql -u user -h mymachine.com -p ERROR 2003 (HY000) Cant connect to the MySQL server on 'x.x.x.x' (111) please advise. thanks -- MySQL General

Re: default table type = innodb is stable??

2005-10-15 Thread Hiu Yen Onn
Jigal van Hemert wrote: - Original Message - From: Hiu Yen Onn [EMAIL PROTECTED] if i uncomment it, then mysql server wont start at all. if i comment it, then, that's ok. please advise. thanks again If the mysql server does not start it will probably leave a lot

default table type = innodb is stable??

2005-10-14 Thread Hiu Yen Onn
hi, i have a machine with 6G memory, loaded with RHEL4. now, my question is mysql support innodb as the default table type? will be stable running RHEL4? i saw /usr/share/mysql/my-innodb-heavy-4G.cnf file, then, i replace the existing one (/etc/my.cnf). but, it failed to start the mysql

Re: default table type = innodb is stable??

2005-10-14 Thread Hiu Yen Onn
for mysql? thanks again Ady Wicaksono wrote: Currently i have 4 Gbyte RAM and RH 9 Linux using InnoDB and yes, it's stable :) Hiu Yen Onn wrote: hi, i have a machine with 6G memory, loaded with RHEL4. now, my question is mysql support innodb as the default table type? will be stable

Re: default table type = innodb is stable??

2005-10-14 Thread Hiu Yen Onn
it, then, that's ok. please advise. thanks again Hiu Yen Onn wrote: Are you using the my-innodb-heavy-4G.cnf file for your machine? i loaded the cnf file to /etc/my.cnf. then, it fails to start. what's wrong with it? mind to tell me on how to set the default table type equal to innodb?perhaps

Newbie: MySQL cluster configuration

2004-12-20 Thread Hiu Yen Onn
have not noticed that file in my machine. weird pls give me more information and ideas.thanks -- Mr. Hiu Yen Onn System Administrator Shin Yang Group of companies Website: www.shinyang.com.my Email: [EMAIL PROTECTED] Tel: (6085)656699 ext.253

where is my my.cnf files??

2004-12-08 Thread Hiu Yen Onn
hi, i compiled mysql-4.1.7 from source. actually, i want to configure a mysql cluster. from the documentation, i need to add some flag into a file called my.cnf. i searched through the files. it consisted of my-small.cnf, my-medium.cnf, my-huge.cnf. but, i cant see the file my.cnf file. where

Re: mysql cluster installation

2004-12-07 Thread Hiu Yen Onn
Hiu Yen Onn wrote: hi, I wish to have clusters of MySQL. i installed it from RPM. version, 4.1.7. but, i cant get the ndbd command to start my NDB. do i really need to install from tarball?? i am really new to MySQL clustering. all this while, i am using MySQL standalone database. pls guide me

mysql cluster installation

2004-12-06 Thread Hiu Yen Onn
hi, I wish to have clusters of MySQL. i installed it from RPM. version, 4.1.7. but, i cant get the ndbd command to start my NDB. do i really need to install from tarball?? i am really new to MySQL clustering. all this while, i am using MySQL standalone database. pls guide me... i am willing to

archive data

2003-11-19 Thread Hiu Yen Onn
hi, i am using linux redhat 8 to power mysql. i installed mysql version 4.0.13 using rpm package. by default, the data file of mysql is alocated at /var/lib/mysql, but i have a limited of diskspace of /var dir (it is about 1G), so, it was easily full loaded with data. now, i want to archive the

Access my mysql db remotely...

2003-10-21 Thread Hiu Yen Onn
i want to create a user who access from internet remotely to my db (outside firewall)? what is the solution then? how can i define the user accoutn? [EMAIL PROTECTED] Cheers, yenonn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: