uncleflo
Registered since September 28th, 2017
Has a total of 4246 bookmarks.
Showing top Tags within 21 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 camera search material access customer travel test standard review documentation css money engineering engine develop webdesign device photography digital api speed source management program phone discussion question event client story simple water marketing app yacht content setup package fast idea interface account communication cheap compare script study market live easy google resource operation startup monitor training
Tag selected: db.
Looking up db tag. Showing 21 results. Clear
AWS RDS Aurora | CLUSTER DEMO | Cross Region Replica, Types of Endpoints, HA & Fully Managed - YouTube
Saved by uncleflo on May 27th, 2019.
Let's learn Amazon Aurora Database from scratch. What are new features of Aurora over RDS? How to achieve HA with Aurora Cluster? What are different types of Endpoints with Aurora? Aurora compatibility with MySQL & PostgreSQL. Reader, Writer & Custom Endpoints in Aurora Cluster.
database check understand achieve architect administrator practical exercise amazon watch cluster learn db howto solution problem advanced administration infrastructure system replication available
MySQL Table Locking
Saved by uncleflo on May 9th, 2018.
In this tutorial, you will learn how to use MySQL locking for cooperating table access between sessions. MySQL allows a client session to acquire a table lock explicitly for preventing other sessions from accessing the table during a specific period. A client session can acquire or release table locks only for itself. It cannot acquire or release table locks for other sessions. Before going into detail, we will create a sample database named sampledb that includes a simple table named tbl to practice the table locking statements.
mysql lock howto tutorial demonstration table client session explicit administration rdbms db database practice technical understand article demo concurrency control learn guide description
VividCortex - Application performance starts with your database
Saved by uncleflo on April 18th, 2018.
Most app performance issues originate in the database, but engineering teams lack visibility into the data tier. VividCortex provides unique insights into database workload and query performance, enabling faster issue resolution. The result is better application performance, reliability, and uptime. This ebook will help you understand key questions that you should pose about your database—and it will show you exactly how you can answer them, quickly and safely, with VividCortex.
performance development engineering team database db test optimization overview analysis question code query sql
MySQL LOCK TABLES and UNLOCK TABLES Syntax
Saved by uncleflo on April 18th, 2018.
MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating with other sessions for access to tables, or to prevent other sessions from modifying tables during periods when a session requires exclusive access to them. A session can acquire or release locks only for itself. One session cannot acquire locks for another session or release locks held by another session. Locks may be used to emulate transactions or to get more speed when updating tables. This is explained in more detail later in this section. LOCK TABLES explicitly acquires table locks for the current client session. Table locks can be acquired for base tables or views. You must have the LOCK TABLES privilege, and the SELECT privilege for each object to be locked.
lock unlock lock mechanism sql mysql database db development administration howto release data table code deadlock solution description reference documentation
Temporary tables in SQL query optimization
Saved by uncleflo on April 18th, 2018.
SQL queries can get complex in a big hurry. If you are querying multiple tables, and in particular if your query involves operations like UNION and INTERSECT, then you can find yourself in a big, messy pile of SQL. Worse, that big pile will often run slowly, sometimes to the point where a web application times out! I won’t inflict a real-world example on you; that would be cruel. So let’s look at a “toy” problem, keeping in mind that this won’t illustrate any time-savings, just the technique involved.
query complex temporary table operation union intersect problem description solution development database db howto sql optimize blog article
select without from
Saved by uncleflo on March 27th, 2018.
Let's get that straight from the beginning: select without from is not standard conforming SQL. Full stop. Nevertheless it works in many databases—also in standard conforming ones. That's no contradiction: the standard explicitly allows conforming databases to “provide user options to process non-conforming SQL statements”0. The behavior of such statements is completely up to the vendor, of course. So what alternative does the standard offer to select without from? A surprisingly simple and yet powerful one: values without insert.
sql database db conform option explicit values howto discussion blog development code data select modern
Using SQL WITH clause to create temporary static tables at query time
Saved by uncleflo on March 27th, 2018.
A few days ago, I came across the following problem: I currently work on a project where I am the responsible of an application which generates entries to a log table every time a job is executed. This table contains a lot of information on statuses of jobs, possible problems, exceptions, duration, aso. I was working on some analytics on this data and needed to enrich the data by the version of the software which generated the log entry (since we were not capturing this in the log table). From our configuration management tool, I was able to extract the dates when which versions of the software was deployed in production
data analysis project application analytics static db work development sql clause production howto code
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
phpMiniAdmin for MySQL
Saved by uncleflo on March 8th, 2018.
phpminiadmin - extremely lightweight alternative to heavy phpMyAdmin for quick and easy access MySQL databases. Instead of installing huge phpMyAdmin (~11Mb) and trying to figure out how to use all it's features, just upload one ~30Kb file and it's ready to use! Then access it via the browser (ex. http://yoursite.com/phpminiadmin.php). Script will ask you for DB login/pwd. After successfull db login you will see area where you able to enter any SQL commands (select, update, insert, etc.). Even if you don't know SQL it's still easy to: browse tables and see all the data, click to un/highlight rows
manage tables in DB, export and import data to .sql and CSV using 'quick links' on the top bar (see screenshots), see what databases you have permission with, check server status and statistics, ability to do CRUD (i.e. insert, select, update, delete), and launch any SQL supported by any version of MySQL. And due to it's simplicity script really fast and need just a little server resources! (your hosting provider will be glad ;)
installation mysql script page fast mini admin administration web website data database db sql browser permission table server developer work
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
PHP Mini SQL Admin
Saved by uncleflo on February 15th, 2018.
PHP Mini SQL Admin - Lightweight alternative to heavy phpMyAdmin. Extremely small (~30Kb) standalone php script. Easy to Install, simple to use. No SQL knowledge required for basic operations. Features: full MySQL support, extremely small (~30Kb), just in one php file.
php tool mysql interface connect light lightweight alternative small simple operation feature database file easy useful db dbms frontent mini query sql
How to setup your PHP site to use UTF8
Saved by uncleflo on June 27th, 2017.
According to Google (via: DF), UTF8 is now the most popular character set on the web! I wonder how much this is down to sensible defaults in web authoring tools, rather than a conscious shift in mindset. It's a long time since I looked at it, but as far as I can remember Dreamweaver defaults to UTF8 for new web pages, so a lot of beginning web designers are probably building Unicode sites without even realising it. I think there are a couple of reasons that many web designers and developers still aren't using Unicode across the board.
reference technical development administration utf-8 utf8 db database php webpage unicode site advice lookup server guideline practice web code setup character set
SQL Source Control
Saved by uncleflo on June 7th, 2017.
Connect your database to your version control system. Version control schemas and reference data, roll back changes, and maintain the referential integrity of your database. Solve other database challenges like deploying without losing data. And because it works with the tools you already use, it's an easy setup. Plugs into SQL Server Management Studio. Version control your schemas and static data. See who made what changes, when, and why
source control product software solution administer develop development server dbms database db howto introduction website explanation use application
Centreon Development - How to write a module
Saved by uncleflo on December 9th, 2016.
You want to create a new module for Centreon 2 or to adapt an existing one? You’re at the right place! You should know Centreon contains a page dedicated to the installation and the uninstallation of modules (Administration > Modules). To make the module appears on this page, its directory must be placed inside Cetreon’s modules/ directory.
documentation development nagios module extend howto example structure php db mysql install uninstall functionality feature sql
Apache Cassandra - Manage massive amounts of data, fast, without losing sleep
Saved by uncleflo on October 12th, 2016.
The Apache Cassandra database is the right choice when you need scalability and high availability without compromising performance. Linear scalability and proven fault-tolerance on commodity hardware or cloud infrastructure make it the perfect platform for mission-critical data.Cassandra's support for replicating across multiple datacenters is best-in-class, providing lower latency for your users and the peace of mind of knowing that you can survive regional outages.
apache opensource rdbms scale data mission-critical performance fast administration software solution db distributed
Application Performance Management & Monitoring | New Relic
Saved by uncleflo on May 25th, 2013.
PHP Application Performance Monitoring Pinpoint and solve PHP application performance issues down to the line of code. New Relic is the only tool you’ll need to see everything in your PHP application—from the end user experience to server monitoring. Trace problems down to slow database queries, slow 3rd party APIs and web services, caching layers, and more.
php development monitor management relic application web iphone android trace service cache experience server problem query db load time point pin code tool slow
Ask Tom: On ROWNUM and Limiting Results
Saved by uncleflo on March 27th, 2013.
This issue's Ask Tom column is a little different from the typical column. I receive many questions about how to perform top- N and pagination queries in Oracle Database, so I decided to provide an excerpt from the book Effective Oracle by Design (Oracle Press, 2003) in hopes of answering a lot of these questions with this one column. Note that the content here has been modified from the original to fit the space and format.
oracle db database technical description information query column design
Best way to store IP addresses in MySQL
Saved by uncleflo on February 4th, 2013.
It’s tempting to store IP addresses in a database as a VARCHAR(15) in the absence of a dedicated IP address field type in mysql, but that isn’t the most efficient way of doing so. The best way that I’ve come across to store an IPv4 address is to store it as an unsigned integer. In phpmyadmin you might set up an ip address field
guid information db ipv4 development address php database mysql ip
IP Geolocation online API - DB-IP
Saved by uncleflo on January 20th, 2013.
Backed by the continuously growing and improving DB-IP database, our online API makes it easy to use real-time IP geolocation without the need of hosting and maintaining hundreds of megabytes of data. With the DB-IP API, your data is always up to date and our server cloud ensure that your application always gets a timely and accurate answer. Here you will find everything you need to seamlessly integrate the DB-IP API into your application.
api db geo location internet service online rest lookup host accurate answer integrate information list
SQLite Home Page
Saved by uncleflo on September 6th, 2011.
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.
database sql sqlite opensource programming software development c db sqlite3 reference Advanced Databases
No further bookmarks found.