I have configured master-master replication in mysql 5.7.22 and its working fine. I am using below settings for PK values. I found issue in their ID sequence and pk values missing their sequence values    1 2 3 5 6 8   its missing 4 &amp; 7 because its replicate latest auto increment value from one server to another server so its skip the numbers. Is there any workaround through which we can maintain this sequence  Server A: auto-increment-increment=2 auto-increment-offset = 1  Server B: auto-increment-increment=2 auto-increment-offset = 2
Using OpenSUSE leap 15.1 10.2.29-lp151.2.9.1-x86_64 from vendor OpenSUSE (installed)  CREATE TABLE testtab2(     my_id2 INT AUTO_INCREMENT,     name2 VARCHAR(10),     comment2 VARCHAR(20),     PRIMARY KEY (my_id2) );   testtab.txt:  |Roger |hurray   | |George|today    | |Paul  |yesterday| |John  |last year| |Ringo |tomorrow |   LOAD DATA LOCAL INFILE 'testtab.txt' INTO TABLE testtab FIELDS TERMINATED BY '|';   works fine with linenumbers (my_id) 1-5  INSERT INTO testtab (name,comment) VALUES ('Beatles','band');   this gets linenumber (my_id) 8 - should be 6.  If testtab.txt have 8 records and using INSERT INTO 1 record this gets linenr (my_id) 16. This happens in other tables too - one moved from 199 to 256.  Anyone who can solve the problem?
It seems pretty straightforward to dual boot those versions of Windows when the newest is installed after Windows XP. But the inverse isn't happening on my machine. I tried even editing the BOOT.INI file, but the boot just freezes or displays that a file is missing when I try to boot another partition.  Currently I'm stuck with Windows XP, and I need to boot my Windows 7 instead.  What is the solution? I caught an Eevee, which of its evolutions will it evolve into? So I just caught an Eevee. Now, I need 25 candies to evolve it. The fact is that in the GameBoy color versions, that Pokémon needed a stone to evolve instead of experience. Depending of the stone he was fed with (thunder, water or fire), he was evolving in a different Pokémon.   Is the stone feature also in Pokémon Go? If not, what decide the evolution of this Pokémon?   Bonus point : If it's possible, how can I get a stone? When I look in sys.sql_logins, I see a column called is_policy_checked. Can I trust that my password policy has been checked for all of the logins where this column value is 1? Taylor series $\frac{z^2+z}{(z-1)^2}$ at $z=-1$ Endpoint of a line knowing slope, start and distance In a Cartesian system, I've got the slope, start point and distance of a line segment.  What's the formula to find the endpoint? How to loop over the lines of a file? Say I have this file:  hello world hello world   This program  #!/bin/bash  for i in $(cat $1); do     echo "tester: $i" done   outputs  tester: hello tester: world tester: hello tester: world   I'd like to have the for iterate over each line individually ignoring whitespaces though, i.e. the last two lines should be replaced by  tester: hello world   Using quotes for i in "$(cat $1)"; results in i being assigned the whole file at once. What should I change? Combinations of sets raised to the power of a prime modulus: $\binom{p^{\alpha}-1}k \equiv (-1)^k \pmod p$ Recommendations for Numerical Analysis texts? Just freeze an application (suspend the CPU, save its state to disk) and 'defrost' it when I want to use it 4 weeks later. How can I backup my RAW photos while travelling without Internet access? An inequality about Stirling numbers For all positive integers $n,r,k$ that $n=rk$, how to prove the inequality $$(r-1)!^k\le \frac{c(n,k)}{S(n,k)}\le (n-k)!$$ $c(n,k)$ is unsigned Stirling numbers of the first kind and $S(n,k)$ is Stirling numbers of the second kind.  Any help would be appreciated! I would like to use the sentence     He was 'over-eager' to implement his plan, leading to failure.   I am looking for a single word which expresses over-eagerness in a negative sense.  TIA Change Windows 7/8/10 system language - welcome screen, login, etc How to prove $n^5 - n$ is divisible by $30$ without reduction I have a Asus ROG G551VW laptop and I'm trying to install Ubuntu 16.04 on my laptop, but when i try to load the installer, my laptop just freezes and its fan starts working for no reason. I have tried to install Ubuntu 14.04 on my laptop and the installation went smoothly. What should I do if I want to install Ubuntu 16.04 on my laptop?  Any help would be greatly appreciated. Windows 10: Keyboard type rate extremely slow after boot I have upgraded my computer using a core i5 2500K from Windows 7 x64 to WIndows 10 x64, and the whole system runs fast and reliable, with one exception: after booting from SSD, which takes only about 10 seconds, my keyboard is really slow for the first 1 or 2 minutes right after booting. "Slow" means that when I start notepad, and type some characters, it takes a second for each character to appear on screen. Everything else is fast, including mouse movement, starting programs, only keyboard input is that slow. After 1 to 2 minutes, the keyboard suddenly behaves normally again.  This happens with every kind of keyboard I connect, no matter if I use the legacy PS/2 adapter, or USB.  Does anybody have any idea what might be the cause of this strange behaviour? calculation of $\int_{0}^{1}\tan^{-1}(1-x+x^2)dx$ Compute the definite integral   $$ \int_{0}^{1}\tan^{-1}(1-x+x^2)\,dx $$   Failed Attempt:  Let $1-x+x^2=t$. Then  $$ \begin{align} (2x-1)\,dx &amp;= dt\\ dx &amp;= \frac{1}{(2x-1)}dt \end{align} $$  Changing the limits of integration, we get  $$\int_{1}^{1}\tan^{-1}(t)\cdot \frac{1}{(2x-1)}dt = \int_{1}^{1}\tan^{-1}(t)\cdot f(t)dt = 0 $$  where $f(t)=\frac{1}{(2x-1)}$.  Is it true that $\int_{a}^{a}f(x)dx = 0$? If not, then where have I made a mistake in my attempted solution? How can I determine the current brew package count? I tried to get the number of available brew packages by running  brew search | wc -l   but I don't know how accurate this really is. What do I need to take into account to get a more correct number?  PS: macports lists 19,889 packages online Currently, this site embeds YouTube videos as Flash. (see an example: )  However, this is not the best solution, as now YouTube also supports HTML5, and some users (like me!) prefer to use HTML5 player instead of Flash. Supposedly, it should also work on devices that don't have Flash player (I can't confirm because I don't have one).  The solution seems quite simple: just change the embed code to an iframe, as described at     EDIT:  says:     Note: YouTube &lt;object&gt; embeds were  on January 27, 2015. Please migrate your applications to the , which can intelligently use whichever embedded player – HTML (&lt;video&gt;) or Flash (&lt;object&gt;) – the client supports. jQuery Isotope filter to no items?