Re: limit of record in table Myisam
i was asking for things like these.. look for the thread with this subject: "mysql and limitations and hardware features support" for aswer to particular question read this: http://dev.mysql.com/doc/mysql/en/table-size.html regards d2clon Arcangelo Casavola wrote: Hi, i've MySQL 4.0.18 and 1 table type Myisam with many record (1.900.000) Is there a limit of number of record for this table? thank's Arcangelo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: load balancer and cluster
thanks gary: of course this is the perfect solution, and it will be a very good open source project, but: how is it posible that the mysql team has not implemented this proxy solution all ready? i am not a lazy guy, of course if a need to implement this i will do, but i prefer a mysql's solution becouse i want the mysql's products guaranty. thanks fernando (aka d2clon) Gary Richardson wrote: What about writing a proxy server for each of your application nodes? It probably wouldn't be hard to "fake" the mysql protocol and proxy to an active server.. You could have a listener on each of your application nodes bound to port 3306. On 6/27/05, d2clon <[EMAIL PROTECTED]> wrote: thanks for the reply. but this solution its imposible because my applications are done allready, or perhaps the applications are not mine. i need a transparent balancer, and i dont anderstand how is possible thet it does not exists. grettings d2clon Gary Richardson wrote: You're probably best to implement it as a layer in your application. You could put a layer around DBI (or whatever programming API you're using) to retry the query on another node if it fails. On 6/23/05, d2clon <[EMAIL PROTECTED]> wrote: (sorry for my english) hello people: i want to answer if do exists any mysql solution that implements load balancer and redundancy between 'application layer' and 'mysqld layer' i will try to explain me: i want to implement a completed mysql cluster system, and the documentation is very good, but i see a problem: we need to look the picture in this page: http://dev.mysql.com/doc/mysql/en/mysql-cluster-overview.html in this picture we can see that the 'storage layer' implements correctly redundance and load balancer feature, because the 'SQL layer' ask for data to a 'storage layer' but not to a one particular node. but the applications in the 'application layer' do the petitions to the 'SQL layer' directly to a particular node, and them: what happen if a node in the 'SQL layer' is off? how i can offer a load balancer feature between 'application layer' and 'SQL layer'. i searched a lot on the web but i only founded out answers but not solutions.. i also see this thread in this mail list: http://lists.mysql.com/search.php?q=load+balancer&list=&m=a&begin=60 but i did not found an answer in this thread. any help? thanks a lot fernando guillen (aka d2clon) -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: load balancer and cluster
thanks for the reply. but this solution its imposible because my applications are done allready, or perhaps the applications are not mine. i need a transparent balancer, and i dont anderstand how is possible thet it does not exists. grettings d2clon Gary Richardson wrote: You're probably best to implement it as a layer in your application. You could put a layer around DBI (or whatever programming API you're using) to retry the query on another node if it fails. On 6/23/05, d2clon <[EMAIL PROTECTED]> wrote: (sorry for my english) hello people: i want to answer if do exists any mysql solution that implements load balancer and redundancy between 'application layer' and 'mysqld layer' i will try to explain me: i want to implement a completed mysql cluster system, and the documentation is very good, but i see a problem: we need to look the picture in this page: http://dev.mysql.com/doc/mysql/en/mysql-cluster-overview.html in this picture we can see that the 'storage layer' implements correctly redundance and load balancer feature, because the 'SQL layer' ask for data to a 'storage layer' but not to a one particular node. but the applications in the 'application layer' do the petitions to the 'SQL layer' directly to a particular node, and them: what happen if a node in the 'SQL layer' is off? how i can offer a load balancer feature between 'application layer' and 'SQL layer'. i searched a lot on the web but i only founded out answers but not solutions.. i also see this thread in this mail list: http://lists.mysql.com/search.php?q=load+balancer&list=&m=a&begin=60 but i did not found an answer in this thread. any help? thanks a lot fernando guillen (aka d2clon) -- 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]
mysql and limitations and hardware features support
hello people: im very interested about the limitations and hardware features support. for example: software limitation: how much rows does a table can to have? how much size of a database does mysql support? ... hardware features support: has mysql multi-processor support? how much processors? how is the size maximum of the RAM that mysql support? ... any url? thanks a lot d2clon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
load balancer and cluster
(sorry for my english) hello people: i want to answer if do exists any mysql solution that implements load balancer and redundancy between 'application layer' and 'mysqld layer' i will try to explain me: i want to implement a completed mysql cluster system, and the documentation is very good, but i see a problem: we need to look the picture in this page: http://dev.mysql.com/doc/mysql/en/mysql-cluster-overview.html in this picture we can see that the 'storage layer' implements correctly redundance and load balancer feature, because the 'SQL layer' ask for data to a 'storage layer' but not to a one particular node. but the applications in the 'application layer' do the petitions to the 'SQL layer' directly to a particular node, and them: what happen if a node in the 'SQL layer' is off? how i can offer a load balancer feature between 'application layer' and 'SQL layer'. i searched a lot on the web but i only founded out answers but not solutions.. i also see this thread in this mail list: http://lists.mysql.com/search.php?q=load+balancer&list=&m=a&begin=60 but i did not found an answer in this thread. any help? thanks a lot fernando guillen (aka d2clon) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]