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. 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

Feed: Planet MySQL; Author: MySQL Performance Blog; Vinicius Grippa | August 7, 2018 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0, Replication PREVIOUS POST In this blog post, we’ll discuss how to set a replication from MySQL 8.0 to MySQL 5.7. There are some situations that having this configuration might help. For example, in the case of a MySQL upgrade, it can be useful to have a master that is using a newer version of MySQL to an older version slave as a rollback plan. Another example is in the case of upgrading a master x master replication topology. Officially, replication is only supported between ... Read More

Feed: Planet MySQL; Author: Shiv Iyer; Recently one of our customers wanted us to benchmark InnoDB, TokuDB and RocksDB on Intel(R) Xeon(R) Gold 6140 CPU (with 72 CPUs),  nvme SSD (7 TB) and  530 GB RAM for performance. We have used Ubuntu xenial 16.04.4, Percona Server 5.7 (included storage engines- InnoDB/XtraDB, TokuDB and RocksDB) and  Sysbench 1.0.15 with custom Lua scripts for this exercise, This benchmarking exercise included bulk INSERTS, WRITES, READS and READS-WRITES. We have tried our best to capture maximum information about the hardware infrastructure and copied / shared scripts we have used for benchmarking. This is not a paid ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/Python 8.0.12 is the second GA release version of theMySQL Connector Python 8.0 series. This series adds support for the newX DevAPI. The X DevAPI enables application developers to write codethat combines the strengths of the relational and document models usinga modern, NoSQL-like syntax that does not assume previous experiencewriting traditional SQL. To learn more about how to write applications using the X DevAPI, seehttp://dev.mysql.com/doc/x-devapi-userguide/en/. For more informationabout how the X DevAPI is implemented in MySQL Connector/Python, and itsusage, see http://dev.mysql.com/doc/dev/connector-python. Please note that the X DevAPI requires MySQL Server version ... Read More

Feed: Planet MySQL; Author: MyDBOPS; Introduction –               MySQL 8.0.10 GPL came out with more changes and advanced features. We have changes on InnoDB physical file layout ( MySQL data directory ) too. This blog will provide the information about the MySQL 8 InnoDB physical files. MySQL system tables are completely InnoDB now ?               Yes, Previously, we don’t have too many InnoDB tables on MySQL system tables. We have the innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info and slave_worker_info in MySQL 5.7 as InnoDB tables. But, now all the MySQL System  tables were converted to InnoDB from MySQL 8.0 . It helps in the ... Read More

Feed: Planet MySQL; Author: Yves Trudeau; Yves Trudeau | July 26, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL PREVIOUS POST The choice of good InnoDB primary keys is a critical performance tuning decision. This post will guide you through the steps of choosing the best primary key depending on your workload. As a principal architect at Percona, one of my main duties is to tune customer databases. There are many aspects related to performance tuning which make the job complex and very interesting. In this post, I want to discuss one of the most important one: the choice of good InnoDB ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The MariaDB Node.js Connector can use different APIs on the back-end: Promise and Callback. The default API is Promise. Callback is provided for compatibility with the mysql and mysql2 APIs. Documentation provided on this page uses the Promise API. If you would like to develop an application with the Callback API or have an existing application that you want to switch from the MySQL APIs to the MariaDB Connector, see the Callback API documentation. Base: Pool: pool.getConnection() → Promise : Creates a new connection. pool.query(sql[, values]) → Promise: Executes a query. pool.end() ... Read More

Feed: Planet PostgreSQL. This blog continues the discussion from my previous post on scalability for IoT workloads where I discussed how declarative partitioning in PostgreSQL 10 can help achieve scalability. While native declarative partitioning is a good start, the experience of creating and maintaining the same partitions I did in my last post becomes much more fun with pg_partman. pg_partman is an extension to create and manage both time-based and serial-based table partition sets. Native partitioning in PostgreSQL 10 is supported as of pg_partman v3.0.1. It is important to note that all the features of trigger-based partitioning are not yet supported ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The MariaDB Connector can use different API's on the back-end: Promise and Callback. The default API is Promise. Callback is provided for compatibility with the mysql and mysql2 API's. Documentation provided on this page uses the Promise API. If you would like to develop an application with the Callback API or have an existing application that you want to switch from the MySQL API's to the MariaDB Connector, see the Callback API documentation. Base: Pool: pool.getConnection() → Promise : Creates a new connection. pool.query(sql[, values]) → Promise: Executes a query. pool.end() → ... Read More

Feed: Planet PostgreSQL. A couple of weeks back, I wrote about how to use Windows Functions for time series IoT analytics in Postgres-BDR. This post follows up on IoT time series data and covers the next challenge: Scalability. ‘Internet of Things’ is the new buzzword as we move to a smarter world equipped with more advanced technologies. From transport to building industry, smart homes to personal gadgets, it’s not just about gadgets and sensors anymore. In reality, it is all about data. Not just simple data, but data that grows at an enormous rate. Businesses and application developers in Internet ... Read More