Tag: MariaDB

Feed: Planet MySQL; Author: Searce Engineering; MySQL Adventures: GTID Replication In AWS RDSYou all heard about that today AWS announced that RDS is started to support GTID Transactions. I’m a great fan of RDS but not for GTID. Since RDS has better settings and configurations to perform well. Many of you people read about the AWS What’s new page regarding GTID. But here we are going to talk about the actual benefits and drawbacks.RDS supports GTID on MySQL 5.7.23 or later. But AWS released this version on Oct10 (two days before). So, for now, this is the only version which supports ... Read More

Feed: Planet MySQL; Author: Jaime Crespo; Jaime Crespo  | October 15, 2018 |  Posted In: Events, MariaDB, MySQL, Open Source Databases PREVIOUS POSTFor Percona Live Europe this year, I got accepted a workshop on query optimization and a 50-minute talk covering TLS for MySQL at Large Scale, talking about our experiences at the Wikimedia Foundation.WorkshopThe 3-hour workshop on Monday, titled Query Optimization with MySQL 8.0 and MariaDB 10.3: The Basics is a beginners’ tutorial–though dense in content. It’s for people who are more familiar with database storage systems other than InnoDB for MySQL, MariaDB or Percona Server. Or who, already familiar with ... Read More

Feed: Microsoft Azure Blog. Author: Rob Caron. Now in preview Protect data in use with the public preview of Azure confidential computing - Years of work with our silicon vendors have allowed us to bring application isolation technology to hardware in our datacenters to support this new VM family. While these virtual machines may ‘look and feel’ like standard VM sizes from the control plane, they are backed by hardware-based Trusted Execution Environments (TEEs), specifically the latest generation of Intel Xeon Processors with Intel SGX technology. You can now build, deploy, and run applications that protect data confidentiality and integrity ... Read More

Feed: Planet MySQL; Author: Percona Community; Alexey Mikotkin  | October 12, 2018 |  Posted In: Entry Level, MariaDB, MySQL, Tools PREVIOUS POSTThere are a number of options for generating ID values for your tables. In this post, Alexey Mikotkin of Devart explores your choices for generating identifiers with a look at auto_increment, triggers, UUID and sequences.AUTO_INCREMENTFrequently, we happen to need to fill tables with unique identifiers. Naturally, the first example of such identifiers is PRIMARY KEY data. These are usually integer values hidden from the user since their specific values are unimportant.When adding a row to a table, you need to take ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Good news ! The MySQL, MariaDB & Friends Devroom has been accepted for FOSDEM’19 ‘s edition as announced earlier! This event is a real success story for the MySQL ecosystem; the content, the speakers and the attendees are growing every year. The first big change for this 2019 edition is that the MariaDB Foundation (Ian) is joining my efforts to build this Devroom. Don’t forget that FOSDEM takes place in Belgium, and our motto is “l’Union fait la Force” [“Unity is Strength”]. FOSDEM 2019’s edition will take place 2nd & 3rd February in Brussels ... Read More

Feed: Blog. Author: Peter V.; This is the second part of a three-part series of blog posts. Read also the first part. Stay tuned for the third part coming soon! The OVERVIEW page, which is the initial page, gives you a high-level view of your environment. You get a quick view of the number of down servers, servers with critical alerts, and servers with warnings. The lower part of the OVERVIEW page shows the TOP TEN SQL statements for the selected servers. Use tags for this list. Select this field, and quickly specify either PROD, an application, or a cluster ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; The FOSDEM organization just confirmed that again this year the ecosystem of your favorite database will have its Devroom ! More info to come soon, but save the day: 2 & 3rd February 2019 in Brussels ! It seems the MySQL & Friends Devroom  (MariaDB, Percona, Oracle, and all tools in the ecosystem) will be held on Saturday (to be confirmed). Stay tuned ! Let's share this on00Share this: ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The C++ connector for the MariaDB MaxScale CDC system. Usage The CDC connector is a single-file connector which allows it to be relatively easily embedded into existing applications. To start using the connector, either download it from the MariaDB website or configure the MaxScale repository and install the maxscale-cdc-connector package. API Overview A CDC connection object is prepared by instantiating the CDC::Connection class. To create the actual connection, call the CDC::Connection::connect method of the class. After the connection has been created, call the CDC::Connection::read method to get a row of data. The ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Introduction Keepalived is a routing software for load balancing and high-availability. It has several applications, but for this tutorial the goal is to set up a simple IP failover between two servers running MaxScale. If the main server fails the backup machine takes over, receiving any new connections. The Keepalived settings used in this tutorial follow the example given in Simple keepalived failover setup on Ubuntu 14.04. Two hosts and one client machine are used, all in the same LAN. Hosts run MaxScale and Keepalived. The backend servers may be running on ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This filter was added in MariaDB MaxScale 2.3 Overview The throttle filter replaces and extends on the limit_queries functionality of the Database Firewall filter. The throttle filter is used to limit the maximum query frequency (QPS - queries per second) of a database session to a configurable value. The main use cases are to prevent a rogue session (client side error) and a DoS attack from overloading the system. The throttling is dynamic. The query frequency is not limited to an absolute value. Depending on the configuration the throttle will allow some ... Read More