System News
back3 4 5 6 7 8 9 10 11 12 13 next
Articles for the keywords: MySQL
14 Jun 2017 MySQL Triggers and Updatable Views [64350]
By Percona

Agustin Gallego writes in Percona, "In this post we'll review how MySQL triggers can affect queries.

Contrary to what the documentation states, we can activate triggers even while operating on views:...

'Important: MySQL triggers activate only for changes made to tables by SQL statements. They do not activate for changes in views, nor by changes to tables made by APIs that do not transmit SQL statements to the MySQL server...'"
(Get More Information . .) open to premium members only

12 Jun 2017 How to configure MySQL Multi-Master Replication on Oracle Linux [64347]
HowtoForge, June 12th 2017

"This tutorial explains how to setup and configure MySQL multi-master replication on Oracle Linux. As you all may already know, MySQL is a well known top notch database product that has proven to be enterprise ready.

As data is crucial for every organization, most database administrators are looking for a suitable solution to setup high availability to ensure user are able to access their data 24/7. MySQL replication is a solution that can ensure a high availability policy.

On top of that, MySQL replication is also able to help database administrators to distribute the load on multiple database servers by load balancing the READ and WRITE requests. Unfortunately, basic replication can only offer benefits on READ requests. Due to that, MySQL multi-master replication was introduced to offer replication for WRITE request as well..."
(Get More Information . .) open to premium members only

07 Jun 2017 MySQL Documentation: Syntax Highlighting [64167]
By Stefan Hinz

Stefan blogs, "MySQL documentation has greatly improved code examples now: There's syntax highlighting in place, and code snippets can easily be copied to the clipboard. Highlighting is language-aware (including "languages" like the shell/command line). See, for example, this page from the X DevAPI documentation that contains a number of code examples for different programming languages...."
(Get More Information . .) open to premium members only

28 May 2017 Top Ten Articles for last few Issues [63616]
Vol 231 Issues 1, 2 and 3 ; Vol 230 Issues 1, 2, 3 and 4; Vol 229 Issue 5

We track how frequently each article is viewed on the web site to determine which the readers consider the most important. For last week, the top 10 articles were:

  • IT Infrastructure for the Data-Driven Era
  • OracleVoice: Charity Serves India's Elderly With Help Of Cloud Tools
  • MySQL Enterprise backup : How to setup a slave for a standalone server with zero downtime?
  • Convenience Store Chain Royal Farms Automates HR 24/7
  • Succeed By Failing: How To Speed Your Software Development -- And Why It Matters
  • From Bioinformatics to Life Sciences - Accelerating Discovery with Innovative Storage
  • Oracle's Machine Learning and Advanced Analytics 12.2 and Oracle Data Miner 4.2 New Features
  • Oracle Analytics Cloud Service is Now Live!
  • The Digital CFO Challenge
  • Friday Spotlight: Security and Patch Updates to Secure Global Desktop

The longer version of this article has list of top ten articles for the last 8 weeks.
(Get More Information . .) open to premium members only

25 May 2017 Calculating Distances with MySQL's Spatial Data Extensions [63821]
By Mark Lewin

Mark writes, "I used to work for a company specializing in Geographical Information Systems, and I still get excited about using computers to interact with geospatial data. Once a field that interested only geography geeks, GIS has now become mainstream, with just about every mobile app offering some kind of location awareness.

Whereas many such applications use some kind of third-party API to work with spatial data, with MySQL you can do this right in the database itself. MySQL provides a number of spatial data types which let you create and store simple geometric shapes like points, lines, and polygons that represent features like cities, roads, and countries respectively, together with their location in the real world..."
(Get More Information . .) open to premium members only

back3 4 5 6 7 8 9 10 11 12 13 next

!-- end archive_section.tpl -->