Tag: INSERT

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST If you are using Galera replication, you know that schema changes may be a serious problem. With its current implementation, there is no way even a simple ALTER will be unobtrusive for live production traffic. It is a fact that with the default TOI alter method, Percona XtraDB Cluster (PXC) cluster suspends writes in order to execute the ALTER in the same order on all nodes. For factual data structure changes, we have to adapt to the limitations, and either plan for a maintenance window, or use pt-online-schema-change, where interruptions should ... Read More

Feed: Planet MySQL; Author: Tony Darnell; Adding a replicated MySQL database instance using a Group Replication server as the source March 25, 2019 Leave a comment You say you want a Replication? One of the best features of MySQL is the ability to use MySQL‘s built-in database replication feature to automatically replicate data from one server (source/master) to another (slave/replica). Group Replication was added in MySQL 5.7 as a way to provide a high-availability solution using a new variation of MySQL replication. (In some earlier posts, I explained how to setup Group Replication using three MySQL database servers and how to ... Read More

Feed: Planet MySQL; Author: Ahmed Bouchefra; Laravel 5.8 is recently released with many improvements so we'll be learning, throughout this tutorial how to create an example CRUD application from scratch. The application we'll be building is a simple CRM with a MySQL database. You can see this Upgrade Guide for instructions on how to upgrade an existing web application from Laravel 5.7 to Laravel 5.8 Tutorial Prerequisites This tutorial has some prerequisites You have at least PHP 7.1.3 installed on your development machine, Working experience of PHP. The OpenSSL, PDO, Mbstring, Tokenizer, XML, Ctype, JSON and BCMath PHP extensions installed ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Phil de Valence. By Andy Jones, Senior Technical Representative at Treehouse SoftwareBy Joseph Brady, Director of Business Development at Treehouse SoftwareBy Phil de Valence, Solutions Architect for Mainframe Modernization at AWSCustomers that still have business-critical data locked in mainframes want to exploit this data with Amazon Web Services (AWS) agile services for analytics purposes, to create new communication channels, and for quickly developing new innovations. Fortunately, Treehouse Software’s tcVISION replicates data in real-time and bi-directionally between mainframes and AWS to allow for these new use cases. Treehouse Software is an AWS Partner Network ... Read More

Author: . Interested in NuoDB's elastic SQL database and want to know how it all works? Download our white paper on NuoDB's database architecture.Looking for the next-generation database As a NuoDB solution architect, I constantly talk to people about what they’re looking for in a database. More and more often, architects and CTOs tell us that they’re building their next-generation data center – often using containers or cloud infrastructure - and they need a database that fits this model. In their ideal world, they want a familiar relational database – but they want one that can deliver elastic capacity, maintain ... Read More

Feed: Planet PostgreSQL. This is the second part of the multi-series Benchmarking Managed PostgreSQL Cloud Solutions. In Part 1 I presented an overview of the available tools, I discussed the reason for using the AWS Benchmark Procedure for Aurora, as well as PostgreSQL versions to be used, and I reviewed Amazon Aurora PostgreSQL 10.6. In this part, pgbench and sysbench will be running against Amazon RDS for PostgreSQL 11.1. At the time of this writing the latest PostgreSQL version is 11.2 released about a month ago. It’s worth pausing for a second to quickly review the PostgreSQL versions currently available ... Read More

Feed: All - O'Reilly Media. Author: Patrick Hall. Cyber crime (source: Pixabay) Check out the "Ethics, Privacy, and Security" sessions at the Artificial Intelligence Conference in New York, April 15-18, 2019. Like many others, I’ve known for some time that machine learning models themselves could pose security risks. A recent flourish of posts and papers has outlined the broader topic, listed attack vectors and vulnerabilities, started to propose defensive solutions, and provided the necessary framework for this post. The objective here is to brainstorm on potential security vulnerabilities and defenses in the context of popular, traditional predictive modeling systems, such ... Read More

Feed: Planet PostgreSQL. Recently someone asked, on irc, how to make table partitioned. The thing is that it was supposed to be done with new partitioning, and not the old way. The problem is that while we can create table that will be seen as partitioned – we can't alter table to become partitioned. So. Is it possible? For my tests I made a table: =$ CREATE TABLE users ( id serial PRIMARY KEY, username text NOT NULL UNIQUE, password text, created_on timestamptz NOT NULL, last_logged_on timestamptz NOT NULL ); CREATE TABLE   =$ CREATE extension short_ids; CREATE EXTENSION   ... Read More

Feed: Cloudera Engineering Blog. Author: Grant Henke. Although the Kudu server is written in C++ for performance and efficiency, developers can write client applications in C++, Java, or Python. To make it easier for Java developers to create reliable client applications, we’ve added new utilities in Kudu 1.9.0 that allow you to write tests using a Kudu cluster without needing to build Kudu yourself, without any knowledge of C++, and without any complicated coordination around starting and stopping Kudu clusters for each test. This post describes how the new testing utilities work and how you can use them in your ... Read More

Feed: Planet PostgreSQL. Foreign data wrappers have been around for quite a while and are one of the most widely used feature in PostgreSQL. People simply like foreign data wrappers and we can expect that the community will add even more features as we speak. As far as the postgres_fdw is concerned there are some hidden tuning options, which are not widely known by users. So let us see how we can speed up the PostgreSQL foreign data wrapper.Foreign data wrappers: Creating a “database link”To show how things can be improved we first have to create some sample data in ... Read More