maria-discuss team mailing list archive
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.
> 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