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,JeremyOn Fri, Apr 19, 2013 at 2:37 PM, Roberto Spadim <roberto@spadim.com.br> 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 STATUSthe 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 backRESTORE FROM CLOUD DATABASE ('A','C','D') TO DATABASES ('X','Y','Z') UNIQUE ID 'ABCDEFGG' PASSKEY='XYZ...'SHOW RESTORE STATUSor, connect into mariadb cloud like a single mysql usermysql 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 usernice 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 =Di 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 <roberto@spadim.com.br>
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 <monty@askmonty.org>
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
SPAEmpresarialRoberto Spadim
SPAEmpresarial_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp