* nm > Is it possible to MERGE innodb tables? No, MERGE is for MyIsam tables only. InnoDb tables are stored in tablespaces, the problem with file size does not apply. You simply use multiple tablespaces when the data outgrows the OS limits.
> Can't find docs on mysql.com hm... mysql.com seems to be down right now... try this: <URL: http://darkstar.ist.utl.pt/mysql/doc/en/ > <URL: http://darkstar.ist.utl.pt/mysql/doc/en/Table_types.html > <URL: http://darkstar.ist.utl.pt/mysql/doc/en/MERGE.html > <URL: http://darkstar.ist.utl.pt/mysql/doc/en/InnoDB.html > > In replication. I guess I can update the slave if the master is not > responding, right? Replication can be done in several ways, for instance, both your servers could be masters/slaves for eachother. Read about replication here: <URL: http://darkstar.ist.utl.pt/mysql/doc/en/Replication.html > > Shall I 'stop slave' before , in case the > master is down? I don't understand this question, sorry! :) > Also will this create problems when the master comes back and the slave > copies updates from the master log file? Hopefully not. I have never used replication in mysql, but I have seen some people with problems on this list. My impression is that there are rearly bugs in the replication code, but it is a bit complex to deal with the setup and recovery after crashes. You should read the manual carefully. > application/web server > | | > | | > master -- slave > > This way I would write master and read on slave as default. That is a common and sensible solution. > But I would like > to use slave as mater automatically if the first server is down. This would be implemented in your middle layer application/web application. This example is python code: try: wconn = connect(primary_write_host) except: admin_warning("primary_write_host is down!") try: wconn = connect(secondary_write_host) except: admin_alert("site is down!") fail("Sorry, database servers are down!") try: rconn = connect(primary_read_host) except: admin_warning("primary_read_host is down!") try: rconn = connect(secondary_read_host) except: admin_alert("site is down!") fail("Sorry, database servers are down!") (The admin_warning()/admin_alert() functions are flood-protected, so you won't get one email/SMS per user click... ;)) > Also I would use a few innodb tables. You can combine MyIsam and InnoDb tables in the same database. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
