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@gmail.com> 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@cs.stanford.edu> 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@au1.ibm.com> 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@cs.stanford.edu
> <mailto:jde@cs.stanford.edu>> 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp




--
Mark Callaghan
mdcallag@gmail.com