Roberto, Leaving aside any technical issues for how it would work or if it would even work...
Do be aware that there's a huge difference between a company doing *development* and doing *operations*. Supporting something like this would be a tremendous burden and very expensive, and it's definitely not something that would break even without at least thousands of users. Regards, Jeremy On Fri, Apr 19, 2013 at 2:37 PM, Roberto Spadim <[email protected]>wrote: > just some ideas... > we could develop it as a native feature of mariadb... think about... > > the user install the database and start works... in some day a guy tell > about disaster recovery, the user don't know about it (disaster recovery) > but know that the data isn't safe in only one machine without backups, > he/she just need one single command to make it safer... > > REPLICATE TO CLOUD DATABASES ('A','B','C','D','E') > SHOW CLOUD KEY / SHOW CLOUD STATUS > > the database connect to mariadb, create a unique server-id (key) and > 'prepare' replication of data =) > the user get the unique server-id (key), create an acount at mariadb > website and really start replication put a password (for restore operation) > and pay a tax for the service (maybe per size of data + size of internet > transfers + fixed tax per database)/mounth, something like mac do with > iphone,ipad,and others i*, or gmail for enterprise, > > in some day, the database A,C,D crashed or server is broken and user want > the data back > RESTORE FROM CLOUD DATABASE ('A','C','D') TO DATABASES ('X','Y','Z') > UNIQUE ID 'ABCDEFGG' PASSKEY='XYZ...' > SHOW RESTORE STATUS > > or, connect into mariadb cloud like a single mysql user > > mysql www.mariadb.org --user=databasekey --password=password > > SHOW DATABASES; > SHOW TABLES; > SELECT * FROM TABLE xxxx; > SHOW CLOUD STATUS; (here we could show servers replicating to CLOUD, and > servers restoring from CLOUD) > > in this case insert/update/delete and queries different from select * from > table xxxx [limit] are not allowed > > =] like a single replication solution, but 'automatic' to user > > nice idea? costly? maybe in the start... but it's a very very nice > solution right?! mariadb need money =) it's an easy solution to get money =D > i prefer running REPLICATE TO CLOUD xxxx command than understand amazon > manual, or other think like it... > maybe we could put it in a plugin? just some ideas =) > > bye guys > > > 2013/4/19 Roberto Spadim <[email protected]> > >> guys, anyone know about a public or private replication service for >> mysql/mariadb? i know the amazon a-z, there's anothers? maybe we could >> receive money creating a service like this in mariadb.org, what you >> think? >> >> >> >> 2013/4/19 Michael Widenius <[email protected]> >> >>> >>> Hi! >>> >>> >>>>> "Roberto" == Roberto Spadim <[email protected]> writes: >>> >>> Roberto> other doubt, i will have about 256 masters >>> Roberto> how could i change limit of masters? in multi-source >>> replication page of >>> Roberto> mariadb it says: >>> Roberto> You can for now only have 64 masters (trivial to increase if >>> necessary). >>> Roberto> https://kb.askmonty.org/en/multi-source-replication/ >>> >>> One can fix this by just increasing the value of >>> MAX_REPLICATION_THREAD and recompile. >>> >>> The only known problem with 256 masters is that this will require 512 >>> threads to be created to handle this. >>> >>> If the current limit is too small for a group of people then we will >>> of course increase it. >>> >>> Regards, >>> Monty >>> >> >> >> >> -- >> Roberto Spadim >> SPAEmpresarial >> > > > > -- > Roberto Spadim > SPAEmpresarial > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-developers > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-developers > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
