Tag: collation

Feed: Planet MySQL; Author: MyDBOPS; In our work, We used to get a lot of requirements for replicating data from one data source to another.Previously I wrote replication from MySQL to Red-shift. In this blog I am going to explain about replicating the data from MySQL to Oracle using Tungsten replicator. 1.0. Tungsten Replicator : It is an open source replication engine supports data extract from MySQL, MySQL Variants such as RDS, Percona Server, MariaDB and Oracle and allows the data extracted to be applied on other data sources such as Vertica, Cassandra, Redshift etc. Tungsten Replicator includes support for ... Read More

Feed: What's New. Amazon Aurora with PostgreSQL Compatibility now supports PostgreSQL major version 10.4, and is available in US East (N. Virginia, Ohio), US West (Oregon), and Europe (Ireland) Regions. PostgreSQL 10 includes various new features including native table partitioning, support for improved parallelism in query execution, ICU collation support, column group statistics, enhanced postgres_fdw extension, and many more. Additionally, this release includes updated versions of the PLV8, ip4r, and pg_repack extensions. This release includes all patches from the PostgreSQL 10.1, PostgreSQL 10.2, and PostgreSQL 10.3 minor versions. It also includes all extensions that are supported in the Amazon Aurora ... Read More

Feed: AWS Government, Education, & Nonprofits Blog. Author: publicsector. Adoption of cloud computing is critical to maintaining our military’s technological advantage. Our nation’s warfighters deserve the most innovative and secure solutions. The AWS Snowball Edge is designed for rugged deployments in unfriendly physical environments. For the military, that may mean using the cloud in the middle of the desert, on board ships, and on the front line of the battlefield.The strategic advantage of making accurate decisions is in the ability to gather, retain, and process data into qualitative information. This allows the military to clear the fog of war faster ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Borys Belinsky and Dmitriy Kostiuk | September 12, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.7.23-23 on September 12, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-23 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free. New Features The max_binlog_files variable is deprecated, and the binlog_space_limit variable should be used instead of it. The ... Read More

Feed: Planet PostgreSQL. We do understand that IoT revolution is resulting in enormous amounts of data. With brisk data growth where data is mostly time series append-only, relational databases and DBAs have a rather tough task to store, maintain, archive and in some cases get rid of the old data in an efficient manner. In my previous posts, I talked about various strategies and techniques around better scalability for data storage using PostgreSQL and Postgres-BDR extension. Data retention is becoming ever so important. So let’s see what PostgreSQL 10 and above have to offer to efficiently manage your data retention ... Read More

Feed: Planet MySQL; Author: Jesper Krogh; The MySQL Document Store became general available (GA) with MySQL 8. One of the nice features of the MySQL Document Store is the X DevAPI that allows you to query the data from a multitude of programming languages using the same API (but while retaining the conventions of the language). The programming languages with support for the X DevAPI includes JavaScript (Node.js), PHP, Java, DotNet, and C++. I will be using MySQL Connector/Python 8.0.12 for the example in this blog. The example is executed on Microsoft Windows with Python 3.6 installed, but it has ... Read More

Feed: Planet PostgreSQL. Avinash Vallarapu and Jobin Augustine | August 10, 2018 |  Posted In: Insight for DBAs, Performance Tuning, PostgreSQL PREVIOUS POST The performance of a PostgreSQL database can be compromised by dead tuples, since they continue to occupy space and can lead to bloat. We provided an introduction to VACUUM and bloat in an earlier blog post. Now, though, it’s time to look at autovacuum for postgres, and the internals you to know to maintain a high performance PostgreSQL database needed by demanding applications. What is autovacuum ? Autovacuum is one of the background utility processes that starts automatically when you ... Read More

Feed: Planet PostgreSQL. Avinash Vallarapu | August 6, 2018 |  Posted In: Insight for DBAs, PostgreSQL PREVIOUS POST Implementation of MVCC (Multi-Version Concurrency Control) in PostgreSQL is different and special when compared with other RDBMS. MVCC in PostgreSQL controls which tuples can be visible to transactions via versioning. What is versioning in PostgreSQL? Let’s consider the case of an Oracle or a MySQL Database. What happens when you perform a DELETE or an UPDATE of a row? You see an UNDO record maintained in a global UNDO Segment. This UNDO segment contains the past image of a row, to help database achieve consistency ... Read More

Feed: R-bloggers. Author: Iñaki Úcar. The latest R tip in Win-Vector Blog encourages you to Use Radix Sort based on a simple benchmark showing a x35 speedup compared to the default method, but with no further explanation. In my opinion, though, the complete tip would be, instead, use radix sort… if you know what you are doing, because a quick benchmark shouldn't spare you the effort of actually reading the docs. And here is a spoiler: you are already using it. One may wonder why R's default sorting algorithm is so bad, and why was even chosen. The thing is that there is a trick here, and to understand it, ... Read More

Feed: Planet MySQL; Author: MyDBOPS; In our work, We used to get a lot of requirements for replicating data from one data source to another. Our team provided solutions to replicate data from MySQL to Vertica, Amazon Redshift, Hadoop. Out of which Amazon Redshift replication is a bit complicated as Amazon Redshift is a Database as a service (DBaaS) and the process is not straightforward. So, I take this opportunity to guide on how to replicate the specific set of tables from MySQL to AWS Redshift using Tungsten replicator. 1.0. Tungsten Replicator: Tungsten Replicator is an open source replication engine supports ... Read More