maria-developers team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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