uncleflo
Registered since September 28th, 2017
Has a total of 4246 bookmarks.
Showing top Tags within 8 bookmarks
howto information development guide reference administration design website software solution service product online business uk tool company linux code server system application web list video marine create data experience description tutorial explanation technology build blog article learn world project boat download windows security lookup free performance javascript technical network control beautiful support london tools course file research purchase library programming image youtube example php construction html opensource quality install community computer profile feature power browser music platform mobile work user process database share manage hardware professional buy industry internet dance advice installation developer 3d search camera access customer travel material test standard review documentation css money engineering webdesign engine develop device photography digital api speed source program management phone discussion question event client story simple water marketing app yacht content setup package fast idea interface account communication cheap compare script study market easy live google resource operation startup monitor training
Tag selected: mariadb.
Looking up mariadb tag. Showing 8 results. Clear
How do I allow MySQL connections through SELinux? - Server Fault
Saved by uncleflo on July 11th, 2019.
I'd like to for once leave SELinux running on a server for the alleged increased security. I usually disable SELinux to get anything to work. How do I tell SELinux to allow MySQL connections? The most I've found in the documentation is this line from mysql.com: If you are running under Linux and Security-Enhanced Linux (SELinux) is enabled, make sure you have disabled SELinux protection for the mysqld process.
fedora permission firewall subscribe overflow answer solution question connection database access administration documentation apache server selinux linux howto infrastructure mysql mariadb
Working with Amazon Aurora Global Database - Amazon Aurora
Saved by uncleflo on June 23rd, 2019.
Following, you can find a description of Amazon Aurora Global Database. Each Aurora global database spans multiple AWS Regions, enabling low latency global reads and disaster recovery from region-wide outages. An Aurora global database consists of one primary AWS Region where your data is mastered, and one read-only, secondary AWS Region. Aurora replicates data to the secondary AWS Region with typical latency of under a second. You issue write operations directly to the primary DB instance in the primary AWS Region. An Aurora global database uses dedicated infrastructure to replicate your data, leaving database resources available entirely to serve application workloads. Applications with a worldwide footprint can use reader instances in the secondary AWS Region for low latency reads. In the unlikely event your database becomes degraded or isolated in an AWS region, you can promote the secondary AWS Region to take full read-write workloads in under a minute.
aurora cluster database endpoint latency snapshot amazon query console replication footprint synchronize bucket secondary instance primary compatibility relational capability website failover mariadb howto isolated resource application workcreate enable browser read parameter outage administration aws documentation
sql - MySql : Grant read only options? - Stack Overflow
Saved by uncleflo on June 23rd, 2019.
Is there a way to group all read operations in grant ? If there is any single privilege that stands for ALL READ operations on database. "Reading" from tables and views is the SELECT privilege. If that's what you mean by "all read" then yes: However, it sounds like you mean an ability to "see" everything, to "look but not touch." So, here are the other kinds of reading that come to mind: "Reading" the definition of views is the SHOW VIEW privilege. "Reading" the list of currently-executing queries by other users is the PROCESS privilege.
solution read readonly write administration development privilege query database mariadb mysql data permission user howto question
MySQL Workbench: Database Migration
Saved by uncleflo on May 4th, 2019.
The MySQL Workbench Migration Wizard is designed to save DBA and developer time by providing visual, point and click ease of use around all phases of configuring and managing a complex migration process: White Paper: Migrating from Microsoft Access to MySQL » With the MySQL Workbench Migration Wizard, users can convert an existing database to MySQL in minutes rather than hours or days that the same migration would require using traditional, manual methods. The Migration Wizard allows you to easily and quickly migrate databases from various RDBMS products to MySQL. Click on image to enlarge.
workbench wizard migration migrate database developer process software download mysql mariadb rdbms product traditional visual phase manage administration data structure
Data Warehousing Summary Tables
Saved by uncleflo on June 27th, 2018.
This document discusses the creation and maintenance of "Summary Tables". It is a companion to the document on Data Warehousing Techniques. The basic terminology ("Fact Table", "Normalization", etc) is covered in that document. Summary tables are a performance necessity for large tables. MariaDB and MySQL do not provide any automated way to create such, so I am providing techniques here. (Other vendors provide something similar with "materialized views".) When you have millions or billions of rows, it takes a long time to summarize the data to present counts, totals, averages, etc, in a size that is readily digestible by humans. By computing and saving subtotals as the data comes in, one can make "reports" run much faster. (I have seen 10x to 1000x speedups.) The subtotals go into a "summary table". This document guides you on efficiency in both creating and using such tables.
mysql mariadb warehouse warehousing summary table technique terminology normalization performance large material view total guide efficiency improve development developer create database average administration administrator infrastructure howto blog article description solution
What is MariaDB Galera Cluster?
Saved by uncleflo on March 23rd, 2018.
MariaDB Galera Cluster is a synchronous multi-master cluster for MariaDB. It is available on Linux only, and only supports the XtraDB/InnoDB storage engines (although there is experimental support for MyISAM - see the wsrep_replicate_myisam system variable). Starting with MariaDB 10.1, the wsrep API for Galera Cluster is included by default. This is available as a separate download for MariaDB 10.0 and MariaDB 5.5.
cluster galera mariadb master db linux support engine parallel replication download software storage administration development code application data
Painless HA failover with MariaDB
Saved by uncleflo on February 26th, 2018.
At work, we run a simple high-availability (HA) MariaDB setup that consists of an active master that handles all read and write queries from our applications, a passive master that can take over for the active master at any time, and a read-only replication slave (not shown) that we use for backups and analytics. Replication is configured so that the active master follows the passive master, the passive master follows the active master, and the analytics slave follows one of the masters. For the remainders of this post, I will refer to the active master as the master and the passive master as the standby. The benefits of this master-master configuration is that it allows us not only to failover from master to standby if the master becomes unhealthy, but also allows us to perform patching, reboots, lengthy migrations, and other kinds of database maintenance without impacting our users. Well, almost...
high availability mariadb master slave query db dbms backup replication failover painless administration configuration perform patch reboot application remain impact user configure maintain
MariaDB High Availability
Saved by uncleflo on February 26th, 2018.
In information technology, High Availability refers to a system or component that is continuously operational for a desirably long length of time: Wikipedia up time / total time. Here, the presentation discusses MariaDB MaxScale, setup to see how it works.
connector mariadb nosql crud api core application development administration parse plugin source optimise memory connect graph extend high availability available syncronise audit replicate production howto discussion technology cluster tool db dbms distributed databases
No further bookmarks found.