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 <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>
Hi!
> "Roberto" == Roberto Spadim <roberto@spadim.com.br> 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