could start small and get bigger latter, maybe some sponsors could help, mariadb have a big name now, mysql got smaller in name (ok oracle is big, but many guys replace mysql with mariadb and don't want to get back) in Brazil internet link is small near 100kb/s for upload, so a small hardware of 70mb/s (a single sata hd) works for 700users without problem, the problem is the internet link well just an idea, start with some users without 100% of online status (95% is easy for a simple pc + internet link) for a small company there's many 'small solutions' starting from 100USD/month with cheap hardware and not professional employes if we could get about 1000users = 100k/month, it's a good start, just a number... i'm sure many small company want this, and they normally don't have a biiiig database, just some sales systems about 100mb/user 2013/4/19 Jeremy Cole <jeremycole@google.com>
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 <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 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
_______________________________________________ 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
-- Roberto Spadim SPAEmpresarial