← Back to team overview

maria-discuss team mailing list archive

Re: Parallel Databases and network security


On Mon, Jan 15, 2018 at 08:55:44PM +0100, Sergei Golubchik wrote:
> Hi, Ruben!
> On Jan 12, Ruben Safir wrote:
> > Is there a way to hot copy a database from one machine to another and
> > restrict network access to only between those two machines without using
> > a firewall?
> Hot copy? mariabackup, for example.

I think I want a hot copy.  For years I've run my custom mailing list
set up on mysql on the local box with apache.  I migrated resently to a
new box and new OS (artix with openrc).  I wrote the new init scripts
but I decided to seperate the mailing list, and the database from the 
webserver.  And I closed down IP coonections, just because I got sick
of the port being hammered.

Now, I had two choices, to change the software to talk across the 
open local area network, and move the database to the webserver...
or hot copy, which I know maria has been able to do for a while, but I
never implimented it.  But i want to do this and restrict connections to
the internal network.  It is easy enough to justblock the external ports
but I would rather do this through the database.
> Restrict network access? Specify the correct peer ip address or a host
> name when creating a user.
> Regards,
> Sergei
> Chief Architect MariaDB
> and security@xxxxxxxxxxx

So many immigrant groups have swept through our town
that Brooklyn, like Atlantis, reaches mythological
proportions in the mind of the world - RI Safir 1998

DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002
http://www.nylxs.com - Leadership Development in Free Software
http://www2.mrbrklyn.com/resources - Unpublished Archive 
http://www.coinhangout.com - coins!

Being so tracked is for FARM ANIMALS and and extermination camps, 
but incompatible with living as a free human being. -RI Safir 2013

Follow ups