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