On Wed, 2003-12-31 at 03:41, Robert Mena wrote: > Hi, > > I am currently using the replication function of my > mysql server (3.23.58) to replicate one database. > > Since I host others I'd like to know if there is a way > to automatically replicate a database. I.e as soon as > a use issues a mysqladmin create it is propagated to > the slaves. > > Any tips ? >
Hi Robert About replication, my friend has a little tricky solution: using crond. It's just like ordinary replication. The difference is you don't have to type the commands manually. Instead, you schedule it by crond. You can schedule it any time you wish. Another solution I know is using EAC (Emic Application Cluster) for MySQL. I don't know much about this, 'coz I'm still learning about it. Using EAC, you can have several MySQL servers which appear as a single server to your client. Those servers are guaranteed to have exactly the same contents. From the documentation, it is said that when there is a query that change the content of a server, the query then propagated to all servers. So, may be that's what you are looking for? But I have a good and a bad news for you, Robert. The bad news is: EAC is not free! It is a commercial software. The good news: they provide evaluation version for 6 months. :) Just open their website: http://www.emicnetworks.com/ That's all I know. May be somebody in this list can give better solutions? Regards, Ariyo Nugroho ------------- Platform & Collaboration Group eBdesk Ltd., Indonesia http://www.ebdesk.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
