Tag: INSERT

Feed: Featured Blog Posts - Data Science Central. Author: Vibhor Nigam. This post is a token of appreciation for the amazing open source community of Data Science, to which I owe a lot of what I have learned. For last few months, I have been working on a side project of mine to develop machine learning application on streaming data. It was a great learning experience with numerous challenges and lots of learning, some of which I have tried to share in here. This post is focused on how to deploy machine learning models on streaming data and covers all ... Read More

Feed: Planet PostgreSQL. Published: Sun 05 August 2018 By Brian Davis In Posts. tags: postgresql How expensive is a join? It depends! It depends what the join criteria is, what indexes are present, how big the tables are, whether the relations are cached, what hardware is being used, what configuration parameters are set, whether statistics are up-to-date, what other activity is happening on the system, to name a few things. But we can still try and get a feel for what a couple simple scenarios look like and see what happens when: The number of tables being joined increases The ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL Users, MySQL Connector/J 5.1.47, a maintenance release of the production 5.1branch has been released. Connector/J is the Type-IV pure-Java JDBCdriver for MySQL. MySQL Connector/J is available in source and binary form from theConnector/J download pages athttp://dev.mysql.com/downloads/connector/j/5.1.htmland mirror sites as well as Maven-2 repositories. MySQL Connector/J (Commercial) is already available for download onthe My Oracle Support (MOS) website. This release will shortly beavailable on eDelivery (OSDC). As always, we recommend that you check the “CHANGES” file in thedownload archive to be aware of changes in behavior that might affectyour application. MySQL Connector/J 5.1.47 includes ... Read More

Feed: Planet MySQL; Author: Vlad Mihalcea; (Last Updated On: August 16, 2018) As I explained in this article, multitenancy is an architectural pattern which allows you to isolate customers even if they are using the same hardware or software components. There are multiple ways you can achieve multitenancy, and in this article, we are going to see how you can implement a multitenancy architecture using the database catalog as the unit of isolation. Catalog-based multitenancy can be achieved using any relational database system. However, since MySQL is one of the most popular RDBMS and because it does drive a distinction ... Read More

Feed: Planet MySQL; Author: Airbnb Engineering; Capturing Data Evolution in a Service-Oriented ArchitectureBuilding Airbnb’s Change Data Capture system (SpinalTap), to enable propagating & reacting to data mutations in real time.The dining hall in the San Francisco Office is always gleeming with natural sunlight!Labor day weekend is just around the corner! Karim is amped for a well deserved vacation. He logs in to Airbnb to start planning a trip to San Francisco, and stumbles upon a great listing hosted by Dany. He books it.A moment later, Dany receives a notification that his home has been booked. He checks his listing calendar and ... Read More

Feed: Planet MySQL; Author: John Scott; This may be a “duh” post for some, but I had to post this because I didn’t find the answer in typical places like stackoverflow when I had the issue.  I recently worked on a project to expand database capacity by deploying new MySQL installations with memory, config, and disk space tweaks by backup/restore, replication topology change and, and failover.  I did not notice that the old servers had “explicit_defaults_for_timestamp=OFF”.  After restoring a binary backup and starting the replication thread on the new systems I got this error in the replication thread (column name ... Read More

Feed: Planet MySQL; Author: FromDual; A while ago we released our FromDual Backup and Recovery Manager (brman) 2.0.0 for MariaDB and MySQL. So what are the new cool features of this new release?First of all brman 2.0.0 is compatible with MariaDB 10.3 and MySQL 8.0: shell> bman --target=brman:secret@127.0.0.1:3318 --type=full --mode=logical --policy=daily Reading configuration from /etc/mysql/my.cnf Reading configuration from /home/mysql/.my.cnf No bman configuration file. Command line: /home/mysql/product/brman-2.0.0/bin/bman.php --target=brman:******@127.0.0.1:3318 --type=full --mode=logical --policy=daily Options from command line target = brman:******@127.0.0.1:3318 type = full mode = logical policy = daily Resulting options config = target = brman:******@127.0.0.1:3318 type = full mode = logical policy ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Security. Each day it seems another breach is reported, another hack revealed, more personal user information is stolen, apparently despite the best efforts to thwart such attacks. It's becoming increasingly obvious that guarding against break-ins is simply not enough; one must be prepared for the maliciously inclined to succeed at hacking their way into 'secure' systems. For the Oracle DBA this may not be as daunting a task as it first appears. Oracle offers Transparent Data Encryption (TDE) [available with the Oracle Advanced Security Option] to protect sensitive data at the column, ... Read More

Feed: Planet MySQL; Author: EverSQL; Introduction The goal of this article is to evaluate and highlight the main similarities and differences between the MySQL Server Database and the MariaDB Server Database. We’ll look into performance aspects, security, main features, and list all aspects which need to be considered before choosing the right database for your requirements. Who is using MySQL and MariaDB? Both MySQL and MariaDB publish a respectful list of customers who are using their database as their core data infrastructure.You can speed up any SQL query, automatically. Try it now for free. For MySQL, we can see names ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Chris Azer. In industrial automation, you will find dozens of protocols used by devices and PLC vendors: OPC-UA, Modbus TCP, serial, and more. In fact, often in just one facility, it is common to find two similar processes performing the same function with different equipment.AWS Greengrass reduces the operational overhead for businesses to change protocols as needed through remote deployments. AWS Greengrass uses AWS Lambda, a service that makes it possible to program devices in the cloud. For example, a business can deploy AWS Lambda functions to field devices ... Read More