Is it possible to MERGE innodb tables? Can't find docs on mysql.com
In replication. I guess I can update the slave if the master is not responding, right? Shall I 'stop slave' before , in case the master is down? Also will this create problems when the master comes back and the slave copies updates from the master log file? application/web server | | | | master -- slave This way I would write master and read on slave as default. But I would like to use slave as mater automatically if the first server is down. Also I would use a few innodb tables. Thanks. |-----Original Message----- |From: Roger Baklund [mailto:[EMAIL PROTECTED] |Sent: Tuesday, August 05, 2003 6:25 PM |To: [EMAIL PROTECTED] |Cc: NEWMEDIAPLAN |Subject: Re: table size in mysql | | |* NEWMEDIAPLAN |> how many records can i put in a mysql table. | |As many as you like, pretty much. The total file size could be delimited by |your OS, but this can be dealt with using MERGE tables (splitting a single |table in multiple files) or InnoDB tables (with multiple table spaces). | |> i need a table with more than |> 50,000,000 records (just 4 short fields, it's basically a log with |> id,action,date,result). What do you think? | |Should not be a problem. | |-- |Roger | | |-- |MySQL General Mailing List |For list archives: http://lists.mysql.com/mysql |To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
