maria-discuss team mailing list archive

[Jonathan Ellithorpe <jde@xxxxxxxxxxxxxxx>]

Hehe, yes, I took the shotgun approach. The MySQL lists don't seem to be
quite as active, and the MySQL forum moderators seem to take about 1-2 days
before they approve my posts.

Hmm... thanks for pointing that out about system metadata caching. I'll
have the solve the problem of MariaDB thinking something exists
(table/index/...) when it doesn't, or thinking that something doesn't exist
when it does....

Thanks for your help!

Jonathan

On Wed, Jul 20, 2016 at 1:21 PM MARK CALLAGHAN <mdcallag@xxxxxxxxx> wrote:

> This discussion is much more interesting than the one on the quiet MySQL
> lists. I assume you need to worry about the top half caching dictionary
> information about indexes & tables.
>
> On Wed, Jul 20, 2016 at 12:50 PM, Jonathan Ellithorpe <jde@xxxxxxxxxxxxxxx
> > wrote:
>
>> I see... so the MariaDB top-half (by "top-half" I mean everything that
>> sits above the storage engine) doesn't do nasty things like caching? If it
>> did, then writes at other MariaDB sites wouldn't show up in reads performed
>> at the site caching the data.
>>
>> If the MariaDB top-half does nothing more than essentially translate user
>> operations / queries into calls on the SE, then in theory nothing special
>> must be done to deploy MariaDB at multiple sites accessing a shared storage
>> engine.
>>
>> Jonathan
>>
>> On Tue, Jul 19, 2016 at 10:20 PM Daniel Black <daniel.black@xxxxxxxxxxx>
>> wrote:
>>
>>>
>>>
>>>
>>>
>>> On 20/07/16 14:31, Jonathan Ellithorpe wrote:
>>> > Follow-up: I see in the blog pointed to by Daniel mentioned an SE for
>>> > Cassandra.... so I take it the answer is yes? Does anyone have
>>> > experience with this / know if anything "extra" must be done to make
>>> > that work?
>>>
>>> It falls to the responsibility of the storage engine to ensure that the
>>> ACID guarantees are implemented.
>>>
>>> > Jonathan
>>> >
>>> > On Tue, Jul 19, 2016 at 9:23 PM Jonathan Ellithorpe <
>>> jde@xxxxxxxxxxxxxxx
>>> > <mailto:jde@xxxxxxxxxxxxxxx>> wrote:
>>> >
>>> >     Thanks for the references! That helps a lot
>>> >
>>> >     One other question I have is: can MariaDB work in a distributed
>>> >     fashion? To be more clear, the storage backend I'm developing is
>>> >     distributed, like Cassandra, and I would like to deploy many
>>> MariaDB
>>> >     instances that all access the same storage cluster. Can this be
>>> done?
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~maria-discuss
>>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~maria-discuss
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Mark Callaghan
> mdcallag@xxxxxxxxx
>