maria-developers team mailing list archive

[Jeremy Cole <jeremycole@xxxxxxxxxx>]

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@xxxxxxxxxxxxx>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@xxxxxxxxxxxxx>
>
>> 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@xxxxxxxxxxxx>
>>
>>>
>>> Hi!
>>>
>>> >>>>> "Roberto" == Roberto Spadim <roberto@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp
>
>