maria-developers team mailing list archive
Mailing list archive
Re: User question
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
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@xxxxxxxxxx>
> 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.
> 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
>>> 2013/4/19 Michael Widenius <monty@xxxxxxxxxxxx>
>>>> >>>>> "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
>>>> 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.
>>> Roberto Spadim
>> Roberto Spadim
>> 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