Tag: SQL

Feed: Planet MySQL; Author: Michael McLaughlin; Somebody didn’t like the MySQLi Update Query example on the tutorialspoint.com website because it use the procedure mysqli_query style. Here’s a simple example of using the object-oriented method version. More or less, instead of query it uses the more intuitive execute() method. The update_member function contains the logic and below it is a call to the test the function. It relies on a MySQLCredentials.inc file that contains the hostname, user name, password, and database name. You can create create member table, like my example in MySQL 8, or any other table in your MySQL ... Read More

Feed: CronJ. Author: Ayush Goel; As discussed in my last blog, there are 2 types of databases SQL and NoSQL. So in this blog, we will be looking at one type of NoSQL database that is MongoDB. MongoDB is an example of a document-type database, which means it stores data in JSON-like documents. One of the biggest reasons for its popularity is the data model used is a highly elastic one that allows us to combine and store data of multivariate types. MongoDB Architecture Let’s first discuss the architecture of MongoDB. A typical MongoDB architecture has 3 parts-  Database: A database ... Read More

Feed: Cloud Data Transformation Software | Matillion. Author: Arawan Gajajiva, Principal Architect; User Auditing Part 2 – Dimensional Modeling and Implementing Type 2 Dimensions In Part 1 of this series on Matillion security controls and how to enable user auditing, we showed how to use Matillion ETL to integrate with a couple Matillion v1 API endpoints as sources of User and Audit Logging data.  In Part 2 of this series, we show how to use Matillion ETL to implement a common data design pattern, Dimensional Modeling, to get the most insights out of this User and Audit Logging data. If ... Read More

Feed: Planet MySQL; Author: Alena Subotina; .NET Core 3 .NET Core was presented by Microsoft in 2016, but its 1.x versions had limited set of features comparing to Full .NET Framework. Since then .NET Core has been drastically improved. .NET Core 2.0 has a significant part of Full .NET Framework features and includes new functionality and significant performance optimizations.This year, a new .NET Core 3 is coming. It is currently available as .NET Core 3.0 Preview 9, and despite its preview status, Microsoft officially recommends it to full production use. Besides, Microsoft sends some signals that the development of Full ... Read More

Feed: Planet MySQL; Author: Simon Mudd; If you use replication with MySQL, if you need a backup, if you need a spare copy of a system for testing and for many other reasons you need a way to make a copy of your MySQL system. In the past you could make a copy in various ways: using a cold file system copy with MySQL first shutdownusing MySQL Enterprise Backup, Xtrabackup from Percona or MariaBackup (an Xtrabackup fork). These work against an online running server. However, they required special binaries to run on the source in addition to the traditional mysqld.copying ... Read More

Feed: Planet MySQL; Author: Andrew Grimo; In MySQL 8.0.17 there have been a lot of updates to the MySQL set of offerings. We’ve introduced Cloning into InnoDB Cluster 8.0.17, advances with the MySQL-Router in 8.0.17 and MySQL continues to expand its collection of automation managed features. When Group Replication was first introduced in MySQL 5.7.17, there was considerably less to manage right away compared to a “3-member Async replication setup w/auto-failover“.  Auto-failover tooling requires a lot of thought, determination and coding.  With the advent of Group Replication, MySQL’s users can put aside all that work and let MySQL Server’s Group ... Read More

Feed: Recent Announcements. Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run. With this release, Amazon Athena is now available in US East (Northern Virginia, & Ohio), US West (Oregon), AWS GovCloud, Europe (Ireland, Frankfurt, London, & Stockholm), and Asia Pacific (Singapore, Tokyo, Sydney, Seoul, Mumbai, & Hong Kong) regions.  ... Read More

Feed: Planet MySQL; Author: Continuent; Overview The Skinny In this blog post, we explore the correct way to implement bi-directional Tungsten Replication between AWS Aurora and Tungsten Clustering for MySQL databases. Background The Story When we are approached by a prospect interested in using our solutions, we are proud of our pre-sales process by which that we engage at a very deep technical level to ensure the we provide the best possible solution to meet with the prospect’s requirements. This involves an in-depth hands-on POC, in addition to the significant time and effort we spend building and testing the solution ... Read More

Feed: Radar. Author: Mac Slocum. Attend the Strata Data Conference in New York, September 23-26 to learn how ML, AI, and data are converging. The Strata Data Conferences helped chronicle the birth of big data, as well as the emergence of data science, streaming, and machine learning (ML) as disruptive phenomena. Strata attracts the leading names in the fields of data management, data engineering, analytics, ML, and artificial intelligence (AI). For nearly a decade, it’s provided a venue for developers, data and ML engineers, data architects, data scientists, and others to acquire or hone skills, explore provocative ideas, and network ... Read More

Author: bbulanov. While many enterprises are now ready to embrace cloud computing, they’ve struggled to move highly transactional systems of record to the cloud. For enterprises in regulated sectors such as banking and other financial services, there’s been a real challenge as they look for ways to move mission-critical OLTP SQL databases — and the applications that rely on them — to the cloud. Historically, relational SQL databases required single-server architectures, which made scaling with fluctuating demands both expensive and inefficient. At the same time, scarcity of main memory led to storage-centric design approaches, in turn resulting in a less ... Read More